The method we used to descend from orbit to the surface of an alien world worked, but it would have been far more efficient and far less traumatic if we could just beam down.
Hers is a project I've been working on. When I enter a Date Of Birth, [DOB], I want to have it select, from a dropdown menu, A Generation. Example client is born in 1972, then the selection on the form will select "Gen X"... A client is DOB is 1982...after update it selects, "Millenial"... etc...
I tried to use an update query but it doesn't seem to work. with record sets...do I send a date and get back an ID number based on Year(DOB)... Am I Going in the right direction? If the DOB field is null I want it to select an ID 7 which is on the dropdown form "Unknown"...
Is there a better way?
Reply from Alex Hedley:
You could create a Function in VBA that takes an Year and returns a value.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Microsoft Access 321.
