Option Group Stupid Question!

[Tooom]

Hello, I have run into a bit of a problem with my database...

I have a option group relating to reviewal status as you can see here:

This toggle box however outputs to my table in a number format (Where not reviewed = 1, Under Review =2, etc..). As you can see here where the column is "Strategy Status"

Is there a really easy way to get those numbers to be displayed as the text they represent? I have been down the macro and vba route and got completely lost.

Feels like it shouldn't be too difficult but couldn't do it via the option groups properties, the lookup and relationship on the table view, or (to my knowledge anyway) via a query

 

[pbaldy]

AFAIK an option group can only store a numeric value. Simplest solution might be a table with 2 fields, the numeric value and the text value. Then in a query you can join that table to this one and return the text value.

 

[Tooom]

pbaldy ok thanks that seems sensible will see how I go with it

 

[pbaldy]

No problem, post back if you get stuck.

 

[Tooom]

I'm stuck on the "Then in a query you can join that table to this one and return the text value" bit. I have tried mainly googling "lookup query" and "match data query" but they seem to be different things.

Could I ask for a kick in the right direction? I have set up my table relationship between the new reference table (Table 2) and my Major Equipment table as below:

My query: Do I need something in the criteria to have referenced values appear as the text?

And the new reference table you suggested (Table 2)

So Lost!!!

 

[pbaldy]

I wouldn't think that should be an append query. Try changing it to a Select query. That will make the Append To line go away, and just add the desired fields from the major equipment table.

 

[Tooom]

Hi tried that before but I get a mismatch surely because there are alot more major equipment items than items in my reference table 2?

 

[pbaldy]

Is the data type of the Strategy Status field numeric? That error could be caused by incompatible data types in the join. Also, does every record have a status?

 

[Tooom]

You were right Yipppeeeee! Wasn't set to number =))

 

[pbaldy]

Glad you got it working!