Using Dates from a Form text box to filter a Query

[JasonM]

Good morning everyone!

I have been using Access 2003 for quite some years and I believe that this works in that version. My employer has recently updated to 2010 (I know... They are always on the cutting edge LOL). I have a select query that collects data and summarizes it and then a transform query that rotates the data so i can manipulate it the way I need to display it.

I am using: in the select query: Between [Forms]![frmReports]![txtStartDate] And [forms]![frmReports]![txtEndDate]

it works there when I just run that query, but the crosstab query gives me a microsoft database engine error... What am I missing?:banghead:

Thanks for your help!

 

[pbaldy]

Crosstab queries have long required that the parameters be explicitly declared:

http://allenbrowne.com/ser-67.html

http://support.microsoft.com/kb/209778

 

[JasonM]

Paul, Thank-you. I guess I have never run into this problem, or have found some other work around. The articles referenced were a tremendous help!

Thanks again and happy holidays.
Jason

 

[pbaldy]

No problem Jason, and happy holidays to you too!