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
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