Gender Field

A

Allison

How can I estabish a VBA code to determine the gender by
the first name field in my make table query.


First Name is Sex

Adam Male

Jennifer Female

Amy Female

John Male4
 
K

Ken Snell

You could build a table that contains all possible names (not just American
or US or British or Canadian or Mexican, but all countries) and assign a
gender to them, and then use that table as a lookup table to find the
correct gender as you read in a name.......

Of course, that is a lot of work for minor benefit... after all, to which
gender do you assign these names:
Robin
Lynn
Michael (there are women named this!)
Cary
Bobbie
Chris
Kris
Terry
Shelley

and so on.......
 
F

fredg

How can I estabish a VBA code to determine the gender by
the first name field in my make table query.

First Name is Sex

Adam Male

Jennifer Female

Amy Female

John Male4
Click to expand...

I suppose you could have a table with thousand's of names and use
DLookUp() to match the name with its associated supposed gender, but
then how would the table differentiate between names like Jan,
Michael, Dale, Kelsey, Evelyn, Merle, Maria, Marie, etc. which are
first names of both male and female persons. (And those are just a few
that immediately come to mind. There are more.) Who is to say that it
is not possible to name a woman John or a man Elizabeth.

You might want to re-think what you are trying to do, and not type
cast someone by their name.
 
L

Lynn Trapp

Of course, that is a lot of work for minor benefit... after all, to which
gender do you assign these names:
Robin
Lynn
Click to expand...

Now just how did you get that second name in your list? <veg>
 
G

Guest

If First name is unique, you can use
strSex = Dlookup("tablename","Sex","[First Name] = " &
strRequiredFirstName
 
Top