Yearly Payments

[binksmatthew]

i am making a db for a gym. the members pay yearly and the fact that they have paid is shown by a tick box in the members table. i therefore want to reset these boxes to 'No' at the beginning of each year. anyone got any way that this could be done.
thanks

 

[boblarson]

Just create an Update query in the QBE grid and under Update type FALSE.

 

[binksmatthew]

thanks. ive done that now and it works great. however, is there any way that i can automate it to update on the 1st January every year

 

[boblarson]

I'm sure that there's more than one way, but the easiest I could think of is to have a table that stores the current year, then when your form opens it pulls the value using a DLookup and compares it against the current year. Using an If statement you run the query if it doesn't match and then update the table with the current year.

 

[binksmatthew]

cool. thanks for the pointers. i'll go and give that a try