Hi, I have a table with two columns: ID, Version. I would like to make a query that will append a record with the same ID, but the next consecutive version...

Good morning all! I have searched the archive and didn't find an exact answer to my question, so I am posing this quesiton to the group: I am trying to use...

I need to find each time a code occurs 5 or more times in a 7 day period. Example: CodeA and Town are fields in tblHelpr that I add rows of data to every...

I'm having real trouble with this and hope someone can help! Access 2003. SELECT IngredientMaster.IMNumber, Trim(Concatenate("SELECT INGsAllergens FROM...

I have two fields in a query: closed date final closed date In my dataset I sometimes have property ids listed twice but both date fields are not always...

I've run a query that captures the data set I want. Now I want to eliminate Duplicate names and retain only the unique names. These are text fields, can I do...

I have two tables, one of which has a field (AuditRptTbl.AuditRptYesCount) that I want to update with the Count of "Yes" values in another table...

I have two queries, one a monthly total of gallons used by location, and another a monthly total of cost by location. So what I want is a report with the...

Hi, I am trying to use the iif function for laboratory values. Basically I have lab value with number and alphabets. I want all the values with an alphabet...

Hello. I've recently upgraded to Office 2007... Prior versions of Access allowed the user to update tables (via update queries utilizing another query)...

We have our data in a table for our evaluation of employees. What we need is group or total the number of Yes and No responses to equal the perscentage of...

I cannot find my post from yesterday. We have approximately 1200 employees that we are entering data in a table for their evaluations. We are entering the...

I would like to create a query whereby it will allow the user to pick up more than one filter criteria. For example, if my field values = A, B, C, D My user...

HI to All Daryl S provided me with the following query that works great. however i wanted to modify the query so that it would add the production for the...

Sorry if this has been asked before, but I am not able to locate it if it has. But here is my delima: I need to be able to select the salesperson sales based...

Hi To All, Follow-up request from Mar-31-2010 I would like help with the following subquery if possible Thanks in advance for any help Table: tblProduction...

I am in a class learning about Access but I am stuck on this problem and could use some help. "Change the NetDonation calculated field to subtract the...

I have created a temp table that store ms project plans in an excel format. Each week, I import the updated plans into the temp table and then I then run an...

Hi, I have 2 tables, tbBaby and tbVaccineInjection. tbBaby stores the babies' personal data like Name, BirthDate etc., tbVaccine stores VaccineName,...

Howdy. Is it possible to add a row to a crosstab query that totals each column in the query? Thanks. Danny