UNION query changes results after close and reopen

  • Thread starter Thread starter Jason Christian
  • Start date Start date
J

Jason Christian

I have a UNION query, and the first field is the Client id field. If I run
the queries separately they return the correct client id. If I delete the
UNION, run the query, then add the UNION back in, the correct client is
retrieved. If I then save and close the query, then rerun it, all the client
ids return as 1. This occurs even if I move the field to a different
position or rename the field.
 
Hi Jason,
If you like to paste the sql for the union query to this newsgroup, we could
make some suggestions.

Jeanette Cunningham
 
Back
Top