dbTalk Databases Forums  

Accessing a constant

comp.database.ms-access comp.database.ms-access


Discuss Accessing a constant in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Mark Weedon
 
Posts: n/a

Default Accessing a constant - 10-30-2006 , 07:57 AM






I'm sure this is insanely obvious... but i can't figure it out.

I have a db that organises applications for an event. Included in the
applicant information is their date of birth. On a form or report i can
calculate and display their current age (=(DateDiff("d",[DOB],Date()))/365)
and also their age at the time (=(DateDiff("d",[DOB],"28/07/07"))/365) of
the event.

As you can see i'm using a hardcoded date for the event date so i have to
change the expression all over the place. How can i set this date in one
location and reference it throughout the application?

cheers,

/mark






Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.