Comparing two records

Hi! All,

Is it possible to compare all the records in the same table with the new record.

Or

Is it possible to compare previous record with the new record.

Thanks
Vad

Are you trying to compare the entire record or do you
have a PK, unique field(s) that you are comparing?

TheOriginalStealth
>-----Original Message-----
>Hi! All,
>
>Is it possible to compare all the records in the same
table with the new record.
>
> Or
>
>Is it possible to compare previous record with the new
record.
>
>Thanks
>Vad
>
>.
>

In A record I am comparing date field which is not a primary key is comparing with another datefield in the previous record.

Hi!

I have DeliveriInformationTable which includes fields

DeliveryAgreement#(PK)
DeliveryDate---This is set to current date
DeliveryCharges
HandlingCharges
TotalInvoiceAmout
Invoice#

I have built a form based on the above table. What I am looking for is to have the same Invoice number for the Delivery information entered on the same date.

If I enter 10 delivery information, all those 10 must have the same invoice number in a format like "CurrentYear""0000". It must start at the above format. If it was next year again it must start at "CurrentYear""0000".

For the next date it must be a diiferent Invoice Number like in the above format.

For this I am looking for comparing with the previous record to decide wether it is in current date or some other date.

I am not sure how to get the above mentioned invoice#, but I am making tries.

Thanks
Vad