I am trying to edit a query that has columns of customer information name, address, date, purchase.
my query now, (which is based off the results of a previous query)

today fred 123 TV
today fred 123 radio
today Joe 321 tv
y.day joe 321 radio
y.day sam 222 tv

desired out put
today fred 123 TV
today Joe 321 tv
y.day sam 222 tv

What do I do I tried the first under customers

This type of thing?

http://www.baldyweb.com/LastValue.htm