Count Query Over Multiple Fields

A

Alexdaman93

Joined
Jun 21, 2010
Messages
3
Reaction score
0
Hi,
I'm trying to use a query to see how many times a name appears in a field, and return the number of times it does.
I'm currently doing this in a different query, but only one one column, so my SQL is
Code: 
SELECT [Quarter Peals].Conductor, Count([Quarter Peals].Conductor) AS Total
FROM [Quarter Peals]
GROUP BY [Quarter Peals].Conductor;

Is there a way of using this across several fields (named 1,2,3,4,5,6,7,8,9,10,11,12)?

Thanks,
Alex
 
Also, is there a way of making a form so that when a hyperlink is clicked to open it, it appears in a pop up, rather than a new tab?
 
Back
Top