I have a Query in which you can find a columns with numbers, from 30 to 100,
I want these numbers to be converted in to letters (A, B, C, D, E, F)
according to this,
100 : 95 => A*

I keep getting the "you have a syntax (comma) error" message and when I
trouble shooting the formula. I have put a basic expression in a Report and I
do not know whether I am asking Access to do something it can not (i.e. put
an IIf expression in a report) or if there is actually ...

I have created a report that prints out customer invoices and totals their
cost in a field called CustTotalCost.  I am wanting to get grand totals for
all customers on the last page.  
The report currently displays grand totals for other fields (Hauling Cost)

I have a report that lists students and books and scores by teachers.  I
want a page break so that each page has one teacher and all of her students.  
Right now I have a teacher and her students and the next teacher and her
students on the same page.  I'm totally new to this so ...

Hi all, don't know how this can be done but there must be a way.
I would like a lable on my report that includes the criteria used to
build the report.
I have two variables defined in my code, VarRegionID and VarSiteID.

Could someone remind me of something I've forgotten.  I need to return fields
which contain a single asterisk (*)and I am trying to use statements such as
IIf([field]like "***" .......
mid([field],5,1)="*" .....

Hi,  Can anyone help with the following,  I have 13 reports, I want to create
a command button to print them for the current record in a form.  Has anyone
got any ideas on how to do this.
Any help would be gratefully appreciated

I have a report which displays records accoring to various selections made by
user from front end form. I would like to incorporate a sub report into the
main form as there is 1 piece of data I cannot get from the report as it is.
I need this to apply the same filter. Can this be ...

Is there a way to make lines, boxes and pictures on an Access report
visible in Word when you use Tools, Office links, Publish with Word?
Thanks!
Sammie

Jeff C. gave me fabulous code (that I would never in a
million years have figure out by myself!) to alternate my
lines gray- it's rather fabulous!
So here's the picky question. Originally I had a red line

How do I use VBA to determine the number of pages in an Access 2000 Report?  
Thanks!
-Joe W.

Is their a way to have Access Supress Blank Pages ?
Any Help would be greatly appreciated.
Thank you,
Jeff

Hello I am working with Access 2003, how I would set up a method to run a
report at a particular time and date.

Good Day,
 I am creating a report  that  has a field that is based on a look up
field: so therefore, when I create my report, it shows the field with as a
drop down box. But here is my delima.

I would like to insert a chart into a report that is based on a data entry
query.  The underlying query of the report asks the user to enter a [start
date] and a [end date].  The report then displays the appropriate production
data based on that interval.