Numerical query criteria and quotation marks
Asked By PD
20-Nov-09 04:50 PM
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 will not it let me modify the existing one?
Thanks,
--
PRD
In query design view try deleting the field, save, and then put it back.
KARL DEWEY replied to PD
20-Nov-09 06:18 PM
In query design view try deleting the field, save, and then put it back.
--
Build a little, test a little.