merging two fields

[missMRWhite]

I need to add two fields together to make a third field for example first name, last name to create a contact name. Then delete the duplicates. I don't want to just delete duplicates from last name as there are several records with one last name (Smith) and several people with the same first name (John). I would then create a new table with just the unique names with one John Smith. This would allow me to join these records to a future form.
Thanks!

 

[Norie]

Why do you want a table for unique names?

If you do need the unique names from the table you already have you can just use a simple query.

Something like this perhaps:

SELECT DISTINCT [FirstName] &[LastName] As FullName
FROM [MainTable]

You could then use this query in the future form.

 

[missMRWhite]

a query is fine I don't really need a new table at this point (I can always create a table from a query if needed). I need a count of unique names but I also need counts from 3 other fields - 2 are yes/no fields the other I need >0 but in the end need them all to be in one report/query/table whatever to see a comprehensive set of data. My second question was can I have multiple counts in one query? <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Thanks!<o></o>

 

[missMRWhite]

first problem solved! Thanks!