Report setup

[Damon Heron]

I have a db that the client wants me to prepare a report of transactions,
from the transaction table, in the following format:
(TT = transaction types)
(Each lot may have none or many transactions of each type)
TT1 TT2 TT3 TT4

lota 0 10 8 2
lotb 5 0 0 1
lotc 1 5 0 0
""
etc.

I am able to create a report that has the lots listed sequentially, then the
details of the lot transactions, but not in the above format. Any ideas?

Damon

 

[Olduke]

Create a new report using the wizard.
When it asks you for grouping options, select the Lot as your group.

 

[Duane Hookom]

Your table structure isn't clear. I assume you have normalized data that can
be presented in a crosstab query/report with TTs as column headings.