locked
Report in MS Access 2010 RRS feed

  • Question

  • 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

  •      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
  • 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

  •      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
  • 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