Two problems in one report:
I am reporting a list of names.  
(1)I would like the data (one field: "name") to print in
two columns.  In 'Columns' under 'Page setup' I have set

I want to set up a facsimile transmittal that will be printed.
Most of the fields can be retrieved throughout my database, but two sections:
1. The number of pages that will be faxed
and

Im trying to open a report using a print buton and restrict its records to
the value of a text box on a form.  Under a print button I have this code
DoCmd.OpenReport "rpt_SelectMemberRequest", acViewPreview, memberID =
Forms!frm_memberOverrideRequest!txtMemberID

Several weeks ago, one of your experts (Steve Schapel) showed me how to
determine the quarter in which an employee becomes eligible for a particular
benefit.  The formula Steve showed me was:  
DateSerial(Year([HireDate])+1-(Month([HireDate])>9),(DatePart("q",[HireDate])*3+1)

Hello, please help.
I have a form that contains selection criteria (combo box). There is a
Preview_Report button, and when clicked, displays the Report based on the
criteria selected. I also have a Report, that sourced its values from a Query.

I am trying to create a report which groups on the week ENDING date.  In
addition to do this i need to total a number of values for the 7 days prior
to that week ending date.  This is based on a table which would contain the
daily sales figures.

i have a report in a particular format (with company logo, address
etc) in access. i want to export that to excel in the same format. How
is this possible. If i do 'Analyse with excel' the format is lost. How
do i regain the format.

I am trying to create a report in Access that will count number of calls per
sales rep per product.  So...I would like to break the report up by months
and for each month display about 8 product names horizontally across the top.
Then, along the left side, I want to display the ...

My main report has 7 subreports that are unlinked.  
It will currently print part of sub report on one page and the balance
on the next page.
How do I make subreports print entirely on one page?

Anyone know how to use a control in a report to enter data before the report is printed?
I want to put a text box on a report and use it to
enter a value which will then be used to format the report.
I don't want to use a form to hold the text box. I want a stand-alone report that ...

I have a query based report (rptClientQuestionaire) based off a client ID
text field when it is opened ie: C-2004-1011
the information on the report takes up more than 2 pages so i had to create
a 2nd report page to get all the information i needed on 1 printed report,

I have a report with a report header and report footer.  When I make this
report a subreport, only the report header appears.  Why is that, and how
can I change this?

I have successfully created a label report and I would like to know how to
print only one label at a time instead of a full sheet.  If you reply with
code could you advise me where to apply the code as well.
Thanks in advance

Hi - I am trying to combine multiple reports into one without changing
anything(report,header,detail)on the subreports. I am simply trying to put
reports end-to-end for easy printing.
But when I insert individual reports under "detail" section of the main

I like to show previous month on the report during current month, how could
I do this?
Appreciate any help,
Sarah