DCount Question

[weircolin]

Hi there

Coming back to upgrading a database I created last year. Looked at
some things I would like to improve upon and one of them is due to a
suggestion I got from this board.

On my database I have various fields that I have the means to count.
The part of the database I am working on at the moment is to record
concerns that people have with various services in our area. The
problem I have is that if 50 people have the same concern and they
were all members of the same group I would have to log the concern 50
times to get the correct stats. What I would like to do is have a box
on the form that I could ask "Number of times occurring" and call is
totoccur. I would like to then on a form that I use to get the stats
from be able to get the amount of times it occurs.

Obviously I would like the box totoccur to Default at one on a new
entry.

In the text box just now, the DCount function I use is:

=DCount("*","tblIssuesandconcerns","[Year] =" & Nz([cboyear],0) & "And
[Topic Name] =" & Nz([cbobenefits],0))

The cbobenefits refers to a combo box that has various benefits that
people may have a concern about.

Can anyone help with this?

Cheers

Colin

 

[OldPro]

Hi there

Coming back to upgrading a database I created last year. Looked at
some things I would like to improve upon and one of them is due to a
suggestion I got from this board.

On my database I have various fields that I have the means to count.
The part of the database I am working on at the moment is to record
concerns that people have with various services in our area. The
problem I have is that if 50 people have the same concern and they
were all members of the same group I would have to log the concern 50
times to get the correct stats. What I would like to do is have a box
on the form that I could ask "Number of times occurring" and call is
totoccur. I would like to then on a form that I use to get the stats
from be able to get the amount of times it occurs.

Obviously I would like the box totoccur to Default at one on a new
entry.

In the text box just now, the DCount function I use is:

=DCount("*","tblIssuesandconcerns","[Year] =" & Nz([cboyear],0) & "And
[Topic Name] =" & Nz([cbobenefits],0))

The cbobenefits refers to a combo box that has various benefits that
people may have a concern about.

Can anyone help with this?

Cheers

Colin

So if I was the user, and I represented 50 people, then I would select
50 from your input screen?

 

[weircolin]

Hi there

Coming back to upgrading a database I created last year. Looked at
some things I would like to improve upon and one of them is due to a
suggestion I got from this board.

On my database I have various fields that I have the means to count.
The part of the database I am working on at the moment is to record
concerns that people have with various services in our area. The
problem I have is that if 50 people have the same concern and they
were all members of the same group I would have to log the concern 50
times to get the correct stats. What I would like to do is have a box
on the form that I could ask "Number of times occurring" and call is
totoccur. I would like to then on a form that I use to get the stats
from be able to get the amount of times it occurs.

Obviously I would like the box totoccur to Default at one on a new
entry.

In the text box just now, the DCount function I use is:

=DCount("*","tblIssuesandconcerns","[Year] =" & Nz([cboyear],0) & "And
[Topic Name] =" & Nz([cbobenefits],0))

The cbobenefits refers to a combo box that has various benefits that
people may have a concern about.

Can anyone help with this?

Colin

So if I was the user, and I represented 50 people, then I would select
50 from your input screen?- Hide quoted text -

- Show quoted text -

Yeah, thats right.

 

[OldPro]

Hi there
Coming back to upgrading a database I created last year. Looked at
some things I would like to improve upon and one of them is due to a
suggestion I got from this board.
On my database I have various fields that I have the means to count.
The part of the database I am working on at the moment is to record
concerns that people have with various services in our area. The
problem I have is that if 50 people have the same concern and they
were all members of the same group I would have to log the concern 50
times to get the correct stats. What I would like to do is have a box
on the form that I could ask "Number of times occurring" and call is
totoccur. I would like to then on a form that I use to get the stats
from be able to get the amount of times it occurs.
Obviously I would like the box totoccur to Default at one on a new
entry.
In the text box just now, the DCount function I use is:
=DCount("*","tblIssuesandconcerns","[Year] =" & Nz([cboyear],0) & "And
[Topic Name] =" & Nz([cbobenefits],0))
The cbobenefits refers to a combo box that has various benefits that
people may have a concern about.
Can anyone help with this?
Cheers
Colin

So if I was the user, and I represented 50 people, then I would select
50 from your input screen?- Hide quoted text -

- Show quoted text -

Yeah, thats right.- Hide quoted text -

- Show quoted text -

Then instead of counting records, you need to do a DSUM of a new field.