Available fields not listed in Report Design when Union Query is record source...

C

cpowell100

I have a UNION query with three SELECT statements that returns the
desired records from TWO linked Access tables ("tblNew" and "tblOld"),
which are linked to two Excel 2000 files. Since it's a UNION query, the
three statements return the sum of records from: a) both linked tables
when the joined fields are equal; b) records where the joined field
appears only in Table A; and c) records where the joined field appears
only in Table B.



When creating the report design (either Design View or Wizard), the
UNION query (which I'll call "qryBothTablesOrEither") appears in the pull-
down menu, but none of the fields appearing in the query result set
appear in the Available Fields section of the Report Wizard dialog.
This is not a parameter or crosstab query, so Microsoft's article
dealing with this condition doesn't apply (ref. KB Article 209024,
"ACC2000: Cannot Add Fields to Form or Report When Using Wizard").



I can't modify the properties for indexes, etc. in the linked tables
because they're based on Excel files and are thus not modifiable. How
can I get a report design to recognize all the fields that my UNION
query produces when it's run?



Thanks in advance, Chris
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Union query in Design View? 2
union query for report 4
Union Query Report 0
Union query 5
Record Source not showing field names 4
Access 2007 report to many fields 1
Union Query with two crosstabs 2
Access07 report requiring all fields of the record source? 3

Top