I am trying to add a field that numbers the items on a list as follows:
1) George
2) Steve
3) John

 I open a report using the following
           DoCmd.OpenReport "rptLabel", acPreview, , , acHidden
 As i want to change lots of the .Printer options, such as Margins etc.
The problem ive got is when i want to print the report.  The only way i can

I am attempting to sum an unbound textbox with the follow syntax:
=Sum([TotalRev])
where [TotalRev] is the name of the textbox.  Here is the syntax used in the
[TotalRev] textbox:

I have built a report that outputs a list of invoices by group.  I have
created a text box that outputs the sum of the invoices.  
For the label of this text box I would like to specify the group then add
text. e.g.

I'm creating a report that will look like a receipt for a customer, on this
report I inserted a text box that automatically calculates the amount of
sales tax... the only problem is that my sales tax law states to always round
down.  is there a way to truncate the number and ...

I am trying to calculate the average of 2 English courses fields.
Seems simple except that not all applicants have values for these 2 grades
(Fields are 'Number' datatype).
Default grade for non-entries in either field is 0....so no Null values to

I have a text box with the following expression.  =[FIRSTNAME] & " " &
[LASTNAME] & " " & [Degree]
I would like to sort by the Last Name field in the expression.  How do I set
the Sorting and Grouping function to sort by LastName?

Forgive me for the cross post. I initially I posted this in the "Getting
Started" forum.  However as this question applies to reports and the is the
"reports" forum, I thought it would be more appropriate to post here.
I don't know if this is an appropriate post for the "Getting ...

how would I use a combo box as criteria on a report? For example, I have a
[between] command for a date range, but I want to add a combo box for the
user to be able to select a customer name without having to type the name.
I'm not having any success creation a combo box on the ...

I entered 4 fields(combo boxes) of the same employee list on a form.  The
reason is that I need this form to act as a survey and rate each employee
accordingly, thus every employee will get the same rating that is on that
particular survey.  It would allow multiple employees up ...

I need just the sum of a column.  I am using this  =Sum([NO_DAYS]).  Alls i
am getting is #error.  NO_days is the correct field name... The coulmn
consists of only 1 and .5.
thanks

I laid out a report in landscape and then changed it to portrait.  Now every
other page is blank and I cant get rid of the page.  I have tried taking the
lines out since they carried over.  I tried to narrow the page on the design
view.

Report = Client Invoice
Name of the report is Client Bill Final LOGO
The report contains the following sections (subreports):  
services, alt services, adjustments, expenses, interest

Because of the way in which I am opening a report, it is displayed
behind a form window.  Using Visual Basic or a macro, how can I bring
this report window "to the front", based on its name?
Thanks,

hi..apperciate any help..thx anywys...
i need to display the values of a field as columns instead of rows, so i
went to "page setup" and set the number of columns to 44.
it worked fine and the contents did fit on one page.