Access Count query - also need to concatenate fields
Posted on 2004-08-17
I'm trying to do an Access query, using a table with the following fields:
Each document record consists of DocID, and fields for the party names. There are two vendors and 2 buyers for each document. I need to concatenate the first name, initial and last name for each of the 4 parties involved.
My query needs to show how many records contain each full name. For example, there are 27 documents with John P. Murphy as vendor (either name 1 or name 2, doesn't matter), and there are 32 records with John P. Murphy as buyer (either name 1 or name 2).
I want the results to look something like this:
John P. Murphy Party1 27
John P. Murphy Party2 32
James G. Boggan Party1 41
James G. Boggan Party2 40
Mary C. Smith Party1 19
Mary C. Smith Party2 23
Do I have to use a count function???
All you experts out there, please help me - I need to have this done before Wednesday evening!