Crosstable filtering

[Kim]

Is there anyway to filter column heading in a crosstable so that they are not
added to the total column? my column heading are dates, and I want to filter
out dates after and before, etc.

 

[Duane Hookom]

Probably. What do you mean by "total column"? Is this a Row Heading?

What is the SQL view of your crosstab?
What are the form and control names containing your before and after dates?
Do you want to include or exclude the values between the dates?

 

[vanderghast]

Edit your crosstab in graphical view. Drag the field about the dates in the
grid (once MORE if already present), change the default GROUP BY to WHERE,
add the criteria like:

= #01/01/2009# AND <#01/01/2010#

as example.



Vanderghast, Access MVP