Is looping the best way to do this?

[zags]

I have a date parameter for a query that I'm using to update a table. I need to run the query several times using a different date each time its run. The dates are pay period end dates that are based on a date range that a user enters on a form. For example, a user enters a date range of 01/01/2007 - 03/01/2007 the pay period end dates in that period may be

01/05/07
01/16/07
02/01/07, etc.

The dates are stored in a table as follows

Pay_Start_Date, Pay_End_Date

How do I set this up so that each time the query runs it moves to the next record until it reaches the last date in the table?

Thank you
Access 2003

[ramaswamynanda]

Hi, how are you using the dates returned by the query? will a between clause in your query suffice? for example

update tableA
set a1=value, a2=value........
where mydate between d1 and d2;

here d1 and d2 would correspond to the values your user enters.

nanda

I have a date parameter for a query that I'm using to update a table. I need to run the query several times using a different date each time its run. The dates are pay period end dates that are based on a date range that a user enters on a form. For example, a user enters a date range of 01/01/2007 - 03/01/2007 the pay period end dates in that period may be

01/05/07
01/16/07
02/01/07, etc.

The dates are stored in a table as follows

Pay_Start_Date, Pay_End_Date

How do I set this up so that each time the query runs it moves to the next record until it reaches the last date in the table?

Thank you
Access 2003

[zags]

For each employee a the total number of hours worked for the pay period (pay period end date) by pay code is produced using each date.

For instance employee 68 for the pay period ending 01/05/2007 worked 80 hours REG, 8 OVT. This information is this posted to a table which is eventually distributed to a user.

So if there were 5 pay periods within the user entered date range the query described above would need to be run for each date separately.

I hope this answers your questions

Thanks