Results 1 to 4 of 4
  1. #1
    PATRICKPBME is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2016
    Posts
    171

    Form Entries Not Appearing in Database?

    I needed to enter a new field in a form that divides gross yearly pay by 26. I created a field in my DB entitled "pay period". I then added that field to my form with the function of this file would equal the gross pay field divided by 26. Now, when I enter the gross pay on the form it automatically divides the same by 26 and enters the figure in my "pay period" box. However, when I run a query which includes the "pay period" field I get nothing but blanks. Looking at the database I have found that none of the entries on the form that are automatically calculated appear in the database.



    Wondering if I should have set the function in the database instead of on the form, assuming that can be done???

    Thanks!

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    PATRICKPBME is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2016
    Posts
    171
    Just glanced at this briefly and it appears it will have the answer to my question. Thanks. I will mark this as solved and come back later if needed.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    No problem.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Data not appearing now in form
    By Waterdog in forum Forms
    Replies: 13
    Last Post: 08-28-2015, 12:57 PM
  2. Record Not Appearing in Form
    By MatthewR in forum Forms
    Replies: 29
    Last Post: 06-25-2015, 06:39 AM
  3. Entries automatically appearing
    By ghard123 in forum Access
    Replies: 2
    Last Post: 11-20-2014, 12:47 PM
  4. Replies: 4
    Last Post: 11-03-2014, 08:36 AM
  5. New Employee not appearing in form
    By Canadiangal in forum Forms
    Replies: 1
    Last Post: 06-09-2013, 05:15 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