cardgunner
Registered User.
- Local time
- Yesterday, 23:33
- Joined
- Aug 8, 2005
- Messages
- 210
I have a field in the a query with the following:
% OVER NB: 1-([Monthly MTA Table]!NB/[main inventory table]!PRICE)
I then format the column in properties to percent
When I try to put anything in the criteria I get an error "Division by zero"
I want to only the records that are greater then 80%
% OVER NB: 1-([Monthly MTA Table]!NB/[main inventory table]!PRICE)
I then format the column in properties to percent
When I try to put anything in the criteria I get an error "Division by zero"
I want to only the records that are greater then 80%
