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