Crosstab type report question

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

Guest

I've got a request for a new report in an Access 2000 system that I haven't
had much to do with before
basically it's looking at how long a response takes for a particular
calendar year
and the client wants it to look something like
Month
No of Days Jan Feb ...
1 (count)
2
3

It looks like a Crosstab query is the go but it looks like a crosstab query
can't handle a prompt request for the year that is being looked at. Can
somebody please tell me what I'm missing

(I've also tried a pivotTable form, but it insists on displaying a column
and a row for totals and a 'drag here to filter' section)
 
Crosstab queries can use parameters for criteria. You must specify the data
type of the parameter. Also, it is much kinder to provide a control on a
form for your users. Then select Query->Parameters and enter something like:
Forms!frmParams!txtYear Integer
 
Back
Top