Weekly Crosstab Query

[Guest]

I am currently working on a small database project that is very basic. We
are basically tracking the usage of our 3 internet cafe's. Each user is
required to sign the sheet when they login, as well as when they log out. We
take this info and enter into acces, that way we can create reports to better
understand how everything is being utilized.

Currently I have been using a few crosstab queries to get info per each
direct report. I have used the wizard to create a query for monthly, yearly,
and Quarterly. Now my question would be, what would I need to do to modify
a query to get weekly results. I am not an access Guru by any means so any
help would be appreciated!


Thanks,
Jay

 

[Guest]

If you aren't recording logs on a daily or weekly basis, how are you
recording them?
I'd say it is better to record on a daily basis then you can get any other
date format that you want.

Just look up the date/time format function in help. Put appropriate terms
between the quote marks (like "mm", "d" etc etc)

Week: (format([field]," ")