excel style formulas in query criteria

Originally Posted by Ron Coderre

There are a few ways you can approach your criteria.

Try playing with one of these:
WHERE MID([PartNum],4,2)="45"

WHERE [PartNum] LIKE "???45*"

WHERE LEFT([PartNum],4) LIKE "???45"


Does that help?

Thanks, I am getting error "invalid syntax" when entering as above. If there something missing?
I am entering it into the design view - criteria field.