I have a option group that represents the stages of a project. The option group is in Form1 and the value of the option group is in Table1
I have a option group that represents the stages of a project. The option group is in Form1 and the value of the option group is in Table1
Do you have the option group values stored anywhere? If not you can use a switch function but it isn't as optimal as pulling it from a table.
So you could use
=Switch([FieldNameHere] = 1, "Option 1 Name", [FieldnameHere] = 2, Option 2 Name", [FieldNameHere] = 3, "Option 3 Name")
I started this thread and got called away and looks like it posted the start.
The option group values are stored in table 1. The labels on the form are as listed
Label Status (Option group value)
Ongoing 1
Development 2
Idea 3
Completed 4
When I run my report I want the projects group by Status, but I want a description (same as Label) rather than the number. I could change the option value to the name but I want them group in the order of 1,2,3,4.
I tried to create a second table with StatusDescription and link to the first table and then in the report reference StatusDescription
Table2
Status StatusDescription
1 Ongoing
2 Development
3 Idea
4 Completed
When I run the report a box pops asking for the StatusDescription parameter.
Thanks and sorry for the initial posting mistake.
I read about the Switch Function, but as you stated that is not the optimal methold
So, if these are related to the records in the report, then the status table should be in the report's record source and link from status ID to the table which stores the status ID. But the description needs to be what is included in the report's record source so that it can be chosen as the field to display for your status.
I hope that makes sense.
Yes that makes sense and I believe that is what I am trying to do. As long as I am on the right track then I will keep messing.
Thank you for your help.