I have a question about using the Distinct command. Basically I have a report using a query named Register as its record source. The have a field name Members Fee. In this field contains 2 fees, $25.00 and $10.00. I would like to display these two fields where no matter how many $25.00's or $10.00's there are only one of each is displayed. For expample;
Members Fee
$25.00
$25.00
$10.00
$10.00
Should only display $25.00 and $10.00 once and not show the duplicates. I have to do it this way because these fees can change at anytime. I know the Distinct command is supposed to do this but then I try to use it, I receive an #error on the printout of the report.
Any assistance wil be appreciated.
KJ
Members Fee
$25.00
$25.00
$10.00
$10.00
Should only display $25.00 and $10.00 once and not show the duplicates. I have to do it this way because these fees can change at anytime. I know the Distinct command is supposed to do this but then I try to use it, I receive an #error on the printout of the report.
Any assistance wil be appreciated.
KJ
