yeah if the boss would allow me to do that I would.
If I create 2 remote views, then join them in 1 local view I can get that to work too but again doesn't want it done that way...ha

>Since this is just for a report, I would also just use SQL and forget the view. If this was for data entry as well, then I might have to work on getting the view to work. However, since VFP8 is about to be released, the CursorAdapter is now my preferred method. Bye-bye views!
>
>>aaaarrrrhhhHHHHH!!!!
>>
>>ok I tried what both of you guys suggested...I still get the same problem.
>>
>>What is even more strange is if I setup the 3 parameters with values that make it fail...the view does indeed fail and I get the error...BUT if I run the Select statement by itself (not in a view) with the same parameter values it works!!!
>>I've spent all day on this ooooone teenee weeene view I think I'm just going to give up and change my code around and hard-code the Select statement in the report...just doesnt make any sense that it doesn't work as a view (sometimes)..grrrrrrr. I'm quite frustrated I mean this is like a pretty simple view to begin with.