Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Control # of columns from VB code?
- Thread starter mclosson
- Start date
Hi,
I recommend using crosstab reports in case the number of columns is varying about the data in a table.
For example, i had to make a report from the payroll. The data's organized so that every record has EMPLOYEE, TYPE-OF-TRANSACTION, AMOUNT (just for example). I used i cross-tab so for every TYPE-OF-TRANSACTION the report will grow a column.
I hope i've been clear enough.
Good luck.
I recommend using crosstab reports in case the number of columns is varying about the data in a table.
For example, i had to make a report from the payroll. The data's organized so that every record has EMPLOYEE, TYPE-OF-TRANSACTION, AMOUNT (just for example). I used i cross-tab so for every TYPE-OF-TRANSACTION the report will grow a column.
I hope i've been clear enough.
Good luck.
- Status
Similar threads
- Question
- Locked
- Question
- Locked
- Question