How do I get data from different queries in one report in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I am trying to create a report that has Counting totals from different
queries within the same database. For Example, one line says "Number of
Servers" (which I get from a query that is SELECT Count(*) FROM Table). The
next line would be "Number of Green Servers" (which derives from a query
SELECT Count(*) FROM Table WHERE ServerColor = 'Green')

How can this be done?

Mike
 
Mike,

Have a look at the dcount function. There are dlookup,
dcount, dsum etc functions that work on a recordsource
other than the report's.


HTH

Terry
 
Back
Top