I have a text field that contains either the word "cash" or a number from 1
upwards. I have made it a text field due to the cash option.
I have a report that is sorted by this field but I am getting the result:
Cash

I have a report with the following sections:
Report Header
Page Header
TierGroup Header

I have a report and i'm trying to divide the [PremiumAmt] by 12 if the
[PremiumFreq] equals "Annual". If [PremiumFreq] is not Annual, then it should
just use [PremiumAmt] value. The [PremiumAmt] is a currency field and the
report is based on a query.

I have a variable sub report that would like to put a box around the
detail section. The section displays variable lenth lines that are
linked to a field. How can I put a box around the section. Or around
the max length of the detail report.

I am designing some reports for my boss, and he would like them to be a
little cleaner. For example, one report has a list of items and then a
sumation of the cost (=sum([Amount]). If there happens to be no items
present, the report shows "#Error" because you cannot sum a null ...

I have a text box (txtLegalName) on an 800 page report that
concatenates some information together. I am setting the value of the
text box (which includes the concatenation) on the print event of the
detail section. Originally, I had it in the underlying query of the

I am running an automated application that prints access reports on a
schedule throughout the day.
Between 5 and 6 at night when a reports tries to print, access pops up
a messsage saying that the printer selected in the definition is not

I am trying to use a DLOOKUP in a report To lookup a value in a stored
query from information that is the report.  I have a report that gives
me a customers parent account name and I am trying to then use that
parent account name to look up a comment stored in another query.

I have a cross tab query that will provide sales by month for 2008.  Right
now it is sales for January08.  As there are sales for future months, they
will appear as well.  I want to create a table that has all of the months
listed out already.  Right now, on the first day of the ...

Hi all;
I have a report, many fields. If I set all "can grow" properties to
"yes", then the fields grow fine. Problem is, I need the other fields
to grow to the same size as the largest field for asthetic reasons.

I use the CREATE REPORT IN DESIGN VIEW option to create a report that
doesn't have record source.
Is there a way to add a field from a table to it? Please help
Thank you

My project is in MS Access 2002.
In that I have one Form which enter data in two different Tables, when
I click on Submit Button it will run two diffrent queries one by one.
Now I want to generate Report from that Tables.

My project is in MS Access 2002.
In that I want to generate Report which contain fields 258.I can put
255 fields but how can i add more 3 fields.
when i generate report for 258 fields than it will show msg too many

Hi.  I'm struggling with a DCount in a text box that will generate the
number of items delivered on-time to contract.  The query data source
for the report is called _TU_MOCAS_DUE_UPCOMING.  Note that it's a
parameter query prompting the user for start/end dates to bound the

I am working in Access 2003
I have a combo box with two columns. It is bound to a yes/no field
called "Accept". The forms displays the word "Accepted " in the second
column in the combo box) but records -1 or Yes to the "Accept" field.