angelandgreg
Technical User
I tried searching to see if i can find something first but did not find anything ...
I have a query that looks for the last date for an order number.
But if the order number only exists once it doesn't show.
It only shows the DMAX date IF the order number exists more then once.
How or what should i use to have my query show only the last or only record for an order number?
I have a query that looks for the last date for an order number.
But if the order number only exists once it doesn't show.
It only shows the DMAX date IF the order number exists more then once.
How or what should i use to have my query show only the last or only record for an order number?