|
Use a Summary Query
Define a report break containing both fields. Then in Select Output Type, choose Summary Only. You will only see one occurrance for each distinct break level. The one downside to this is that Query/400 will insert a blank line in between each row. If you want to print out the data without the blank lines, you can run the output of this query to a temporary file and then query the temporary file seperately.
|