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

Running count in Access query

P: 2
I have a simple select query that produces results similar to this

LOCATION FUNCTION
001 1111
001 1111
100 1111
100 1111
100 1121
100 1131
200 1111
200 1111
201 1111

I would like to have a new field in my query to produce a running count (RunCount) based on the unique combination of Location and Function. The result I am looking for would appear like this:



RunCount LOCATION FUNCTION
1 001 1111
2 001 1111
1 100 1111
2 100 1111
1 100 1121
1 100 1131
1 200 1111
2 200 1111
1 201 1111

Thanks in advance for any and all help !!

Loki
Dec 28 '06 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,271
I don't believe you can do this without complicated VBA code being written in a function. You do realise that this is completely foreign to how queries are supposed to work? (Not that that makes this an unusual question unfortunately.)
There is no relationship between records in a dataset except the format they share.
Dec 30 '06 #2

Post your reply

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