QUERY QUESTION

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HELP!!! I have an existing Access document that I've been working with.
Somehow, I've modified it and I am not able to print a detail report. Here's
the message I get when I attempt to print a detail report (the overall report
is fine):
"the number of columns in the two selected tables or queries of a union
query do not match". How do I go in and fix this? I've found the two tables
that are short two columns, but cannot figure out how to go in and correct it
(ie, add the two columns the tables are missing).
 
You do not need to do anything with the tables. Your Union query consists of
two Select queries. A Union query requires that the number of fields in each
Select query be the same. Look at your Union query and see which Select
query has less fields being selected than the other. Next match up the
queries as to corresponding fields and determine in the query with the
larger number of fields which fields have no corresponding field in the
other query and note there position in that query. Bring the Select query
with the fewer fields up to the same number of fields as the other Select
query by adding MissingField1:Null, MissingField2:Null in the positions
previously noted.
 
Back
Top