469,935 Members | 1,695 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,935 developers. It's quick & easy.

Finding problems in reports where functions are involved

hi,
I'm finding this problem most frustrating. (It's probably my lack of
undersating of functions!) I want to fill a control in a report with the
result of a function. I'm calculating the average of a number of fields for
the current record. It all works .. to a point!! Using for and next I can
identify the fileds and get the data. All is fine until the fields are
empty or null (I'm not quite sure.) all I get back is 'error' in the
report, and that is not very helpful. (Even with on error etc in the
function. I've exhausted (probably not actually) all possible combinations
od Nz, iif etc!!

Thanks in advance
Nov 13 '05 #1
1 1153
How about posting the relevant code?

"John M" <jo**@jmawer.demon.co.uk> wrote in message
news:ck*******************@news.demon.co.uk...
hi,
I'm finding this problem most frustrating. (It's probably my lack of
undersating of functions!) I want to fill a control in a report with the
result of a function. I'm calculating the average of a number of fields for the current record. It all works .. to a point!! Using for and next I can identify the fileds and get the data. All is fine until the fields are
empty or null (I'm not quite sure.) all I get back is 'error' in the
report, and that is not very helpful. (Even with on error etc in the
function. I've exhausted (probably not actually) all possible combinations od Nz, iif etc!!

Thanks in advance

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by David McGeorge | last post: by
9 posts views Thread by Sheldon | last post: by
10 posts views Thread by jodleren | last post: by
275 posts views Thread by Astley Le Jasper | last post: by
2 posts views Thread by marybrown | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.