Linking 2 Queries

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kennedys21 - 20 Nov 2007 14:15 GMT

I am having a little issue with queries. I have 2 queries. Query A has the
fields [Tote Number], [Part Number], and[Unit Qty], and Query B has the
fields [Tote Number], [Part Number], and [Qty Picked]. Query A by it self
has 298 records and Query B has 305 records, but when I link them by [Tote
Number] and [Part Number] it is only giving me a total of 108 records. The
main purpose of this query is to show [Unit Qty] compared to [Qty Picked].

Any information would be greatly appreciated!

Reply to this Message

Pat Keller - 20 Nov 2007 15:11 GMT

There's nothing wrong with the query logic... you have to look at the data.
Are the fields you're linking (joining) on always exactly the same. Are
records mising on one or the other implying that, for example, Qty Picked was
zero if there is no record in Query B? Joining tables only works when the
data values are exactly the same - including things like physical trailing
spaces which may look identical to the eye but, in fact, are not. Look at
the data that's NOT coming up from one and try to find them in the other - I
would suspect you'll not be able to. I'd say that you probably have exactly
108 records where Tote and Part match exactly.

> I am having a little issue with queries. I have 2 queries. Query A has the
> fields [Tote Number], [Part Number], and[Unit Qty], and Query B has the
[quoted text clipped - 4 lines]
>
> Any information would be greatly appreciated!

Reply to this Message