crosstab query question

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

Guest

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.
 
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
 
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???
 
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.
 
Back
Top