G
Guest
Hi. I'm working on putting a report together, and one of the items in the
detail of the report shows the values of an options box from the table. The
problem is, the data showing is the numerical value of the information I'm
looking for...example
option 1 is set for "phone"; in the report, value reporting is "1"
option 2 is set for "fax"; in the report, value reporting is "2"
I have a total of 6 different "select only 1" options.
Can I have Access report back "phone" and "fax" and whatever else I have
instead of the numerical values?
I thought about putting in a text field and having as the control source:
=Iif([Order Type]=1,"Phone",Iif([Order Type]=2,"EDI",Iif([Order
Type]=3,"AVL",Iif([Order Type]=4,"XML",Iif([Order Type]=5,"FAX",Iif([Order
Type]=6,"BARF",""))))))
The formula was accepted by Access, but it reported back the value "#ERROR"
Any help would be appreciated...I'm VERY limited in my ability for VB.
Thanks.
detail of the report shows the values of an options box from the table. The
problem is, the data showing is the numerical value of the information I'm
looking for...example
option 1 is set for "phone"; in the report, value reporting is "1"
option 2 is set for "fax"; in the report, value reporting is "2"
I have a total of 6 different "select only 1" options.
Can I have Access report back "phone" and "fax" and whatever else I have
instead of the numerical values?
I thought about putting in a text field and having as the control source:
=Iif([Order Type]=1,"Phone",Iif([Order Type]=2,"EDI",Iif([Order
Type]=3,"AVL",Iif([Order Type]=4,"XML",Iif([Order Type]=5,"FAX",Iif([Order
Type]=6,"BARF",""))))))
The formula was accepted by Access, but it reported back the value "#ERROR"
Any help would be appreciated...I'm VERY limited in my ability for VB.
Thanks.