G
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.
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.