Rows into column headers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The table is transaction and has Type as one of its columns, so as I enter
data, I'm entering rows of data for different TranTypes. There is one
instance where I will only have two rows of data for two different tran types
and I want to make a report with those types as column header. Is there any
way to do this?

Data in DB:
memberNo | Type | Amt
1 Admin 5
1 Dep 4

For report

Member No. Admin Dep
1 5 10
2 4 14

etc.
tia
 
Back
Top