Combined Query - Strange Results

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

Guest

I have two Tables that are joined in a Combined Query - the first Table was
generated from an Excel spreadsheet that lists fee payments made to various
firms, the name of the person that raised the job and the job title. The
second Table contains similar information BUT it is properly normalised and
relationships have been set, using a "lookup wizard" to plug in repeating
names / details.

When I run the Combined Query, the results coming out of the second table
show the "Autonumbers" from the "plug in" tables rather than the actual date
they represent.

I can't find any way to fix this in the KB or on-line help.

Thankyou
Steve
 
There's only one practical way for us to know: Show us the SQL. Open the
query in design view. Next go to View, SQL View and copy and past it here.
Information on primary keys and relationships would be a nice touch too.
 
The SQL is: TABLE [log] UNION ALL TABLE [LOG NEW];

All the Tables feeding into Log New have just an Autonumber Column and the
name I need to feed into Log New. The Relationships are all type 1 - show
where both sides are equal.

If I run a query off the Log New, it works fine and shows what I would expect.

regards
Steve
 
Back
Top