Design the query using Access' query designer and test.