I have created a report that lists names and amounts of money in two columns
from a query that pulls data from several tables in an Access 2003 database.  
I would like to group the report so that the Amount field creates a batch
total every 25 records, like this:

I have a report which displays some numbers.  I choose "general number" as
the format, and "1" as the number of decimal places.  But it displays up to
3 decimal places.  Any suggestions?
TIA

Incessant firewall alerts!
Hello all
I hope you can help me with my problem as I am going nuts! the firewall is
picking a lot of 'Alerts!' with the

First of all thank you for taking the time to look at this post.  Your
knowledge on this subject is greatly appreciated.
I have several reports that I would like to possibly password protect for
structure similar to what Excel can do.  I do not want to password protect

I have a txtbox that shows the inventory level and another txtbox for the
customers to enter the quantity they want to purchase. I had this code using
Visual basic on an after update and after enter event on the amount puchased
txtbox, that if the amountpurchased txtbox is greater ...

This has to be very very simple but I'm not experienced enough to know what
the expression, calculation or what I need to do to get this calculation to
work.
My field is grouped and the count keeps giving me the total. I want the

Good morning,
I saw the article "How conditionally display stuff on a report?", however I have a slight twist.
I have a field "comments" that is occasionally blank.  When the report prints, it prints a blank line if the comment is blank (obviously).  How do I get the report to skip ...

I have a report I am writing to get a price out of a large memo field. I've
created a search that will find it for the report but I can not get it to
total on group footer.
=Mid([fdescmemo],InStr((InStr([fdescmemo],Trim([fbompart]))),[fdescmemo],

In Access 2003, I'm creating a report based on a parameter query that asks
the user for a start date and end date (the data is sales activity tasks that
each have a date when they were/are due).   The dates entered are typically
30-40 days older than today's date and 30-40 days ...

How can I show a previous balance on a report? I need to print quarterly
statements for customers that show the previous balance as a beginning
balance for the new quarter and the new transactions.
My table fields are as follows:

Hello,
I have an Access 2000 report that has a currency column formated with a -
sign: $#,##0.00;-$#,##0.00.
My problem is I would like all amounts to be right aligned. For some reason

I have a report that when it runs it asks for parameters and I don't know why.
On my report are 399 text boxes named text1 to text399
In the On open event of the report I do some things that decide whether they
all show up or not, and assign values to the textboxes.

I am using Office 2007.  I have a multipage excel spreadsheet that I want to
use as a template for a report.  I would be willing to use each workshhet as
a seperate report.  The spreadsheet is a financial statement that includes a
lot of text in cells.

In Access 2003, I'm creating a report based on a parameter query that asks
the user for a start date and end date (the data is sales activity tasks that
each have a date when they were/are due).   The dates entered are typically
30-40 days older than today's date and 30-40 days ...

Our planning system has many access reports that are letters and they need
our corporate header and footer on the first page only.  The reports are
passworded for VBA but could possibly use a macro.  Any suggestions would be
very appreciated as I have spent days googling it and ...