Are there any characters or symbols that will cause problems if I use them in my data?

There are several symbols used in the MS Access system (that Enviro Data is written in) that should not be used in your data. The use of these may cause errors because Access may treat them as actions or code to be acted on and can also cause problems with file names and paths. These symbols include:

. (period) This is OK when used as a decimal point but might cause problems elsewhere.
, (comma) This is generally not a problem but it depends on where it is. It can cause a problem in Site Name.
/ (forward slash)
\ (forward slash)
* (asterisk)
; (Semicolon)
: (colon)
! (exclamation point)
# (number, pound or hash tag)
& (ampersand)
- (dash) When used in numbers might result in subtraction. OK in site or stations names and other text.
? (question mark)
" (double quote or inches symbol)
' (single quote or foot symbol)
$ (dollar sign)
% (percent) This is acceptable for a reporting unit but within other data fields it is best spelled out.

#48Edited 3 months ago