Hello, I have a table of employee information, which include 2 fields called Start Date and End Date. I want to be able to run a query that enables the user...

I know that Access 2003 does not support the ANSI SQL "CASE WHEN...ELSE..END" statement. I know that you have to use an inline IF statement . Also, I've read...

I have a query which runs from a control button on a form. When the query runs, the results are displayed behind the form. The user then has to minimize...

Hello all! I'm working on a task queue database. Currently the queue shows all non- completed tasks. I'm working on a Form where people can go in and see...

I have a form with a list box containing Customer names. Since all customers may not have an associated company name, I made a column in the query of the...

I have too many tables and the db is 4 years old. Some tables look like they have no purpose. Can I run some type of report to tell me if a specific table is...

Access 2007 I am trying to create a query that will look and pull data from 2 different tables based on a username the user inputs and an object name the...

Dear all, I have a table of quotes, a table of relevent customer numbers and a table of relevent quote keywords. I have written a query to return all...

I'm trying to format a CSV spec from a query and so want quotes on some fields and other without quotes -because of embedded commas in some fields. Can...

I have been asked by our purchasing department to modify a query on one of their databases to not include results that have a PO # which starts with "99"...

In my query design grid i can place a criteria such as 830100 or 850600 and it will bring all records for these two accounts under this account column. How...

I have 2 tables, TBL - Claims & TBL - Transactions. This is a one to many relationship, 1 Claim has many transactions associated with it. The issue arises...

I have 2 tables, Claims and Transactions. They have a 1 to many relationship, 1 claim can have many transactions. The issue I am having is that we are...

Could somebody please look at my query. I've looked and looked and tried changing it all different ways, but I can't work out why I'm not getting any data....

I get a syntax error message when trying to run a query using the following as an expression in the query Cat 3: IIf(=True,0,IIf(=,0,IIf(=3 And...

Hi, I'm having trouble with my If statement, not sure what i'm doing wrong, can anyone help? This is what i have, you can get the gist of what i want my...

Hi Everyone, I am using Access 2003. I want a list of patients who are active and have been on therapy 10 days as well as a field that shows how many days...

I have a query and I have the following in the criteria of the ListOrder column IIf(!!="Yes",45,) I want the results to exclude only 45's from the...

I want to set SNumber field of Table01 using a concatenation of two fields Fsn and AllFsn from Table03. Fsn link these two tables, below is my query however...

I have a table that looks like the following RUNID | DATETIME | PROCESS 0001 1/1/09 1201 Neck 0001 1/1/09 1202 Neck 0001 ...