Recent content by RobinR

That was the solution! Thanks!!!

Okay, I adapted the function, and it does not work as it should... The records in Table2 need to be unique for the combination WerkDatum (workdate) and Werknemer (UserId), so I changed the code in red to reflect the combination, plus all the other code to get the date field in there, of...

Thanks HGMonaro! Will try it. The reason I want to do this is that this makes it easier to calculate differences between the dates from different records. Having them all in one record makes making my selections and if statements that much easier (I hope...). Thanks again!

I have read questions regarding similar issues on this forum, but haven't found the solution to my problem... Hope somebody can help! I have Table1 with layout: UserID EventID DateTime For each user id, there will be multiple records for each date, so e.g. 10---47---2-1-2010 10:47:03...

The problem is that we do not have the possibility to adjust the way the access control system works, so the data is as it is. Data is being captured when an employee places his finger on one of the readers.

Each record has an ID number and a description. Your suggestion of FirstOf... is a good one, though, using the ID number as a starting point, didn't think of that! So I should query the rest of the data starting from the record number I retrieved first. The problem still will be that I...

You are right, but the SQL database is populated by the software controlling the access readers. The users SHOULD be doing the right thing, but that is not being checked or enforced. The data as is is the only thing I can work with... :eek:

Hi all, I work for a company that sells access control systems to stores. Access data is stored in a MSSQL database, and I am assigned to build an Access frontend to extract this data and put it in nice reports :D When an employee works in a store, he logs in (action), when he goes on a...