Create/update table from multiple queries

[DaveDiego]

I'm building a report that has a count of cases for employees. I have
separate queries that count, OpenCases, NewCases, TotalCases, Etc. I would
like to put all those counts into a record for each EmpID then create a
report from that table.

Is there some online examples on now to update tables from queries?

[PC Datasheet]

Dave,

That is the wrong approach! Count is a derived value from other data and
shouldn't be saved to a table; it should always be calculated on the fly. You
need a way to distinguish Open Cases from New Cases then you can create a
crosstab query that includes EmoID that will give you the count of open cases,
count of new cases and total cases. Each record from the crosstab query will
look like:

EmpID CountOfOpenCases CountOfNewCases TotalCases.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

"DaveDiego" <Th************************************@usenet1.wi ntermute.cx> wrote
in message news:2m************@uni-berlin.de...

I'm building a report that has a count of cases for employees. I have
separate queries that count, OpenCases, NewCases, TotalCases, Etc. I would
like to put all those counts into a record for each EmpID then create a
report from that table.

Is there some online examples on now to update tables from queries?

[DaveDiego]

PC Datasheet <no****@nospam.spam> wrote:

Dave, That is the wrong approach! Count is a derived value from other data and
shouldn't be saved to a table; it should always be calculated on the fly. You
need a way to distinguish Open Cases from New Cases then you can create a
crosstab query that includes EmoID that will give you the count of open cases,
count of new cases and total cases. Each record from the crosstab query will
look like: EmpID CountOfOpenCases CountOfNewCases TotalCases.

Thanks, I looked at Crosstabs for the first time. It looks like I still
need to look into what I can do with that. So I'm not sure if what i'm
trying to do with work with them.

The queries I'm running count cases based on dates. For instance, old
cases have close date as null and open date before the report criteria.
New cases is another query where open date is within the report critera.
Completed new cases have open and close dates within the report criteria,
etc, etc. In addition to the stats for Ethinicity, income levels, Age,
etc.

I did a report like this on a previous data base and ended up doing a
report with about 30+ subreports which ended up being very tedious and
looked like crap.