Comparing two records

[Guest]

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

 

[OriginalStealth]

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

TheOriginalStealth

 

[Guest]

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