Numerical query criteria and quotation marks

[PD]

I have a query that uses a criteria of >"269.9". I realized it was not
working because the format of the field being queried was text. I
successfully altered the format of the source field to double. Access will
not allow me to remove the quotation marks from around the "269.9" criteria.
It puts them back as soon as I tab off the field. If I create a new query it
works, but why won't it let me modify the existing one?

Thanks,

 

[KARL DEWEY]

In query design view try deleting the field, save, and then put it back.