How to use slash (/) in query column name

[VicM]

Hi,
I'm using Access 2010 on a Win 11 pro box.
Was wondering how to use the slash (/) as part of a column name in a query.

I have a DB containing all books I've read or possess, that are to be read. The main table has a Yes/No field labeled Non-Fiction.
I've built a query that indicates all the books which have been read so far. I wanted to add the Non-Fiction field to the query using the following: F/NF:IIF([Non-Fiction]=False, "F","NF"). When I run this query, the column header appears just as expected, but all the data in the column shows as a blue box with a white hyphen in it.

If I change the criteria to: F or NF:IIF([Non-Fiction]=False, "F","NF"), the data appears correctly. If I change the criteria to: F\NF:IIF([Non-Fiction]=False, "F","NF"), again the data appears correctly and the same if I substitute a hyphen for the slash (/).

Is if possible to have the header appear with the forward slash? Is there any workaround?



Thanks,
Vic

[June7]

Advise not to use spaces nor punctuation/special characters in naming convention.

Odd thing is, I have no problem with query alias fieldname using / character.

Additionally, / aligns data right and with \ aligns left same as is normal for text.

The =False is not necessary. Could use: IIf([Non-Fiction], "NF", "F")

Could do this calc in textbox on report. Label caption can be F/NF.

[Welshgasman]

Works fine for me as well.

[VicM]

Thanks for your replies. But the question I have is: the data you display under that heading a yes/no type?

[VicM]

Forgive me folks. I went back and was going to take a screen shot of what I was talking about. Low and behold, it now works!! Don't have a clue why it didn't work the first time I was working with it.
Again, thanks for your indulgence.
Vic