Report extracting data from 3 queries

[Rallen]

I have a database of 22,000+ entries and have used three queries

1. Sort coins – listing all 22,000 coin and is the basis for most of my report which summarises and totals all entries for each of 536 groups (Eras)

2. Types distinct – using the coding SELECT DISTINCT [SORT COINS Query].COUNTRY, [SORT COINS Query].ERA, [SORT COINS Query].CODE
FROM [SORT COINS Query]; and list 6395 entries (Types)

3. Eras distinct – using the coding SELECT DISTINCT [SORT COINS Query].COUNTRY, [SORT COINS Query].ERA
FROM [SORT COINS Query]; and listing 536 entries (Eras)

Am trying to produce a report that pulls most data from SORT COINS and picks up the totals 6395 from TYPES DISTINCT and 536 from ERAS DISTINCT.

I can extract all that I need from SORT COINS. But cannot extract the data from the the other queries.

If I use any of the other two queries I can only get the data from the fields that I have used for the SELECT DISTINCT but I cannot extract the data from SORT COINS.

I am new to ACCESS and would appreciate guidance.

Baramundiroy

 

[pbaldy]

Generally if the 3 queries can't be joined into 1 you have 2 options. If you're pulling one value from the other query, you could have a textbox with a DLookup function. If the query may return multiple values, a subreport can be used.