Results 1 to 2 of 2
  1. #1
    cartotech81 is offline Novice
    Windows Vista Access 2007
    Join Date
    Feb 2011
    Posts
    7

    Report From Form Based Query

    I have created a form that will run a query and am now needing to figure out how to create a report from the newly filled in query.



    For example I have all my class data in one table. On my form I have a comobox with a listing of the different classes we offer. When someone chooses a class and hits submit it runs the query and gives them a listing of all the dates for that individual class.

    What I would like for it to do is open that same information, but in report form instead of the table looking format.
    I have created a form that will run a query and am now needing to figure out how to create a report from the newly ran query.

    For example I have all my class data in one table. On my form I have a comobox with a listing of the different classes we offer. When someone chooses a class and hits submit it runs the query and gives them a listing of all the dates for that individual class.

    What I would like for it to do is open that same information, but in report form instead of the table looking format.

  2. #2
    alansidman's Avatar
    alansidman is offline Indifferent
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,538
    The quickest way is to use the report wizard and make sure you use the query as the record source. Once you have all the fields in the report design, you can move them around if you don't like how Access arranges the report.

    Alan

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Report based on query
    By asmith in forum Reports
    Replies: 3
    Last Post: 10-07-2010, 10:24 AM
  2. Report based on query + sub-report (1:N relation)
    By BayerMeister in forum Reports
    Replies: 1
    Last Post: 08-19-2010, 03:26 AM
  3. Totals in a query-based report
    By babylikesburgh in forum Reports
    Replies: 4
    Last Post: 02-24-2010, 03:08 PM
  4. Replies: 1
    Last Post: 02-02-2009, 05:52 AM
  5. Problem with Report Based on a Query
    By gmalaret in forum Reports
    Replies: 1
    Last Post: 11-25-2008, 08:38 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums