Replies

This does help for the weekdays, but any work processed on Saturday and Sunday count as only 1 day.

Processing days: [tblRender]![insertdate]-[tblReceived]![availdate]-([shiftID]=2)

What can I add to this so that any work processed on Saturday and Sunday would only count as 1 day?

Thanks again!

This does help for the weekdays, but any work processed on Saturday and Sunday count as only 1 day.

Processing days: [tblRender]![insertdate]-[tblReceived]![availdate]-([shiftID]=2)

What can I add to this so that any work processed on Saturday and Sunday would only count as 1 day?

Thanks again!

Great!!! Thanks again

Great!!! Thanks again

There can be more than one record for the same fileID in this table. This is because one file can be inserted over various shift, and on different days before it is completed.

There can be more than one record for the same fileID in this table. This is because one file can be inserted over various shift, and on different days before it is completed.

Hans,

I have attached a mocked up version. This is Access 2003 (what I use from home). The query would hopefully reflect 3 days to process for the file inserted on 2nd shift.

Thanks again!

Hans,

I have attached a mocked up version. This is Access 2003 (what I use from home). The query would hopefully reflect 3 days to process for the file inserted on 2nd shift.

Thanks again!

I have 2 tables

tblReceived
FileID (name of file) text field (ex. 17R03.OUT)
AvailDate (date that file was available for processing) date field (ex. 07/20/04)
Volume (total letters in file) number field (ex. 50,000)

tblRender
FileID (from tblReceived) (ex. 17R03.OUT)
Insert Date (actual date the file was processed) date field (ex. 07/22/04)
Processed Volume (total processed from fileID) number field (ex. 10,000)
shift (shift working when file processed) text field (ex. 2nd Shift)

When calculating a turnaround time for this work produced, it would actually be 3 days instead of 2 because the work was processed on 2nd Shift. If another 10,000 letters had been processed that same day, by 1st Shift, that portion should reflect only 2 days to process.

Does this help?

I have 2 tables

tblReceived
FileID (name of file) text field (ex. 17R03.OUT)
AvailDate (date that file was available for processing) date field (ex. 07/20/04)
Volume (total letters in file) number field (ex. 50,000)

tblRender
FileID (from tblReceived) (ex. 17R03.OUT)
Insert Date (actual date the file was processed) date field (ex. 07/22/04)
Processed Volume (total processed from fileID) number field (ex. 10,000)
shift (shift working when file processed) text field (ex. 2nd Shift)

When calculating a turnaround time for this work produced, it would actually be 3 days instead of 2 because the work was processed on 2nd Shift. If another 10,000 letters had been processed that same day, by 1st Shift, that portion should reflect only 2 days to process.

Does this help?

Thanks so much.

I am trying to find an example of this in an Access book. I do see some information on the TransferText, but am not quite sure what to use for the SpecificationName.

Thanks so much.

I am trying to find an example of this in an Access book. I do see some information on the TransferText, but am not quite sure what to use for the SpecificationName.

Thanks, this is exactly what I needed. Any ideas why it would not work with defined column names?

Thanks, this is exactly what I needed. Any ideas why it would not work with defined column names?

Typo, meant cell A3. I have re-attached the spreadsheet with part of the formula in Cell G3 of Sheet1. I need to add additional criteria to this formula. The result should be 40,584…which is a match for for the date of 06/01/2004, and inserter 8 (from Sheet2, column .