I designed an Access database for a project.
It consists of tables, queries, forms, reports and macros.
Just about all the bugs have been worked out except for a summary
page.
In addition to a client data entry form, I included a client work
summary page which is intended to display a count, average and sum of
session hours; a count, average and sum of optional hours and a grand
total of both the session and optional hours-for an individual
client.
the problem is that for instance, 3 entered for session hours and
nothing entered in the space for optional hours does not yield a total
of 3 (3+0=3).
Instead the total space is blank. If I enter 3 for session and 3 for
optional, it's ok and I get 6. When I enter 3 for session and 0 for
optional, however, it yields a total of 3, but it reports the 0 for
optional as a session. Therefore when the averages are totalled, the
result is 3 session hours divided by 2 sessions, because the zero is
being counted as 1 session. the resulting answer is obviously wrong -
(3+0=3)/2=1.5. The correct answer is obviously
(3+0=3)/1 =3. I tried inserting the NZ function into the query but
it's still now right. Consider the sample zip attached.