I ran into something weird with a set of queries today.
I have a main query that retrieves data from about 8 other queries.
It uses a main table for the shape of the "report" and fills in the
details with left-joins from the other queries.
Individually, the other queries work fine.
MT = Main Table
Q1 = Query1
Q2 = Query2 etc.
Data is as follows:
MT.Col1, MT.Col2, MT.Col3, Q1.Col1, Q1.Col2, Q2.Col1, Q2.Col2 ... Q8.Col2
The problem is that the final query produces identical data for Q1.Col1 & Q1.Col2 !!!
They are not identical !!!
There are two cures:
1) Break the final query into two parts, making it less complex. Works fine.
2) Remove a Nz function from the initial Query1. Works fine, but it needs to be there.
The problem is solved, but I'd appreciate any light that someone could shed on this.
It is very disconcerting to see JET take the liberty of "transferring" a whole
column of data on its own.
Thanks,
Wayne
I have a main query that retrieves data from about 8 other queries.
It uses a main table for the shape of the "report" and fills in the
details with left-joins from the other queries.
Individually, the other queries work fine.
MT = Main Table
Q1 = Query1
Q2 = Query2 etc.
Data is as follows:
MT.Col1, MT.Col2, MT.Col3, Q1.Col1, Q1.Col2, Q2.Col1, Q2.Col2 ... Q8.Col2
The problem is that the final query produces identical data for Q1.Col1 & Q1.Col2 !!!
They are not identical !!!
There are two cures:
1) Break the final query into two parts, making it less complex. Works fine.
2) Remove a Nz function from the initial Query1. Works fine, but it needs to be there.
The problem is solved, but I'd appreciate any light that someone could shed on this.
It is very disconcerting to see JET take the liberty of "transferring" a whole
column of data on its own.
Thanks,
Wayne