I have a form that pulls GRADE and AvgOfASH VALUE from a querry.  The GRADE
is shown in the reportheader and the AbgOfASH VALUE is shown in the details
section.  I want the AvgOfASH VALUE to show up in red if it is out of spec
and green if it is in spec.  The high and low limits ...

I have a report that comes up in print preview for the user.   Occassionally
when the user decides to print this report to a printer, an error pops up
that says that access is 'unable to print your object'.  When they switch
printers (they shouldn't have too as this is a true ...

On Average, how long should it take a programmer to develop reports (or a
report) in Access? What is the fastest method to developing reports? If you
need a report with a lot of joins across multiple tables, what is the best
method?

I have a text box that I only want visible on the last page of the report. I
am working in Access 97. Does anybody know how to do this? Thanks in advance.

I have a basic invoice form where the individual line items are summed and
freight added to give a total.  I want to create a summary report of many
invoices, but have a  problem in getting a grand total as I can't get a
correct sum of the shipping costs.  For example using ...

We have a 2003 access database, we have tables for our dealers and customers.
Recently all reports about our customers homes have just started creating
duplicate records when the report is generated, but only for one of our
dealers and only for some of his customers. I have ...

I have a repot which i want to sort in financial year (april, may,
june, july, aug, sep, oct,nov, dec, jan, feb, march) order how do u do
this, cause if you go into ordering and grouping and select month and
assending it buts it in alphabetial order.

Hello I am printing labels for are products with  Price/Currency data.
The problem I am having is that in order to get the $ .00 to print I had to
add the code
=Format([MyFieldData],"$#,###.00")

I have a report based on a query of defects by part types.  I would like to
limit the report to the top ten defective parts.  Can you help me with this?  
Thanks.

Hi All,
My report is showing its name on the top of every page which is what I wanted
it to do. but....it's also showing it eventhough there is no data on the page.
Here is an example of the report:

I am a newbie and have  a query.
I am currently developing a database to record staff hours and absence
information and I am summarizing the info by department and sub-department.
In the report template I have done this. The number of rows between the

I want to bind a textbox to a different query which has calculated fields.
Does the query have to be open? In the textbox control source I used the
expression builder to put this expression in
=[QWhelpingAverageReport]![CountOfFEMALE #]. When I view the report it comes

I have a report that counts the number of projects people have started or
finished based on date fields. I was able to count the projects started using:
=Abs(Sum([Auditor] And IsNull([Ph2c])))
But I am unable to count the number of projects finished. I want to say,

I have a report based upon a query.  When I run the query, my column of
numbers is .01 cent short.  I do not see how to change the query to round
up, so I went to properties in the report and made sure that the decimal
places were set to 2.  It was originally auto.  Neither auto or ...

I am a relatively new user to Access and I am using Access 2000.  I am
using the report and group headers to calculate totals for the report
and for the most part it is working well.  However, I have some
aggregate functions in the controls that appear to be too long and