Invalid use of vertical bars error

G

Guest

I have Office Professional 2003, and kept getting an invalid use of vertical
bar when attempting to look at a query in Design view. I am able to open the
query in SQL view, and it is written with commas, but for some reason when
you switch to Design view the commas get changed to pipes. I download 2007
trial in hopes it wold fix the error. It didn't, and I have tried to open a
couple of queries in the Northwind 2007 example database, for instance the
inventory query, and I get the following error Invalid use of vertical bars
in query expression Nz([Quantity Purchased]|0) Any ideas, I have googled for
an answer and have found nothing.

Thanks in advance.
 
A

Allen Browne

Open the Windows Control Panel.

Under Regional Options, what character do you have defined as the List
Separator? That character may affect the way your arguments are separated.
 

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

Query design view - commas being changed to pipe characters 4
invalid vertical bar 2
invalid use of vertical bars in expression 1
Invalid Vertical bar error 1
Vertical Bar error 1
Vertical bar errors 1
access 2003/2007 - problems with unwanted pipe character 0
every query throws "invalid use of null" 1

Top