Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Exporting from Report Central to Excel | Excel Discussion (Misc queries) | |||
When exporting a report from Access to Excel columns misaligned | Excel Worksheet Functions | |||
Exporting data from access to excel | Excel Worksheet Functions | |||
exporting report to excel- Help! | Excel Discussion (Misc queries) | |||
importing/exporting from access to excel | Excel Discussion (Misc queries) |