Search results

ignore my last comments, just saw page 2 lol - the db you sent back works - i will look at picking it apart from all your comments and changing as advised so I can learn from this as well - many thanks all for your help, it is really appreciated.

Any help would be appreciated. I cannot work out how to sort by 2nd order (Date then ID) in SQL, Ive added Row Counter but this doesnt change when I refresh (after adding rows that should be in the middle, etc) so I cannot use this. Help!!

How can I do this please, whats the SQL to add for a 2nd sort order please?

I tried that but it didnt work - i will update the basic db, appreciate any help :) really do appreciate it all.

Ah, its not working if the same date is used (which will be the case sometimes)

Seems to work :) Super Thanks. One other thing, how do I make it so the running sum can be currency, as I cannot fix this as its not a real field.

WoW!! Thanks. I think that worked. I will do some testing to be sure, but adding a new line with a date in between listed dates, then refreshing sub form gives me the correct running total :)

yes but the date column doesnt work when i try it, as that would fix it lol SELECT TBL_Money.ID, TBL_Money.Date, TBL_Money.Day, TBL_Money.Month, TBL_Money.InOut, TBL_Money.InOut, TBL_Money.Amount, TBL_Money.Payee, DSum("[Amount]","TBL_Money","[ID]<=" & [ID]) AS [Running Total] FROM TBL_Money...

yes, i have the running sum working if on record ID - but I want to add new entries and resort by date and this does not work as I want it to, as some of the ID's may have dates out of order, if that makes sense.

I have a form with sub form. The sub form shows data in Date Order and as entries are added I have a button that sorts this in date order as well. I need to be able to grab the previous row (after sorting) to calculate a currency so example: Row 1 - 2/1/24 - £2 Row 2 - 1/1/24 - £1 After Date...