Multi-criteria queries?

[lem_123]

Ive had a quick look at other threads to see if this question has been asked already, so hopefully Im not repeating a previous question!

I am completely new to Access but have been asked to perform multi-criteria queries across multiple tables. I realise it would be easier to just put all the information into one table, but if anyone could explain how to do the above I would be very grateful.

Thanks

 

[KenHigg]

Bring the tables into the query builder, add the joins, bring down the fields you need then add the criteria.

 

[Wayne Cramer]

I'd just like to add that most queries are multiple criteria across multiple tables. I don't know about it being easier but I'm sure it's not wise to put all of the information into one table.

 

[georgedwilkinson]

I'd just like to add that most queries are multiple criteria across multiple tables. I don't know about it being easier but I'm sure it's not wise to put all of the information into one table.

Unless the database is a data warehouse/reporting database, not OLTP. But I don't think that's what we're talking about here.

 

[lem_123]

Thank you for your replies

I have added the tables I need and the corresponding relationships, but when the query is run the displayed results produce a blank screen with no information. Does anyone have any suggestions?

Thanks

 

[georgedwilkinson]

Please elaborate on what "blank" means. Can you still see the objects on the form but they just don't have data, or is the form literally blank? Those are 2 different, real symptoms.

In the first case, your query is wrong or you don't have any data. In the second case, there's a flag in properties on the form (can't remember the property name right now) that may be set incorrectly.

 

[boblarson]

Thank you for your replies

I have added the tables I need and the corresponding relationships, but when the query is run the displayed results produce a blank screen with no information. Does anyone have any suggestions?

Thanks

When linking tables for queries, remember that you must have data in all of the tables for a record to appear UNLESS you have set outer joins (in other words, if you have a customer and you have an Inner Join set on orders and order details, you will not get any records for that customer if the customer exists but they have no orders or order details). So, if you want all customers to show up regardless of whether they have orders you must use an outer join.

But, you also need to make sure you mapped your relationships correctly. Can you post a screen shot of your relationships?