multiple table qrys

[pollypocket]

im trying to create a qry to extract information between two dates i have used between [enter start date] and [enter end date] which works fine based on one table.

the problem im having is i need information from several different tables which i have tried but when i run the qry it returns nothing... any help would be appreciated..i have attached this below

thankx a mill

 

[Pat Hartman]

I didn't download your db. I don't have time to look at it. You probably need to break up your query. When the criteria needs to be applied before the tables are joined, you need to create queries to do the selection and apply the criteria and then join the queries together to produce the final recordset.

 

[jon98548]

Pat, doesn't this occur when you have a null value from a linked table? I have had trouble with this before , but found that the query wouldn't bring a record across where certain fields were null. I worked around this by have default values in those fields.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=54208&pagenumber=2

 

[Pat Hartman]

If you are using a Left (or right) join and the criteria is on the many-side table, you will loose the rows where the many-side table is null. That is why you break the query into two pieces. Apply the selection criteria to the many-side table. Then join that query to the one-side table with a left join.

Your method would not be accepatable in any case where a default value is not desiarable nor would it work in the above situation.