Primary key, by definition, means no duplicates. How would A4 ever equal A5?

--
George Nicholson

Remove 'Junk' from return address.


"CJT" wrote in message
...
I would like this excel function =IF(A4=A5,C5-C4,C5) to be utilized as
a function in a query in MS Access where the fields that supposed to
be in column A are the primary key fields and the next fields which
are in column C, are to be calculated in.The answers to this function
are to go into a new field.....Any help please? :(