Save report in Excel

[FoxProProgrammer]

Hi folks,

My report has about ten fields, one of which is a check box whose control source is a Yes/No field. I save the report output to an Excel file by selecting Office Links on the Tools menu. All the fields except the Yes/No field appear in the Excel file. Does anyone know if this is a limitation of Access, or did I do something wrong?

Thanks!
dz
dzaccess@yahoo.com

 

[VicM]

FPP:

I've never used this technique before, but from what I can see the Office Links option you are using is meant to be a table analyzer of sorts. Although, I'm not quite sure what it does.

I don't think it's meant to be used for putting a copy of the report into Excel. You'll note that if you have a header in the report, that information never makes it to Excel.

If you could give a bit more information on what your desired endpoint is, we might be able to make helpful suggestions.

HTH,

Vic

 

[FoxProProgrammer]

Hi Vic,

I want to export the report output to Excel so I can analyze the data and publish a report for our customer. The report contains a column that indicates if the unit under test (UUT) passed or failed. One thing that I need to do is count how many UUTs passed and how many failed. The report also contains a Yes/No field that indicates if the UUT was previously tested. I use that to determine how many reworks passed and failed. I suppose that I could do all this in Access instead of Excel. Perhaps I should approach it from that angle, but I am much more familiar with data crunching in Excel than in Access. I came up with a workaround to my problem by using a text box instead of a check box. The "Yes" or "No" data exports to Excel properly, and I use an IIf statement in the spreadsheet to test for "Yes" or "No", and count each. I'll take a look at the summation functions in Access to see if I can figure it out. It would be nice to automate the counting, and include the results in the Access report.

Thanks for any advice on how to do this.
dz
dzaccess@yahoo.com

 

[FoxProProgrammer]

By the way, I didn't even notice that the header information didn't get exported into Excel until you mentioned it. However, even when I exported the report output to Excel through the File Save As/Export menu option, the header wasn't saved in Excel. It looks to me like the Office Links menu is just a shortcut to save the report output in Excel or Word format. I don't see any difference in the output between using Office Links and the Save As/Export menus.

Best regards,
dz
dzaccess@yahoo.com

 

[VicM]

dz:

You might want to persue creating reports in Access. It seems the way you approached the task might be a lot more labor intensive than having an Access report do it all.

My next suggestion was going to be exactly what you did. You know what they say, "Great minds, think the same."

Good luck.

Vic