Good Afternoon:
I have 9 sets of criteria that I entered on 9 different lines in
access.  My first line consists of criteria for Retirees only.  Right
now I have:  [Retiree Eligibility Date] <Date(), [Retiree DOD] Is

Sort changes between PC's!!
With Access 2000 and tables linked to SQL db tables.
I get different results on any other PC and it makes no sense.
This is a very simple query.  (Read notes below)

Well, that's the best description I can think of anyway.
I need help with a solution. I have a set of data (vehicles) that I
have managed to extract a complete history for. This dataset shows the
month and year of every inspection that was completed on the vehicle

I have been working on this for hours, and short of beating my head against
the wall, have decided to ask, have been unable to find anything in the forum
that answers my question.
I have two tables.  One has patient number, patient name, total charges,

I have a table with 1.4 million records on it. Every morning we have to
delete the table, import data from a unix based program. Re-create the table.
Then use a macro to add information to the table that the unix info doesn't
have. Every time this is query is ran, the message ...

I have an ODBC connection to an AS/400 from Microsoft Access.  I have made
tables in Access 2003 that have all the same fields in the AS/400 by running
a make table query.  Now I would like to keep these tables current by running
update queries to find the changes made to records ...

I want to take the difference of two columns.  For example, I have panel
number (text) and a date (text).  I want to do a count function for each of
the columns (panel number and date) and then subract them from each other.  I
tried doing it and it said I have a data type ...

I have the following columns in a tabel
A    B   
IBM    x
IBM    x

Hi I am trying to create and And statement and this is what I
currently have:
[Status of Coverage- Retiree]<>"CANCELLED" And [Status of Coverage-
Spouse]<>"CANCELLED" Or Is Null

Check:iif(([slot id] is Like "10 1*" Or Like "10 2*" Or Like "10 36*"),"Not
Front End Regional", [tblMPOS-Class].[Tote Groupings])
Any idea where I'm going wrong with this?
Thanks!

This is an extension of Subject "Two PCs Diff Results"
I'm trying to add this code to the below code just before the FROM:
"\#mm\/dd\/yyyy\#") AS DueDate, tblTrackingData.TR_CLOSEDATE
SELECT tblTrackingData.TR_GRIEVANCECOORDINATOR,

I am getting the following error, and I dont know why
"The expression you entered has a function containing the wrong number
of arguments."
Past 0-30 days: IIf([proj_ship_date]-[request_date]>=0 and

How to display query result in text or combo box as default value?
Thanks!

I am needing help with calculating my date criteria in a query.
At the beginning of each year (January), I will need to print a report
extracting data for the whole coming year.
I could have put as a criteria the following:

I posed this question about a year ago, and now my news server has dropped
the old responses I received.
Unfortunately, my PC crashed and I cannot find the query that I used, so I
apologetically am going to ask the same question again.