Easy query question ( I think!)

[freda42]

I think this is a fairly straightforward query, as I am so nearly there..but not quite.

I have a number of tables, among them a tblEnquiries and a tblQuotes. Not all enquiries will have quotes, but some will. There is a one to one relationship between them - there can only be one quote per enquiry.

I want to run a query to show all the enquiries that have been made, with the associated quotes. I want it to also show all the enquiries that have NOT had quotes made.

I have got a query to show me all enquiries that have quotes, but it misses out those enquiries without quotes.

What should I be doing?

Thanks !

 

[KKilfoil]

You need to change the type of 'join' you have made in your query.

I am not on a PC with Access right now, so the following is from memory:

If you 'right-click' on the actual join line between your two tables in the query design form, you should get a dialog that allows you to pick one of three choices, with the default being 'show only those records where a record exists in both tables', which is what you have now.

Pick the appropriate choice, which should be somethings like 'Show all records in tblEnquiries and only those records in tblQuotes that match'.

 

[freda42]

Woo hooo! You're a star

I knew it was something simple, but I couldn't figure it out for the life of me!

Thanks