criteria in cross-tab query

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?
 
D

Duane Hookom

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SELECT works with parameter query but CROSSTAB doesn't? 2
crosstab query with datea parameters 2
Using automation to load a cross tab query to Excel 11
Using a Cross Tab query as a subreport 1
Cross-Tab Query 2
Forms with parameters to pass to cross-tab queries 3
Cross Tab Report Vs Dynamic coulmns 0
Cross tab date problem 1

Top