Search results

Hi, Bit of a strange question / problem. I am using a Dlookup between two queries. Everything runs fine is I leave the join as option 1: only include rows where the joined fields in both tables are equal. But if I change it to number 3 Include ALL records in right table in left it returns a...

Hi, Looking for a hopefully simple answer to this problem. I have a list of employees and sort criteria. for example empID....Criteria 1234......T 1234......F 1234......T 1234......F 1235......F 1236......T 1236......F 1236......F 1236......F 1236......T 1236......T 1237......F The output I...

Hi, I am looking to create a summery on a dataset. I have Employee ID Duration 1234..............10 1234..............20 1234..............8 1234..............9 1236..............40 1236..............2 1236..............20 1236..............10 I want to summerise the data to calculate the...

Hi, I have a query I am trying to build currently which creates a running total based on set criteria. I essentially have three columns (All times are in minutes). The visit ID, the duration of a visit and the time difference between the current and previous visit. e.g. ID Duration...

Hi, I have a quick (hopefully) query about adding up consecutive values to get a running total. Currently I have the following ID Value 1 0 2 5 3 2 4 0 5 1 6 30 7 2 etc... I am looking for a way to get a running total up to the...

Hi, I am having some "fun" :banghead: at the moment trying to work out how to compare two times on different rows. The current setup I have is: StartDTM EndDTM VisitID 09:00:00 10:00:00 1 11:00:00 12:00:00 2 12:15:00 13:00:00 3 etc etc... I have found a SQL...