danielmurray
Programmer
I need to create a crosstab query to count client ages by male and female. This is part of a much larger report with lots of selection criteria based on date assisted, type of assistance, etc. I have a working select query to remove any clients with repeat assists.<br><br>I generally create an unduplicated select query by setting the Unique Values or Unique Records in the Query's Properties to Yes. However, those options are not available in a crosstab query.<br><br>I tried to "feed" the crosstab query with a select query that de-dupes based on the user's selection criteria, but then the crosstab query complains about undefined parameters. I tried to follow the message's advice to setup a parameter list, but things just got out of hand, since I am selecting on a ton of criteria.<br><br>I am stuck between the necessity for a crosstab query but without the ability to dedupe it. Any help would be greatly appreciated.