Bring together tables without Union Query

[Guest]

I have just combined 2 databases and have joined the data together for a
report by use of a Union Query. Is there any way to use a totals query to
accomplish the same thing since all data comes from tables. 1 set of data has
two relational tables and the other is just one table. The data from both is
essentially the same. I have tried but my join is not working as I get way
to many records.

I would like to be able to use a totals query since I have memo fields in
both which are truncated by the union query.

Any ideas?

 

[John Vinson]

I have just combined 2 databases and have joined the data together for a
report by use of a Union Query. Is there any way to use a totals query to
accomplish the same thing since all data comes from tables. 1 set of data has
two relational tables and the other is just one table. The data from both is
essentially the same. I have tried but my join is not working as I get way
to many records.

I would like to be able to use a totals query since I have memo fields in
both which are truncated by the union query.

Any ideas?

Memo fields are truncated by totals queries too, if you group by the
memo field. What's the "total" of a memo field anyway?

Please explain your table structure and just what result you want.


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps