Access IIf function help

[drz]

Hello - hope someone can assist with this simple function - I'm stuck...
I'm creating a query, among others there are two fields named DSalePrice and DRetailPrice.
I want to create a new field that will return the lesser of DSalePrice and DRetailPrice.
The function I created is:

IIf([DSalePrice]<[DRetailPrice], [DSalePrice], [DRetailPrice])



I keep getting an error that says The expression you entered contains invalid syntax. You omitted an operand or operator, you entered an invalid character or comma, or you entered text without surrounding it in quotation marks.

Would appreciate any help. Schedule

[aytee111]

Show us the whole SQL string, this may not be where the error is occurring.