Lord_Vader
Registered User.
- Local time
- Yesterday, 23:23
- Joined
- Mar 24, 2009
- Messages
- 15
I want to add "record numbers" in a query based on more than one field.
Notice how the "Want" column resets ordering at a new person, and doesn't increment when Person & Field 2 are the same.
I can do this with more than one query, but I was wondering if there was a more concise way (With DCount maybe?) (Though I realize that is essentially another query as far as access is concerned)
EDIT: Table didn't format, attaching as excel
Notice how the "Want" column resets ordering at a new person, and doesn't increment when Person & Field 2 are the same.
I can do this with more than one query, but I was wondering if there was a more concise way (With DCount maybe?) (Though I realize that is essentially another query as far as access is concerned)
EDIT: Table didn't format, attaching as excel
