I created a action log database and I have a field named Due Dates. I named another field Overdue Dates which is currently blank. I the Due Dates are past...

I have a field named Due Dates and also a field named Overdue which is currently blank. When the Due Dates is past due, I want to display in the Overdue...

This is a logical question I need answered to help develop a query... We clean things brought into our facility... we want to know what jobs were not completed...

I need to do an AND query on the same field in a table. For example, in the simple table that links documents and their associated keywords I might have doc1...

I have an Access db that keeps track of employees and dates that tasks are assigned to them, along with their completion date. I have a query that counts the...

Hello I’m having some problem to make a query that joins 2 tables. The two tables (by kind of product) have some identical fields and others that are...

My query either returns 1.5 million records or it wont run due to the following error. "The SQL statement could not be executed due to an ambiguous...

I have 3 different fields in 2 tables and wish to display them. all the 3 fields have different names in the 2 tables. How do I create a union based on any one...

Greetings, I'm having trouble getting unique results from the a query which uses the "last of" a date column and any other fields. Whenever I select...

This seems to be a common problem from looking at all the other postings... Anyway, I have a very simple query that runs fine from the database...

I have the following setup in a query. I need return all records if parameter is left blank. criteria = +Space(3) or = +space(3) is Null also have...

Using Access 2003: I cannot seem to be able to use the operator in an IIF query criterion. Why is that and what should I do instead? Example: if a...

Hi, I'm kind of new at Access. I know how to do this in T-SQL script for SQL server but can someone tell me how to do this in Access 2000? 1. I need to...

Hi all, I don't know if I'm drawing a blank and missing something easy and obvious, but what I'd like to to is take my table that has 2 date columns and build...

Hi, I am new to vb and MS access and database programming. I am doing a project for Distributor Invoice system. I have problems as mentioned below. I have 2...

I have a query that is pulling data from one talbe. If there are duplicateds, which there are, How can I combine them? Same customer number, same name, same...

I want a drop down box of valid values on my parameter query. Per online examples, I created a form, which allows me to see a drop down box of valid values...

This is my second post for this - thank you Each month I create a new table using the SQL below, where the records are just copied from the GoalsMain table,...

Hi - I want to run an update a memo field using an update query. not sure why it will not let me update the field when there is more than 127 characters. it...

Would performance be better if I queried a linked table or if I used a pass-through query? and why? or would it matter at all?