I need to selectively update a field in my master table with new data. By selective I mean only records that meet a particular criteria need to be updated. ...

I have 3 tables in the database. When I go to create the append query, only 2 of the tables show up in the dropdown to select the table to append to. The...

I have a series of queries and forms which when the database is on my computer, works fine but when I put it on the client's network, I am getting an...

I have a query that counts the number of records where the criteria has defined values. This produces a list of the number of records for each month based on a...

Ok. I have a major problem that I am not able to figure out. here are the details: My compnay receives parts in on a PO and line item. that is one movement....

I have a table & form created for logging results of workorder paperwork audits. There are 5 yes/no questions, like "Is Document 1 missing?", "Is Document 2...

My dataset has 3 columns: customer id, store location, charges I'd like to write a single select statment that will show each customer id once, with the store...

I have a query based on a membership table in which I need to pull out all the people who do not have an email address. When I design the query and put "is...

Please help me find a solution so I don't have to manually go through 14,000 lines :) I imported an excel spreadsheet into Access to find the duplicated...

My question is about ethics and efficiency. I have a query that process the results of four other queries. All five perform some calculations ans well as...

Hi I have a query where I am trying to return one "hearing" record (child record) per "case" record (parent record) if the three WHERE qualifiers are met....

Is it possible to perform a multiple column "not in" query in access? I created the query select * from climktvaluefromgroups c where (c.group, c.invdate,...

Hello, I have two fields in a query, if they both are blank I don't want to see it. But if one or the other is blank I want to see it. Thanks.

I am trying to write an IIf statement with the following info. If the ="OnTime" and the is greater than 2 hours then "Detention" and then if the ="Early"...

I am taking 4 fields from a linked AS 400 database, the 4 fields are IDAREA = T IDAISL = RA IDBAY = IL1 IDLEVL = 9 I need the word "TRAIL19" to be my parameter...

I have a query that pulls an employees license information from the training table and links the emp id field to get their name from the employee database. I...

I have a query that links 2 tables, 1 is employee and the other is training by their employee id. I have an input created in a query that allows you to put...

I have a Datetime field that I need to relate with another field but the seconds portion is messing me up. What function can I use to strip out (or reset to...

I have read as many threads as possible hoping to avoid having to ask this question, as I know it is a frequent one, but I am having trouble with apostrophes...

I have a query that prompts the user for the install number. I also need it to omit any records that have "obsolete" in any of the revision fields. Following...