criteria in cross-tab query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a user form where they select date parameters for queries
the criteria: >=[forms]![REPORT]![txtFromDate] And <=[forms]![REPORT]![txtToDate] works fine for all query types EXCEPT cross-tab... can any one help me get the cross-tab query to work?
 
I quick search through google groups might have found the solution. You must
set the data types of the query parameters. From the menu select
Query|Parameters and enter:
[forms]![REPORT]![txtFromDate] Datetime
[forms]![REPORT]![txtToDate] Datetime
--
Duane Hookom
MS Access MVP


Loon said:
i have a user form where they select date parameters for queries.
the criteria: >=[forms]![REPORT]![txtFromDate] And
Click to expand...
<=[forms]![REPORT]![txtToDate] works fine for all query types EXCEPT
cross-tab... can any one help me get the cross-tab query to work?
 
Back
Top