| | |
|
|
|
Gender Field |
|---|
| message from Allison on 26 May 2004 |
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
|
| fredg replied to Allison on 26 May 2004 |
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.
|
| Ken Snell replied to Allison on 26 May 2004 |
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
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.......
|
| Lynn Trapp replied to Ken Snell on 26 May 2004 |
Now just how did you get that second name in your list? <veg>
|
| Ken Snell replied to Lynn Trapp on 26 May 2004 |
Yeah, you!
|
| anonymous replied to Allison on 26 May 2004 |
If First name is unique, you can use
strSex = Dlookup("tablename","Sex","[First Name] = " &
strRequiredFirstName
|
| Joseph Meehan replied to Allison on 26 May 2004 |
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.
|
|
Archived message: Gender Field (MS Access)
