Results 1 to 2 of 2
  1. #1
    Rhubie is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2012
    Posts
    85

    Calculated Fields in Entry Form

    Table Pricing


    Pricing Query

    I am building a data entry form - when they enter their date I want it to save to the pricing table. The pricing query has calculations built in - can I use the pricing query to build the form - and show the calculated fields on the form - refresh before saving to the pricing table? Will the data be saved to the Table? The calculations will not be saved to the table.

    Or should I build the form on the pricing table and create fields in the form to show the calculations?

    I'm kind of new to the form building.

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    can I use the pricing query to build the form - and show the calculated fields on the form
    Sure, nothing wrong with that as long as you aren't trying to store/save the calculated values in the underlying table.

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

Similar Threads

  1. Replies: 6
    Last Post: 09-27-2012, 08:27 AM
  2. Replies: 1
    Last Post: 03-27-2012, 05:25 PM
  3. Replies: 0
    Last Post: 02-24-2012, 11:16 AM
  4. Replies: 1
    Last Post: 05-04-2011, 03:51 PM
  5. Calculated fields in form
    By speckytwat in forum Access
    Replies: 15
    Last Post: 04-27-2011, 05:01 PM

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