I am creating a Access DB for a Little League registration and would to put a value in a field determined by the applicants DOB. I want to write a query to put the value Pony in the league field if the date is between 12/1/96 and 12/31/00 for example. I will need to for 6 different divisions meaning if date between XXXX and XXXX update table league set division = Mustang where DOB between xxxx and xxxx, and so on. Thank you in advance for your time and knowledge. D.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Date range to determine another field value 1
- Thread starter d22
- Start date
- Status
Similar threads
