bioinformatic
Technical User
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
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