in a query having the between dates and also a sum

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Asha - 10 Nov 2005 11:56 GMT

I am trying to create a query where the user will require to enter the from
and to date and also the query to create a sum of the amount field.
When I apply the sum to the field required I get 0 amount in my total field
that I apply the sum to.
greating appriecate any help

Reply to this Message

Jeff Boyce - 10 Nov 2005 13:03 GMT

We can't see how you've tried to do this. Please post the SQL statement ...

Signature

More info, please ...

Jeff Boyce
<Office/Access MVP>

> I am trying to create a query where the user will require to enter the from
> and to date and also the query to create a sum of the amount field.
> When I apply the sum to the field required I get 0 amount in my total field
> that I apply the sum to.
> greating appriecate any help

Reply to this Message