collapsing query results

[Lydia]

I have a query that returns a result set like this:

Rec ID 1: Ledger = FY07 Amt = $300.
Rec ID 1: Ledger = FY06 Amt = $200.
Rec ID 1: Ledger = FY05 Amt = $100.
Rec ID 2: Ledger = FY07 Amt = $30.
Rec ID 2: Ledger = FY06 Amt = $20.
Rec ID 2: Ledger = FY05 Amt = $10.

I need a report that looks like this:

Rec ID FY07 FY06 FY05
1 $300. $200. $100.
2 $30. $20. $10.

Note that while it might appear that a crosstab query would work, in
fact, there are several fields that will fill in where I have noted
the "Rec ID" above and I anticipate that these fields will take 2-3
lines.

Is there some way to create a query that will let me do this?

Lydia

 

[Stefan Hoffmann]

hi Lydia,

I need a report that looks like this:
Rec ID FY07 FY06 FY05
1 $300. $200. $100.
2 $30. $20. $10.

Note that while it might appear that a crosstab query would work, in
fact, there are several fields that will fill in where I have noted
the "Rec ID" above and I anticipate that these fields will take 2-3
lines.

Which "several fields"? Are they functionally dependen from RecID? Then
you may use DLookup() in your report.



mfG
--> stefan <--