View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default 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