P
PR
I have a table which contains the following
Customer Number:
Customer Date:
Customer Item:
I am tiring to build a query that returns the last date a customer brought
and item and what that item was.
I have tried to use group by 'Customer Number' with last 'Customer Date'
and last 'Customer Item'. I get the last date but not the last item? I have
tried to use max, but get the same.
Can anyone help.
Paul R
Customer Number:
Customer Date:
Customer Item:
I am tiring to build a query that returns the last date a customer brought
and item and what that item was.
I have tried to use group by 'Customer Number' with last 'Customer Date'
and last 'Customer Item'. I get the last date but not the last item? I have
tried to use max, but get the same.
Can anyone help.
Paul R