Query Percentages

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].
 
D

Duane Hookom

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Percentage Change 2
Formula for percentage calculation 1
Query to find the Percentage of items in a field 3
adding a field in a make table query 7
Blank or Null in a Cross Tab Query in Access 2003 2
Help writing formula for investing spreadsheet 0
Subquery 6
Calculating Percentages Using a Query 3

Top