Calculated Field on Report

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

Using Access 2003
I created a "Find Unmatched Query Record" Query and then
created a report based on that query. When there are NO
unmatched records, (instead of the record being blank) I
want a field to show a message - "No Unmatched Records."
If there are any unmatched records, I want a calculated
field to show the total number of unmatched records. How
can I set this up?

Thank you, Karen
 
Add an unbound textbox to your report and put the following expression in
its control source property:
=IIF(DCount("*","NameOfYourQuery") = 0,"No Unmatched Records", _
"The Total Number Of Unmatched Records = " &
DCount("*","NameOfYourQuery"))
 
Thank you - It worked great!
-----Original Message-----
Add an unbound textbox to your report and put the following expression in
its control source property:
=IIF(DCount("*","NameOfYourQuery") = 0,"No Unmatched Records", _
"The Total Number Of Unmatched Records = " &
DCount("*","NameOfYourQuery"))

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com







.
Click to expand...
 
Karen said:
Using Access 2003
I created a "Find Unmatched Query Record" Query and then
created a report based on that query. When there are NO
unmatched records, (instead of the record being blank) I
want a field to show a message - "No Unmatched Records."
If there are any unmatched records, I want a calculated
field to show the total number of unmatched records. How
can I set this up?
Click to expand...


Another way is to have a text box with the expression:

=IIf(Report.HasData, Count(*), "No") & " Unmatched records"
 
Back
Top