Can't Get Rid Of Quotes

  • Thread starter Thread starter Brad
  • Start date Start date
B

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]!
Click to expand...
[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 <=
Click to expand...
([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.
 
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]!
Click to expand...
[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 <=
Click to expand...
([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.
.
Click to expand...
 
Back
Top