Hi,
I'm creating an app in access 2000 that will run 30 reports from the same 3
tables Most of the reports will only have 3 or 4 fields. I'm wondering if it
is possible to only create 1 (or a few) report templates, instead of 30 and

I'm working on a database that tracks our warehouse employee's productivity.  
While everything else is going great, I'm having a problem I'm hoping I can
find some help with.
The database stores the area they worked in, such as Shipping or Palletizer,

I have a union query that produces four rows of data. In my report, I have
created unbound text boxes with =sum([FieldName]) as the source.
My report show four text boxes with the same info, one for each row in the
query.

I have a label (lblWarning) in the Page Footer of a report.  I want
lblWarning not to print on the first two pages but then print on all the
pages thereafter.
How can I do this?

I am using a rich text field (rtf2) in my reports detail and when I put a
textbox in my report's page header the formatting of the text in my detail
section goes crazy. In better words the space between all the characters
change without any obvious pattern.

I have a query with about 132 rows. The field names are Owner & Count.
I want to have a report that only runs the top 10 from the query.
Thanks,
Dave

I have put SQL in my modules 10000 times but I can not figure out for the
life of me why this keeps giving me an error!  What am I missing?
Set RecMach = CurrentDb.OpenRecordset("SELECT TBL_MFG_S.*, cmb_PARTS.*
FROM (TBL_MFG_S INNER JOIN cmb_MACHINE ON TBL_MFG_S.MFG_MACHINE =

Hope this is the right forum.
I have a report that returns the FULL_NAME (example Doe, John) from a query.
I would like to have the results look like (Doe, J.) minus brackets of
course.

I have inserted a graph into an MS Access report that is based on a parameter
query.  Once filtered down, there are three records.  In each record is a
date field, for which I am using the yyyy format to display the year along
the X axis.  The three records have dates of whatever ...

I am printing on an Epson 1520 across a peer-to-peer network using Acess2002.
I go into paper size to change it to
PRINT ON SPECIFIC PRINTER
TRACTOR FEED  

I have a db of hospital patients. The main purpose of the db is to search
those records on a number of different fields. The user is presented with a
form on which they select the search criteria. This builds a string which is
used as the "WHERE:-" clause in opening a second form ...

Hi.  Thanks for reading my question.
I have a radio button to select the events in the form and I would like to
pass that parameter to the report header indicating which event report is.  
There are 5 options user can choose (New Year, Pres B'day, Christmas etc.)

Self taught access user needs to know how to create reports to:
show results within a set date paramiter
and also
show results if a radio button isnt selected (i.e. a false rather than true)

I am having problems with this code which does not want to work in a text
box of my report
"CompanyAVisits Query" is the query the report is based upon.
Field Names as follows:

Hi I have tried the forms NG's but no help so I am trying the same approach
now on a report.
How to I get a calculated figure of £1.925 to show as £1.92
This is a calculation  for the VAT paid on a total price of £11.00