Access Query Help

[ritchielong]

I have a access query made up of 2 tables [tbl_circuits] & [tbl_sitenames].
from the table circuits i am using fields [cr_name] & [cr_area] from sitenames i am using [sn_number]

i need my query to create 2 indexed columns based on the [cr_area] and then on the [sn_number]. The new [cr_area_index] will increase each time the [cr_area] value changes. and the new [sn_number_index] will increase each time the [sn_number] changes.

Any ideas, many thanks.

[PEB]

There is Sure and heavy solution by some functions in VB and CREATE TABLE QUERY

or

there is probably a solution only with SQL that don't come to my mind?


What do you want?

:)

[ritchielong]

The ideal solution would i suppose be in SQL then it can run direct from the access query page.

Thanks

[PEB]

So i've not idea yet.... I've to think!
For the other manner there is a post from today where i've posted the needed code!

[ritchielong]

Thanks Peb

Have found your post and scratching my head i cant understand the coding. So will hang fire and hope an SQL solution springs to mind.