how do I write this expression in a query:Count = 1=$100.00, 2=$500.00,
G Guest Sep 9, 2007 #2 flyboy said: how do I write this expression in a query:Count = 1=$100.00, 2=$500.00, Click to expand... Try this: IIf([Count] = 1, 100, IIf([Count] = 2, 500, 1000)) Tom Lake
flyboy said: how do I write this expression in a query:Count = 1=$100.00, 2=$500.00, Click to expand... Try this: IIf([Count] = 1, 100, IIf([Count] = 2, 500, 1000)) Tom Lake
