Retreiving Data from sources when one is null

[jsncat]

I am combinign five queries into one and cannot get the query to run if one
of the original quesires does not have any data for a field. Is there an if
then statement or something I can use that tells access to retrieve all data
from a certain date even if one field is blank?

Thank you

 

[piccpp]

Access has the IIF function - IIF(expression,true,false).

 

[Dan]

You might want to right click on the join (the line between the data
sources) and select the join properties. There you have the option to show
all data from one source and only the those records from the other source
where the joined fields are equal.