Select and sum records before a given date

[JulieL]

I'm using a query to work out an account balance. I want to find out the sum
of all transactions before a given date. The date is entered by means of a
table before running the query. I can get the sum of all transactions, and
the sum of transactions between a pair of dates, but not just up to this
date. Using the totals row I have AmtReceived set to sum and Date
<=Forms!SCStatement!BBF. PLease can somebody tell me why this doesn't work?
I'm going slightly mad.

 

[Jeff Boyce]

Julie

What happens if you substitute an actual date in the query's selection
criterion? Does it work properly?

Do you get an error message when you try to use what you described? What
does it say?

If you refer to a form in your query's selection criterion, that form has to
be open.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[JulieL]

Hi Jeff

Sorry to take so long to respond. I have resolved the problem - I simply
had a type mismatch. Obviously spent so long staring at it I couldn't see the
wood for the trees! Thanks anyway

Cheers
Julie

Julie

What happens if you substitute an actual date in the query's selection
criterion? Does it work properly?

Do you get an error message when you try to use what you described? What
does it say?

If you refer to a form in your query's selection criterion, that form has to
be open.

Regards

Jeff Boyce
Microsoft Office/Access MVP