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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

access error - help 2
Access #Error & Excel Pivot 0
code filing 5
Date format question - Regional Setting? 10
Access Query problem 1
Access 2007 Runtime Error 3075 5
OWC chart. Categories=dates 1
Access Access, problem with query. 5

Back
Top