Unique Index required in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 an SQL solution which will enable 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.
 
Back
Top