Query Question: two tablew with same field name???

[Gary]

I am trying to make a query where I have one table "call it products sold "
that has the price, lbs, QTY of the sku's.... I have a second table "call it
sku's" that has sku's with the lbs, sku name, sku descriptors, etc.

Anyway, I am making a new query where I need to calcualte LBS * QTY... As
you can imagine Access can't perform the math as it doesn't know which table
to pull LBS from... Can I perform the math in this query or do I have to
perform the math in a prio query?

 

[Allen Browne]

Use tablename.fieldname to disambiguate.

Instead of LBS * QTY, use:
Table1.LBS * Table1.QTY