If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I put column headings on 2 rows in Access like Excel
In a computer class, we would like to put a column heading, such as
Technician Number on 2 rows like you can in Excel to save paper. Is there a way to do this? Thanks for your help. |
#2
|
|||
|
|||
How do I put column headings on 2 rows in Access like Excel
On Mon, 27 Oct 2008 10:01:01 -0700, Edna
wrote: In a computer class, we would like to put a column heading, such as Technician Number on 2 rows like you can in Excel to save paper. Is there a way to do this? Thanks for your help. Excel is not Access. THEY ARE DIFFERENT. A Table is not a spreadsheet. THEY ARE DIFFERENT! Tables are for data storage, not for printing or presentation. Create a Report for printing; there, you can control the labels and headers to your exact preference. -- John W. Vinson [MVP] |
#3
|
|||
|
|||
How do I put column headings on 2 rows in Access like Excel
On Mon, 27 Oct 2008 10:01:01 -0700, Edna wrote:
In a computer class, we would like to put a column heading, such as Technician Number on 2 rows like you can in Excel to save paper. Is there a way to do this? Thanks for your help. What did your instructor say? -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#4
|
|||
|
|||
How do I put column headings on 2 rows in Access like Excel
For printing always use a report. Don't print a datasheet or a form. In a
report you can control the layout in many different ways, grouping the report and including values in a group header and/or footer for instance, or you can use subreports to include data from a related table or tables. Take a look at the reports in the sample Northwind database which comes with Access to see some examples of what can be done. And read up on reports in the Help system. Ken Sheridan Stafford, England "Edna" wrote: In a computer class, we would like to put a column heading, such as Technician Number on 2 rows like you can in Excel to save paper. Is there a way to do this? Thanks for your help. |
#5
|
|||
|
|||
How do I put column headings on 2 rows in Access like Excel
Edna,
Yes, you can place this on two rows by using labels in a form or a report. This is implied in the other responses. Printing Tables and/or Queries is more of a debug or audit option and not intended for normal production reports. If you don't want to create a form or report, you still have the option to copy the table to Excel or to export to Excel - the field headings become the column headings and you may wrap the column headings. These spreadsheet results "can be printed to save paper" -- Hopefully helpful, Dick D "Edna" wrote: In a computer class, we would like to put a column heading, such as Technician Number on 2 rows like you can in Excel to save paper. Is there a way to do this? Thanks for your help. |
Thread Tools | |
Display Modes | |
|
|