Option stores numbers, need text

[AWilderbeast]

Hi,

I am using group options and they store a number instead of the vaules you typed in, is there anyway of making a group option that will store values and not numbers?

 

[ColinEssex]

You decode the numbers when you do a query and a report.

No need to post 3 times it leads to confusion

Col

 

[AWilderbeast]

yeah sorry was my browser refershing, then page not displayed then posting it.

how do i do a decode?

 

[neileg]

Hold the option number and the equivalent text values in a table and join this in your query.

 

[AWilderbeast]

i see what you mean, but dont know how to go about it, could you knock me up an example please

would be most appreciated

 

[neileg]

You are holding the option value in your table, 1,2,3 or 4. You need a table with 4 records, 1,2,3 and 4 with whatever text you want to use. In any query where you use the main table, add in the options table and join it on the option number. Then use the option text field to populate your query instead of the option value.

 

[AWilderbeast]

shit lol, i still dont know what you mean embrassin, im not dumb honest

 

[AWilderbeast]

shit lol, i still dont know what you mean embrassin, im not dumb honest

 

[ansentry]

Have a look at the attached sample;

 

[AWilderbeast]

thanks alot really apprectiate it