generating report in 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?

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.

thanks

(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)

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 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).

Good luck!