Count Query Over Multiple Fields

Alexdaman93 · Alexdaman93's Computer Specifications

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

Alexdaman93 · Alexdaman93's Computer Specifications

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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Query to count on multiple fields	=?Utf-8?B?V2VtYmxleUJlYXI=?=	Microsoft Access Queries	2	6th Jun 2007 04:35 PM
Unable to count multiple fields in a single query	=?Utf-8?B?TFcgQWNjZXNzIE5ld2JpZQ==?=	Microsoft Access Queries	2	24th Apr 2007 09:00 PM
COUNT QUERY in make query table adding fields.	=?Utf-8?B?RWxyaWM=?=	Microsoft Access Queries	0	10th Jan 2005 02:27 AM
Re: COUNT multiple fields	Michel Walsh	Microsoft Access Queries	1	23rd Sep 2004 02:11 PM
count multiple fields of one table in one query	=?Utf-8?B?RmxvcmE=?=	Microsoft Access Queries	2	29th Jul 2004 12:44 AM