You know, I really hate to ask this question, but:

How do I set the field value of the query to the value I want returned? When I have counted Code 005, 006, 006, etc, I need
the union query that called the parameter query to see this total
count as Code 012, and thus insert it into the proper ascending order.


Thanks

Ernest