Invalid Vertical Bar Error

[Guest]

I created a query to select Days Difference and I keep getting this vertical
bar error:

Invalid use of vertical bars in query expression
'DateDeff("d"|[date_opened]|[date_closed])& "Days - " &
Format(DateDiff("h"|[date_opened]|[date_closed])Mod 24) & " Hours"'.

I've gotten this error in the past when I try to modify a crosstab from a
Access wizard. Are there any patches or any solutions? I can't modify the
query.

 

[Ken Snell [MVP]]

Change the pipe characters ( | ) to commas.

 

[Guest]

Thanks for the quick response.

I've tried that but I get another error "The expression you entered contains
invalid syntax"

Change the pipe characters ( | ) to commas.

--

Ken Snell
<MS ACCESS MVP>

I created a query to select Days Difference and I keep getting this
vertical
bar error:

Invalid use of vertical bars in query expression
'DateDeff("d"|[date_opened]|[date_closed])& "Days - " &
Format(DateDiff("h"|[date_opened]|[date_closed])Mod 24) & " Hours"'.

I've gotten this error in the past when I try to modify a crosstab from a
Access wizard. Are there any patches or any solutions? I can't modify the
query.