access error - help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i keep getting this error: Function isn't available in expressions in query
expression '(Format([Date],"DDDDD"))'

my database was working fine and now half of my dates do not display and my
charts are not working due to this problem.

please help.
 
How are you trying to use [Date]? Do you have a field you named "Date" or
are you trying to use Format against the function call to get today's Date?

"Date" is a reserved word and cannot be used as field name. If you are
trying to return Today's date (calling the Date function), drop the square
brackets.
Also, four d's return the day of the week spelled out. Five d's are
meaningless.
i keep getting this error: Function isn't available in expressions in query

expression '(Format([Date],"DDDDD"))'

my database was working fine and now half of my dates do not display and my

charts are not working due to this problem.

please help.
 
Back
Top