Results 1 to 2 of 2
  1. #1
    fairyrak is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2016
    Posts
    6

    there is no autofill in access so how do you make this formula?

    Hi, I used excel a lot and there was this nifty autofill feature but I now have access and I don't have idea how to autofill formulas or something, my problem is exactly that:



    I have a table, i want to add a new field:

    I want a field named qx with a formula that if for example I write 251 in the field value of the field pr, record 1504 then:
    the field value of the field qx and record 1504 is the number of records that exist in overall in the field pr that have a value of 251 (but only counting from the record 1 to the record1504)

    But I don't want this for only the row 1504, but I want that in the future when I enter info on the record 1505, and I write lets say 232 in the field value of pr then the field value of qx becomes how many times there was a value of 232 in pr (from the record 1 to the record 1505 now!)

    By the way, I'm only used to excel, so in this access forum I guess you wouldn't say "the cell D12444" (assuming that its field name is fie and its record number is 12444?) but then how do you say it?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    There IS an auto fill,sorta. Not as good as excels tho.
    you can run a query to fill many fields. Excel can't.
    access doesnt use cells. But you use the index to update the record.

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

Similar Threads

  1. Access autofill from one table to another
    By chorne in forum Access
    Replies: 7
    Last Post: 09-12-2016, 09:25 AM
  2. Replies: 19
    Last Post: 07-13-2015, 10:15 AM
  3. Replies: 41
    Last Post: 05-29-2015, 02:58 PM
  4. Replies: 1
    Last Post: 02-14-2015, 02:29 AM
  5. Access Form Autofill Option
    By smarty84handsome in forum Forms
    Replies: 9
    Last Post: 01-08-2012, 08:06 PM

Tags for this Thread

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