Run a series of queries

[Guest]

hello all,

can someone help me run append query where the date criteria comes from a
dlookup?

qryTimeSheets
fldName
fldHours
fldDate

Dlookup is getting the dates from tblPayDates - this table is populated in
the beginning of the year through a userform.

The reason for this scheme is because I need to sum the hours for a
payperiod for all payperiods from the beginning of the year to present - to
track a cumulative amount of hours worked above 80 hours for a two week
period.

 

[Rob Oldfield]

You'll need to provide some more detail about what's going wrong. By
default, if you run a query that references another query, then anything
(including lookups) that the second one needs will be evaluated
automaticlly. What are you trying and what error are you getting?

 

[Guest]

Thanks for taking this one on Rob,
I haven't got so far to get an error.
I'm having trouble setting this thing up.
Here is some more detail:
I created a database with a linked table from our payroll system
tblTimeSheets and created another table with the paydates throughout the
current year:
tblPaydates
fldCountID PayBeg PayEnd
1 1/1/06 1/15/06
2 1/16/06 1/30/06
...and so on

tblTimeSheets will track the submitted hours from the employee's but what
the system does not do is track the overtime in the way that we would like to
award it, which is:
1. Hours over 80 for a two week period are considered OT
2. Before we pay out the overtime, the person must work 35 hours of OT first
which is not paid out, then any and all above that initial 35 hours of OT is
paid.
So the object of what I'm trying to set up is the user would choose what
payperiod they want to calc from the tblPayDates, then I wanted to run an
append query for each payperiod from the tblTimeSheets into
tblGatherPayperiods
My initial plan was to set up a macro that runs 24 appendqueries or loop the
same one where the date criteria was fldPayEnd from the tblPayDates so I
could have the payperiods separated to calc and cum the OT.
I don't know how to reference the date criteria from tblPayDates when I'm
setting up a query with tblTimeSheets as the datasource.
I could just manually enter all the dates in and udate it every year but
that's ridiculous.

 

[Rob Oldfield]

Could you provide a sample of what tblTimeSheets looks like please.