summarize numbers

ron1337

New member
Local time
Today, 15:26
Joined
Sep 18, 2004
Messages
5
If I have a list of numbers, how can I create a summary of them so they show sequences.
ie:
data= a100, a101, a102, a103, a105, a106, a107, a110
report= a100-a103, a105-a107, a110
 
Ron,

You're gonna have to use some VBA for this ... OK?

Wayne
 
Oh Oh, thats not the answer I was hoping for.
Is it easy to apply VBA to queries and reports?
I'm very rookie to Access, but I'm decient at VB.
 

Users who are viewing this thread

Back
Top Bottom