Using Arrays

[Aberdeen123]

Hope someone can help:

I am trying to create a report which details the number of hours worked by each employee for the last seventeen weeks.

If for some reason one week returns a null or zero value this week (only for the respective employee) has to be disgarded and the so called 18th week be used and so on.

I have a Staff Table and TimeSheetLines Table which has a weekendingdate field and staffid field.

Can anyone push me in the right direction as to how to extract this imformation?

I am aware of how to extract the imformation for the last 17 weeks but am not sure how I can add to this if some values are null.

Thank you in advance

 

[a.sinatra]

You probably could run an append query that updates null values to "0"
________
Nash-Healey Specifications

 

[Aberdeen123]

You probably could run an append query that updates null values to "0"

i may not have explained myself properly:

If for one week the number of hours is zero or null this week has to be disgarded and the following week be used. I.E. I am looking to create a report which details the number of hours worked for each employee for the last seventeen weeks with each record being 1 or greater. The user determines where the 17 weeks begins

The report will be grouped by employee.

 

[billyr]

Hope someone can help:

I am trying to create a report which details the number of hours worked by each employee for the last seventeen weeks.

If for some reason one week returns a null or zero value this week (only for the respective employee) has to be disgarded and the so called 18th week be used and so on.

I have a Staff Table and TimeSheetLines Table which has a weekendingdate field and staffid field.

Can anyone push me in the right direction as to how to extract this imformation?

I am aware of how to extract the imformation for the last 17 weeks but am not sure how I can add to this if some values are null.

Thank you in advance

Using a query, you can isolate all timesheet records for a specific employee, >= to a specified date, with hours not null and not 0, ordered by date.