getting "overflow" message when querying percentage

[scottsoo9]

I have a percentage of funds expended category and am trying to get all the funds that are 75% expended or greater.

I have been typing in the criteria section >=".75" and am getting an overflow message when i run the query. I have tried different variations of this like adding a percent sign with no such luck. What is the reasoning for the overflow message? Why cant I get it to work. Thanks, Scott

 

[DCrake]

Remove the quotation marks and try again.

David

 

[scottsoo9]

Still does not work. No matter what I do, I get an overflow message when I try to run the query.

 

[DCrake]

If you do not have any crirteria does the data display ok

David

 

[scottsoo9]

yes, I get 487 results. Does it have anything to do with the fact I have my results already in the percent format?

 

[Atomic Shrimp]

What calculated fields have you in the query? You mentioned a percentage field - could there be a division by zero problem here?

 

[scottsoo9]

my fields are

Dollars Auth: F15
Dollars Expended: F16
% Funds Expended: ([F16]/[F15])


and then i put >=.75 in criteria and get overflow message

 

[scottsoo9]

I am getting this information from a table from Excel that is linked to Access. I was told this is most likely the problem. Is this true? How do I go about correcting it? Scott