Hi, I have had a gym database designed for me by a friend, he had to give me an unfinished product and now I have been left with some problems and 1 week until my gym opens.
My problems are as follows:
I need to have a system on the database whereby you can goto a customers record when they log in, and click a button or whatever to indicate that they have attended that day (I need this so i can check how many times people attend in a certain time period and if people havent attended in a certain amount of time)
I need reports which can be mail merged to all members whom have no attended within the past 2 weeks for example.
I also need to have a membership renewal form, its already there but not linked into the expiry dates for any of the other forms, so if i renew a membership its not going to show up in payments or customer form.
I have other problems aswell, obviously any help I get will be rewarded.
Heres the link to the database:
http://rapidshare.de/files/13873373/IsisDb.zip.html
My problems are as follows:
I need to have a system on the database whereby you can goto a customers record when they log in, and click a button or whatever to indicate that they have attended that day (I need this so i can check how many times people attend in a certain time period and if people havent attended in a certain amount of time)
I need reports which can be mail merged to all members whom have no attended within the past 2 weeks for example.
I also need to have a membership renewal form, its already there but not linked into the expiry dates for any of the other forms, so if i renew a membership its not going to show up in payments or customer form.
I have other problems aswell, obviously any help I get will be rewarded.
Heres the link to the database:
http://rapidshare.de/files/13873373/IsisDb.zip.html