Search results

Hi All, So i have been sent unstructured data which i need in a nice format to analyse. I have attached what i would like the data to look like (the part at the bottom of the image). I dont know if there is any code which would help in getting my data to look in that format. Appreciate any...

@plog @arnelgp - Thank you both so much for your help. I will try this out today and will let you know how i get on. Again , appreciate your willingness to help :)

Thanks for the response - please find attached a version 2 which contains three sheets of the raw data how it is sent to me. Even if all periods to date are still "0% paid" (say we have 3 months data), out of those three months 2 of those for a specific transaction should have "duplicate" next...

Hi All, Need some help with a large data set that my team handles each month (sample attached). It is rather manual and I have tried, and failed to overcome the manual aspect so am reaching out to anyone that may have had an issue like this in the past or if not, has any good suggestions...

Right, I have attached an extract of those 23K rows which is my dataset. I've had to delete majority of the rows as its just struggles to attach. Each row has a transaction "DocumentNo". Each will have its own start and end date and those are the ones i require a rollout schedule for according...

@MajP - thanks for that offer. If i do i most certainly will!. Frustrating thing I'm facing at the moment is running the query. Have over 23K rows which are going calculate at least 10 extra rows for the future release dates. I've put my first query into a made table to see if it speeds it up...

Thanks so much both for your help! Greatly appreciated. @MajP @CJ_London

Hi thank also for your input, however i am no Access expert by any means and am slightly stumped on what "admCount" field is/how its calculated along with the [counter] field. If possible do you have a mock DBase with this in so i can visually understand what the mechanism/logic is? Thank you :)

Hi thank you so much for your help! Let me try this out and see if I get the intended results. if I continue to struggle would it be useful if I could show you via a zoom call? hopefully I will be able to resolve my issue with your above solution. My initial one I was getting Tied up in...

Hi all, I was wondering if someone can assist me with a function I can use in my query which will allow me to calculate the release amount of a prepayment each month until the prepayments dates elapse. Example: current period date: 31 Dec 2020 Prepayment Value $170 Term Start Date: 07 April...