There might have been a question like this but I cannot find.
I use option buttons in the form but in the report I want to see text instead of numbers.
How shall I do it?
AlexandraK 0 Newbie Poster
AlexandraK 0 Newbie Poster
I did it, I did it! Yoohoo! :icon_cheesygrin:
vb5prgrmr 143 Posting Virtuoso
Glad you were able to solve it yourself, but why did you not post your solution so others could learn from it or why have you not marked your thread as solved?
Good Luck
AlexandraK 0 Newbie Poster
So,
I'm sure there must be an easier way but I've never learnt VB or MS Access.
On my form I have an option group with 7 option buttons.
When any of them is chosen, Access keeps the data as a value.
The problem was that when I made a query based report, I saw those values only instead of the text.
So, I created a new query and I "translated" the value back to text by an expression coloumn.
Example:
Paying method:
(1) Check
(2 )Mastercard
(3) EFT
(4) ART
(5) Cheque
(6) Visa
(7) American Express
Expression in the query:
PM: IIf([Paying method]="1","cash",(IIf([Paying method]="2","M/C",(IIf([Paying method]="3","EFT",(IIf([Paying method]="4","ART",(IIf([Paying method]="5","Cheque",(IIf([Paying method]="6","Visa",(IIf([Paying method]="7","Am Express",0)))))))))))))
Finally I created a report based on this new query and I grouped the data by the text of [PM] instead of the value of [Paying method].
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.