I'm trying to use a Totals Query on a table that has a few records that I can define as duplicates.
Scenario:
Table A has 4 fields: FirstName, LastName, email, Company
There are 50 rows in the table.
The table was first created when 40 leads filled out a simple form and provided their info. 10 forgot to include an e-mail address. 10 forgot to write their names, but did provide an e-mail. Then, the 10 individuals who hadn't given an e-mail address to match their names returned, and they submitted all the required data this time. I end up with a few rows where FirstName and LastName are duplicates of previous rows, but the later email field has data that the prior one does not (for those 10 individuals who essentially submitted two forms), and I would simply like to take that data from the later submissions and mash the duplicates into a single record.
HOWEVER. The fact that some people did not provide first names or last names at all means that the totals function is counting everyone with no first and last name provided as a duplicate (because the FirstName and LastName fields for all of them match: they are blank). So if Jane and John Doe both gave me their email addresses but didn't write their first and last names, my database counts them as duplicates when I "Group By" the two fields of first and last name... when of course they are not duplicates.
I feel like there is some easy way to do this that I'm missing, but I can't figure what I'm doing wrong at the moment.
Thanks!