By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,317 Members | 1,344 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,317 IT Pros & Developers. It's quick & easy.

query design help for book index

P: n/a
I have a table with the following 2 fields:

Serial # ( values range 1 to 1400 and represent a birth certif #)
Location (text field that is the name of a geographical location
appearing on the birth certificate somewhere)

looks like this:
Serial# Location
1 Town X
1 Town Y
2 Town Q
3 Town Y

I have massaged the original table of records to eliminate duplicates
(same name appeared more than once on a BC). Some names appear in as
many as 120 records.

Now I need to try to format this for an index in a book of BC extracts.

So I need someway to print records that look like this
Location BC #'s
Town A 25, 88, 99, 245, 1200
Town B 22, 41, 1022
Town C 112
et al.

I am stumped as to how to approach this.
I did use a group by query to get a nice listing with the locations and
how many records there are for each (count).

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a

This discussion thread is closed

Replies have been disabled for this discussion.