MS Access Query Search Fails on Boolean

[jt]

I have a query that I would like to search on where my field is a boolean.

This is the error and the sql statment below,

Error: No value given for one or more required parameters.

SQL : SELECT * FROM [tablename] WHERE Red-Flag = True

Appreciate any help on this, since I am new to SQL.

Thank!
jt

[Bob Barrows]

jt wrote:

> I have a query that I would like to search on where my field is a
> boolean.
>
> This is the error and the sql statment below,
>
> Error: No value given for one or more required parameters.
>
> SQL : SELECT * FROM [tablename] WHERE Red-Flag = True
>
> Appreciate any help on this, since I am new to SQL.
>
> Thank!
> jt

a) Since you've used a non-standard character (-) in your field name, the
first thing to try is surrounding it with brackets :
WHERE [Red-Flag] = True

I was going to offer another option, but the more i think about this one,
the more I think that this will sove your problem. I think Jet is trying to
evaluate Red-Flag as the subtraction of the value contained in the Flag
parameter from the value contained in the Red parameter. In this case it's
not the correct interpretation from your point of view, but that's one of
the consequences of using non-standard characters in your object names.

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[roger]

"jt" wrote

> Error: No value given for one or more required parameters.
>
> SQL : SELECT * FROM [tablename] WHERE Red-Flag = True

Does "Red-Flag" mean [Red] minus [Flag]?

If it's one field I think I'd rename it "RedFlag"
or perhaps "[Red-Flag]" would work in the SQL.


--
roger

[jt]

Thanks! Work great.

jt

"Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
news:uja4UC5JEHA.1312@TK2MSFTNGP12.phx.gbl...

> jt wrote:

> > I have a query that I would like to search on where my field is a
> > boolean.
> >
> > This is the error and the sql statment below,
> >
> > Error: No value given for one or more required parameters.
> >
> > SQL : SELECT * FROM [tablename] WHERE Red-Flag = True
> >
> > Appreciate any help on this, since I am new to SQL.
> >
> > Thank!
> > jt

>
> a) Since you've used a non-standard character (-) in your field name, the
> first thing to try is surrounding it with brackets :
> WHERE [Red-Flag] = True
>
> I was going to offer another option, but the more i think about this one,
> the more I think that this will sove your problem. I think Jet is trying

to

> evaluate Red-Flag as the subtraction of the value contained in the Flag
> parameter from the value contained in the Red parameter. In this case it's
> not the correct interpretation from your point of view, but that's one of
> the consequences of using non-standard characters in your object names.
>
> Bob Barrows
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>
>