by Nasa_r » Sat, 03 Nov 2001 07:15:14
I would like to "group" data to show only the following:
Current Report Output
H1216 4
H1216A 6
H1216AA 7
H1216AB 8
H1216AC 9
H1216Z 4
Would like to create a report that looks like this instead:
H1216 4
H1216A 30
H1216Z 4
Thanks.
--
Posted from rsahnchez.arc.nasa.gov [143.232.150.14]
via Mailgate.ORG Server - http://www.Mailgate.ORG
by Paul Brunea » Sat, 03 Nov 2001 12:55:19
yourNewField = Left(yourExistingDataField, 6)
Then you can sort on that new field and make a summary field for it.
Cool?
PB
PS: This will only work for the type of data that you have shown in your
example. You will have to get creative if one of your possible pieces of
data is
H12167AB
or
H121AA
> I would like to "group" data to show only the following:
> Current Report Output
> H1216 4
> H1216A 6
> H1216AA 7
> H1216AB 8
> H1216AC 9
> H1216Z 4
> Would like to create a report that looks like this instead:
> H1216 4
> H1216A 30
> H1216Z 4
> Thanks.
> --
> Posted from rsahnchez.arc.nasa.gov [143.232.150.14]
> via Mailgate.ORG Server - http://www.Mailgate.ORG
I have a Leads table for a Telemarketing company that stores over 20,000
leads for about 10 agents. That would average 2000 leads/agent. Each of
the 10 agents have a unique AgentID numbered 1-10 appropriately assigned to
each record in the LEads table. The data is arranged in a random order in
the table.
So, here's my question. I would like to group 2,000 or so leads for each
agent in a unique way. I want the data to list each new AgentID after every
record and repeat it 2000 times for each of the 10 agents. Here's a data
layout example:
(Note the AgentID column)
LeadID,AgentID
1001,1
1005,2
1009,3
1010,4
1002,5
1003,6
1004,7
1007,8
1006,9
1008,10
1014,1
1019,2
1015,3
...
Thanks
2. No Result Set Returned from SP in ASP Page
3. SQL Question: Help with grouping data
4. tempdb
5. Grouping data by rules (top 10 - MDX / OWC question)
6. US-TX-ANALYST NEEDED IN DALLAS, TX
8. How to use Recordset Object to run stored procedures in VC++6?
9. Beneficial to group data types when creating tables?
10. Grouping data in an SQL query