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

 

[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