Unique Index required in a query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ritchie9710 - 26 Sep 2006 13:59 GMT

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.

Reply to this Message

[MVP] S.Clark - 26 Sep 2006 15:38 GMT

I would create the destination table ahead of time, with the needed indexes.
Then use a delete query to empty it, and an append query to populate it,
each time you need to do your process.

Signature

Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

>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
[quoted text clipped - 7 lines]
>
> Any ideas, many thanks.

Reply to this Message