how to export cross tab queries by date parameters

[beginner_access]

How can you export cross tab queries by using date parameters (for example: Jan 1, 2014 to December 31, 2014)

Any suggestions?

Thank you all in advance.

 

[CJ_London]

assuming you have a date field in your query, use a criteria for it of

Between [Enter Start Date] AND [Enter End Date]

Make sure you change the Total value from group by to where

 

[beginner_access]

assuming you have a date field in your query, use a criteria for it of

Between [Enter Start Date] AND [Enter End Date]

Make sure you change the Total value from group by to where

Thank you CJ_London. I do have the date field and I inserted your code under date field criteria and changed the Total Value to Where.

It is giving me an error message:

The Microsoft office access database engine does not recognize '[Enter Start Date]' as a valid field name or expression.

Any thoughts?

 

[beginner_access]

assuming you have a date field in your query, use a criteria for it of

Between [Enter Start Date] AND [Enter End Date]

Make sure you change the Total value from group by to where

Actually... you are right. I had to add [Enter Start Date] and [Enter End Date] in the parameters with data type as date/time and it worked!!

Thank you so muchhhhh