Extracting information from totals queries

G

Geraldwho

When i run a totals query to total the records in my timetable(Employee,
Timein, timeout, Job), i want to paste that total into the Jobs Table in a
time field, so that i can export that from the job table into an external
database (ODBC)
 
K

KC-Mass

Construct and run an update query that uses the Totals query as its source
and updates the ODBC table.

Regards

Kevin
 
J

John W. Vinson

When i run a totals query to total the records in my timetable(Employee,
Timein, timeout, Job), i want to paste that total into the Jobs Table in a
time field, so that i can export that from the job table into an external
database (ODBC)
Click to expand...

It's best NOT to store the totals in any table at all! If you store the data,
and subsequently edit one of the underlying records, your stored total will be
wrong with no way to detect that fact.

Just export the totals query, rather than exporting from the table. The syntax
is exactly the same - you *don't* need to store the data redundantly in a
table in orer to export it.
 
Top