M
marksac
Guest
I have a table that has a column with records from 1-5.
There is 1300 records & each has a field called QG which has a number either 1, 2, 3, 4 or 5. What I am trying to do is to have a count of 1's (for example) in some type of display (text box or something) & so once I will delete some records from that form/subquery it will update the number of 1's in that text box.
I am trying to get an running count of certain types of records. Here is what I have. I have a form that has a subquery loaded in there where I select certain records & I move them out then refresh the query (still within the Form). What I am trying to do is to get a running count of certain type of number that exists in a record field I call it QG. There is three types of numbers in there 1 , 4 & 7. I want to set up a field that will give me a running count of those three numbers in seperate fields.
Thanx
There is 1300 records & each has a field called QG which has a number either 1, 2, 3, 4 or 5. What I am trying to do is to have a count of 1's (for example) in some type of display (text box or something) & so once I will delete some records from that form/subquery it will update the number of 1's in that text box.
I am trying to get an running count of certain types of records. Here is what I have. I have a form that has a subquery loaded in there where I select certain records & I move them out then refresh the query (still within the Form). What I am trying to do is to get a running count of certain type of number that exists in a record field I call it QG. There is three types of numbers in there 1 , 4 & 7. I want to set up a field that will give me a running count of those three numbers in seperate fields.
Thanx
