Darrell
Registered User.
- Local time
- Today, 20:15
- Joined
- Feb 1, 2001
- Messages
- 299
I'm creating a simple report based on a query for demand tracking.
I am trying to sort based on one of the fields in this report but I get the "Too complex to be evaluated blah blah blah..." message.
This field is calculated in the query so I can't see why it doesn't work.
The query is basically this.
A: SalesDays
B: ForecastQty
C: DaysIntoMnth (Entered by User)
D: = B/A*C
E: SalesToDate
F: = B/E
G: = C/A
H: = F/G
And I'm trying to sort by H in the report.
Can anyone offer some assistance....
I am trying to sort based on one of the fields in this report but I get the "Too complex to be evaluated blah blah blah..." message.
This field is calculated in the query so I can't see why it doesn't work.
The query is basically this.
A: SalesDays
B: ForecastQty
C: DaysIntoMnth (Entered by User)
D: = B/A*C
E: SalesToDate
F: = B/E
G: = C/A
H: = F/G
And I'm trying to sort by H in the report.
Can anyone offer some assistance....