Search results

I cant thank you enough! Autonumbering in Query Column is the solution I was looking for! Worked perfectly!

Thank you for the effort! I had gotten to that point. Where I get confused is how to keep the number from increasing. If you open the form/query/report and scroll down or click anywhere the number will start to increase. We will just make sure the report is ran immediatly after the...

Here is the quote from a website, I cant post the link yet..... How can I generate a sequence of numbers (like record numbers) in a query. In a module: (declarations)Option ExplicitDim mlngCounter As LongFunction ResetCounter() mlngCounter = 0End FunctionFunction GetNextCounter(pvar As Variant)...

I do understand it is increasing because of the query. What do I need to do to get the ranking of the AvgScore out of total qty of questions? Is a Dcount? if so I dont know how to do that. It keeps coming back wrong. I need to produce a report that shows: Question1: AvgScore: 2.37 RanK: 4...

OK, because I guess this isnt clear. The database that was suggested in an earlier post. Showed us how to code the query to generate an auto number. Basicly my co worker needs to generate a table of data that shows questions 1-100, thier averages, and the number that average falls under...

This helped is a lot for a similar question. However, how do you keep from the auto number from changes (Increasing each time) I have to leave access and return for the number to start again from 1. The number will keep adding if i view the report, query, or do anything to it. Your help is...