Need Query Help

[dmaier]

I am trying to create a query where I can create a report of the number of registrants and guests for a meeting by registration type.

Each registrant and guest has their own specific reg_type.
They are:
A for Adult
G for Girl
NMA for Non Member Adult
NMG for Non Member Girl

I have used this before when I have tried to convert the G reg_type to a number before:

Girls: Sum(Val(Format(Asc([reg_type])-71,"\0;\0;\1")))

Question is how can I convert the NMA and NMG to the Ascii format to use like this or is there a better way?

 

[glynch]

Try:

SELECT Count(reg_type) FROM tblRegistrants WHERE reg_type = "NMG" OR reg_type = "G";

That will give a count of the number of girls (member and non-member combined) registered. You can use variations of that same query to get a count for any reg-type or combination of reg_types.

Remember to try to keep things as simple as possible and let built-in functions do your work for you.

HTH

 

[dmaier]

Didn't work

I have attached a jpg file of the query.

Please note that the registrant for these events have guests who are listed under the registrant's ID. We want the guests grouped with their registrants so we can tell what categories they are in. In other words, we want the registrant's name and the guests categories.

i.e.
Registrant NMA NMG A G
Jane Doe 2 1 1 5