Extracting information from totals queries

  • Thread starter Thread starter Geraldwho
  • Start date Start date
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)
 
Construct and run an update query that uses the Totals query as its source
and updates the ODBC table.

Regards

Kevin
 
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.
 
Back
Top