Sorting the good from the bad.... (1 Viewer)

Darrell

Registered User.
Local time
Today, 19:42
Joined
Feb 1, 2001
Messages
196
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....
 

ThreeCrow

Registered User.
Local time
Today, 11:42
Joined
Jun 22, 2005
Messages
148
Need more information

You are telling us nothing.
 

richary

Registered User.
Local time
Today, 19:42
Joined
May 26, 2004
Messages
167
Fields D, F and G can probably be calaculated controls on the report, which should make access less likely to choke on the query.

If that fails, you'll need to post the SQL so people can look at it.
 

Darrell

Registered User.
Local time
Today, 19:42
Joined
Feb 1, 2001
Messages
196
Hmmm where to start.....

I spent a lot of time looking at the query and trying to see why that wouldn't sort by H either (I was getting the "Overflow" error). So I searched on that problem and there was some reference to div/0. When I looked at the query it was indeed generating a few #errors in the F field and so I changed the query so that it gave a zero value instead of an #error and sure enough that has solved the problem. :eek:

So thanks anyway....
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom