Update of Query results

[Guest]

Hi,
I have this query written with an SQL statement as below:
SELECT Sum(Abs([Pre-study Montage settings documented during
Calibration]="Yes")) AS CountYes, Sum(Abs([Pre-study Montage settings
documented during Calibration]="No")) AS CountNo
FROM SLQC;

This statement is to count the number of replies that are "Yes" and "No" for
a single question. , but the problem is that as data is continously being
entered it does not update the query table. It is stuck at the same number of
records when I wrote the above SQL Statement.

Please Help!!!!!
Thanks

 

[Jeff Boyce]

Does Access know it is supposed to requery?

You haven't said where the results of the query is shown, "as data is
continually being entered".

If you are using a form for data entry (hint: use a form for data entry!),
you can add code to the form's (or a control's) AfterUpdate event to re-run
the query.

 

[Guest]

Hi,
The results of the query is shown in a table for under "Query"

The data is entered in to a form which has its own table and bot update
automatically as data is entered. Th results of the query is updated to the
date I prepared the query, but any data entered after , is not in the count.

Thanks for your replies.

Does Access know it is supposed to requery?

You haven't said where the results of the query is shown, "as data is
continually being entered".

If you are using a form for data entry (hint: use a form for data entry!),
you can add code to the form's (or a control's) AfterUpdate event to re-run
the query.

--
Regards

Jeff Boyce
<Office/Access MVP>

Hi,
I have this query written with an SQL statement as below:
SELECT Sum(Abs([Pre-study Montage settings documented during
Calibration]="Yes")) AS CountYes, Sum(Abs([Pre-study Montage settings
documented during Calibration]="No")) AS CountNo
FROM SLQC;

This statement is to count the number of replies that are "Yes" and "No" for
a single question. , but the problem is that as data is continously being
entered it does not update the query table. It is stuck at the same number of
records when I wrote the above SQL Statement.

Please Help!!!!!
Thanks

 

[Jeff Boyce]

Please post the SQL statement of the query.

--
Regards

Jeff Boyce
<Office/Access MVP>

Hi,
The results of the query is shown in a table for under "Query"

The data is entered in to a form which has its own table and bot update
automatically as data is entered. Th results of the query is updated to the
date I prepared the query, but any data entered after , is not in the count.

Thanks for your replies.

Does Access know it is supposed to requery?

You haven't said where the results of the query is shown, "as data is
continually being entered".

If you are using a form for data entry (hint: use a form for data entry!),
you can add code to the form's (or a control's) AfterUpdate event to re-run
the query.

--
Regards

Jeff Boyce
<Office/Access MVP>

Hi,
I have this query written with an SQL statement as below:
SELECT Sum(Abs([Pre-study Montage settings documented during
Calibration]="Yes")) AS CountYes, Sum(Abs([Pre-study Montage settings
documented during Calibration]="No")) AS CountNo
FROM SLQC;

This statement is to count the number of replies that are "Yes" and

"No"
for

a single question. , but the problem is that as data is continously being
entered it does not update the query table. It is stuck at the same

number
of

records when I wrote the above SQL Statement.

Please Help!!!!!
Thanks