[AccessD] Difficult calculations

Yes, he does need to use data from different records but the same field in 
his calculation. I was actually thinking along the lines you propose - but I 
don't know how to automate the process so that he doesn't have to create 144 
(or more) queries. It seems like there should be a way to loop through the 
table and reproduce this activity over and over again for each value in each 
StmtType. Any suggestions?

Thanks!
Gina

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bobby Heid
Sent: Tuesday, March 07, 2006 1:48 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Difficult calculations

I would recommend the use of one or more temporary tables to process the 
data.  It looks like from your description that he needs to use data from 
fields in different records in one calculation.

Maybe something that would first put all of the VUH Inpatient Revenue JanYTD 
data into the work table.  The another query that would add the VUH 
Outpatient Revenue JAN YTD data to the corresponding work record, etc.

Then he would have one or more final queries that would take all of the data 
in the one record needed for a given calculation and calculate it.

Is that clear as mud now?  LOL.

Bobby