txt box in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that returns two columns, another that returns two fields; a
count of the number of records in each of the two columns in the first query.
In a report based on the first query, I would like to add two text boxes at
the bottom of the report with their control sources set to the two fields of
the second query so it looks like this:

1-120B 231234
1-121B 323456
1-122B 214253
1-123B 376098
1-124B 365241
1-125B
1-126b 263547

6 5

This isn't working. I get errors in the text boxes. Why? The only way I've
been able to do this is create a sub report based on the second query and
insert it into the first report, but this is cumbersome. Formatting is
difficult, things won't line up.
Any help is appreciated.

Ripper
 
If the fields are called Field1 and Field2, try a text box with:
=Count([Field1])
and
=Count([Field2])

That should give you the count of records where the field has a value (i.e.
where it is not null).
 
Back
Top