querying a query as a row source help

[hollyh]

Okay so I am trying to run a query where the row source on a table references another query of a table with the categories, yes, no, don't know

i would like to convert these to a numerical value in a new query, iif statements do not work. am i missing something obvious thanks.

 

[John Big Booty]

I'm not sure how you are currently doing this, but if you use an Option Group these values would already be being stored as numbers.

 

[hollyh]

Hi Sorry, I'm confused. this is not for a report but for a query..can you do it in the query?

 

[John Big Booty]

How are you currently storing the values for Yes, No, Don't Know?

 

[hollyh]

Okay sorry I figured something out

The person who made the database (not me)

created a main table with a column SMOKING
linking to a query of another table
called YNDK with ID autonumber, then yes..no..don't know

I would like to convert these values to either 2 for yes or 1 for no or null/blank

 

[John Big Booty]

So what value is actually being stored in the Smoking field?

 

[hollyh]

text

yes
no
don't know

in a drop down box

 

[John Big Booty]

So you have a table that contains the values; Yes, No, Don't Know, and presumably an ID for each, I'll guess, 1, 2, 3, and the corresponding field in your main table is storing Text

 

[hollyh]

i am dyslexic

i must've typed something wrong it works. thanks

 

[John Big Booty]

Glad you got it sorted