I have another question regarding dates, but I think this one is simple.  
Say, for simplicity’s sake, I have two fields in my query.  One is called
“MonthlyHoursDate”  with the following criteria:  “>=[Type Beginning Date:]
And <=DateSerial(Year([Type Beginning Date:]) ...

I am ultimately looking to generate a report that repeats itself for each
client listed in a table.  (Similar to how a mail merge would work.)  For
instance, we create a proposal for a given project, and in a related table
called tblProjectClient, we may have only one client or many ...

I am trying to connect to an access database through reporting services to
generate some good looking reports.
The connection string for the database on my desktop is as follows:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "f:\sales order

Dear NG,
I've got two books - Michael Alexander's - Microsoft Access Data
Analysis and Virginia Andersens' MS Access 2002 - The Complete
Reference.  Both are good books, espeically Alexander's, but only

I have a table looking something like this:
Name    Field1    Field2    Field3    Field4
Bill         1                              3
John       1                2            3

Sorry to pollute the post with so many dumb questions!  Until I figure
out how to write queries that accomplish more than 1 thing at a time, I
was wondering if there was any way to automate queries.  For example, I
have a delete query that deletes bad data.  I run an update query ...

I want to restrict the use of a delete query, which is run through a delete
record button on a form, by adding the need to enter a password. I would be
grateful for any suggestions of how I might achieve this.
Thank you

I have a table that looks like this.....
ORDER    SHIPCOST
1                   $3.00
1                   $1.15

Hello, I am creating what I hope will be a very simple database.  It has two
tables; one with employee personal information, one with their vacation time.
In the vacation time table, I have a number field that lists the total
amount of time each person is entitled to, another ...

I realize my last post revealed too much information and made it
confusing. Let's start from scratch:)
I would like to assemble a query that counts distinct values.
Here is my count(disctint()) query thus far:

I have a sql statment that is calling for data on a different server, based
on certain numeric values I have on a list in the statement.  I have 4000
values on the list, and since an error popped up stating that I could not
have more than 1000 values in a list, I broke them up by ...

My  ODBC sql code below is giving me the error: #933: SQL command not
properly ended. Can anyone tell if I'm missing a comma or something that is
holding this query up?
thanks, Perry

Hi, I'm sure this is so simple I will feel stupid...  I can not remember how
to find records that have duplicate ID numbers.  I was given a spread sheet
with 45000 records and asked to locate any records with duplicate ID's.  I
remember doing something like this in access so I've ...

The qry COADS contains only 86 records, one for each county.  The
qryScanLog contains 88 records, one for each county.  I have tried all
possible joins and I cannot get 88 records to show up in the resulting
query - I get only 86.  Under the join properties I specify that I want

I have a table with one of the fields is a look up field with multiple
values.
After that I made a query with all the field from that table. If I run
it from this point, the look up field still works.