Query Automatically Add Quote Marks in Criteria

[bioinformatic]

Hi all,

Microsoft Access is automatically adding quote marks in my criteria section of my query. I am searching for >=50. A few columns have >=50 and in some other columns Access corrects my expression to be >="50"

I've tried building a new query, loading a new table, and building a new database. 9 out of 20 columns show >="50" while the rest are correctly displaying >=50 in the criteria section.

I checked autocorrect options and I don't know why Access 2000 is doing this to my query.

All help is greatly appreciated.

Thanks,
Randy Wei

 

[MisterC]

It sounds like the fields' data type is set to text.

 

[bioinformatic]

Thanks MisterC. I thought it was clear that when I imported numbers, the field data type would have been automatically set to number. I think there were some null or blank values which may have caused the data type for that column to be set to text.

Thanks again