As part of the report I'd like to have a table that would list all different values in column in column A and the number of times they appear in the table in column B.
I have a bit of a hard time how to populate the table the easiest way.
I have all the values in a separate source table, so first coloumn is easier.
but do i have to write the dcount statement for each row for second coloumn?
any easier way to do it? Could I display results of query as subquery in report.
And a subquestion. If you have a bunch of textboxes with increasing names like NameBox1... for for/next loops in reports... is there an easy way to assign those names?
I have a bit of a hard time how to populate the table the easiest way.
I have all the values in a separate source table, so first coloumn is easier.
but do i have to write the dcount statement for each row for second coloumn?
any easier way to do it? Could I display results of query as subquery in report.
And a subquestion. If you have a bunch of textboxes with increasing names like NameBox1... for for/next loops in reports... is there an easy way to assign those names?