Here is a sample of the actaul table..

Date ID Description field 1 field 2 Gross Revenue

2/19/2004 Details Page 216610 165104 1007.98
2/19/2004 Landing Page 4968 4878 527.94
2/19/2004 No Results Page 137264 74944 3093.14
2/20/2004 Details Page 346056 259348 1831.66
2/20/2004 Landing Page 10308 10272 735.82
2/20/2004 No Results Page 223462 121882 4845.06
2/21/2004 Details Page 295816 222550 1672.56
2/21/2004 Landing Page 9054 9002 688.34
2/21/2004 No Results Page 167172 94252 4180.94
2/22/2004 Details Page 275650 211330 1981.48
2/22/2004 Landing Page 8102 8040 726.28
2/22/2004 No Results Page 148674 84052 3791.76


Thanks for your help!


"others jump in please" wrote:

A bit more info please, but your problem may be difficult
to solve.
Do the record samples you gave occur many times in the
table; e.g., are there many instances of records with
ClientID= "details"? YES

Do the records always occur in four-
record sets of ClientID="details", "landing", "noresults",
and "opt1"? YES

Do the records have any other fields that
might connect or relate one record to another? NO

The reason
for that question is that there needs to be a way to
uniquely relate one instance of record "details" & "amt."
with its corresponding record of "landing" & "amt."

I'm thinking that if there is no way to positively and
uniquely connect associated records then doing a unique
calculation will not be possible.

If, on the other hand, the table only contains four
records, i.e. one record for "details", one related record
for "landing", etc., then there might be a solution.

Hang in!

-----Original Message-----
Hi everyone...

Sorry for the confusion. Client iD, Id Description and
Amt. are separate
fields in my table. Clinet id has details, landing , no
results and opt1 as
values. I need to generate a new value in the client id
field called
"Results" where results takes the Amt. value of landing
and subtracts it.
from the amt value. of details ...... Thanks

" wrote:

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

.


.