2 TABLES FOR ONE REPORT

B

BUCKPEACE

IS IT POSSIBLE TO USE 2 TABLES IN ONE REPORT? i CANNOT LINK THEM AS BOTH
HAVE INFORMATION THAT IS UNLINKABLE AND VERY DIFFERENT.

THANKS VERY MUCH -
 
B

BUCKPEACE

one is a summary and one is the detail. I wanted to show the summary in the
top of the report and the detail under it. numbers are all very different.
IE -

Total hopitals visited = 5 (summary)
count: dr. smith visted 3
dr. jones visited 2
(detail)
 
R

Robert_DubYa

Is your summary table based on your detail table? If so use sorting and
grouping in your report and create a group header to sum the information.
 
J

John Vinson

IS IT POSSIBLE TO USE 2 TABLES IN ONE REPORT? i CANNOT LINK THEM AS BOTH
HAVE INFORMATION THAT IS UNLINKABLE AND VERY DIFFERENT.

THANKS VERY MUCH -
Click to expand...

Please turn off your caps lock. It's hard to read and impolite - it
looks like you're SHOUTING AT US.

You say downthread that you have a master record and then details
about that master record. If you have a table with 500 master records,
and another table with 5000 detail records, how can YOU - not to
mention Access - determine which detail records go with which master
record? Are you certain that you don't have SOME linking field?
Normally there would be just one; the Primary Key field of the master
record would link to a corresponding foreign key field (just one
field, not "lots of numbers") in the detail table.

If you don't have such a linking field, then I can concieve of no way
of looking at your details table and determining which records should
be included on your report. Can you?

John W. Vinson[MVP]
 
Top