Hi Nick.

>My primary problem is that the value button appears for sfquery, but when I click the value button there is no value on some fields , however the same field has a values in the report wizard when I am initially selecting fields for the report (step 2 data selection) and click on value button.

The only thing I can suggest is tracing the Init method of SFGetValues to see what's happening when getting the unique values for the field.

Doug