Question Change Records

[duvenhlc]

I need to due an calculation in a query. The qurey needs to count the number of records, fine I can do that. I then need to use this record to give each record a certian value. For instance I have another calculated value, say 6 and there was 3 counted records in the query. I the devided 6 by 3 to get 2. I want a certain field in the first record to be 0 the same field in the second record must be then be 3 and same field in the third record must be 6. This nubers will constanly change depending on the number of records and the calculated value. I think I need to loop trhough the records and is not sure how to do it. These answers do not need to be saved in a table, need to output it in a report.

Thanks

 

[ezfriend]

Perhaps, describe what you are trying to accomplish rather than explaining your record results so we have a better picture of what's going on.

Peace.
EZfriend

 

[duvenhlc]

Ok,

I need to do an Audit on something. There is like x amount of main headings. Under these is headings is questions. If you select a question a the posible answers is displayed. if you select the answers a value is alowcated to a question (record in access). I can then list the scores from the highest to the lowest for the main headings. The main catagory is divided into a % based on the users discretion but adds up to 100%. The questions is then also a fraction of the main catogory. If a catogry is like 15% and there is three questions will each question be 5% there off. Each answers should then have a % alowcated to it. Meaning that if you select the lowest one you score 0 and at the highest full score. The amount of answer to a question can differ depending on the question type. It is this last part what is the problem, how do I do final allowcation of values to the answers.