Can anyone point me in the right direction here, I would like to open
a table in access 2003 by date.  I have an asp web page which needs to
read data from a table with each days today's date (which ever day
that is) then a new table is created with today's date.

Some one told me that it is faster a query that has a where like this:
where Id=1 or Id=2
instead of
where Id in(1,2)

I've had to retire beaten for today.  I've been trawling GG's
endlessly but I'm not getting anywhere with this so I'm resorting to
posting here.  Please help me if you can, I'd really appreciate it :)
Basically, what I am looking to do is to show by club and where

I have a budget to post 1500 letters
The database supplied has 2000 records
Can I randomly remove 500 records
All the best, Garry

is it possible to update two columns after each other, using one query?
ie...
i need to update an AGE field from Date of Birth of a person and then after
that, update a field to flag people in certain age groups?

I have a query set up which currently contains three records. I would like
to be able to add an expression which shows the results of a particular field
summing all three records.
Example;

Briefly stated, I have a table structured like:
VariableName (string)   Value (double)   Date (date)
Variable names can be repeated (don't worry, in the actual table I
have index numbers that call up the variable names from another

Our application uses a msaccess frontend and a mssql backend (linked tables).
Our application occasionally experiences blocking in sql.
We have identified a situation with the combo boxes. When the rowsource of
the combo box is large the sql2005 activity monitor shows “Suspended” ...

I have 2 dates - DOB (date of birth) and DOA (date of anniversary) for
contacts. I've got a union query that enables me to pull both of these fields
into a single field called CombinedDate. This is the SQL statement for the
union query:

Crosstab Query Help
I am trying to create a crosstab query to compare sales by customer-
then by year & month.  I want it to be set up the following way:
        January    February    March  .....

I have a field in a query named CreatedLogin.  I wish to populate this field
with a value from a field named LoginName from a table named zzLogin.  
DLookup does not work, nor does a direct lookup.  There are no forms in this
application.  How would I do this?

In basic terms:  I have a table with fields of Social Security No, Name, and
Type (3 letters).  There are multiple occurrences of the same SSN and Name,
but there may be different Types (e.g., AAA, BBB, CCC, etc).  I need to find
all occurrences of Type CCC.  I don't need to find ...

I have a table with Multiple records for the same serial number.  I need to
return only the latest record and the next previous record based on the date
of the occurence.  Can any one help me wit this scenario?

I've got this SQL that works fine:
SELECT Unit, Function, Min(Prod) AS AProd
FROM tblGLFINAL
WHERE (((Desc)="Product Code Allocation") AND ((Acct) Not Like "4*"))

Just had an issue that in 10 years of using Access never saw - just wondering
if I just never encountered it or what...
I have a form running a query, the user enters a date.  The report needs to
show the date - so the query has a field like this: