Query: SubQry Rpt Average Days Per Step

Type: Select
Has Parameters: Yes
Has Joins: No
Has Subquery: No

Tables Referenced

Temp Entrepreneur Steps
ProcessStatus
Entrepreneurs
Delivery Locations

Columns Selected

Entrepreneurs.[Delivery Location ID]
[Delivery Locations].[Delivery Location]
OwnedBy
[First Name] & \
Entrepreneurs.[Process Status ID]
Status
Entrepreneurs.[Date Record Created]
IIf([Reactivated]=True,\
[Temp Entrepreneur Steps].[Step 1 Last Date]
[Temp Entrepreneur Steps].[Step 2 Last Date]
[Temp Entrepreneur Steps].[Step 3 Last Date]
[Temp Entrepreneur Steps].[Step 4 Last Date]
[Temp Entrepreneur Steps].[Step 5 Last Date]
[Temp Entrepreneur Steps].[Step 6 Last Date]
[Temp Entrepreneur Steps].[Step 7 Last Date]
[Temp Entrepreneur Steps].[Step 8 Last Date]
[Temp Entrepreneur Steps].[Step 0 Last Date]
DateDiff(\
DateDiff(\
DateDiff(\
DateDiff(\
DateDiff(\
DateDiff(\
DateDiff(\

Where Clause

(((Entrepreneurs.[Process Status ID])<>59))

Order By

[Delivery Locations].[Delivery Location], Entrepreneurs.OwnedBy, [First Name] & \

SQL

SELECT Entrepreneurs.[Delivery Location ID], [Delivery Locations].[Delivery Location], Entrepreneurs.OwnedBy, [First Name] & \, Entrepreneurs.[Process Status ID], ProcessStatus.Status, Entrepreneurs.[Date Record Created], IIf([Reactivated]=True,\, [Temp Entrepreneur Steps].[Step 1 Last Date], [Temp Entrepreneur Steps].[Step 2 Last Date], [Temp Entrepreneur Steps].[Step 3 Last Date], [Temp Entrepreneur Steps].[Step 4 Last Date], [Temp Entrepreneur Steps].[Step 5 Last Date], [Temp Entrepreneur Steps].[Step 6 Last Date], [Temp Entrepreneur Steps].[Step 7 Last Date], [Temp Entrepreneur Steps].[Step 8 Last Date], [Temp Entrepreneur Steps].[Step 0 Last Date], DateDiff(\, DateDiff(\, DateDiff(\, DateDiff(\, DateDiff(\, DateDiff(\, DateDiff(\ FROM [Entrepreneurs], [Temp Entrepreneur Steps], [Delivery Locations], [ProcessStatus] WHERE (((Entrepreneurs.[Process Status ID])<>59))