Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2009

    Unanswered: Can someone help me with this

    I have form bas on Table that has these fields [ID] [Salesdate] [SerailNumber] [BookNumber] [EndingNumber] and the table name is TblSales. How do I code for a form that will show me all [SerialNumber] where there was [EndingNumber] on the perivious date but there is no EndingNumber entered on current date. Forexample

    [ID] [Salesdate] [SerailNumber] [BookNumber] [EndingNumber]
    1     07/01/09    1234              1022             125
    2     07/01/09    1222              1028             130
    3     07/02/09    1234              1022             156
    In this senerio I would like to see SerialNumber 1222 since there was entery on the previuos date but no entery on today.
    Last edited by healdem; 07-03-09 at 04:24.

  2. #2
    Join Date
    Apr 2005
    Zagreb - Croatia
    Look at "DemoSerialNumA2000.mdb" (attachment, zip).
    Open Form1 and try.
    Attached Files Attached Files

  3. #3
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    sorry don't understand the logic of what you are trying to do with that......
    mebbe its me..
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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