I will be having 10s (if not hundreds) of clients and want to include the
client name address, etc. in the header of reports.  Is there a way to store
the client information in a table and have the report header pull the
appropriate information? For example, the version that is ...

I am working on modifiying an existing Report and I am a little rusty in
Access.
I have a report that "On Open" is running a Make Table Query.  The make
table query prompts for a Start Date and an End Date.  

I have a table with a number of 'true/false' fields.
It's a list of members of a high school class and there is a 'true/false'
field for clubs etc. that each graduate may have been in.
I am attempting to generate a report that will list all the 'True' fields

I am trying to print a report on a tractor feed dot matrix printer.  The
size of the form is like 6" wide and 3.5" tall.  My report is that exact
size and I have defined a paper to be that exact size.  But when I print
the report (one page) it previews as four pages with the next ...

I need to set up a condition for error trapping blank records in a report
action.
Popping up a message box, before the report is displayed.

I have a query that gives the following data:
Defect Reason  1/3   1/4   1/5   1/6   1/7
Blush                         2                     5
Shine                1              1              1

Hello, can anybody help? Is it possible for a text box in
a report to be visible only if there is any data in it.
To clarify, I have text box in which I sometimes have put
in some notes/instructions. If, (which is the norm) I

I have a form that is used to collect parameters for a query (QBF). The form
works fine but how to do I pass the results to a report? I tried using the
report wizard and based te report on the query but instead of using my form
to enter the parameters, several input boxes are ...

Hi how do I send a report to a non default printer by using a command button?
I want to set up command buttons to send reports to different printers rather
that using file print and then choosing the printer.
Is this possible and if it is how do I go about it?

I have used the tables wizard to set up 3 tables - one for customer
information, one for products and one for the sales person who sold the
product.
I used the reports wizard to create an invoice showing the order by the

Hi;
Used A2K in Windows 98SE to create an MDB database.
2 of the reports print on legal size paper all other reports print on letter
size.

I'm somewhat new to Access 2000, so please bare with me...  I have created a
purchase order database in Access 2000 that includes two main tables,
"Orders" and "Order Details", and a number of support tables such as the
"Vendor Details", "Employees" and "Shipping Companies" ...

I have a database that follows this process: the user prints a form
(datasheet) to fill out data, enters the data into a data-entry form, prints
out another form (proofing sheet) to proofread the data, then prints a final
report that includes calculations using the data.

I want to be able to toggle a control's visibility off
when a certain condition is met.
E.g. : if control.value = 0 or control.value = null then
me.control.visible = false

I am trying to convert elapsed days into elapsed weeks, with any fraction of
a week, rounding up to the next highest week.  In Excel, I use the MOD()
function to detemine if Days/Weeks is even or not, and if not, I add one to
the result.  I don't see an equivalent function in ...