Query excessive motel expenses

[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

 

[KARL DEWEY]

Try this --
Expr3: [LODGING] - ([DAYS]*150)

 

[John Spencer]

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
'====================================================