Total greater that a number

[Kelleyz]

I have a query based on 2 tables that generate the monthly energy usage for
an account. When I run the report I only want to see the accounts that have a
total for the year greater that 60000.

 

[Duane Hookom]

Do you have a value in your report's record source that is the [total for the
year]? If not, you will need to create it in your report's record source so
that you can use it to filter your records.

 

[Kelleyz via AccessMonster.com]

In my report when I set it up through Wizard I totaled the usage year set for
each customer. And now what I want it to do is only show me the customers
that are >=60000.

Do you have a value in your report's record source that is the [total for the
year]? If not, you will need to create it in your report's record source so
that you can use it to filter your records.

I have a query based on 2 tables that generate the monthly energy usage for
an account. When I run the report I only want to see the accounts that have a
total for the year greater that 60000.

 

[Kelleyz via AccessMonster.com]

I figured it out. I needed a Where function for my billing date range to
make it total the usage column.

Thanks

In my report when I set it up through Wizard I totaled the usage year set for
each customer. And now what I want it to do is only show me the customers
that are >=60000.

Do you have a value in your report's record source that is the [total for the
year]? If not, you will need to create it in your report's record source so
that you can use it to filter your records.

I have a query based on 2 tables that generate the monthly energy usage for
an account. When I run the report I only want to see the accounts that have a
total for the year greater that 60000.