var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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 -
text9 may be 01/01/2010 and text11 may be 05/01/2010.
Between [Forms]![frmDayMonthYear]![text9] And [Forms]![frmDayMonthYear]![text11]
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"?
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.
Thankyou it works great!