Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2009
    Posts
    67

    Unanswered: Help with form design

    I'm having issues how to design this form. I have form with (Date, ProductID, ProductName, ProductPrice and LastNumebrSold) This information is enter daily. For each day I like to see the previous days data all in one form and update only the [LastNumberSold] and also enter any new product that was not in the day before and at the end I want to run report to give me the different between the two day's LastNumberSold. I tried Dlookup but I'm afraid I will miss product that was sold out before the new day's data. Any help with help. Thanks

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Maybe a little information about your table design might help... and maybe a screenshot of your form?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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