Criteria does not work on a calculated expression

  • Thread starter CDG via AccessMonster.com
  • Start date
C

CDG via AccessMonster.com

I am working on a query that sums 2 fields separately. I created an
expression to calculate a percentage based on these 2 sums - sum of column 2
/ sum of column 1. I set the format to percentage. The sums and calculation
of the percent work fine. I now need to tell the query to only display
records that have a percentage of 80% or above. When I place >=80 or >=80%
in the criteria area, an error message is displayed. I also tried this in a
filter and did not have much success. Any ideas on how I can get this to
work?

Thank you.
 
K

KARL DEWEY

A percentage is a decimal fraction of 1. One hundred percent is one times
the number. Criteria for 80% must be entered as 0.8 as 80 is 800%.
 
C

CDG via AccessMonster.com

I did try the fraction in the criteria and it did not work. This is a
calculated expression field and it seems as if nothing is working to display
the records I need. The 2 columns are sum (aggregates). Any other ideas?


KARL said:
A percentage is a decimal fraction of 1. One hundred percent is one times
the number. Criteria for 80% must be entered as 0.8 as 80 is 800%.
I am working on a query that sums 2 fields separately. I created an
expression to calculate a percentage based on these 2 sums - sum of column 2
Click to expand...
[quoted text clipped - 6 lines]
Thank you.
Click to expand...
Click to expand...
 
Top