Hi , me again, another really quick question.....

Is there some way of getting Seek to look at more than one index.

I have a table, which contains a ID field, Branch Name field, and Date
field, used for collecting stats from our branches every week.

I want to be able to search this table for an ID where the Branch name
equaled "blah blah blah" and the date field equaled "blah blah"

So, it's easy to use seek on 1 index, but is it easy to seek on 2 indexes.

Andy.

Probably you'd be better off using a query though.

-- Jim Ferguson, FMS
   http://www.fmsinc.com