Hi, I am trying to use VB for macros in Word, but cannot find out how to select records for merging from VFP. All records are no problem, with

SQLstatement:="Select * FROM myfile",

but how do I qualify the statement to select specific records, or a range of records? I have tried adding WITH name >= Olsen AND name <= Petersen', but all I get form Word is a msg that it cannot open the VFP file. The Help file is not very informative either, so I am stuck. I did such things in Word 6 with Wordbasic...

Rolf