I have a subreport in my reportfooter. if the subreport do not have any
data, it shows me the blank page at the end of the main report. do i
need any vba code in my report footer not show the report footer if the
subreport has no data, if so can i get some example please.

Is there something that can help me print a text box on the left side which
is in the center (within 1 record) of a format grouping??
I could print the first text box only for a group.  That easy, just select
the Hide Duplicates.  This will print that text box only that the ...

I and listing an inventory by manufacturer and model with totals on each group.
the totals work for the model but the total by manufacturer picks up the
total of the last group.
My detail section has the info to print and CntManuf ( =1 ) and ModelCount (

I  would like to take this report:
553011    FICA-SS/Medicare-Sourcing   
(rev) 3/06 bud vs act FICA    $795.00
(rev) FICA  SS/MedicareSourc    $1,983.00

I am having a problem with the coding below is in the Event Procedure on the
“On Open” property of the {rptLetter}:
Sub cmdPrint_Click()
'Check if no results in any field, if all missing

In an educational survey report, I am listing the results in the detail area
for each section of a course responding to the survey.  In the Course
section, I have summary fields for the number of sections reporting and the
total number of students this covers.  These =sum(...) ...

I've got an unbound text box where 4 fields are being combined to display on
1 line.
They are:
[FIRST]  [MIDDLE] [LAST]  [STATE]

Is there any way to change the source of the data in labels in reports? I
went through quite extensive designing of the actual report and would rather
figure this out than have to start all over.  As part of one of the tables on
the report, I currently have an ID number.  I would ...

What I am attempting to do is to write a system that print checks (I may
have made multiple posts regarding various problem concerning this system). I
apologize for having to make multiple posts.
I've now gotten to the portion where I am actually formatting the output of

I have a database that has three reports. I would like to be able to select a
report by option button then click a command button and print preview that
report. Can someone show me how to do this with either a macro or VBA. I have
tried with a macro but have not been able to get ...

Okay.  I really need help because this is just killing me.
I have created a form from a table.  Then I created another form from a
table and embedded it in to the first form (thus, a subform).
Now.  I created a stored procedure and then created a report off of

I have Account no in one field and Amount in other field. There are several
accounts (one hundred pages in a report). I want page wise total in report. I
also want grand total at the end of the report.

I have text boxes in a report that I need to use for calculations to compare
sales goals with actual amounts.  The actual amounts work fine, but I keep
receiving #name# errors on the subquery, which is drawing info from a table
called "tblSalesGoals".  The sql statement that ...

I have a radio group on a form of mine. In my table I store it as a number
rather then all the text, but on my reports I print for users I would like to
display the full text. How can this be done?
Thanks ahead of time.

Hi again
I'm working on an invoice report, and I want the the item numbers for a
particular customer to appear on one page.  At the moment I am have a
number of customer and their items appearing on the page.  Could