Group: microsoft.public.access
From: =?Utf-8?B?Qy4gSGVybmFuZGV6?=
Date: Thursday, October 18, 2007 2:11 PM
Subject: Restart Record Count

Hello, I am counting records in a query and I need the count to restart at 1
for each sub-set. In the example below, I want to count [Action ID] within
each set of [ISSUE ID] and result in [New Count]. Any suggestions are very
much appreciated.
ISSUE ID Action ID New Count
123 95 1
123 97 2
123 98 3
123 101 4
456 110 1
456 116 2
456 118 3

Thanks so much!!
--
~ Chris