field to return concatenated fields if record meets max criteria

[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 #########

 

[Clifford Bass]

Hi,

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

Clifford Bass