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?