T
the8thdove
Can I convert yes/no boxes in a form to show the text title in a query or
mail merge in word
mail merge in word
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick B
Not sure what you mean. If a field contains a Yes or No value, you wnat it
to instead show the "text title"? What is the "text title". Would it only
do this if the value was yes? Or no? Why bother to have a yes/no field if
you want to show something else?
More details, please.
Rick B
to instead show the "text title"? What is the "text title". Would it only
do this if the value was yes? Or no? Why bother to have a yes/no field if
you want to show something else?
More details, please.
Rick B
T
the8thdove
I'm sorry that might not have been clear.. I am registering school districts
for their open positions. I created a form so that I could just click on the
areas they were hiring in i.e. a yes not box. Now that I am finished
registering the school districts, I would like to run a query to see what
school districts registered for the various subjects. But when i run the
query to merge to a word document it only show true,false in the areas and
not the subject areas they chose. Is there a way I can show the subject they
chose instead of it saying true/false?
for their open positions. I created a form so that I could just click on the
areas they were hiring in i.e. a yes not box. Now that I am finished
registering the school districts, I would like to run a query to see what
school districts registered for the various subjects. But when i run the
query to merge to a word document it only show true,false in the areas and
not the subject areas they chose. Is there a way I can show the subject they
chose instead of it saying true/false?
R
Rick B
Ah. It seems that you would want to pull the appropriate fields to the Word
document and just place a literal at the top of the columns so you have the
jobs listed across and the schools down the page, with the checks where
appropriate.
You could modify your query to pull the school name, then in the next column
write an IF statement to pull the literal, instead of the yes/no if the
value is true. Youd have to do this for each field (job name) though. Your
column would contain something like this...
JOBJANITOR: IIF([Janitor],"Janitor","")
What this does is...
it says to return a new field and name it "JOBJANITOR". For this field,
look at my table and if the value in the field [Janitor] is true, return the
literal "Janitor". Otherwise, return a blank. You would need to modify it
to include the name of your field (replace [Janitor]) and also what you want
the name to be (which is what is before the colon. You'd need to add a
column for each job in your database.
Hope that helps. I'm sure there are other ways, but this will do what you
asked.
Rick B
document and just place a literal at the top of the columns so you have the
jobs listed across and the schools down the page, with the checks where
appropriate.
You could modify your query to pull the school name, then in the next column
write an IF statement to pull the literal, instead of the yes/no if the
value is true. Youd have to do this for each field (job name) though. Your
column would contain something like this...
JOBJANITOR: IIF([Janitor],"Janitor","")
What this does is...
it says to return a new field and name it "JOBJANITOR". For this field,
look at my table and if the value in the field [Janitor] is true, return the
literal "Janitor". Otherwise, return a blank. You would need to modify it
to include the name of your field (replace [Janitor]) and also what you want
the name to be (which is what is before the colon. You'd need to add a
column for each job in your database.
Hope that helps. I'm sure there are other ways, but this will do what you
asked.
Rick B