Can't Get Rid Of Quotes

[Brad]

Thanks for taking the time to read my question.

In my query design I want to have the following critera
in the criterial line for a field

=([qryINGRED]![Per kg (CAD)]/10)-0.5 And <=([qryINGRED]!

[Per kg (CAD)]/10)+0.5

I use the builder, or write it myself, but either way,
when I leave the Criteria line for that field, I get

=([qryINGRED]![Per kg (CAD)]/10)-"0.5" And <=

([qryINGRED]![Per kg (CAD)]/10)+"0.5"

Quotes around the 0.5 Why is this happening?

I can't get rid of the quotes.

Thanks again for the help.

Brad

p.s. I didn't name the fields, I am fixing this one up.

 

[Brad]

I figured it out.

Once of the queries was a union query, and some text was
going into a number field. That is where the quotes were
coming from. The field has to hold all numbers for the
quotes not to appear.

Brad

-----Original Message-----
Thanks for taking the time to read my question.

In my query design I want to have the following critera
in the criterial line for a field

=([qryINGRED]![Per kg (CAD)]/10)-0.5 And <=([qryINGRED]!

[Per kg (CAD)]/10)+0.5

I use the builder, or write it myself, but either way,
when I leave the Criteria line for that field, I get

=([qryINGRED]![Per kg (CAD)]/10)-"0.5" And <=

([qryINGRED]![Per kg (CAD)]/10)+"0.5"

Quotes around the 0.5 Why is this happening?

I can't get rid of the quotes.

Thanks again for the help.

Brad

p.s. I didn't name the fields, I am fixing this one up.
.