Prev: I am providing services to transfer money through my bank account.
Next: Faxing
From: WuiChi on 25 May 2010 17:07
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.
From: golfinray on 25 May 2010 17:10
Try:
datediff("d",[firstfield],[secondfield])
--
Milton Purdy
ACCESS
State of Arkansas


"WuiChi" wrote:

> 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.
From: John Spencer on 26 May 2010 09:48
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

golfinray wrote:
> Try:
> datediff("d",[firstfield],[secondfield])
 | 
Pages: 1
Prev: I am providing services to transfer money through my bank account.
Next: Faxing