Problems with query

[Antony26]

This is probably an easy one for you guys but i'm a bit of a novice on access.
The problem is i'm doing my payslips on access and I know what I want it to do but can't do it. I want a running total for Sal,Tax and NI, so whatever record (payslip) I look up it displays the Sal, Tax, and NI iv'e paid so far to date.
Any help would be appreciated

Antony

 

[FoFa]

Does the table that holds the SAL/TAX/NI contain date data so you can select it by a date or daterange?
Is there any other criteria for selecting which SAL/TAX/NI gets included in the totals?

 

[wkalo]

Hi There

If You Attach Sample Database It Will Be Easier To Understand Your Request And To Help Much Faster....