Search results

I have a report in which there are a list of number with the duplicates hidden. At the end of the report I wish to Count all of these numbers, NOT including the duplicates. When I do the count at the footer it still counts the duplicate numbers. How can I count only distinct numbers?

I need to send an automatic email update every week when a certain event does not happen. Does anyone know if this is possible in Microsoft Access and if so how I would go about doing this? =)