Orders held up for one or more reasons

[vangogh228]

I have a database of submitted orders that were temporarily held by our Order Management group for any one or more than one reason categories. There are 20 possible errors that could cause this temporary hold to occur. Once the error(s) is/are fixed, usually by getting missing information, then the order is released to the fulfillment group.

The basic information needed is the average duration between the Hold Date and the Release Date for a particular reason. So, in the table, the fields of concern are:

HoldDate
ReleaseDate
Reason1
Reason2
Reason3

etc. The Reason fields are Yes/No.

I want to be able to get a report that shows the average duration for each reason, but all in the same report. I can get it for a single reason, but without writing 20 separate queries or putting 20 formulas in my report, I can't seem to get what I need.

Any help is greatly appreciated.

 

[grnzbra]

You might want to try a table with the fields
Order#
HoldDate
ReleaseDate
Reason#
and have one record for each reason