在MS Access中生成报告 [英] generating report in ms access

问题描述

我正在使用查询来获取ms Access中的数据.我想使用报告来打印数据，但是由于每页必须为两列的限制，我该怎么做?

I am using a query to fetch data in ms access. I'd like to print the data using a report, but with the constraint that it must be two column per page, how do i do this?

或者您是否可以建议我如何在ms Access中执行查询并以代码形式获取查询返回的记录，以便我可以以其他方式生成报告.

or if you could suggest how i executed a query in ms access and get the records returned by a query in code, so that i can make the report another way.

谢谢

推荐答案

(对不起，我使用n00b太多了，无法使用注释功能，因此即使不确定，我也将其作为答案发送)

(Sorry, I'm too much of a n00b to use the comment function, so I'm sending this as an answer, even though it's not definitive)

列技巧可能会起作用:报表的设计"视图中实际上只应具有一列控件.在设计视图中，确保只有Image1控件(摆脱了Image2控件)，然后调整报表的大小，以使空白空间等于或小于可打印区域的大小.调整报表大小时，应抓住空白区域的右边缘，然后将其逐字地拖向左边距.最后，在页面设置中为2列设置报告.

The column trick could work: You should only have one column of controls actually in the Design View of your report. In design view, make sure you only have the Image1 controls (get rid of the Image2 ones) and then resize the report so that the white space is half the size of the printable area or less. When you resize the report, you should grab the right edge of the white space and literally drag it towards the left margin. Finally, set the report for 2 columns in Page Setup.

Access应该自动将第一列中的内容添加到第二列中，并使用相关的字段内容更新控件.

Access should automatically make the second column from what you have in the first column, and should update the controls with the relevant field contents.

可以通过设置图像控件的控件来源"属性而不设置图片"属性来确保正确分配了图像. (图片只是指向文件名的直接链接，但是控制源"将从字段中读取并将不同的图片分配到它们的适当位置.)

You can make sure that the images get assigned correctly by setting the "Control Source" property of the image control and not setting the "Picture" property. (Picture is just a direct link to a filename, but Control Source will read from a field and assign the different pictures to their appropriate places).

祝你好运！

这篇关于在MS Access中生成报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！