C
CW
I have a query that shows customer details including their latest order date.
I get this by using Group By Max in the Order Date field.
The query doesn't give me customers who have never placed an order, i.e.
their order date field is null.
I know I could do a separate query to pull just those records, but ideally I
would like them to be included on the one report, possibly at the top of the
listed records, before those that do have order dates.
Can do, or not?
Many thanks
CW
I get this by using Group By Max in the Order Date field.
The query doesn't give me customers who have never placed an order, i.e.
their order date field is null.
I know I could do a separate query to pull just those records, but ideally I
would like them to be included on the one report, possibly at the top of the
listed records, before those that do have order dates.
Can do, or not?
Many thanks
CW