>Can I use a query for my data source for a VFP report instead of a table, like in Access( ewww! ), or is there a query/filter function in the table designer?
>
>Thanks.
Yes, you can use a cursor generated by query in VFP report. Something like

SELECT * ;
  FROM mytable ;
  WHERE <some conditions> ;
  INTO CURSOR mycursor

Just don't use alias in the fields references in report. There's also Query Designer in VFP. You can call it from VFP menu or from command window

Modify Query myquery

If query with name 'myquery' doesn't exist it'll be created.