Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    160

    Unanswered: Comparing 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
    Vad

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    define "compare"
    define "previous"

    (and i'm not just being difficult!)

    izy
    currently using SS 2008R2

  3. #3
    Join Date
    Aug 2003
    Posts
    160
    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.

    My apologies I already posted this in the form, no one replied for this.

    Compare: Comparing the date field with the last record entered into the table.

    Previous:The last record entered into the table.

    Any help

    Thanks
    Vad

    Originally posted by izyrider
    define "compare"
    define "previous"

    (and i'm not just being difficult!)

    izy
    Vad

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •