Exporting Yes/No fields to text

[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

 

[John Nurick]

Hi Bill,

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

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

 

[Dancing Bear]

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