Results 1 to 3 of 3
  1. #1
    Baks is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2017
    Posts
    1

    Entering calculated data from a query to a table


    Hi I have a problem with calculating data. I need to do a database wher I have a products and their costs in one table, do a one to many relationshop to another table (orders) then calculate an overall cots based on cots of the products selected and amount of products selected. I can calculated this in query but I don't know how to insert data into field. I'm new to databases. I hope anyone know what I mean and can assist me as I already spent few hours on that one field:/

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    It is not normally considered to be good practice to save calculated data to a table. Better to do the calculation whenever and wherever it is required.
    If you have the calculation in a query then you can show the result in a form or report based on that query
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    You may get some ideas for a Customer--Order--OrderDetail---Product database design from this link.


    Also this free tutorial from RogersAccessLibrary will also help with the steps involved to design a database to match requirements.
    Spend 30-45 minutes working through the tutorial to experience the design process. It can be used with any database.

    Good luck.

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

Similar Threads

  1. Replies: 2
    Last Post: 07-29-2015, 07:31 AM
  2. List Box selection not entering data in table
    By MFS in forum Programming
    Replies: 6
    Last Post: 03-19-2013, 11:03 AM
  3. Replies: 12
    Last Post: 10-15-2012, 08:07 AM
  4. Replies: 2
    Last Post: 11-02-2011, 08:10 PM
  5. Replies: 0
    Last Post: 03-15-2010, 02:38 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
  •  
Other Forums: Microsoft Office Forums