processing table data

  • Thread starter Thread starter dave
  • Start date Start date
D

dave

Hi
I have data in one table sth like this...
test id name qty amt
3 xyz 1 12
3 xyz 2 24
GP

0
4 abc 4 1
2 xb 2 34
2 xb 2 1
GPNT extra blah
0
5 abc 2 10
NT testtest
0
2 xyz 1 3
2 abc 3 12
NT note without group
0


GP stands group, NT stands for note for only upper item...GPNT means note
for whole group..
I need to output sth like this...(grouping is by id)

id name qty amt
------------------------------------------------
3 xyz 3 36
------------------------------------------------
4 abc 4 1
2 xb 4 35
note: extra blah
------------------------------------------------
5 abcd 2 10
note: testtest
2 xyz 1 3
2 abc 3 12
note: note without group


is this possible to get this output? i m thinking its very complex..i hope
atleast you understand what I want...
pls help me..even its possible through some function or routine or some
code, tht also would be greatfull...
thanx in advance
dave
 
Hi
I have data in one table sth like this...
test id name qty amt
3 xyz 1 12
3 xyz 2 24
GP

0
Click to expand...

This doesn't make sense to me. Did word wrap make this meaningless, or
do you have a table with five fields, in which some records have four
fields occupied, some records have none, others have one, and that
sometimes text and sometimes numeric? What are the datatypes and
actual contents of the five fields? Is each field used for only one
type of data, or do you have a mixture of different datatypes in each
field? If so, *this isn't a table*.
GP stands group, NT stands for note for only upper item...GPNT means note
for whole group..

I need to output sth like this...(grouping is by id)
Click to expand...

Create a Report based on your table. Use the Sorting and Grouping to
group by ID; make the Group Footer visible and put your totals in it.

John W. Vinson[MVP]
 
hi john
thnx for prompt reply..
u need to read msg in html format to get idea wht i want..
thnx
dave
 
u need to read msg in html format to get idea wht i want..
Click to expand...

You're posting to a USENET newsgroup, which is a text-based medium. It
is NOT my responsibility to dig up some other way than my excellent
Agent newsreader to view your question; it's your responsibility to
explain your problem in a comprehensible manner. This can be done in
text; please do so.


John W. Vinson[MVP]
 
Back
Top