Show Query Results

  • Thread starter Thread starter Linda RQ
  • Start date Start date
L

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
 
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
 
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;
 
Thanks Duane.


Duane Hookom said:
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;
Click to expand...
 
Back
Top