Changing a unbound field in a detail line

G

Goldar

My table contains group of account records that contain Account number,
Account description, Sub Account description and Sequence number. I want to
be able to change the detail printed line so that the Sub Account field
contains "(No sub accounts exist" whenever an Account group contains only one
record ([Sub Account] is null). If more that one record exists in the group,
I want the Sub Account field to contain the Sub Account description ([Sub
Account]). I'm not sure how to proceed.

Thanks...
 

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

Conditional change to a field in a printed detail line 2
Suppress printing of 1st detail record 0
Copy previous record into form field 0
Suppress total for first record of a group 1
Autonumber field in Excel that behaves the same as Access 0
Assign a value to a field from the Format event 3
Condition Group Footer to be visible based on number of records in detail sectio 1
Space at end of multi page list to accommodate new entries 1

Top