Re: Where Clause in OpenForm statement

"Mike Charney" <nothing@xxxxxxxxxxxxxx> wrote in
news:Woapg.125616$dW3.100006@xxxxxxxxxxxxxxxxxxxxxxxxxx:

I am having trouble with the where clause in an openreport
statement in an Access Data Project.

DoCmd.OpenReport "rptAllRecords", acViewPreview, , "[active]="
'True'

When I hit the button that is supposed to open the report I
get the following error:


Does anyone know what the problem is?


"[active] = " 'true' has a doublequote wrong.

if active is a text field withe the word true in it, then

"[ACTIVE] = 'true'"

if it's a boolean field,
"[ACTIVE] is true" OR "[active] = 1" will work
"[active] = true" also works in JET SQL, not sure about server.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

.

Quantcast