By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
460,045 Members | 1,389 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 460,045 IT Pros & Developers. It's quick & easy.

Access Query Help

P: 4
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.
Sep 26 '06 #1
Share this Question
Share on Google+
4 Replies


PEB
Expert 100+
P: 1,418
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?

:)
Sep 26 '06 #2

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

Thanks
Sep 26 '06 #3

PEB
Expert 100+
P: 1,418
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!
Sep 26 '06 #4

P: 4
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.
Sep 26 '06 #5

Post your reply

Sign in to post your reply or Sign up for a free account.