Hey smarties, hoping someone can help me with something.
I would like to display birthdays within the next 2 weeks.
Iv tried a few things and some work, some didn't, but iv just ended up so confused. im sure its easy!
attached a screen shot.
Novice
Windows 7 64bit 
Access 2007
Hey smarties, hoping someone can help me with something.
I would like to display birthdays within the next 2 weeks.
Iv tried a few things and some work, some didn't, but iv just ended up so confused. im sure its easy!
attached a screen shot.
VIP
Windows XP Access 2010 32bit
Calculate current birthday and check if it falls between current date and current date + 14 days.
Birthday: CDate(Month(s_DateOfBirth) & "/" & Day(s_DateOfBirth) & "/" & Year(Date))
Criteria: BETWEEN Date() AND Date() + 14
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Posting Permissions
Reply With Quote