J
John VW
I have a table with many records, the fields are Date/Policy No/Ad
on1/Addon2
The fields Addon1 & Addon2 are populated with either a "Y" or "N"
What I want to do is a query that sorts by date but counts the numbe
of "Y" in one column & then counts "N" in the next column & then d
exactly the same for Addon2
A crosstab query will do it for one Addon field but I want a query tha
will do it for both
Any ideas??
thank
on1/Addon2
The fields Addon1 & Addon2 are populated with either a "Y" or "N"
What I want to do is a query that sorts by date but counts the numbe
of "Y" in one column & then counts "N" in the next column & then d
exactly the same for Addon2
A crosstab query will do it for one Addon field but I want a query tha
will do it for both
Any ideas??
thank