I have a report with Detail info as follows, grouped by
Cost Center:
COST CENTER 06273
 Asset Name   Asset#  Oper. Date  Job#    PlanTime Plan$

I am producing a report of prize money won, and I have a total.  I now want
to split this into units, tens, hundreds, thousands etc so that these values
can be put in the correct place for printing on pre-printed cheques.
Thanks

I need to create an annual report which would list the total orders by
customers by month. I created a working query which groups the orders
'count(ORDER_CLIENT) AS Tot_orders' , customers 'CLIENT_NAME' and
'month(ORDER_DATE) AS Month'.

OK...I was able to generate the numbers in Excel, then
export them into Access.  I formatted the numbers
as "00000", which worked fine, ie. 00001, 00002, etc. But
when I ran the label report, the formatting was as 1, 2,

I've begun to see frequent occurences of the following:  I print a report
and in the report header I find the word none in brackets in a very large
font on the report.  It's not showing up on my monitor. I have no hidden
text, label, etc.

I have a main report with multiple subreports, whenever a
subreport has no data it eats up a small amount of blank
space, which messes up the look of my report.  I want to
make my sub report show up with the headings and at least

I have several reports that list instructor names.  I want the report to
display "None Listed" if the value for the instructor is null.  I have
entered =Nz([Instructor], "None Listed") in the text box control source  but
I keep getting "#Error" in all my reports.  What am I doing ...

I had a wild idea, and maybe someone out there can tell me
if this is possible, and if so, how to do it.  I need to
make several hundred inventory labels, starting with the
number 00001.  I know there is a way to do sequential

Pretty new to Access here, and finding it's helping us
with great information.
I have some reports, like "cancelled orders" that often
will have NO Data for the time period requested to run.  

Is there a way to have a vertical label or text box spans
an entire detail area?  Is there a property I can set?  
for the detail area or the text box itself?
I have several rows of records in my report.  I'd love to

I have created a query/report using the following;
Expr3: Format([Start Date],"mmm")
This seperates my data into months.  I now need to include which year, ie
Dec 04, Jan 05.

I would like to set some format properties for a bound textbox using VBA (or
??). My question is : is it possible to run vb function that check textbox
value for each record and then set property for it.
I don't think that this is possible so I thought to solve this by doing

When I print my report every other page has data on it.  And every other
other page is blank.  So it's:  data page 1, blank page, data page 2, blank
page, etc.
Anyone know how to fix this?

I want to count the number of records that are displayed
in a report.  I put a textbox in the footer with
=Count("*"), but I keep getting an error.  What am I
doing wrong?  All I want is a total number of records on

I am having trouble getting Access 2003 to "see" my default printer.  I am on
a network and all other Office apps. print fine.  Any suggestions?
James