Search results

  1. C

    Question Stock FIFO example

    Dave, I have no doubt you know what you are talking about from your first post! I dont want to get too complex, while practicing coding and access for a real world problem, so any help would be greatly appreciated . :-) To try and keep it simple - i need to firstly copy the records to the sock...
  2. C

    Question Stock FIFO example

    unfortunately that is one of the parameters - as each week when we buy some nails for example the price will change - thus putting in a price when we purchase. likewise for sales this too can be flexible, and easier at this stage to keep it variable. Thus the key for FIFO is to attribute the...
  3. C

    Question Stock FIFO example

    Right – many thanks so far however I am trying and getting nowhere fast! So as a quick summary I am trying to have a database working on a FIFO basis and record items. Having taken the previous database, I am tyring to adapt it. I have a few tables: 1. Products (no and name) 2. Customers (no...
  4. C

    Question Stock FIFO example

    JHB thats brilliant thanks for the tip! - once i have sorted out this issue will be asking how the user managed to do the security bit! Gemma - T-H Fifo is quite an important bit of coding - mainly for items that are low value and relatively high turnover, ie birthday cards etc, where we have...
  5. C

    Question Stock FIFO example

    Hi all, I know this has been posted before, however the link, and database put up by someone is locked so that I cant see how the person has coded their database to show how to sell stock at a FIFO basis for cost of sales? Does anyone have a working example of a stock database which I could...
  6. C

    Hi From Simon

    Hello all just arrived onto the forum - am currently using access 2013 having used 2003 for a while. living in london and a fair novice at programming and coding hope you all can help! Simon:banghead:
Back
Top Bottom