Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2004
    Posts
    364

    Unanswered: Displaying "Between" criteria in a query field?

    In an Access 2003 query, is it possible to display the criteria as in a field?

    My query counts visits between two dates, uses the date column with the following in the criteria section -
    Code:
    Between [Forms]![frmDayMonthYear]![text9] And [Forms]![frmDayMonthYear]![text11]
    text9 may be 01/01/2010 and text11 may be 05/01/2010.

    So for example, could I have a field named "Criteria" which would then display when the query is run something like "Between dates 01/01/2010 and 05/01/2010"?

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    It would be most common to display it on the form or report using the query. A textbox control source of:

    ="Data from " & [Forms]![frmDayMonthYear]![text9] & " And " & [Forms]![frmDayMonthYear]![text11]

    you can probably get that into the query if you want.
    Paul

  3. #3
    Join Date
    Aug 2004
    Posts
    364
    Thankyou it works great!

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Happy to help!
    Paul

Posting Permissions

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