Running a Report simultaneously across multiple tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hiya
We have written a call-handling system in Access to record the calls taken by our telephone helpline staff. The call records are entered via forms into 6 tables, depending who the customer is (we had 6 natural groups we defined for the process). Each table has exactly the same fields, but none of the fields contains exactly the same data across all 6 tables, i.e. there is no field I can find to create a relationship between the tables

We need to run reports for certain criteria against all 6 of these tables, e.g. list all new calls for a certain date, or list all calls with actions outstanding. Currently we are running 6 reports against 6 tables, creating 6 reports - this results in having to enter date parameters 6 times. Ideally I would like to run one report against all 6 tables at the same time to produce one report output. Is this possible please? Alternatively, can the output from the six reports be concatenated into one output

Thank you very much

Sue
 
I would recommend one table that contains an extra field that stores one of
six different values.
If this isn't possible, you can create a UNION query to concatenate all the
tables into one recordset. Also, it is a good idea to get
parameters/criteria from controls on forms.

--
Duane Hookom
Microsoft Access MVP


Sue said:
Hiya,
We have written a call-handling system in Access to record the calls taken
Click to expand...
by our telephone helpline staff. The call records are entered via forms into
6 tables, depending who the customer is (we had 6 natural groups we defined
for the process). Each table has exactly the same fields, but none of the
fields contains exactly the same data across all 6 tables, i.e. there is no
field I can find to create a relationship between the tables.
We need to run reports for certain criteria against all 6 of these tables,
Click to expand...
e.g. list all new calls for a certain date, or list all calls with actions
outstanding. Currently we are running 6 reports against 6 tables, creating 6
reports - this results in having to enter date parameters 6 times. Ideally I
would like to run one report against all 6 tables at the same time to
produce one report output. Is this possible please? Alternatively, can the
output from the six reports be concatenated into one output?
 
Back
Top