two fields needing to look like one for a count how?

[techexpressinc]

I need to get a count of the number unique of females and males on my db.



I have first name, last name, gender.

So, I need to merge those fields (first name, last name) and carry the gender through with the merge to get a count.


How would I code this up in a query?
Thx
Russ
Rneuman @ scaninc

[RuralGuy]

[first name] & " " & [last name] As FullName
will take care of part of your issue.

[techexpressinc]

Thank I will give it a try.
Russ