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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Data Reports
I’ve used something along this line to edit report outputs on the fly from SQL. This may help. SELECT OutputColumn1, (SELECT 'test1' = CASE WHEN (Field = ‘@euro’) THEN " € " + OutputField2 END) AS 'OutputColumn2', OutputColumn3 FROM tblReport Results should be...- Trighosts
- Post #2
- Forum: Visual Basic (Classic)
-
Need some advice on Report Generating
Current situation is: I am generating a report by parsing through a record set and populating an Excel 2000 spreadsheet and invoking the print. Reasons and benefits are as follows: 1. The base document is easy to edit in Excel 2. The document is in Landscape format and is slightly wider than...- Trighosts
- Thread
- Replies: 3
- Forum: Visual Basic (Classic)
-
Moving Data From one column to another on different rows
Jamfool Thank you very much. I will have to make some modification. However, you have put me in the right direction. Any day I learn something new is a good day. Thanks -
Moving Data From one column to another on different rows
table: 4 columns col1: userID, col2: YearRef, col3: PastYearData, col4: CurrentYearData example: col1 col2 col3 col4 1 2003 xyz abc 2 2203 qrs zzz 1 2004 abc 123 2 2204 zzz 456 Each year I need to keep track of current data (CY) and past data (PY). Looking for a...
