i was able to go in design view to widen and extend labels and descriptions.
now when i do this, only a few pages will print instead of 10. anyone know
what i did to cause this and the fix

I have a report designed and I would like to add a count of the total number
of items on the report at the bottom.  How do I do this?
Thanks

       I want to open a query, and print it out.  Right now, I'm using the
code:
       DoCmd.OpenQuery "qryMyQuery", acViewPreview
       Of course, when the query opens, the heading is "qryMyQuery."  Is

Im having trouble displaying the query data on my reports.
I have figured out how to display one set of the data, that was 'site name',
however when trying to display the start/finish dates of the query I cant
find it the same way using the control source function.

I have one column of data (say 10 items) that I would like to format into
columns of 5.  How do I do this?

I have an Access97 frontend/backend database running on w2k os. The
problem I'm having is with one user. When then preview a report the
report appears to be enlarged. What should print on 2 pages consumes 10
pages. Any ideas what might be causing this?

I currently have 6 new Dell computers all with XP-OS and
Office Pro 2003. Only one of them will open/edit/print
Reports in Access. All the user accounts are "Standard
User", and it doesn't matter whether the data is local or

Hello.  Not sure if this is a report question, or query question, but here's
my problem.
I have several yes/no fields in a table, for example, Quote Declined, Quote
Issued, and Quote Bound.  I need to report on the number of Quotes Declined,

Is there a way to bypass the print menu when printing a
report and use VBA to specify which printer to use?
Thanks.
Chris

I have a report which lists products that have been ordered by customers. To
improve readability, I'm trying to get the report to print with alternate
shading where I have a line of product with the background shaded and the
next unshaded and so on. Is that possible in Access? ...

In my report I'm trying to sum a field [req_str] only where the date [edate]
is less than 1/1/2004.  
This is what I typed into the control source of the text box:
=sum (([req_str]) where ([edate] <"1/1/2004"))

I am trying to print totals on a report which contains a sub-report. I want
to print one line of totals in the report footer which shows totals from
columns in both the main report and also from the sub-report.
Showing the totals from the main report is fine but I cannot get the ...

I used a wizard to create a report and it has inserted a 'Ref Header' which
is working as intended. However I would like to insert a page break at the
end of the section and could (I think) do with a 'Ref Footer' but cannot see
how to introduce that. In fact without the wizard I ...

I need to create a query extracting all records in a table
which have been updated - does anyone know what Microsoft
Access field shows the date the record was last updated?  
Many Thanks

I have a report in a access database and want to preview it every time,
before printing it.
I have created a button to open the report but it always opens in Fit to
window mode. This is as good as usless as I cant read it to see the results