I have a summary query where the records are grouped on the following
fields:
-SaleMonth
-Car

I have recently asked this question ?
I have a form which has the following fields, CourseName, courseStartDate,
CourseFinishDate and a subform with the fields ExamName, ExamDate.
I would like to put an after update event procedure on ExamDate to

How can we delete a file using MS Access commands?

I`m trying to craete  a raw source for combo box from a table.
The problem is that the values shows more then once, I tried to do select
distinct but it didnt help, probably because of the ID(autonumber).
what to do?

I have a form which has the following fields, CourseName, courseStartDate,
CourseFinishDate and a subform with the fields ExamName, ExamDate.
I would like to put an after update event procedure on ExamDate to restrict
entry to greater then coursestartdate and less then ...

I have several apps that use ODBC linked tables to various back ends (SQL,
DB2, ProvideX), and all of them could benefit from any efficiency I can
provide. Someone told me I could speed these up significantly by using
SQL-specific passthrough queries instead of linked tables.

I ran the sentence below using query in MS Access. The execution is working
well, has no any problem.
INSERT INTO Table1 ( [Deposit Number], Items, Amount, [Deposit Date],
Reported,

SELECT Requests.[Date Time], Requests.Status, Min(Responses.Date) AS
MinOfDate, Max(Responses.Date) AS MaxOfDate, Requests.[Request ID]
FROM Requests INNER JOIN Responses ON Requests.[Request ID] =
Responses.[Request ID]

I'm trying to use 2 multiselect list boxes, the first with a list of
countries, and the second with a list of data points (population, GDP,
etc) and want the user to be able to select from both, then push a
button to get the results.

I'm using access to query a SQL database.  One of the fields in the database
[trddate] uses the datetime format.  If I use the following format in my
query selection I'm ok. BETWEEN '5/1/2006' AND '5/26/2006'.  If I try to use
a form to make a query selection ie. Between ...

tblTransfer is used to hold data of where our assets are in the company and
which internal contract to charge for each weeks period of hire. As they are
moved to a different contract we enter them into tblTransfer so we have a
history of where they have been and use this query to ...

We're using VB6 with an access database (jet engine) - we've always used
Access 2000 - since many customers  hadn't updated to office 2003 yet.  
However - I needed to rebuild my development machine - so temporarily
transferred my VB6 over to another machine with office 2003.  Now ...

Here's my table structure:
tblGroup:
JobNumber
GroupID (pk)

I'm using Access to manage 700 annual budgets, each tied to a client, in a
simple table:
[BudgetID] (key field)
[BudgetStartDate]

I have two Visual Foxpro tables linked into my Access 2000 database
with odbc.  The  database is for a Meals on Wheels non-profit.  One of
the foxpro tables is called 'clients' and the other 'meals'.  Client
information like name and address are in the 'clients' table, which is