Recent content by Chris Hinds

Hi plog, Thanks for replying again. The fields are as follows: Log_pk = Number Person_pk = Number Job_pk = Text Time = Date/Time Action = Text The data is in a linked table sourced from the CSV file. I checked with other queries and all the dates are valid and in the correct format for...

Just realised the other thing that I screwed up in the original explanation... it might be the case that I have a number of records like this: Job_pk Person_pk Action Time a 29 Start 11/11/2011 12:25:11 a 29 Pause...

Hi Plog, Thanks for your help - that's an amazing improvement on how complex I was trying to make it. My sub-query is running just fine and giving me the results I'd expect but when I run the main query I am getting a "Data type mismatch in criteria expression" error... The only significant...

Hi, First post but reasonably familiar with Access, nest queries and relational data including on SQL Server. I have a number of data extracts from an SQL server that export to CSV for use in a tactical reporting solution being used to define requirements for the strategic solution. Due to...