RE: Y/N in a text field to a Y/N Datatype field HOW?

Great it worked Thank you so much. So I dont need to make a seprate query
just bring down my other fields and add that expression for all the fields
that need to be converted correct? Thanks again

"Ofer Cohen" wrote:

Yes, in the same way

IIf([dbo_tblProductversion].[Attachments]=True,"Y","N")
--
Good Luck
BS"D


"troy" wrote:

OK I will. You know I just looked at the table where the data is comming from
and that table has the correct data type as yes/no. So what I need to do is
to send that data to a table that has the fields set up as a text data type.
It looks like they are manually typing in either Y or N into that table. How
do I convert a dtattype of y/n to text. Is it the same way or? Thanks for
being so patient!

"Ofer Cohen" wrote:

It should, before you run any update query you can try it with a simle Select
Query

Select [dbo_tblProductversion].[Attachments] ,
IIf([dbo_tblProductversion].[Attachments]="Y",True,False) As NewAttachments
From dbo_tblProductversion

Check the new field values if it answer you question, if it does the change
it to update query

In any case back up your data first
--
Good Luck
BS"D


"troy" wrote:

Does this expression look like it would work? I have about 5 fields the same
way. Driving me nuts
IIf([dbo_tblProductversion].[Attachments]="Y",True,False)

Thank you so much for your help!

"Ofer Cohen" wrote:

Yes it will replace the Y and N text values to True and False, so you can
update the Yes/No field
--
Good Luck
BS"D


"troy" wrote:

I need to find the expression that will show me the results of every record
that has a Y or N in the "Attachment" field that holds the data (the Y or N).
What you gave me will do the trick?

"Ofer Cohen" wrote:

Try

IIf([FieldName] = "Y", True , False)

In that case every field that doesnt have "Y" in it will be False

--
Good Luck
BS"D


"troy" wrote:

How do you pull data (in a query) from a datatype "text" that is manually
typed in as either a Y or N so I can append or update to another field that
is set up as a Datatype Y/N field? I want to do an update query but dont know
the expression to do this. Can it be done? Can someone help? Thanks in advance
.

Relevant Pages