Hi there ... thanks for your diligence on this. please see my responses
below. thanks

"others jump in please" wrote:

Hi Victor,
I see a possible solution if the record sets are always
tied together by the date field - one record set per
unique date. True? TRUE


Not true? Also, I don't see
any "opt1" records in your sample - are they added later
and tagged with the same date as the related records? --- NO, I just left it out of the table to make it smaller for pasting in this message. but the structure is the same as shown with a few more values in the id description field


Also, I presume that you want the new "results" record to
be tagged with the related date as well. True? YES

My day is almost over (CDT), and I want to test the idea
before I pass it along - don't get your hopes too high at
this point! My coding skills are not good, so if the idea
doesn't work with a pretty straightforward Make Table
query, then I'll have to yield to others. I'm also
thinking that an Excel solution might work, too (export
the data out, sort it, create the results record, and
import back in to Access). ------ OK THANKS

Talk to you tomorrow.
hj

-----Original Message-----
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

.


.


.