I have a database that includes a lot of checkbox (yes/no) information.
Because there is so much checkbox info, I need to reproducee my reports into
an Excel format.
However, after having generated the report in Access and clicked on Analyse

I have a database that does bid estimates for our company.  It lists all the
subprojects (bids) within an overall project (master project) and totals them.
Master Project
    Subproject1

How do I sort a report with macros?  I want to have one report sorted a
number of different ways by just having a button with a macro for each sort.  
Currently, I have to have either multiple reports or multiple queries which
is bogging down my database.

How can I create a page break to force a new page when the number in field
changes for example:
I have a field "Bldg" where each building has a number (each building has
more the one record) I want access to do a page break on the report whenever

I am having a problem with the following iif statement:
=IIf(Sum([Hours])>0,(Sum([Hours]))-40,"0")
I have a query based report that returns the number of hours worked per
project each day for each employee. The total hours for the week is then

How do I print row numbers in a report?  I would like each row to be numbered
in order 1,2,3... regardless of the sort/query performed.
I have used Autonumber in creating a table, but do not know how to generate
an auto number for each row in a report.  If I run a query, the row ...

I'd like to group data in a horizontal line separated by commas. For
instance,
Let's say we have two fields, category and item.  I'd like the report to
look as such:

I have several text fields with data that goes on for several lines (the
fields are results of VB function queries).  How would I make the report
automatically scale vertically when it needs more lines?

I want to know how to eliminate the carrage return and line feed from the
detail section, currently the data looks like this
    BEECH-NUT
    Baby Foods in jars without salicylate

In Access 2000, when I change the print properties on a report to "specific
printer" and "landscape" and then save the report, it goes back to the
default printer and portrait the next time the report is open.
Any ideas how to get it to stop doing that?

Thank you for those that answered my first question, I think I may have
outlined what I wanted incorrectly.  I need to list telephone directories by
zipcode.  Since telephone directories contain more than 1 zipcode in coverage
and vise versa I need to know the total number of ...

I have a simple two table database that has 1) customers 2) Appointment.
Using Access 2000, I need to be able to print a specific customer from the
database, during a set time period. So Is it possible to have a parameter
set for 1) customer ID, then input the Id. 2) create a start ...

I am designing a report for our customers to show upcoming changes to their
product and their options with regard to the change.  Not all customers will
have the same number of options.  I have a table with the customer
information and options (which includes their rates and ...

I have developed a report in Access 2002 that has two grouping levels,
Record ID and Payment Method.  For each transaction record, the report
prints one or more payment methods and the amounts for each payment method.
I am currently trying to find the best way to calculate the ...

Is there a way to prevent users from printing reports in Access?
I have disabled the toolbar and Menu bar but it is not preventing users from
doing Ctrl P
Many thanks