field to return concatenated fields if record meets max criteria

  • Thread starter Thread starter PAR
  • Start date Start date
P

PAR

I have a summary report by category, for each category I have ave price & max
price. I need to show the lot number and name of lot if it sold for maximum
price.

Tried
iif([Price] =Max([Price]), ([Lot No]&' - '[Name]),)

but I get #########
 
Hi,

You need something after that last comma. If you do not want to
display anything use Null or "".

Clifford Bass
 
Back
Top