Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2003
    Posts
    225

    Unanswered: Filtering - by option boxes multiple

    I am trying to design a form which will provide my users multiple reporting options using the same query.

    my query contains the following fields:

    Daycode
    WeekNumber
    PeriodNumber
    Line
    Machine
    Eventcode
    TotalTime
    Occur
    Avg

    i want the user to choose in this order :

    a time period to run the report.....either Daycode, WeekNumber,PeriodNumber

    then select:

    a Line,

    then select either Totaltime, Occur or Avg (this will require to be sorted Desecnding..

    then finally to decide wheter to have all the data remaining, or sorted by machine.

    DB is here--------> http://www.utteraccess.com/forums/do...?Number=537339

  2. #2
    Join Date
    May 2004
    Location
    The Netherlands
    Posts
    52
    You can try to build the query runtime based on the parameters on your form and execute then this build query.

  3. #3
    Join Date
    Mar 2003
    Posts
    225
    ok thanks, any examples floating around anywhere ?

  4. #4
    Join Date
    May 2004
    Location
    The Netherlands
    Posts
    52
    You can try something like this:

    Code:
    Dim strSql As String
    Dim qdf As DAO.QueryDef
    
    strSQL = "Select Daycode, Weeknumber From tabel_name " & _
    	"where Daycode = " & form_name.control_name.value
    
    set qdf.sql = strSql
    qdf.execute

  5. #5
    Join Date
    Mar 2003
    Posts
    225
    hmm.. had a play but no use, i have no real idea how to get this to work...

    any freelancers out there ?

  6. #6
    Join Date
    May 2004
    Location
    The Netherlands
    Posts
    52
    Be sure that the report will use this query.
    A good developer is a lazy developer - don't be to lazy, share your knowledge

Posting Permissions

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