abesimpson
Active Member
- Joined
- May 3, 2003
- Messages
- 435
I import a text file of several million records into Access every month .
Each record has a date field, and a value field. The database is sorted first on date, then on value. Each date has many values, but there is no fixed number of records per date.
The sorted database looks like this:
Date1, Value1
Date1, Value2
Date1, Value3
Date1, Value4
Date2, Value1
Date2, Value2
Date2, Value3
Date3, Value1
Date3, Value2
Date4, Value1
etc.
I need to add a count per record, to get this:,
Date1, Value1, Count1
Date1, Value2, Count2
Date1, Value3, Count3
Date1, Value4, Count4
Date2, Value1, Count1
Date2, Value2, Count2
Date2, Value3, Count3
Date3, Value1, Count1
Date3, Value2, Count2
Date4, Value1, Count1
etc
I habve NO idea how to do this. Any help will be appreciated.
abe
Each record has a date field, and a value field. The database is sorted first on date, then on value. Each date has many values, but there is no fixed number of records per date.
The sorted database looks like this:
Date1, Value1
Date1, Value2
Date1, Value3
Date1, Value4
Date2, Value1
Date2, Value2
Date2, Value3
Date3, Value1
Date3, Value2
Date4, Value1
etc.
I need to add a count per record, to get this:,
Date1, Value1, Count1
Date1, Value2, Count2
Date1, Value3, Count3
Date1, Value4, Count4
Date2, Value1, Count1
Date2, Value2, Count2
Date2, Value3, Count3
Date3, Value1, Count1
Date3, Value2, Count2
Date4, Value1, Count1
etc
I habve NO idea how to do this. Any help will be appreciated.
abe