calculation

[vasu1211]

ocity ostate dcity dstate carrier price
A B C D X 1200
A B C D Y 1500
A B C D Z 2000

BASE Price for this lane is 2500



This is a sample taken out from my report. Now i want to
calculate savings such that savings= base price- lowest price among all the carriers. ie in this example it will be savings= 2500-1500. These values are different for different lanes. How do i put this calculation in form of an expression.

 

[TheAceMan1]

How are ya vasu1211 . . .

Have a look at the [blue]DMin[/blue] aggregate function! . . .

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[dhookom]

In your report footer, you should be able to use an expression like:
=2500 - Min(price)

Apparently we don't need to know where "lane" and "2500" come from ;-)

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]