Yes you can in Access 2010 or greater. It might be possible in earlier version but that I am not sure of.
The key is the Expression "Builder" and this can be found in the Query Design Tool. Below are a few screen grabs that might be of help to find it and use it.
Good Luck,
Tracy