Recent content by BABM

Sorry! This image show the results more clearly!

Thankyou for your help. I tried: SELECT tblLabour.Key, tblLabour.Job, tblLabour.WeekEnding, IIf([tblLabour].[EmployeeKey]=[forms]![frmAssyHours]![Employee1],[Time],0) AS T1, IIf([tblLabour].[EmployeeKey]=[forms]![frmAssyHours]![Employee1],[Time],0) AS TH1...

I want to make it a maximum of 20 employees. I have a employee key field which is a number field. This query maybe is a nightmare, that is why I am asking for help on how to do it a better way. The original reason for doing it is to mimic an excel spreadsheet that is currently being used to...

Here's the reason I am doing it. The attached image shows the way I want to display the data.

Here's some more info about my problem. I've attached an image of the table. I am trying to first of all filter out and separate the employees on a job and each date that they are on. Then I am trying to put them together on one line. I first of all list the Distinct employees for a...

I am trying to gather data in a query. There are too many left joins and it takes far too long to execute. I have attached a database file that shows what I am trying to achieve. I have 6 employees at the moment and that works fine but I need up to 20 and then it is too slow. I know my...

Hi I'm still stuck on this one and hoping someone can confirm my code. Anyone out there?

I have just changed to windows 7 and I'm trying to make sure my database created in 32-bit will function correctly. Since changing the I get the following: Sorry cannot find the Mousehook.dll file. This worked fine before. I have made sure the dll file is in the system32 folder and the...

Thanks for the reply. It is the 64-bit version of office I'm running. The database is opening. There are some unexplained errors that are happening. I only have a rough idea about changing the Declare functions and LongPtr. I was hoping someone with more sound knowledge than me could...

We have changed to windows 7 and I am trying to make all the right changes ot my existing 32 bit MDB to make it work correctly. I have read about adding PtrSafe to the declare functions and changing Long to LongPtr for handlers and pointers. I'm finding it hard to get my head around. I have...