Filter problem

[cbende2]

Hello all,

I'm experiencing a error when I go to add a filter, "Syntax error in string in query expression "MyFieldName""

If I go to to the table where the field is located, I CAN apply a filter.

However, If I throw this single field on a form and switch to datasheet view, all of a sudden I can not filter it.

Additional info:
whenever I go to build a query with the field, it throws brackets around this field and no others... this is weird.

For example...

SELECT MyTable.field1, MyTable.field2, MyTable.[problemfield]
FROM MyTable

What's going on here?

NOTES: there is no space in field name, the field is a date field

[orange]

"Syntax error in string in query expression "MyFieldName""

How about showing us the table design, and the form and any related code that gives the error message?

[cbende2]

By table design I'm not sure what you're asking, I'm guessing you want me to show you my table in design view?
TABLE:
FORM:
QUERY:

SELECT AnnualTrackingTable.*FROM AnnualTrackingTable;

[ssanfu]

whenever I go to build a query with the field, it throws brackets around this field and no others... this is weird.

That is normal. The reason Access adds the brackets is because you have spaces in the field name. Should never use spaces in object names; only alphanumeric and the underscore.

Access would also add brackets around the field name "Plan Type" because of the space.

[cbende2]

Ssanfu, I know this is normal if you have spaces, but for the particular field 5500deadline, it puts brackets around it. That doesn't have a space, and it's the problem field.

[ssanfu]

I don't have In a copy of 2013, so (in a copy of the dB) try changing the name so it doesn't start with a number.... maybe "dte5500deadline" or "deadline5500".

Somewhere\somewhen I remember reading that Access might not like having field names the begin with a number. (but I could be wrong).