No Duplications?

Aug 17, 2006

Can anyone advise me on the following please.
I have built a very straightforward contact name and address DB to record all enquiries coming in to my business.
I don't want to enter any duplicates and I thought the best field to allow no duplications on was Address 1. Unfortunately this didn't work because I have three addresses all starting "The Old Coach House" but they are all in different locations. Then I thought of Post Codes, but we have enquiries coming in from countries that don't use Post Codes, like Ireland, so these are blank creating duplicates.
Has anyone got an answer to the problem, it's probably dead easy when you know how but being new to Access I can't see it.....HELP:(

Keith

View Replies


ADVERTISEMENT

Modules & VBA :: Counting Multiple Records And Specific Duplications

Aug 15, 2014

I have a table that contains names of employees and the name of awards they received.

tblEmployeeAwards
EmployeeName, AwardName
John,Nobel
John, Pulitzer
Michael, Fulbright
Jane, Nobel
Jane, Fulbright

I would like to know the following:

1. How many employees received more than one award (answer: 2).
2. How many employees who received the Nobel prize also received any second prize (Answer: 2).
3. How many employees who received the Nobel prize also received the Fulbright (answer: 1).

View 10 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved