Results 1 to 3 of 3
  1. #1
    radian89 is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    Dec 2015
    Posts
    37

    Wholesale and Retail Price based on Buy item quantities

    Hi...

    I just wondered, where can i find something to learn & read for Pricing rule, between wholesale & retail price.


    my goal is i want to create invoice with pricing based on buy quantity, so the price displayed & agreed are based on that.
    example :

    if i buy :

    less than 20 pcs (1-19) = retail price
    more than 20 pcs (20-more) = wholesale


    how to do it? the table, queries, relationship, code, etc.
    Help please

    thanks a lot
    warm regards,

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,646
    Learn relational database principles and design. Here is a good tutorial site. http://www.rogersaccesslibrary.com/
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    radian89 is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    Dec 2015
    Posts
    37
    Quote Originally Posted by June7 View Post
    Learn relational database principles and design. Here is a good tutorial site. http://www.rogersaccesslibrary.com/
    Hi June7,

    thanks a lot for the link

    warm regards

Please reply to this thread with any new information or opinions.

Similar Threads

  1. one Price for first item, another price after that...
    By santinimatias in forum Database Design
    Replies: 3
    Last Post: 02-11-2015, 03:11 PM
  2. Replies: 9
    Last Post: 03-13-2014, 07:42 AM
  3. Item without price, or duplicate price
    By Auto in forum Reports
    Replies: 5
    Last Post: 07-29-2013, 09:46 PM
  4. Replies: 5
    Last Post: 07-29-2011, 12:55 AM
  5. retail and wholsale in a ms access 2007 database
    By damie in forum Database Design
    Replies: 7
    Last Post: 12-16-2010, 12:29 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums