Right Function

[jbphoenix]

In my query I have a field that contains an id. The id consists of 8 characters. I need all part to find all parts where the last character in the string is an "F". This is how I have the query setup right now.

Field: Finished Good:Right([Part]![User_8],1)
Criteria: "F"

When I run the query I get an error - ODBC call failed. ORA-00936:missing expression (#936).

Why am i getting this error?

 

[Brianwarnock]

The space in the field name Finished Good probably, never have spaces in names, also why [Part]![User_8],

Try
finished_good: Right([User_8],1)

Criteria F


Brian