Query not bringing up all records

  • Thread starter Thread starter Bob H
  • Start date Start date
B

Bob H

I have a table with over 100 records in it of Product and Location and I
am trying to build a query on another query to show a specific
location. But first I know I must build the first query, but here is the
problem.
As I said the table I am building the query on has 115 records, but the
first query is only returning 35 of those records.
Each record in the table has a Product and a Loctaion so the query
should return all 115 records.
In the design of the query I have Fields 'Product' and 'Location' both
from Table tblHydraulic.

Thanks
 
Your discription here is a little confusing, it sounds like your
relationship of the tables isn't right and also like you may be working too
hard. Why not build one query that uses both tables and pulls your data.
The relationship of the tables/queries right now is one to one so if query
one and query two don't have an exact match in the relationship then you
will only get those records that are a relationship match.

You could post the SQL of both your queries and someone may be better able
to assist you if they can see it. Just change the view to SQL while in the
query grid and copy and paste into your post.
 
Yes you are right there Pete, I didn't think about that.
So I have decided that is what I'll do, in as much to use the tables in
one query.
In doing so I found that:
tblHydraulics location criteria gave up 22 records for a spercific
location, then when I added tblPrecisionEquip, where there are 285
records, and about of which there are 69 in the same location as from
tblHydrualic; running the query on both tables from the same location,
before I even select or add any fields to the query, it gives me 6402
records, but when I specified the same location as from tblHydraulic, it
returned 1518 records!
Back to the drawing board I think

Thanks
 
Please ignore Pete D as he only has one answer and it is use an
obsolete database.

Jet sucks, even Microosft admits this, they've written that in 1,000
places.
 
Back
Top