G
Guest
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!
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!