Quote Originally Posted by OBP
I always use a Form to enter the Criteria (Filter) in and then use that on a Pre-Query which I then Crosstab. That way you can get the "Criteria" working in a normal select query and then Crosstab it.
I am not sure if Access 97 is the same as Access 2000-2003, but if it is you will have to Declare the Criteria as Parameters.
I use the Forms![Formname]![Fieldname] in both the Criteria row and parameters, where Formname is the actual name of your form and Fieldname is the actual name of your field.
Hi OBP,

Thanks for the reply, For now my knowledge of Access & SQL isn't great as such, your suggestion is something for me to do further down the line as I currently won't know where to begin to setup a form and use the criteria entered into the form as a basis for producing queries & reports.

Would you therefore be able to advise how I can peform what I have asked in my Original Post without constructing a form and/or provide some pointers on how I would build a 'report wizard' form?

Thanks,