Query - Show Latest... (1 Viewer)

[Number11]

Hope you can help.

I have created two separate queries as follows

Order Requests - Have "Max" on to show the latest Requested Date

Dispatched - Have "Max" on to show the latest Dispatch Date

Now i need a 3rd query to show all Requests and latest dispatch date, but this is only matching up the two and does not show if a request has been made and not yet dispatched is this possible

 

[bob fitz]

Try changing the relationship join in the query design to include all records from dispatched