Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Report in MS Access 2010 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I want to give an option to the user, when creating a report, to select the range of data to be exported in the shape of report. How can i do that? I have created a macro for exporting the data but it exports all the data in that table.

    Regards

    • Moved by litdev Wednesday, July 24, 2013 6:54 AM From Small Basic
    Tuesday, July 9, 2013 4:27 AM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote
         please read "PLEASE READ BEFORE POSTING"

    This forum is about the Small Basic programming language!

    Jan [ WhTurner ] The Netherlands

    Tuesday, July 9, 2013 8:52 AM
  • Question
    Sign in to vote
    1
    Sign in to vote

    Am assuming that this 'create report' button is on a form.

    on the form add a combo box name Range (Type in the ranges you want the user to select)

    add a query that filters data using the value on the range combo box (this is the query that the report will use)

    use the *like* function in the query criteria

    or

    use the where clause in on the macro still with the combo box on the form

    other wise give more detail

    M.K.N

    Tuesday, July 9, 2013 9:15 AM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote
         please read "PLEASE READ BEFORE POSTING"

    This forum is about the Small Basic programming language!

    Jan [ WhTurner ] The Netherlands

    Tuesday, July 9, 2013 8:52 AM
  • Question
    Sign in to vote
    1
    Sign in to vote

    Am assuming that this 'create report' button is on a form.

    on the form add a combo box name Range (Type in the ranges you want the user to select)

    add a query that filters data using the value on the range combo box (this is the query that the report will use)

    use the *like* function in the query criteria

    or

    use the where clause in on the macro still with the combo box on the form

    other wise give more detail

    M.K.N

    Tuesday, July 9, 2013 9:15 AM