[AccessD] thought processes and temp table creation (I think)

Hi All, 

I am having some trouble getting my brain back to Access after not using 
it for a while. I got a promotion and am not doing much hands on work at 
the moment but I need to fix up an issue for a client. 

I have a database that keeps track of building jobs to be done. In each 
job there is a field for the following 

JobID, BuildID, AreaID, SubelementID, WorkID, StandardID, Location, 
Description, TradeID, Quantity, Cost, Frequency, StartYear, Priority, 
Done, Approved, Comment.

When a job is entered it is given a start year and a frequency. When it is 
checked as done if it has a frequency, the database creates a new entry 
for the next occurrence and marks it as not done. 

The client requires a report to be handed to a contractor for prediction 
of budget estimates for the next 5 to 10 years.  In this report it must 
have a value for each job to be done. So I need to generate an entry for 
every job in the database which has a frequency within the report dates. 

So I have come up with the following thought process;

variables : RepStartDate, RepEndDate, Workyear

process 

                loop through jobs in table 
                Where done = N
                While StartYr + Frequency between RepStartDate and 
RepEndDate
                              Copy record, add new workyear field
                      Insert record into temp table
                        While WorkYear + Frequency between RepStartDate 
and RepEndDate
                                         Copy record, add new workyear 
field
                             Insert record into temp table 

generate report on basis of original and temp table data 

Just wanting clarification of my thought processes after almost a year 
away from access. 

 Regards, 

Connie Kamrowski

Senior Software Support Analyst
Information Technology
NSW Department of Primary Industries 
Orange

Ph: 02 6391 3250
Fax: 02 6391 3290
This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient, please delete it and notify the sender. Views expressed in this message are those of the individual sender, and are not necessarily the views of their organisation.