Storing a variable between sessions

N

NeilH

I'm building a membership database for a small Sports Club. we have a fixed
membership year from 1st April to 31st March. I want to have a variable
describing the current membership year e.g 2004 that I can carry over between
sessions.

I can't use the date as in February/March we prepare for the next year e.g
sending out invoices but may still have members choosing to join for the last
month of the previous year.
 
D

david epsom dot com dot au

:~) That's what a database is for.

Create a table, something like tbl_Options, and
use it to store odd bits of persistent data.
Then you can lookup the value when you want:

vDate = dLookup("MemberYearDate","tbl_Options")

and you can use also the table (and the membership
year) in any query.

(david)
 
Top