Hi
I am trying to calculate a percentage amount based on a "Either/OR" condition.
The application is to give customers a percentage discount if their service is not working for a certain length of time. Example: If the time is > 6hrs AND < 36hrs then calculate 10% of the Monthly Bill and return this value, if > than 36hrs then calculate 15% of the Monthly Bill and return value. How does one do this in a query or report?
Regards
Darren
Thanks a lot, that worked fine.
[This message has been edited by gallagher (edited 01-21-2002).]
I am trying to calculate a percentage amount based on a "Either/OR" condition.
The application is to give customers a percentage discount if their service is not working for a certain length of time. Example: If the time is > 6hrs AND < 36hrs then calculate 10% of the Monthly Bill and return this value, if > than 36hrs then calculate 15% of the Monthly Bill and return value. How does one do this in a query or report?
Regards
Darren
Thanks a lot, that worked fine.
[This message has been edited by gallagher (edited 01-21-2002).]