hello... i dont use access very often so i guess i am a "noob" at this....

i am having a problem with a query. it draws data from multiple tables that all share similar fields. when i run the query, no data (or even blank spaces) shows up. i am assuming that i have a problem with my "relationships" but this is a fairly simple database and i fail to see where my mistake is comming from.

i donno if this is too vague of a question or not.. but i need to figure it out before tomorrow... so if u read this after thursday.... disreguard it. :)


thanks for any help you all can give me
~jcwillie

This happens when none of the records in tblA has a related record in tblB. Check your tables. You may want to change the join type from Inner to Left. The Left Join will return all rows in tblA even when there is no related record in tblB.