• Measure occurrences in MS Access SQL

    I was wondering whether it is possible (and if it is, the way) to perform the following task in Microsoft Access: there are two tables; first one consists of three columns 1) ID 2) tweet text and 3) date. Second table is a single vector of words, like a lexicon. For every row of the first table, I...

    dempar5 pointsBadges:
  • Value too Long in Microsoft Access

    this is a hypethetical question.. Using MS Access you enter the last name of a student, and you recieve an error message stating that the value is too long for the field. What are your next steps?

    Jeffhill5 pointsBadges:
  • How to insert row number using SQL

    When importing data from Excel into MS Access, how do you insert a row number using SQL?

    JimStAubin201515 pointsBadges:
  • Conversion of Microsoft Excel formula to Access

    How do I convert the below given formula of MS Excel to MS Access for the following data: ID Level Session Gender Regular/Plus Shift Programme Section 13 INTERMEDIATE 2013-2015 MALE REGULAR MORNING FSC ENG FSC B-4 14 INTERMEDIATE 2013-2015 MALE REGULAR MORNING FSC ENG FSC B-3 15 INTERMEDIATE...

    MUHAMMADYOUSAF10 pointsBadges:
  • Cascading combo boxes in Microsoft Access database

    I am a Continuing Education Teacher and I have been asked for help in building a function in a Microsoft Access database. I must say I have not yet found a solution. So, here what is needed: “I have constructed a contacts and networking database that I use to gather information on my professional...

    lawantyson5 pointsBadges:
  • Microsoft Access: Reports in Custom Groups vanish

    I have a couple different groups under Customs Groups in Access, and more than once now, when I open a Group there is nothing in it?

    Jaljets5 pointsBadges:
  • Paste records in OLE Unbound Excel Object in Access Form

    Ok so I have built a database that is used to house and manipulate records that I get from a monthly report that is posted online. Basically I work for the Army and we have over 50 units. Each unit has anywhere from 10 to 1000 soldiers in it. I initially had tried to build a database with a table...

    Brianaaskew40 pointsBadges:
  • Can you accept or decline task in Microsoft Access?

    Can task be forwarded to a person among group of persons in Access?

    ahonutere5 pointsBadges:
  • Sorting of students strength on one form in Microsoft Access

    I have a table named Students with the following fields and data ID Level Session Gender Regular/Plus Shift Program Section: 13 INTERMEDIATE 2013-2015 MALE REGULAR MORNING FSC ENG FSC B-4 14 INTERMEDIATE 2013-2015 MALE REGULAR MORNING FSC ENG FSC B-3 15 INTERMEDIATE 2013-2015 MALE REGULAR MORNING...

    MUHAMMADYOUSAF10 pointsBadges:
  • Updating forms in Access

    I have updated a form with membership information, adding several new fields. How do I get Access to update previous entries to include the new fields?

    lmack15 pointsBadges:
  • Microsoft Access import foreign key

    My question is basically this about MS Access: How do you import data into an existing table if at least one of the fields actually contains a foreign key related to another table? Let me give an example: Tables/fields involved: 1. "tblEmployee" with fields "EmployeeID", "EmployeeName", "StateID"...

    HardlyNotMe5 pointsBadges:
  • Building a query in Microsoft Access

    Hello: I need a code to create an auto generated multi record report depending on date like if I have a 4 portions loan that it's payment will take 4 years. The report will create a 4 records each in a year of how much to pay, starting from the first year. I want the query to calculate as that: I...

    theseeker7210 pointsBadges:
  • Microsoft Access joining tables

    I made a new table by doing group-by max from table-A, through Query design. Now I need to include a new column from table-A that matches the content in the Max column (which I already done max group-by). I try to do some ways but its picking the whole data in Table-A (but I need only matching...

    vinulopez015 pointsBadges:
  • VB6 and Access database combo box

    I have 2 combo boxes. In first combo box, I have district name from database table. If I select any one district, combo2 will display all schools in the concerned district from the access database table.

    shekarsuma5 pointsBadges:
  • Auto populating Excel fields from an Access query

    How do you auto populate an Excel report leveraging data computed in Access - is there a link function?

    Brigita5 pointsBadges:
  • Query for add, delete, update and insert using VB6 and Microsoft Access

    How can I query for add, delete, update and insert in Visual Basic 6.0 and MS Access?

    nagu7645 pointsBadges:
  • Error when truncating number field in Access

    I keep getting an error when truncating a number field in Access. What should I do?

    jonwagner5 pointsBadges:
  • Microsoft Access: Transpose multilple columns with single row into multiple rows single column

    I have 26 columns with a single row of totals. I would like the columns to be rows and a single column with the totals

    jshwltr97495 pointsBadges:
  • Expression incorrect or too complex in Access 2007

    I have two queries that are exactly the same, the first is based on September data, the second on December data. The first one runs correctly, the second one gives the following error message: This expression is typed incorrectly or it is too complex to be evaluated.

    ewillems5 pointsBadges:
  • Microsoft Access: Sum of duration from two different table

    In Access, how do I get the sum of duration from two different tables?

    AqilaNiazi5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.