Query with no results

[Justin]

I have a database with multiple tables and I have designed forms to enter data. In form view i can view all data that is input but as soon as i try and use a select query to extract the data from the multiple fields, my queries are blank. Can anyone help me with why this would be?? many thanks

 

[Rich]

has the record been saved?

 

[Justin]

Yes the record has been saved on further inspection I think it is because some related fileds in other tables are blank. How do I deal with blank fields so that my data is returned whether fields contain values or not? thanks

 

[Rich]

you have to change the joins between the tables in the query design window

 

[Justin]

Thanks very much for your help woith this