I want to store the result only on printing the report.Could tell me how to do that.
I am not an Access Guru but to my knowledge if you are going to store anything to be referenced at a later date it has to be a place holder in your table. Someone with a bit more knowledge than me needs to kick in some input on this one. For me I have a place in my table to hold Unique values. Sorry I couldn't help any