Flagging a field

[Annie]

Hi
I have a golf club database and was wondering if it was possible to 'Flag' a
players Date of Birth to show when there is a change in an Age Category ie:
Over 18, Over 40, Over 65 etc..

Many thanks

 

[David F Cox]

You should not be storing age information in a table unless it is age at a
specific time, e.g. when joining. This is called a calculated field, and
generally should not be stored in a table.

You should be accessing the table through a query that calculates the
current age range.
If you think about it you should be running your update age groups query
every day to ensure it is accurate. If it is not run every day the data may
be wrong. Whereas a query that shows the age ranges has only to be run when
required, and will always be accurate.

However knowing how to do it right has never stopped anybody from doing it
wrong -<)

You can do it using an IIF functions. (read help)
something on the lines of:
IIF(agecat65plus = False and CalcAge>65, "Now over 65", IIF(agecat40plus =
False and CalcAge>40,"Now over 40", IIF( ...

 

[Lynn Trapp]

Annie,
If you limit yourself to 3 age ranges, you can probably use conditional
formatting for this.

 

[David Cleave]

Another tip which might help. You could create a macro to run a query to show
you the people who have recently had significant birthdays. If you call the
macro 'Autoexec', it will run whenever the database is opened - so the first
thing the user sees could be a list of the people who have changed age
category.

Ta

David

Annie,
If you limit yourself to 3 age ranges, you can probably use conditional
formatting for this.

 

[David F Cox]

You should not be storing age information in a table unless it is age at a
specific time, e.g. when joining. This is called a calculated field, and
generally should not be stored in a table.

And if I think about it the age ranges are probably validas at a particular
date which specifies eligibility for a competition, which is a valid reason
for storing this info. Sometimes the fingers act faster than the vrain,
Sometimes the brain does not act at all.