crosstab query question

P

Playa

I have created a crosstab query and one of my crosstab Column Headings is
Date. I was wondering if there is anyway to create a parameter on this so I
can select between a certain date range? If so how? Thanks in advance.
 
D

Duane Hookom

Create a form with two text boxes for entering your date range values. Then
set the criteria in your query to something like:

Between Forms!frmDates!txtStart and Forms!frmDates!txtEnd

Then select Query->Parameters and enter
Forms!frmDates!txtStart Date/Time
Forms!frmDates!txtEnd Date/Time
 
P

Playa

I did this and it works fine for a normal query but I cannot get it to work
with a crosstab query. I keep getting errors. Can this only be used with a
normal query???
 
D

Duane Hookom

Did you set the query parameters?
When you state "I keep getting errors", this should be followed by the error
messages since we can't see them.
 
Top