I have a report I print....that when there is not a number greater zero....it
prints $0.00.  The information it pulls from is from a form.  I want to be
able to print the Label...but  leave the field blank if 0 or less.  I can't
change the form...because the form needs to show ...

I have data that tells me the following: sales rep, recruiter of sales rep,
manager of sales rep and sr. manager of sales rep. I need to run a report
that will list all the sr. managers, then have all the managers under that
sr. manager, then all the recruiters under each manager ...

Hi everyone,
I am having a bit of a problem. I am doing a report to show monthly savings.
My report is based on a query with the following fields: Date closed by month
and Summary of savings. Here is the problem. The report shows the date closed

I have a table for entering tickets, there is a date, violation, and a fine
feild. I have made are report that adds all the fines together. The report
adds all  of the new enteries ont it. What I want to do is each week print
out a report with only that weeks information on it ...

I am having trouble with one of my fields converting to excel.  The field
name is Apartment # and is a text field.  Everything works fine except when
someone enters a number with the letter A, example 11A or 12A.  When they
enter 11A of 11 A it exports the value of .4583, when ...

Can anyone know how to setup when print in a report with one page set to
landscape and other set to portrait? I need help to print a report first page
is landscape and the second page is portrait, it has to print in a single
paper with double side printing. I have set the force ...

I am attempting to filter out specific records from a tool inventory that
matches a criteria and run a report.
SELECT Toolno, ToolDesc, ModelNo, SerialNo, IIf(NameID Is Null, "Available:
" & Location,

I have a report that lists the names of people who have been to our store in
the past six months.  I need to send this out to someone.  It take about
three pages and only has one column (Customer Name).  I would like to somehow
create a one page report that lists this  one column ...

How do I call up a specific report based on 2 fields on a form?
To explain myself.  I already have the form made, and on the form are the
fields CustomerID and ContractID.  I would like the create a command button
on this form and when clicked it would open the report based on the ...

I have a parameter based query that returns a single column of names.
Example:
John Smith
Goerge Johnson

I have three separate reports based on three separate queries.  Now I have
been asked to combine them and I don't know where to start.  I have one
report that is a list of action items, another showing issues, and a third
showing requests.  I need some help here; where do I ...

I want to have a report that shows the orders in the database that have an
order date <2007.  I need the report to group by order date <2007, the
highest $ amount first.  However I need the report to keep the customers
together.  In other words, if ABC Company has total orders in ...

I have a report which is based on a query. One of the fields in the query is
a based on a field in a table which is also used as a source for a combo box
on a form. There are 4 values, lets say Val1, Val2,Val3 and Val4. In my
report I want to count how many records have Val1, how ...

I need to report a summary report on one page that will only show the
totals a specific fields for a date range. The way I have it now, it
prints EACH record in the date range. I need one page showing the
totals. Any ideas?

Want to create a command button that will force print a report to multiple
network printers. Will need to store the list of printers in a table for
maintance purposes.