Query Percentages

  • Thread starter Thread starter Sharon
  • Start date Start date
S

Sharon

Why won't my queries recognize percentages? I created an
additional field to calculate a percentage.

ExcptRate: ([ExcpSum]/[smple_sz])

I tried to run queries to group the percentages:
= 0%
0.00% and =< 10%
10% and +< 25%
25%
Click to expand...

The prompt kept asking for the [ExcpSum].
 
Where does ExcpSum come from? Is this a field in a table?
I would use .25 rather than 25%.

_____________
Duane Hookom
MS Access MVP

Sharon said:
Why won't my queries recognize percentages? I created an
additional field to calculate a percentage.

ExcptRate: ([ExcpSum]/[smple_sz])

I tried to run queries to group the percentages:
= 0%
0.00% and =< 10%
10% and +< 25%
25%
Click to expand...

The prompt kept asking for the [ExcpSum].
Click to expand...
 
Back
Top