I am having trouble with using a #symbol in a field name. When i export the table to excel the # symbol is substituted with a .

I know that the # symbol is a wildcard.... can it be used as a field name?

You will have major issues if you want to use the # as a field name or as part as your queries etc will fall over.

In theory you can name a table field anything you want, BUT you will get into trouble somewhere along the line.

Access don't like:

-Reserved Words like Date, Now, Name, Mod etc.
-Spaces
-Special Symbols like @, #, $, ., etc

If you have somthing like this in your fieldnames you have to enclose [] around the fieldname if you want to refrence it.

I often use CamelCase for objects.

FirstName vs First Name

JR