Checkbox

[Mantaii]

Hi!
I want to have the following setup:



January - Job Blogs in not a member of a club but completes the race. His results is recorded but as a non-member. (Checkbox - empty)

February - Job Blogs is a member of the club, completes the race and his results are recorded as a member (tick box - checked) but January results still show him as a non-member.

When I go to enter in Joe Blogs' result for March, the tick box next to his name is automatically checked as a member in the results form since he is a member from February.

Can this be done?

[jzwp11]

I would recommend using a date field to indicate when a person becomes a member. You will also need a date field attributable to the race, from there you should be able to differentiate whether a person was a member or not a member when they competed in a race on a particular date.

[Mantaii]

I have a date (month and year) for each race, is it possible to retrieve a date from when the tick box is clicked or I guess it would be just easier to enter in a join date to the member.

Thanks for your reply.

[jzwp11]

If you only have the month and year for the race, you would only be able to determine if the person joined within the same month of the race or before. If that is good enough for you, Access can work with that.

You would just enter the join date of the member. You would then compare the month/year of the join date to the month/year of the race to determine membership status. Access has built-in functions to extract the month and year from a date, so there is no need to have separate month and year fields in the table that holds the names of people. Those functions are month() and year() respectively.