Exporting Yes/No fields to text

  • Thread starter Thread starter Dancing Bear
  • Start date Start date
D

Dancing Bear

Table includes 7 fields - each for one day of week Sunday through
Monday.

They are Yes/No fields.

Need to export the results of a query that includes those fields to a
text file, but I don't want the text file to be ones & zero's.

If there is a check (yes) for Monday and Tuesday, I get
0,1,1,0,0,0,0.

What I would like to see in the text file is
0,Mon,Tues,0,0,0,0

Is there a formatting expression that can do this?
Could you please tell me what it is?

Thanks for any help
Bill
 
Hi Bill,

Try something like this for each field (replacing XXX with its real
name):

fXXX: IIf(Nz([XXX],0)<>0, "Monday", "0"))
 
Thanks a ton!
It works great!
Bill

Hi Bill,

Try something like this for each field (replacing XXX with its real
name):

fXXX: IIf(Nz([XXX],0)<>0, "Monday", "0"))

Table includes 7 fields - each for one day of week Sunday through
Monday.

They are Yes/No fields.

Need to export the results of a query that includes those fields to a
text file, but I don't want the text file to be ones & zero's.

If there is a check (yes) for Monday and Tuesday, I get
0,1,1,0,0,0,0.

What I would like to see in the text file is
0,Mon,Tues,0,0,0,0

Is there a formatting expression that can do this?
Could you please tell me what it is?

Thanks for any help
Bill
Click to expand...
Click to expand...
 
Back
Top