Query - Show Latest... (1 Viewer)

Number11

Member
Local time
Today, 00:37
Joined
Jan 29, 2020
Messages
372
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

AWF VIP
Local time
Today, 00:37
Joined
May 23, 2011
Messages
4,317
Try changing the relationship join in the query design to include all records from dispatched
 

Users who are viewing this thread

Top Bottom