invalid vertical bar

W

WuiChi

I receive a message that "The expression you entered has invalid vertical
bars(|). I am just modifying an existing query when I get this error
message. I have tried to use commas instead but I get a different error.
You omitted an operand or operator, you entered an invalid character or
comma, or you entered text without surrounding it in quotation marks.
This is the query field that I am trying to modify.
Days Old: DateDiff("d"|[Corporate Received Date]|[Today's Date])

Thanks for your Help.
 
J

John Spencer

The most commons separator characters are commas (,) or semi-colons (;).
Unless your computer is set to use some other character as the delimiter I
would try those.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 

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

IIF Condition 5
Vertical bar errors 1
Vertical Bar error 1
DLookup syntax in control on form 7
Invalid Vertical bar error 1
Execute code from string 9
Left function query error 2
How to change Number to Text 1

Top