Crosstab Qry Prob

[KRISH]

Hi!

My report based on a crosstab query. Is there any way to
give criteria for both Rowhead and columnheads. Pl. help.

Thanks

Krish

 

[Duane Hookom]

You can display the fields you are using for row and column headings more
than once in the query grid. Use the second instance of the fields and set
their Totals to "Where" and enter your criteria. Make sure the "Show" box is
unchecked.

I assume that you understand that any parameters must be set with their data
type in the Query|Parameters like:
Forms!frmA!txtStartDate Date/Time