MS Access Query

[FionaG]

Hi There. Just a 'quick' query regarding using MS Access.
I've imported an Excel spreadsheet into Access that has a 'Part No.' and
'Price' column. I want to have a lookup query - when entering a part no.
the price will display. What properties do I need to put on the Part No box in access to achieve this?
Any suggestions gratefully accepted....
Cheers! http://www.PCGuide.com/ubb/smile.gif

------------------
FLoG

[Max]

If this is what your after - The easiest way to do this in a query is to write a select query based on your table. Select the PartNo and Price fields, add [Enter Part No]to the criteria section on the PartNo field. Now when you run your query you will be prompted to enter the PartNo and return the price for it. NB: You don't have to display the PartNo value.

Hope this helps

[bassman]

Hello Max,
Although your input on the forums is much appriciated, pulling up topics that are 5 months old most likely will go unnoticed by the original poster. They have either moved on or have found their answer somewhere else.
I for one will certainly keep your knowledge of Database and Spreadsheet progs in mind http://www.PCGuide.com/ubb/wink.gif

Keep on posting http://www.PCGuide.com/ubb/smile.gif and lets try to stay current http://www.PCGuide.com/ubb/wink.gif
Thanks

------------------
Please let us know if what we suggest helps. This helps us help you better.