Can someone help?
I have 7 records in the underlined query and it is
supposed to fit on one page but for some reason it
produces 2 pages. and I checked all the sizes of the

I am using a field [SeatsContact] on my report that in design mode, looks
like a drop down box.  The Row source for this field follows:  SELECT
[zPTContracts].[ContractsKey], [zPTContracts].[Contracts] FROM
[zPTContracts]

I have made a report of the sales but the date in the query is fixed. I want
my user to change the date quickly. How do I insert a question box or input
text box.
Thanks

I'm having some major problems with Access reports at the moment. I've
designed a VERY simple database for the school where i work to aid in the
writing of pupil reports.
In the Access report i can get the data to run in colums across the page,

I open a report through a button in a form.
This form is a result of a consultation, and the same sql that I use when
making the consultation, I pass for the report.
How to order the in accordance report below:

I have a report that I've grouped three memo fields:
Leadership, Employee, Other Comments.  
I have a header for each field, but now there is too much space after each
field, especially if there is no data in Employee and Other Comments.  I've

How is it possible to print a report to one printer tray and then a copy to
a second printer tray?
Thanks
Regards

I'm trying to use Access' report feature to print out a one-page summary of a
single record within a table. Instead, every time I try to print the report,
it prints once per entry in the table. For example ... if my table has five
entries in it, and I only want to print out a ...

Hi--
What I'm trying to do is something very simple.  I am trying to append
text to a report in Access only when there is data listed.  Let me 'splain.
This database is used for tracking computer inventory.  One particular

Is there any wasy by which i could convert my access reports to word
document, without changing its formatting.
Thank you.
Taher.

Hello,
I need to get some help with how to sort a report item.  It is not assending
or descending.  I need it in a specific order.  I'm at a loss.
Project #0014  Johnson House

I am trying to calculate how many times the letter C appears in a text box on
a report and display the total in another text box. Can anyone help?
Please.
Thanks.

I have created a report based on a parameter query and a sub-report within
the main report based on a seperate but related parameter query.  When I run
the report I am initially asked to enter the parameter data for both queries.
As I advance the report to the next interation of ...

In access how do I print 2 pages on one sheet? ie page 1 & 2 on sheet 1, page
3&4 sheet 2 ....

I am attempting to  printa current record on a report. This is the code I am
running
   stDocName = "Flight#"
   DoCmd.OpenReport "flight#", acNormal, , "[Flight_Number] =