Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2010
    Posts
    6

    Exclamation Unanswered: how to generate this report

    hello,

    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 or two per page, how do i do this?

    http://i.imgur.com/gmAQo.jpg

    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
    Last edited by coolcurrent; 12-30-10 at 21:01.

  2. #2
    Join Date
    Dec 2003
    Posts
    24

    Wink

    it must be two column or two per page
    not clear here..
    you want only two columns printed in a page or two records printed in each page of report

  3. #3
    Join Date
    Dec 2010
    Posts
    6
    Quote Originally Posted by tvdrajkumar View Post
    not clear here..
    you want only two columns printed in a page or two records printed in each page of report
    it must be two record per page, but in column, left and right

  4. #4
    Join Date
    Dec 2003
    Posts
    24

    Question

    but in column, left and right
    Go to Page setup->columns There is an option to print down then across, across then downchoose the across then down

    Edit:
    Set the no. of colums to 2 Page setup->columns
    Last edited by tvdrajkumar; 12-31-10 at 05:01.

  5. #5
    Join Date
    Dec 2010
    Posts
    6
    1 i have several image path store in my access database,
    2 i have a query that fetched paths based on bookid (which can mean more that one record)
    3 when i execute the query, it ask for bookid, then fetches several pics
    4 i want to print those pics in the report as i layed it out above

    remember, the pics are not stored in the db, i only get the paths in the query results, and i have to load all the pics in the report, it will be several pages report.

    thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •