Search results

Just one more thing, now I have had a chance to try this out... I am using this query as the record source for a form, which is opened with a filter to select diffrent users. I put "WHERE [Account ID]=1" in as an example of one user. I really need to do this for diffrent users. So if it is...

Thanks! I really appreciate this.

How would I go about using the If's? I understand what you are thinking of, i'm just not sure how I would go about implementing it.

I have a query, and I want a field that shows the current balance as of that transaction, eg: _________________________________________________________ |__Transaction ID__|__Type_______|__Amount__|__Balance__| |__1______________|__Deposit_____|__£10______|__£10_______|...