I think that I’m missing something really easy here.  I have a query drawn
from an “Volunteer Hours Tracking Table” that returns the total number of
hours worked by those volunteers who came in during the past month.  To do
this it uses the equation:   (Sum((DateDiff("n",[Start ...

I have 3 Make-Table Queries that I would like to run automatically after
closing a form.  Would I use the DoCmd (RunSQL) for this? If so where would I
begin writting the code?  I assume in the OnClose event of the Form.  Am I on
the right path?

I have a table that stores student id's, name, class type, and class date.
The data is laid out as such:
12345    John Smith     Math Update     1/21/09
67891    Mark John      English             7/10/08

I have a command button the runs several update and delete queries using a
macro. Is there any way to silence the prompts that say you are updating x
records or you are about to delete x records? Any help is appreciated.

I have a query with sub query and get an error message that sub query
returns more than one record.
It seems that my query reference miand field query is not on current
record, but the whole table.

I have one access table linked to a number of select querys that pulls
out certain data using the WHERE command.
How can I add a sequential number to the querys? I need to leave the
queries as Select and not MakeTable etc.

I know that there are many posts regarding non-updatable queries and I've
read thru most of them but still don't quite understand what I need to do to
get this query to be updatable, or perhaps it's just not possible.  Sorry if
this is a newbie question.

Thanks in advance to anyone who can help here!  From what I’ve read so far, I
want to create a “Parameter Query”.  My current query (SQL below) groups the
total hours volunteered in several departments by month.  When run, it
returns all the results going back to the beginning of ...

I want to Activate/Enable Multiple users on a Access database at the
same time.
The database does not allow multiple users to add or edit records at
the same time.

I have multiple tables and wish to write a query to 'append' them together. I
have a common customer number against each record in each table.
For customer I want to run a select query that will generate a row for the
customer number from each table without having to write tables ...

I have a table that has the following fields that I used in a query:
Date
QCP_ID
Batch_ID

Hello,
I have a query with two columns labeled “Response” and “OutCome”.
I'm trying to figure out how to convert the text values listed the in
“Response” column to a Yes/No value in “OutCome” column.

paid amt         transport amt            Difference
22                     23                                -1
22                     23
45                    42                                 3

I have two tables:
Table 1 Field Names:
1.  Emp ID
2.  Units

I'm not sure if anyone can help me with this, but I thought I'd ask anyway.
I have several queries linked to a table in my work's database. The table
gets its data from a calculator that another department uses to amortize
loans and calculate delinquent totals. My department uses ...