Recent content by Prometheus48

Oh right thank you for all your help with this.

Hiya, brilliant thank you. Just tried it, how could i modify it to count the number of lateness in one month, for each employee please.

Hi Ya, i have included 20 test records along with a form i designed for it.

Sorry doesnt seem to have attached, file is too large? i have shortned this down. If you have an email address i can place this in my Office 365 account and share the folder with you.

Hiya, i have attached a test DB with a table and a form, any help would be greatly appreciated.

Hiya makes perfect sense, I’ll put together a sample table and form that goes with it. Thanks again.

Hiya I’ll post some tomorrow when I am back at work, I don't have any related tables.

Hiya I’ll look into the SQL statements for a count query.

Sorry but I have sensitive information on here so won’t be able to post any sample on here.

Hi ya, this would be over a month to month basis.

Hi Isaac, these are added into a table and forms are used for the data input. The lateness is selected from a drop down list within that form.

Hi everyone, hope you can help I have a database that tracks sickness, absence, conduct etc using queries. But I want to produce something that will tell me how many times someone is late. This is logged by site, date, first name, last name and (lateness) as part of a drop selection the managers...

Hello all, I’m very new to Access and have developed a basic database for an art gallery I work for. I do know the basics for creating forms and queries etc. But I have a few issues that I really can’t get my head around, and would really appreciate any help I could get. I aiming to develop my...