KRISTIN
05-24-2002, 10:15 AM
I need to create a query which selects certain records based on the first two letters of the input in a certain field... for example, if i have a 'month' field, I want to select all records which start with MA... I have tried running a query with critera "Left([Month]), 2" but this selects only records which are only 2 letters long... thanks for any help
Kristin
Kristin