Recent content by JamesMF82

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, I will give this a go thanks!

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...

Thanks Plog!

@plog I will have a play with this and let you know, thanks :)

Hi, Sorry about that. Ok so with what I would like to see in my results based on the table is (excuse the periods they are purely for spacing): ID..Duration....Difference.Running total (RT).........Workings for the RT 1......30..............0..............30............As diff is under 20...

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...

@spikepl Tried the function, but alas no joy. was getting the error Compile error. in expression 'RunningSum([DifCri]'. DifCri being the column I am trying to run the calculation on. I added a new module under the database name in VBA and put in your code. ***Update*** Adding the table...

Hi, It's going to be run in as a query and not a form. I will have a play around with it. Thanks all

@CJ Hi, I was hoping you could advise me on one last part. I have tried putting my information into your selection, but I am getting a few errors. The values I have against the spacers are: myvalue = DifCri myTable = 03_Difference_Criteria ID = VisitID The formula I have is the following...

Running Total: DSum("[myvalue]","[myTable]","ID<="&[ID]) --> seems to work. Now if only I hadn't run it on 150,000 lines first of all!

^Thanks for this! @Plog - Quick question, I did search better after and came up with a DSUM query, however when it seemed to ignore the criteria of the ID. Just for my own peace of mind, can you see why? Running Total: DSum("[myvalue]","myTable","ID<=ID")

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...

^True to that! Thanks again