Help Formatting Reports

Chris

I have a survey with 50 choices along with a comments section for the
hospital i work at. Many of them are a yes/no/n-a.
I have the report down to two check boxes a yes/no, if it is yes it is
checked and a n/a box. This report,when printed out, takes 2 8.5x14
pages, landscaped. i brought the margins down to .5 all around.

The report is something like this, per page

questions--------------------------------------------------
Answers---------------------------------------------------

What I would like to do is something like this, per page.
questions-----------------------------------------------
Answers------------------------------------------------
Questions---------------------------------------------
Answers----------------------------------------------
Also I would like to consoldate the fields in the report.

Instead of having
yes/no n/a

I would like to have something like
yes/no/n-a

Thanks for your suggestions

Chris

Nov 13 '05 #1

Subscribe Post Reply

1069

Salad

Chris wrote:

I have a survey with 50 choices along with a comments section for the
hospital i work at. Many of them are a yes/no/n-a.
I have the report down to two check boxes a yes/no, if it is yes it is
checked and a n/a box. This report,when printed out, takes 2 8.5x14
pages, landscaped. i brought the margins down to .5 all around.

The report is something like this, per page

questions--------------------------------------------------
Answers---------------------------------------------------

What I would like to do is something like this, per page.
questions-----------------------------------------------
Answers------------------------------------------------
Questions---------------------------------------------
Answers----------------------------------------------
Also I would like to consoldate the fields in the report.

Instead of having
yes/no n/a

I would like to have something like
yes/no/n-a

Thanks for your suggestions

Chris

A very confusing message. Is this simply a report to print the survey
or is it to print the report with the data that has been entered?

Regarding your 1 page per question...double click on whatever band the
questions/answers is on and make sure that you have KeepTogether set to
true and that the PageEject is not set to After or Before.

Nov 13 '05 #2

by: Mike MacSween | last post by:

tblCourses one to many to tblEvents. A course may have an intro workshop (a type of event), a mid course workshop, a final exam. Or any combination. Or something different in the future. At...

Microsoft Access / VBA

reports/ can we alternate no shading and then shading for multiple records such as a phone directory to help distinguish

by: buck | last post by:

reports/ can we alternate formatting such as "no shading" and then "shading" for multiple records such as a phone directory in Access2000 reports

Microsoft Access / VBA

Curious about Access 12 Report Formatting

by: Dave | last post by:

I was curious in regards to Access 12; specifically more fluent report formatting. I'm an average user, but from my end, I find more and more need for cleaner reports....and do not always want...

Microsoft Access / VBA

Export Help

by: JayDawg | last post by:

If anyone is willing to provide some consulting pro-bono, or for a very small charge I would really love the asistance. If anyone can fix my problem here online that would be even better. Here...

Microsoft Access / VBA

Help creating a 'legend'

by: Swans, What Swans? | last post by:

In one of my tables, in addition to a text field that is a Description field, there are two fields for color formatting the data in reports. They are Longs and hold the foreground and background...

Microsoft Access / VBA

Access Report Issue - Really Need Help

by: narpet | last post by:

Hello all... My company generates reports in an Access database that are used as quotes for our customers. We have always then mailed (snail mail) the quotes to the customer. Now my boss wants...

Microsoft Access / VBA

merging Access query into Word document HELP

by: babyangel43 | last post by:

Hello, I have a query set up in Access. I run it monthly, changing "date of test". I would like this query to be merged with a Word document so that the cover letter is created in Word, the fields...

Microsoft Access / VBA

Conditional Formatting on ACCESS reports

by: GAC | last post by:

I've used conditional formatting on ACCESS reports but have come up with a problem using it for a FIELD that has a value of either YES or blank/null. The default formatting (used when condition(s)...

Microsoft Access / VBA

Crystal Reports Custom Rounding/Default Number Formatting in crosstable

by: Pittaman | last post by:

Hello I am creating some crystal reports (for visual studio 2005) based on the content of certain .NET objects. I'm doing this in .NET 2.0. For one of them I'm using a Cross-table to summarize...

.NET Framework

Access Conditional Formatting Help

by: summerlw | last post by:

Access 2003 VB 6.5 I'm attempted to run conditional formatting on a date field based on the value in another field. I've steped through this code and it is recognizing the values correct and is...

Microsoft Access / VBA

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Similar topics