No subject
Wed Dec 28 11:38:03 CST 2011
John Pontiac Grand Prix
Jill Pontiac Grand Prix
Bill Pontiac Grand Am
Joe Chevy Camaro
Tami Dodge Intrepid
Dave Pontiac Grand Prix
Mike Pontiac Grand Am
Jeff Chevy Camaro
Mary Pontiac Grand Prix
Kim Pontiac Grand Am
I want it to give me:
Pontiac Grand Prix 4
Pontiac Grand Am 3
Chevy Camaro 2
Dodge Intrepid 1
If it makes a difference, the car make and the model are in a table
that is linked to the main table, where the name would be, by a number
(PK). For instance, Pontiac Grand Prix would be represented in John's
record with a 10 maybe.
And, to muck up things worse (although I hope not), this list of cars
is might change (i.e. next year there might be a Ford Focus, and maybe
there won't be something that is there now.).
Thanks for any help you may be able to give. This is a continuation of
my last post (Counting "unknown" fields), and I am so close to pumping
this program out...I just need to finish this and another problem that I
have already done previously...with the list's help of course.
Take care!
John W Clark
More information about the AccessD mailing list