Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dmotwani
Starting Member
1 Post |
 Posted - 2005-06-09 : 21:39:40
|
| Hi,I have the following thing to accomplish - 1. One table is populated with the data already.2. I have to loop this table to get the records one at a time. 3. I have to directly dump this record data into a report.4. This report should be sent to the printer immediately without displaying on the screen.5. Loop through till all the records from the table have been read.Can you please advise, how to accomplish this?Thanks,-Deepak |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-06-09 : 22:09:27
|
| You create a "Report" in MS Access. The report does everything you mentioned; it loops through the rows in any recordset that you bind it to, and you build a template and it formats that data just the way you want, with calculations, groups, subtotals, grand totals, graphics, lines, fonts, anything you need. Once you design it and save it, you simply print it to whatever printer you want.You might want to pick up a good book on beginning MS Access or read up on "Reports" in the MS Access help file. The report wizard will help you build simple reports to get you started.- Jeff |
 |
|
|
|
|
|
Printing report directly from table data