My report needs to calculate the difference between a date [when] and the end
of each month.  I think I need DateDiff(), but how can I describe the second
date parameter?
My report looks like this:

I have a form that supplies parameters to a query. I have 2 different
reports ( OSrpt and ONrpt ) depending on this query. I want to preview OSrpt
if the categorieID of the supplier selected by the user is equal to 1 and if
not to preview ONrpt instead.

I have a situation that is more of a nuisance than
a problem per se'.
I have an application wherein a record is selected
via a "right-click" in the "Record Selector" area of

Can someone explain how I can create an expression(I assume and IIF()) that
will put a footer in a report if true and not put it in if false?

I have a problem with a memo field truncating in a report.
The field originates from a query designed to return the "last comment".  
The base table contains multiple entries for each entity, with date/time
fields for each entry.  The query returns the max date and comment.  This

I am really having difficulty with a solution to this problem.  Not much SQL
experience.  Any help/suggestions appreciated:
I have a report based on a cross-tab query that shows the percentage results
from different audits conducted at different departments (17 departments,8

I am trying to generate a report based on the following query: qryTestReports
The SQL for this query is:
SELECT tblRequest.REQUEST_NO, tblRequest.TITLE, tblRequest.NOTES,
tblQueue.Q_INC, tblQueue.QID, tblQueue.Q_YEAR, tblTest.TEST_TYPE,

I have a rectangle in the detail section of a report with the below code
attached to it in the on format event.
If [HostGuest] = "host" Then
   [Box16].BackColor = 9824951

I have a form with multiple checkboxes (47), where I'd like to hide the
checkboxes themselves but not the labels associated with the checkboxes. I've
tried setting the checkbox size to 0" but I get a weird checkbox in the
upperleft hand of my report, and it doesn't seem to work on ...

I have an underlying table that has hyperlinks to a picture file.  I am
creating a report based on this table.  Instead of showing the hyperlink, I
would like to have a 3"x3" picture.  Is there a way to do this that you know?
Thank you,

I have a report that has been spread out across columns using Page Setup.  
The problem is that the total number of parts (added in the Feport Footer)
always shows on a second page.  The reason I set up columns was that it would
keep everything on a single sheet.  How do I force ...

I have created Access reports with charts in them, and need to export them
out to Powerpoint. The only thing I could do was export the reports to Word,
but the charts did not come out.
Hs anyone tried this?

I need some help with a report.  If there is no data/no records for the
report, I'd like to display the word "No" in a text box (Text150).  
If there is data, I'd like to display "yes" in the same box if possible.
Here is my code in the report's no data section.

I would like to utilize the ability in Access 2007 to export a report to a
PDF or XPS format. However, the option button for this is greyed out on my
toolbar. I do have Adobe installed on my computer, could that have disabled
the option? Abviously I could just print to Adobe, but ...

In Access. I created one form and report, and then I can find them in the
VBA. Also, I can use them as objects with Form_*** or Report_***.
But when I created the second report and form, I can't find them in the VBA.
Why?