422,767 Members | 1,136 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 422,767 IT Pros & Developers. It's quick & easy.

Change option group inherent values

P: 13
Hello,

I have a form with an option group in order to classify some parameters. I have created a simple debug example in order to understand all the information https://www.dropbox.com/s/sh162n5sbm...oup.accdb?dl=0

The option group has three options (Excellent, good or spoilt). Access creates inherent values (1, 2 and 3) to save the selection information in the table as it can be seen in the following image:
https://www.dropbox.com/s/t2nl9uib6p...Group.png?dl=0
Note that the values cannot be changed to strings

When creating the excel, the following results are obtained:
https://www.dropbox.com/s/3s502hffht...lInfo.png?dl=0

Well, for the users, the information (1, 2 or 3) is not enough because they do not know what is the correspondence.

I have thought in applying a replace all VBA line code to substitute the values, but this is not a good approach.

Could you please help me with some ideas?

Thank you!!!!
Sep 12 '17 #1

✓ answered by Seth Schrock

Are you saying that you have 12 different fields, each of which can have the values of Excellent, good or spoilt (1,2 or 3)? If so, then you would just add the new table 12 times to the query editor (it will give all but the first one an alias) joining each one to a different one of the 12 fields and then you would once again only display the description fields, but in this case the description field from each of the 12 fields. I would recommend providing an alias for each of the description fields to make the export easier to understand.

If that isn't what you are describing, then I'm lost.

Share this Question
Share on Google+
5 Replies


Seth Schrock
Expert 2.5K+
P: 2,882
Probably the easiest would be to create a table with two fields: an ID field and a description field that allows you to link the 1,2, and 3 to the proper description. You can then create a query that joins the table that you are currently working on to this new table using the ID field and the field that your option group is linked to as the join fields. Then display the description field instead of the number field. You can then export this query to Excel.
Sep 12 '17 #2

P: 13
Hello Seth Schrock,

I will implement your solution in order to solve my problem.
Thank you!
Sep 13 '17 #3

P: 13
Hello again Seth Schrock,

I think your solution only works if only one field is being converted. Am I right or am I missing something?
In my case, I have a list of 12 fields associated to the option group
Thank you
Sep 13 '17 #4

Seth Schrock
Expert 2.5K+
P: 2,882
Are you saying that you have 12 different fields, each of which can have the values of Excellent, good or spoilt (1,2 or 3)? If so, then you would just add the new table 12 times to the query editor (it will give all but the first one an alias) joining each one to a different one of the 12 fields and then you would once again only display the description fields, but in this case the description field from each of the 12 fields. I would recommend providing an alias for each of the description fields to make the export easier to understand.

If that isn't what you are describing, then I'm lost.
Sep 13 '17 #5

P: 13
@Seth Schrock

It is exactly as you stated, 12 different fields each of which can have the values of Excellent, good or spoilt (1,2 or 3).
With the 12 new tables added to the query, I was able to finally finish this task.
Thank you!!!!
Sep 13 '17 #6

Post your reply

Sign in to post your reply or Sign up for a free account.