Unique count and date associated

N

Nelson

Afternoon, I understand the unique count and its working for me I am getting
a result list of unique customers, but now I need to get the unique date
associated to that unique customer

Basically all I want is the date associated to the first time this customer
called us and display it next to the result of my unique customer list.

Any suggestions?

Thanks in advance
 
P

Patrick Molloy

use the DMIN() function

the first parameter is your entire table of data. your criteria will be the
column nale and the customer name and your third parameter the field, ie
date column.

mail me direct & I'll give you a demo file
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top