How to search access database for purchase history?

Question

I need to create a form or something user friendly to search my database of purchase history. In the table i'm searching i have the following fields: Supplier, Invoice #, invoice date, location, part #, qty. I want to be able to search for a part # in a certain location and have it return the suplier, invoice number, date, and qty. I'm new to this whole access thing and i'm struggling.

Thanks

Answer 1

The syntax for this query is

SELECT * FROM [TABLENAME] WHERE "invoice number" = actualnumberyouwant

I'm not really big on access so I don't know how to build this into an access form, but make "actualnumberyouwant" a variable...and replace [TABLENAME] with the actual name of the table.