Hi, I have this strange problem...
In my pageheader I have 2 independant textfields together with some
other fields
The 2 textfields aren't printed....

I need to get this to work:
=IIf(Forms.[Helpgate Menu].replist is null And Forms.[Helpgate Menu].Mgrlist
Is Null,"Questions - All Reps"),iff(Forms.[Helpgate Menu].Mgrlist Is not Null
and Forms.[Helpgate Menu].Replist is null,"Questions - Per

I have a report with detail lines with
Name Col1 Col2 Col3 Col4 Col5 Col6 Col7
The Col's are numeric fields.  I do not want to print the detail line if ALL
the Cols fields for that detail line have values that are zeros or nulls.

I am trying to do ID labels - 2 across and  down.  I am not doing very well
in the sizing of the lables.  Is a report th best way to do this?

I have a report with a grouping that may optionally be set to page break on
change.  When I change the Group Footer’s ForceNew property from 0 to 2 in
the Open Event to get the page break, I always get a blank page at the end of
the report.

Is there a way with expressions to control whether an individual detail line
shows or not in a report?  I am not referring to suppressing all detail
lines in a report.

In my underlying query I have field called "Employee" that has either CAT or
Volt as the data that input.
This is how my report looks
Shift Header

How can i get a report to print out  my calender for the month.  I have all
the data in access and use forms to update it, but i am unsure how to set up
a calender report to take that information and put it into each day along a
month.

I've created bar-chart showing payments in different currencies (variable
quantity) grouped by year and destined to be filtered by ClientID value. The
query-code under the chart is:
TRANSFORM Sum([qryPayments].PaymentValue) AS SumOfPaymentValue

How to display the "Current Month" in a report header in an unbound text box
inAccess 2003?

I have an Access 2003 report that has multiple calculated values.
Now I need to use of those values in a subform. Is there a technique in
Access similar to SetValue so a
calculated report value can be transferred to a table field?

I have few reports that take from 30-60 seconds before they open up due to
have query calculations. What is the best way to I have a message such as
“Please wait while the report is generate.” be displayed and then disappear
once the report opens up?  

My office decide to switch from excel to access. The db will be used to fill
several vouchers. I have no problem with form but when It come to report I
faced the following:
In excel voucher is designed with header, the body and footer as as access,

I am setting up a dealer report in Access where each dealer can have a
different number of detail rows on each page. But I can't find out how to
print one page per dealer rather than several pages, each containing one row
for the same dealer. How do I do this?

I have a accdb file in MS 2007 , with tables and queries with Order
No,art no,style details and delivery dates.
I need to create a calnder report where i can see the foll in a yera
calender,