C
cappiel
I have a table that contains the following data:
Field1 Field2 Field3 Field4 Field5 Field6 Field7 Field8
Field9 Field10
(null) H (null) SLD (null) next 1/11/08
test1 N (null)
(null) H (null) SLD (null) next 1/31/08
test1 N (null)
1/11/08 (null) L (null) SLD next (null)
acct (null) 1
1/11/08 (null) L (null) SLD next (null)
acct (null) -1
1/31/08 (null) L (null) SLD next (null)
acct (null) 4
1/31/08 (null) L (null) SLD next (null)
acct (null) -4
I want the query results ( or whatever means necessary) to look like
this: For each "H" line, underneath it, should be the "L" lines for
that date:
Field1 Field2 Field3 Field4 Field5 Field6 Field7 Field8
Field9 Field10
(null) H (null) SLD (null) next 1/11/08
test1 N (null)
1/11/08 (null) L (null) SLD next (null)
acct (null) 1
1/11/08 (null) L (null) SLD next (null)
acct (null) -1
(null) H (null) SLD (null) next 1/31/08
test1 N (null)
1/31/08 (null) L (null) SLD next (null)
acct (null) 4
1/31/08 (null) L (null) SLD next (null)
acct (null) -4
Any help would be greatly appreciated. I'm not surehow my data table
will appear in the post so hopefully it's clear.
Thanks!!
Field1 Field2 Field3 Field4 Field5 Field6 Field7 Field8
Field9 Field10
(null) H (null) SLD (null) next 1/11/08
test1 N (null)
(null) H (null) SLD (null) next 1/31/08
test1 N (null)
1/11/08 (null) L (null) SLD next (null)
acct (null) 1
1/11/08 (null) L (null) SLD next (null)
acct (null) -1
1/31/08 (null) L (null) SLD next (null)
acct (null) 4
1/31/08 (null) L (null) SLD next (null)
acct (null) -4
I want the query results ( or whatever means necessary) to look like
this: For each "H" line, underneath it, should be the "L" lines for
that date:
Field1 Field2 Field3 Field4 Field5 Field6 Field7 Field8
Field9 Field10
(null) H (null) SLD (null) next 1/11/08
test1 N (null)
1/11/08 (null) L (null) SLD next (null)
acct (null) 1
1/11/08 (null) L (null) SLD next (null)
acct (null) -1
(null) H (null) SLD (null) next 1/31/08
test1 N (null)
1/31/08 (null) L (null) SLD next (null)
acct (null) 4
1/31/08 (null) L (null) SLD next (null)
acct (null) -4
Any help would be greatly appreciated. I'm not surehow my data table
will appear in the post so hopefully it's clear.
Thanks!!