Query excessive motel expenses

  • Thread starter Thread starter Fly Boy 5
  • Start date Start date
F

Fly Boy 5

I'm trying to pick out cutomers with motel charges over $150 per day and
calulate the amouts that are over.

We have a maximum of $150 per day.
Expr1: [DAYS]*150 It displays the total in dollars.

Expr2: [Expr1]<[LODGING] It returns a -1 for customers that are above $150
per day. I need to be able to subtract the dollar amount of Expr1: from
[LODGING] to provide the amount over.

Thanks for your help
 
ADD Another calculated field
Field: DollarsOver: Lodging - (Days *150)

If you want to see just a number when it exceeds zero, then

Field: DollarsOver: IIF(Lodging-(Days*150)>0,Lodging-(Days*150),Null)


'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
Back
Top