Hi,

I hope someone can help this is infuriating me as I am by no means an Access expert , I'm just above beginner.

I am putting together a databse for our Credit Controllers to manage their arrangements to pay arrears.

The Main table consists of the fields.

CustNumber---Surname---Promise Amount---Actual Amount---Date

13456 Nakamura £25 £20 20/09/05

45323 Petrov £55 £55 13/09/05

21245 Hartson £23 £21 21/09/05

67543 Sutton £45 £26 25/09/05

23541 McGeady £50 £50 24/09/05

This table is input by a form.

What I want to do is to produce a Query which will total the Promise Amount column and The Actual Amount column using a Date Parameter.

For example I want to know how much has been brought in between 20/09/05 and 25/09/05 therefore producing the result that I'll get a total of £143 for the Promise Amount Column and £117 for the Actual Amount Column. I have tried using the "sum" in Totals, but I think the date parameter is affecting that, the date parameter query I'm using is :

Between [Enter the beginning date:] And [Enter the ending date:]

I'm using Access 2000. Can anyone help?

Thanks in advance

Steph

Sounds like a simple totals query where you sum the numeric fld and a 'Where' on the date fld using a 'between' for the date range you need... :confused:

:(

Afraid no luck.

See attached Gif

What happens? (I think you need to 'un-check' the display box in the third col (?)