If I understand the problem correctly, just set the property of the textbox
on the report to be
=dcount(status,my source query or table name,status = 'R' )
_
From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Dave Moreau
Sent: Wednesday, October 24, 2007 10:56 AM
From: ms_access@yahoogroups.com on behalf of Peter Groman
Sent: Wed 10/24/2007 11:05 AM
To: ms_access@yahoogroups.com
Subject: RE: [ms_access] FW: 0718 AM
If I understand the problem correctly, just set the property of the textbox
on the report to be
=dcount(status
,status
= 'R' ) CTRLF(10) CTRLF(13)
MyFunctioName = txt1 txt2 txt3
End Function
_
From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Dave Moreau
Sent: Wednesday, October 24, 2007 11:05 AM
To: ms_access@yahoogroups.com
Subject: RE: [ms_access] FW: 0718 AM
great...we'll give them all a trythank you for your help today!
Dave
From: ms_access@yahoogroups.com on behalf of Peter Groman
Sent: Wed 10/24/2007 11:19 AM
To: ms_access@yahoogroups.com
Subject: RE: [ms_access] FW: 0718 AM
To do that using the formula I