Gender Field

  • Thread starter Thread starter Allison
  • Start date Start date
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
 
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.......
 
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.
 
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>
 
Allison said:
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...

There are programs that do this, but as noted, they use a look up file.
You would need a copy of one of those look up files. I remember Word
Perfect's Infocentral did a great job. It must have had a rather large
database.
 
If First name is unique, you can use
strSex = Dlookup("tablename","Sex","[First Name] = " &
strRequiredFirstName
 
Back
Top