Yesterday I posted a question about how to return records that had data
only.
What was done was that Not 0 Or Not Is Null was put in different rows of the
criteria in the query. That worked very well, but it created another issue.

I would like to know how to change the record source for a report in visual
basic.  I have one report that can be run using either Query C or Query F.  I
have the reports being run off of a form where a user enters a year and then
selects either fiscal or calendar.  (Note only ...

I have a query that has 12 fields/columns.  8 of the columns are 4 sets of
two (hrs to date and hrs for this month four times each - because there are
four office branches).
I need to make a four page report that shows 2 out of the 8 columns, per

Stephen Lebans & Marshall Barton & any other Guru out there....,
First let me say thanks for contributing to this post.  Perhaps I have
bitten off more than I can chew but I believe Access can do what I need
done.......I have reviewed the RTF function and it is a great feature and ...

I've designed a mailing label to contact parents.  My database contains a
main table with the information on the church members.  A second table
contains child information.  I'd like to mail to households with children
satisfying certain criteria.

I don't know if anyone can help me, but any advice would be appreciated.  
I've got a report that is called Service Report, it has a subreport called
ServiceSubreport.  It is linked by Customer ID number, Service Address, and
Type of System. I have a from that has a button for ...

I'm using Microsoft Office Professional 2003, Access product, at its latest
and greatest updates applied level.  I have a legal form length Form Letter
with the following information on it.
Now on this day, (date),  the above entitled cause comes on for hearing

My IIf statement works fine.  However, I would like to show "No Number" if
the phone field is null. --Not if the statement is false, then it should be
blank--
=IIf([txtNotify]=-1,[Phone],"")

I get a report that uses 0 and 1 for No and Yes how can I make that show in
the report Yes and No and not 0 and 1

Ocassionally the text on the first page of my report is too long to fit on
one page and spills to the next.  This isn't a problem.  However, it
sometimes prints the last row of text in between pages, that is part of the
line is on the bottom of the first page and part on the top ...

I have a report which I have successfully hide the remarks label and field if
there is no remark. However, I have a rectangle box called Box 73 round the
remark area and I want to also make it invisible if there is no remark. How
do I do that? Thanks.

It seems to be impossible to save an Access report to the Excel 97-2002
format using VBA without user-interaction.
I tried several Formatting-parameter-values:
   DoCmd.OutputTo(acReport, ..., acFormatXLS, ...)

I have a menu with many buttons on it, each one applying a different filter
to the same report.  I want to make the report reflect which filter they
chose to apply, activated by a macro, if possible.
Example: If they choose to filter results by date, I want the subtitle on

I've worked with Access for a while but never used Reports (always used it as
a database for a program or for a web site).  I have a couple of questions.
Our database is relatively simple.  A list of donors for an organization.  
First name, last name, address, etc, plus how much ...

Hello,
        I wish to change the font property of a label to switch of the
underline under certain conditions. I have the following code
Public Sub HideQuoteTotals(ReportName As Variant)