Date And Time Of Member's Entry And Exit.

[bhavik1978]

Hello!

I have been trying to make a database for my local gym with about 250 members, what I wish to have is an entry and exit time recorded in attendance register. I am not very good with access and hence request you all to give me step by step instructions.

Little contribution will also be of great help.

Thanks
Bhavik

[ajetrumpet]

You'll have a difficult time getting step by step instructions with any sort of quality unless you hire someone.

In a general sense, have a table in your database and write the values to it with an APPEND query behind a macro called AutoExec. AutoExec runs when the database opens. Use the NOW() function to record entry and again to record exit behind whatever button you issue the quit command from. Good luck with it.

[NoellaG]

Hi,

question: do you want to enter the data/time they enter/leave the club, or your application? If the latter: there's a question similar to it in the topic "login tracking" in this forum. if it's the first: just add 2 fields in the appropriate table. Any beginners book/guide should be able to help you there.

greetings
NG

[bhavik1978]

hello there,

Thanks for replying, i know it is difficult to explain in detail but is it ok if i can attach my database, i don't want someone to do it for me, all i want is guidance, i am very patient and in no hurry at all. you can explain me 1 step a day even thats fine with me, i agree it is quite boring, but little by little i will make it.


well i want to have date and time of entry and exit of club members.

[NoellaG]

Hi,

of course you can zip your database and include it here. I'm sure someone will find the tima to give you a helping hand there. But don't forget to include a description of the purpose of the database and some explanation of the structure (tablenames and fieldnames, relations:how you see it and why you did it as it is) could be very helpfull.

grNG