This question already has an answer here:
I have data like multiples of 40.
and so on.
I would like to label every record that is a multiple of 100. I have tried a couple of methods and can't get them to work either as a query in the label or as a select statement.
"STATION" = %00 RIGHT ("STATION", 2) = 00
I get invalid SQL statement.
Does anyone see what I am doing wrong?
Respectfully I did search and did not see any of the example questions you presented. However it still does not answer my question, re-stated, what am I doing wrong?