Hi All,
I have 2 tables and I simply want to click on the record in one table and have it copied to another table where I enter the quantity in an adjacent field.
I don't know code but can put together a form and build macros. I tried using a command button, wizard and duplicate record...
Three different suppliers supply an identical part. How do I run a query to return only the lowest priced record.
I.E.
Part Number Supplier Price
3 33 $34
3 22 $35
3 12 $29...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.