|
|
Sum is Null by
DS
I have an unbound textbox on a report footer and if it's null or on error
comes up I want a 0 to appear. This is what I have and it doesn't seem to...
|
May 10th, 2007 05:40 PM
by DS
|
6 |
126 |
|
|
Return null (blank) instead of zero by
Eastharbour
I have written an expression using the IIF function. It evaluates two number
fields and performs a calculation. I would like to display null (blank) if
the...
|
|
2 |
88 |
|
|
Formatting columns in a report by
cinnie
hello
My report has 3 columns and is sorted on A_Header, then B_Header. The
columns contain data from the B_Header and the Detail. All works well except...
|
May 10th, 2007 04:39 PM
by cinnie
|
0 |
94 |
|
|
Overall Average by
Terye N
I have a report which groups on Dept and shows number of complaints resolved,
and average age of complaints by department. There is a new page for each...
|
|
2 |
98 |
|
|
Report limitation and subreports by
Are A M
Hi. I'm working with Access 97 ( I know. Its old and outdated). I have two
questions.
1: I'm trying to make a report showing about seventy fields from two...
|
May 10th, 2007 03:29 PM
by Klatuu
|
1 |
100 |
|
|
|
|
2 |
104 |
|
|
|
May 10th, 2007 09:59 AM
by jillc
|
0 |
113 |
|
|
|
|
3 |
131 |
|
|
Calculation in a Text Box by
CEV
I have a text box on the footer of my form. The control source is as
follows:
=Sum(Abs(="Vocational"))
That text box calculates a number for me. Now what I...
|
|
3 |
94 |
|
|
Font Initialization Error by
Adrian Turner
I am using Access 2003 and I am having problems printing some reports. A
couple in particular work fine in preview etc, but when I try to print (using...
|
|
4 |
111 |
|
|
Unwanted Parameter Prompts? by
Nick CWT
I'm using the following expression in a text box on a report footer. When I
go to view report I'm getting Parameter prompts for Total JR CG1,3,2,and 4?
I'm...
|
|
5 |
103 |
|
|
GroupHeader Repeat by
Lamar
See below. I got the answer to my original question. But when I use
"Payment History" report as a subreport then it does not work ("txtName"
starts to...
|
May 10th, 2007 12:12 AM
by Lamar
|
0 |
68 |
|
|
Hide Duplicates by
ironwood9 via AccessMonster.com
My report lists projects by date, descending - there are typically about 4-5
projects per day - I only want the date to show once, thinking that...
|
|
1 |
93 |
|
|
|
|
3 |
103 |
|
|
DoCmd.OpenReport error 2501 by
Tony Girgenti
Hello.
Using Access 2002 on Windows XP Pro, SP2 computer.
When running the code at the end of this post, it blows up on the
DoCmd.OpenReport with error...
|
|
3 |
106 |
|
|
|
|
1 |
80 |
|
|
|
|
2 |
181 |
|
|
Report Footer Problems by
Bill
I haven't seen any posts describing this but my Access 2007 program crashes
when I atempt to scroll to the report footer where I inadvertantly copied a
bunch...
|
May 9th, 2007 07:53 PM
by Bill
|
2 |
86 |
|
|
Can Shrink where data is spaces by
mscertified
How can I make 'can shrink' work when the data contains spaces? I have no
control over the data since it comes from a mainframe system. I tried the
following...
|
|
1 |
85 |
|
|
Mail Merge / Access vs Word by
getitright
When using Word to create a mail merge for projects with several thousand
created/merged documents, Word takes too long.
When embedding a Word document in an...
|
|
0 |
84 |