Query with criteria without field from table

[macattack03]

Is it possible to create a query with criteria for a field thats not included

If i want to use 4 fields to make a query customer # last name first name and amount paid but when i set the criteria i only want to find specific customers from VA but the state isn' t included from table i created how is this done

[orange]

Well if the state field is not in your table, or a related table, then it can't be done. However, if we knew more about your data base or business, then we may be able to suggest a data structure that would accommodate the busines rule.

[macattack03]

I have sportings good business and i tke special orders i have information in regards to my customers inputted into table. Im trying to find the customers information from a query i have made but i didnt include the state can i use a criteria for the state even though i didn't choose that field from the table.

[orange]

Can you show us a jpg of your relationships window? You'll have to zip the file since you have fewer than 10 posts.

If you have a Customer Table you'll need fields like

CustomerID PK
CustomerFirstName
CustomerLastName
CustomerEmail
CustomerPhone
CustomerAddress1
CustomerAddress2
CustomerCity
CustomerZip

include things about Customer that you need for your business.

See the videos I mention in https://www.accessforums.net/databas...d-35234.html#3