Thanks Allen. I will run with that and let you know how it goes.

Thanks for your patience.

"Allen Browne" wrote:

Create a query. In the Criteria row under the number field:
0

That will eliminate all the records where the number as zero.
(Presumably you don't have negatives.)

Or you can put a text box on the report if you wish.
Set its Control Source to:
=([YourNumberFieldNameHere] 0)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"omoluabi" wrote in message
...
Thanks Allen, your suggestion makes perfect sense but I forsee that being
a
problem when I'm creating the reports. How do I indicate that the incident
occured in the report? I'm certain the report query will bring up the
corresponding frequency provided the incident occured, however I would
like
to display a checked checkbox alongside the frequency. How can this be
done?
Sorry if my questions are too basic, I'm a newbie in this field.

"Allen Browne" wrote:

Instead of a Yes/No field and then a Number field to record how many,
could
you get away with just the Number field?

If the answer was No, presumably the Number is zero. It seems to me that
this would be a better (more reliable) design, as it would prevent the
existence of bad data (e.g. where the Yes/No field contains No, but the
Number field contains 8.) Having just the Number field avoids that kind
of
inaccuracy.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"omoluabi" wrote in message
...
Hi all,
I'm designing a database that requires users to specify the number of
times
a Yes/No field occurs. This number is not required if the choice is No
but
if
Yes, I plan to create a drop down menu for the user to specify the
number
of
times the choice occured.
My first thought is to create a Frequency field for each choice but
then I
thought there must be a better way to do it. I came up with an idea to
create
a Frequency table (tblFrequency) described below:

tblFrequency:
Field: FreqID
Field: Freq

I'm planning to make FreqID a foreign key on my Incidents table which
contains the choices (Yes/No) fields.

The problem is that I'm somewhat short of ideas on how to make this
work.
Thanks for your patience.

.

.