Print Status of Record for Specific Field

G

Guest

I have 5 subreports in a Main report that outputs 40 rtf files based on the
code number of work units in an organisation. The output is run from a Form
and nested macros.

In one subreport I want to print all the records that meet the work unit
code but where the status of a particular record is "p" I want to the macro
to print "Pending" in the output file.

Tks for any advice.
 
S

Steve Schapel

Mike,

I am not sure this needs to be done in the macro. Can you just put an
unbound textbox on the subreport, with its Control Source set to
something like this?...
=IIf([Status]="p","Pending",[Status])
or, maybe along these lines...
=IIf([Status]="p","Pending",Null)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

price field value varies function of quantity field same record 2
print a specific record 1
Button on form to print report for current record 4
query oldest pending record 1
Ct:1 Appears in Left Join for all values rather than selected valu 1
Report pulls one record from open form. 7
Reports with Multiple Subreports 1
Validating field within print single record code 1

Top