Some of the fields in my table are:
ID
AccountName
AccountID
Material
Revenue
Sold Date
I'd like to create a query with a calulated field. The field would be called Revenue Range. I want the Revenue Range results to be as follows:
Revenue Revenue Range
<=$1000 1K or Less
<=$100000 1-100K
<=$250000 100-250K
>=$250000 Over 250K
My attempt rendered an error. What is wrong with expression I wrote?
Revenue Range: IIf([tblAccounts]![Revenue]<=1000,"1K or Less",([tblAccounts]![Revenue]<=100000,"1-100K",([tblAccounts]![Revenue]<=250000,"100-250K",([tblAccounts]![Revenue]<=>=250000,"Over 250K",""))))
ID
AccountName
AccountID
Material
Revenue
Sold Date
I'd like to create a query with a calulated field. The field would be called Revenue Range. I want the Revenue Range results to be as follows:
Revenue Revenue Range
<=$1000 1K or Less
<=$100000 1-100K
<=$250000 100-250K
>=$250000 Over 250K
My attempt rendered an error. What is wrong with expression I wrote?
Revenue Range: IIf([tblAccounts]![Revenue]<=1000,"1K or Less",([tblAccounts]![Revenue]<=100000,"1-100K",([tblAccounts]![Revenue]<=250000,"100-250K",([tblAccounts]![Revenue]<=>=250000,"Over 250K",""))))