Number rows in Query

[lexi0088]

I am trying to number my rows that appear in my queary. The query actually goups and sums data, so the count function will not work. I have the following code in my module:

Global IncrementVariable As Integer
Function IncrementValues(QTY) As Integer
IncrementVariable = IncrementVariable + 1
IncrementValues = IncrementVariable

End Function


The following field in my query:
Seq #: IncrementValues([QTY])

The problem is that the number does not start with 1, it starts with 2 and then increments by 2. It aslo does not reset when I close and rerun the query. Please help.

 

[lexi0088]

I have figured out part of my problem... I was refrencing this increment field in another field, which was making it increase by 2. Any reason why you cannot reference this field?

 

[wnz]

I am also trying to add a field in my query to include an incremental number for each row of the query result. I started using Access a month ago and so far know nothing about coding and modules. I'm wondering if there is anyway to make this happen without writing code. If coding is a must, could someone tell me where to start?

Thanks a lot in advance!

 

[dhookom]

wnz,
Check the FAQs for this forum.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]