Show Query Results

[Linda RQ]

Hi Everyone,

Using Access 2003.

I created 2 queries. One is qryVentThpyCurrentAreaCount and has 2 fields
the Area Name and then the count of ventilator patients for each area. The
second one is qryCurrentVentCount which just has one field which is the
total number of Ventilator Patients for all areas.

I would like to show these results on a form. I have a DLookup field on
this form for another query result but it seems to take a longer time to
load the form since I added that. Is using the DLookup field the best way
to show query results or is there another way to display query results that
looks nice and is efficient and a beginner like me can achieve.

Thanks,
Linda

 

[Duane Hookom]

You might want to try use a subform to display the results.

 

[Linda RQ]

Ok...That worked well but it needs to go to beauty school, it look tacky.
If I have several queries that only have one number to show should I just
make a subform for each one? I have been experimenting with trying to join a
bunch of these count queries with no luck so far.

Thanks,

Linda

 

[Duane Hookom]

A subform can look like a simple text box. It doesn't have to display
anything else.

If you have several queries that return a single row, you can combine them
all into a single query like:
SELECT qryA.FieldA, qryB.FieldB, qryC.FieldC
FROM qryA, qryB, qryC;

 

[Linda RQ]

Thanks Duane.

A subform can look like a simple text box. It doesn't have to display
anything else.

If you have several queries that return a single row, you can combine them
all into a single query like:
SELECT qryA.FieldA, qryB.FieldB, qryC.FieldC
FROM qryA, qryB, qryC;