I am making Project in MS Access.
In that I want to generate Report.
now when I creat new Report using wizard then it show me only Report
Header,Report Footer,Page Headerand Page Footer.

Hello.  I am trying to add a dlookup like I use on my forms to pull a
value from an unassociated query onto my report.  Is there a way I
have to structure this that is different than a form?  I am just
looking up one field in a query called balance.  The query is

I have a report with two subreports.
I have a form that filters the main report.  
How do filter one of the sub reports using vb?
ex: main report lists projects with their summary.

Good morning,
I have the following code attached to a command button that up to yesterday
did what it was supposed to do (sort of):
********************************

I have a group
and created a sum of the details items in the group
When the total is zeroi do not want the detail to appear
thanks

Is there a way to create a timestamp inside a report showing the last time
that a table was updated? We have a secretary who is enters data weekly. To
use the report, I'd like to be able to point out when the table was last
updated so that the report is timestamped accurate up to ...

I'm running a report where I have work orders.  They are grouped by appr and
comp.  I need to create a report that will show all the appr tickets, but
give me a total count of appr and comp.  I have the report generated the way
I want, with total count, but how do i hide just the ...

I have created a report that I need to put the grand total at the bottom of
for two of the columns.  What I have done is put two unbound text boxes in
the footer aligned under the columns I need to sum.  In the control source
for each of these boxes I have typed =Sum([Amount ...

Is the anyway to put multiple pages from a word document into a report?  When
I insert the word document as an object into my report it only displays the
first page.

I have a subreport in my main report.  I have a text box in my mainreport
that returns the value of another text box in my subreport.  When a record in
my main report does not have a linked record in my subreport, the text box in
my main report returns an Error.  

Good afternoon:
I created a report that contains a subreport... I would like this subreport
to be limited to 20 records per page... Any idea on how to achieve this
result?

i am trying to hide the label in a header when the field is blank, and based
on other discussions used the following code, but it is not working.  
Private Sub GroupHeader1_Print(Cancel As Integer, PrintCount As Integer)
Me.lblSubclass.Visible = Not IsNull(Me.SUBCLASS_CODE)

If I filter a form and use DoCmd.OpenReport “MyReport”, acPreview, ,
Me.Filter  to open My Report, is there a way to print the filter somewhere on
the report?  Something like:
((MyQuery.ACTUALSHIP Between #1/1/2007# And #1/31/2007#) AND

My report is very simple: date by month, who is responsible/activity, actual
due date, reference number for another document.  This is my first time using
this program and I have kept it very simple and used the wizard to do
everything.  I have quite a bit of text that I want to ...

I have an access report that has some blank fields.  I would like those
fields to show on the report only if there is data in the field.  How can I
do this?