Recent content by aqueue

  1. A

    BOM Database

    Ok. Right I have been getting errors on those link you sent. I think it is probably because I am very tired! I decided to simplify the database as I think adding all the classifications and overhead might have confused everything. I can accomplish everything else using basic queries and...
  2. A

    BOM Database

    Hi. Thank you for the reply. That is correct... So keeping up with food: SKU's Flour Salt Water Pepper The above makes a small cakes (probably wont taste nice!). Then I take 6 of those, ad a bit of packaging and then create my finished good which is sold. More then happy to...
  3. A

    BOM Database

    Hi Guys. Happy 2017! I tried to repurpose an old thread ID 149001 (sorry cant post links yet) but got lost in translation. The principle is the same. You have ingredients --> component --> finished good. With just these three levels, I could create three queries and the costs could roll up...
  4. A

    Hi from UK

    Hi. Just a quick into from me. I am a basic Access user and solve my problems by using queries upon queries upon queries or a million intermediate tables. However, I am stuck on something which I will start a new thread. I am probably a little better in Excel as I find that easier and use it...
Back
Top Bottom