>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

You might want to try changing your WITH to a WHERE.