how do I prevent multiple copy of field in a query?

A

Aliriazi

In my receiving table I have a multiple copies of a same field with different
quantity and different dates. I am trying to use the value of the field from
receiving table in my main inventory query. The result is on the main
inventory query multiple copies of the same field appear on the query. How
can I prevent this?

Your advise is greatly appreciate.

Al.
 
P

pietlinden

Aliriazi said:
In my receiving table I have a multiple copies of a same field with different
quantity and different dates. I am trying to use the value of the field from
receiving table in my main inventory query. The result is on the main
inventory query multiple copies of the same field appear on the query. How
can I prevent this?

Your advise is greatly appreciate.

Al.
Click to expand...

Huh?
You can't keep multiple copies of the same table from your query. How
about giving an example of what you're talking about.

You mean you have something like:

Product(ProductID (PK), ProductName, QOH...)
Receipt(ReceiptID (PK), SupplierID (PK2), ReceiptDate...)
ReceiptDetails(ReceiptID (PK), ProductID (PK), Quantity)

What kind of query are you trying to write? Just explain it in
English... and then throw in your SQL so everyone can understand what
you're talking about.
 
Top