Exporting an Access report into Excel
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
|