Crosstab Qry Prob

  • Thread starter Thread starter KRISH
  • Start date Start date
K

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