I have a report with check boxes on it. When I export it to Excel 2002 I get
all the fields except the checkboxes (I would be happy if a got -1 and 0).
Any ideas less than changing the report to have text boxes for these fields
instead of check boxes.
Thanks,
Stan

Aside from converting your check boxes to text boxes that display True/False
there isn't a way to get those check boxes downloaded to your Excel file.

However, you could use MS Query and using the same record source as your
report (table/query) query the data into Excel, which you could then use as a
source for a pivot table report of some type.

Hope this helps...
--
Kevin Backmann


"Stanley" wrote:

I have a report with check boxes on it. When I export it to Excel 2002 I get
all the fields except the checkboxes (I would be happy if a got -1 and 0).
Any ideas less than changing the report to have text boxes for these fields
instead of check boxes.
Thanks,
Stan

Hi,

where is the data exported from?

Cheers,
Shane

"Stanley" wrote:

I have a report with check boxes on it. When I export it to Excel 2002 I get
all the fields except the checkboxes (I would be happy if a got -1 and 0).
Any ideas less than changing the report to have text boxes for these fields
instead of check boxes.
Thanks,
Stan