Just trying to get the last transaction for each customer based the sales date and I just can't get it right. I need one record for each customer. I will be joining this table on a customers table on custno. I realize this is a fairly simple query but I am having trouble with it. Could someone offer some assistance please?