Benjamin Bolduc
Registered User.
- Local time
- Today, 15:21
- Joined
- Jan 4, 2002
- Messages
- 169
Hi everyone,
I'm working on a new and complicated report that has two subreports in it. Everything is linked and set up right but there's one annoying problem. I have a field on my Main Form that is linked to a field in a subform. Not every record on my main form has a corresponding record on the subform. So half of the records get (#Error) messages in them when there is no matching record.
I'd like to have set up so that if there is no data for the field it'll just display "0". This seems like it should be relativly easy but I just can't seem to figure out.
Any Ideas would be very much appreciated.
Thanks!
I'm working on a new and complicated report that has two subreports in it. Everything is linked and set up right but there's one annoying problem. I have a field on my Main Form that is linked to a field in a subform. Not every record on my main form has a corresponding record on the subform. So half of the records get (#Error) messages in them when there is no matching record.
I'd like to have set up so that if there is no data for the field it'll just display "0". This seems like it should be relativly easy but I just can't seem to figure out.
Any Ideas would be very much appreciated.
Thanks!
