how to create "if-then" in access quiries

[Jon_P]

I am working with a large amount of data but I only need the data a specific set of vendors "packaging vendors", I would like to have the query only pull data for packaging vendors which would be identified by a unique vendor number. can anyone help me please?

[alansidman]

Can you be more specific? What do you mean by unique vendor number? You have not provided enough information.

[tigeravatar]

If the "unique vendor number" is 123456, then the SQL query would look like this:

Please Login or Register  to view this content.

If that's not what you're looking for, then please provide more information like Alan has already stated.

[Jon_P]

The extract I have from our ERP data base is purchasing information it has over 65000 records, each vendor is assigned by the ERP system a unique vendor number, so they’re not sequential, I only want to pull information for vendors that supply packaging material. I have a list of those suppliers and their vendor numbers. what I wanted to do was create a query that will only pull information from the extract for those packaging suppliers I have on my list.

[Jon_P]

Thank you -- i have added some additional detail hopfully it will help

[MarvinP]

Hi Jon,

It sound like you have a table of ALL and another table of what you WANT. If you pull both those tables into a query and connect them by a common field and make the connection a one-to-one relationship, it should give you what you want. It will only show the records in the ALL table that match the field data in the WANT table.

I hope that helps...