Query Problem with sort

[philcon]

Using the query design tool, I have developed a query which contains a number of expressions as fields which are based on calculations using fields in the tables queried.

i.e. totcosts: = [rawmaterial]+[manufacture]

where another expression might be

rawmaterial : =[stock]+[delivery] (real fields from tables)

Everything works fine until I try and sort the results of the query by [totcost]

I then receive a dialogue asking for the vaule of [rawmaterial]

Can anyone advise why this problem occurs or possible ways around it?

Many thanks


Phil.

 

[mwolf00]

you could try to sort on the individaul components that make totcost --> stock + delivery + manufac1 + manufac2

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rich Cook