Report of New Customers

  • Thread starter Thread starter Meg
  • Start date Start date
M

Meg

Hi. I am writing a database for a friend of mine who is running a
pizza business. They would like to be able to know how many of their
customers are repeat customers. The customer table has a firstdate
and lastdate field - which shows their first date ordering, and
lastdate ordering. How would I determine the number of customers
where the firstdate and lastdate are not the same (which would be my
repeat customers)? I wasn't sure what the best method was. I would
need to show on the report the number of total customers, and the
number of repeat customers.

Meg
 
Meg said:
Hi. I am writing a database for a friend of mine who is running a
pizza business. They would like to be able to know how many of their
customers are repeat customers. The customer table has a firstdate
and lastdate field - which shows their first date ordering, and
lastdate ordering. How would I determine the number of customers
where the firstdate and lastdate are not the same (which would be my
repeat customers)? I wasn't sure what the best method was. I would
need to show on the report the number of total customers, and the
number of repeat customers.
Click to expand...

If you only want the report to display the repeat customers,
then use a criteria in the report's record source query.
E.g. set the criteria for the LastDate field to:
<>[FirstDate]
 
Back
Top