Results 1 to 2 of 2
  1. 03-07-2019, 11:54 AM #1
    anniehall
    anniehall is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Oct 2016
    Posts
    17

    Unit price increase and how to report historic sales as well as present sales - help needed please


    I run a very small cottage industry making and selling handmade cards. I created a database (Access 2010) several years ago to manage this, which holds details of my cards (approximately 600), all my sales, delivery info, invoice templates, etc. I now want to increase the prices of my cards.

    I'm pretty sure I know how to increase the prices across the board, but I need my reports and invoices to be able to show historic prices as well as current sales.

    Can anyone help please. Annie
    Reply With Quote Reply With Quote
  2. 03-07-2019, 11:58 AM #2
    orange's Avatar
    orange
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    See this link for info.
    AccessFunctions_SyntaxAndExamples TechontheNet
    M$oftVBA Function Details
    Debugging VBA and Error Handling
    Links to articles re Database Planning and Design
    DataPig Videos Revived DataPig Queries
    DataPig Form Basics
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Display total sales and this year sales to a specific customer
    By Thomasso in forum Queries
    Replies: 2
    Last Post: 11-14-2018, 08:20 AM
  2. Sum Total Sales Revenue by Sales Rep coving Multiple Regions in Different Months
    By macmill in forum Access
    Replies: 16
    Last Post: 12-28-2017, 02:04 PM
  3. Unit price increase and how to report historic sales as well as present sales - help needed please
    By anniehall in forum Database Design
    Replies: 26
    Last Post: 11-02-2016, 10:38 AM
  4. Allocate Purchase to Sales on FIFO basis-Updating Sales with Barcode and Splitting
    By nilnilnil in forum Programming
    Replies: 0
    Last Post: 12-13-2012, 03:18 AM
  5. making sales return(amount minus) on particular sales date...
    By alex_raju in forum Forms
    Replies: 5
    Last Post: 06-30-2011, 02:24 AM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums