Creating a report from an InnerJoin Query

[Guest]

I've created a query from two tables. The first is a "master table" of data
elements with an associated "common name" for each element (i.e SSN is the
common name used for all fields that define a social security number - SSN,
SOC-NBR, etc.) as well as other descriptive information about the element
(data type, field length, etc.). I ran a MAKETABLE query which created a
second table (that contains the "common names" and their frequency - ie. SSN
and 84, zip and 78, etc. in decreasing order of frequency.

I've now beat my head against the wall for two days trying to create a
report that breaks on common name - showing the common name and frequency in
the header, followed by detail records for all the data elements that use
that particular "common name" - ie. 84 detail records for SSN, followed by a
header break for ZIP and then 78 detail records, etc.

My last attempt has been to do an InnerJoin query between the two tables.
This give me a results set with the detail records I'm looking for, in the
correct ranking (most frequency common name to least frequency, further
sorted by element name. Now I can't seem to get the report to print. When I
try to run it I'm prompted for a parameter value (don't have a clue why) and
then the report is unable to find the field values (I get ##error in each).
The sources for each field on the report are the fields found in the
InnerJoin query.

Any ideas???

,

 

[Guest]

Jim,

I think you want to create a report with a subreport. The report will be
based on your table from the maketable query. The subreport will be based on
your master table. The report will be linked to the subreport (master-child)
using your common names. The subreport should be placed in the detail
section of your main report.