Access is adding quotation marks on its own

[DJ_DEF_CON_1]

I am working in a query. In the last few days something has happened where quotation marks are being added to any criteria I am adding. I have to go into SQL mode to delete the quotation marks.


Does anyone have any ideas?

 

[SQL_Hell]

I am working in a query. In the last few days something has happened where quotation marks are being added to any criteria I am adding. I have to go into SQL mode to delete the quotation marks.


Does anyone have any ideas?

Can you post the query? Is this an update / insert / parameterised query?

 

[DJ_DEF_CON_1]

It is a regular select query. Under one field I put >now()-30 and after I exit it looks like this >now()-"30"

 

[DJ_DEF_CON_1]

Please forget it. I have now noticed that this field is a text box, not a date field

 

[SQL_Hell]

It is a regular select query. Under one field I put >now()-30 and after I exit it looks like this >now()-"30"

hmmm strange!

I assume the field is date/time, and you are using the Query designer jobby.

Try to code the query in SQL mode, save it and see if it does the same.

also try brackets around the whole statement, like

(now() - 30)