Im creating a report that is based off of 2 queries.
where_used_tbl - This query contains the following 3 fields:
where_used_count - This is a count query that contains 2 fields:
This query shows me how many different assemblies each component is used in.
The part numbers for the where_used_tbl that the queries were generated from come from 2 other tables. In one table all the part numbers start with the number 0(through-hole components) and in the second they start with the number 2(surface mount components).
The report includes the 3 fields from where_used_tbl query and count of where_used_tbl. The problem is that in the report, the part numbers starting with 0 are not included. Only the part numbers starting in 2 are present, listing each assembly it appears in and the total.
Both queries contain ALL the part numbers i want in the report. Why are half the numbers missing?
where_used_tbl - This query contains the following 3 fields:
Part No.
Assembly No.
Assembly Description.
Assembly No.
Assembly Description.
where_used_count - This is a count query that contains 2 fields:
Part No.
count of where_used_tbl
count of where_used_tbl
This query shows me how many different assemblies each component is used in.
The part numbers for the where_used_tbl that the queries were generated from come from 2 other tables. In one table all the part numbers start with the number 0(through-hole components) and in the second they start with the number 2(surface mount components).
The report includes the 3 fields from where_used_tbl query and count of where_used_tbl. The problem is that in the report, the part numbers starting with 0 are not included. Only the part numbers starting in 2 are present, listing each assembly it appears in and the total.
Both queries contain ALL the part numbers i want in the report. Why are half the numbers missing?
