my query is empty :/

[viperstingray]

Hello,

I have just created a query so that I may base my report on it. The query ties together 4 tables. I only included the fields that will be in my report. I created the report using the wizard and used my new query as the source but it does not want to work. I tried opening the query and it was empty even though I have entries in the database.

ANY IDEAS

 

[mresann]

I need more information than what you posted. What tables do you have? What are the relationships between the tables? In addition, if you have no data in any one of the tables, it will return no records.

If you can, zip the database file and post it as an attachment.

 

[IanWright]

Sorry to intrude on someone elses post but I just read something you said which is the problem I'm having..

I'm trying to do 10 queries that Count the quantity of items slightly different items within different rooms, say 5xgreen chairs, 2xdamaged blue chairs.. = 7 chairs obviously. Thats what the query stand alone will return. I want to combine all 10 of these queries however, to create a "summary form" for each room. The problem i have is some of the items don't exsist in some of the rooms, this gives a null result for that single query, and forces the result within the combined query for all the fields to null.

Is there a way around this problem? Hopefully it'll help the other guy if this is his kinda problem?

Thank you!