Don't know about rest of the group, but I was really
puzzled by your question the first time around, so I
really couldn't think it through too clearly.

Perhaps you need to give more information about your table
design. Is "ClientID" a field in the table,
with "details", "landing" etc. being values in that field
in separate records? Are "ID description" and "amt."
separate fields?

If you can help out a bit with more explanation, maybe
some more people will jump in and help you find a solution.

Regards.

-----Original Message-----
I am reporting due to lack of repsone. However, I really
owuld like some help
on this.

I have a table which looks like this:

ClientID ID Description amt.
details Details Page $10
landing Landing Page $10
noresults No Results Page $10
opt1 Picker Page $10

I need to create a new calculated item under ClientID
called "Results" which will be results = details -
landing. so that in query output, i will see all the line
items under client id and the new calculated item in
client id called results ....

Thanks

.