A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Setting Up & Running Reports Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
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 Go to last post
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...
May 10th, 2007 05:26 PM
by Eastharbour Go to last post
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 Go to last post
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...
May 10th, 2007 04:14 PM
by Terye N[_2_] Go to last post
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 Go to last post
1 100
crystal reports 10 by daruco94
How can I open a Access 2007 DB in Crystal Reports 10?
May 10th, 2007 01:25 PM
by daruco94 Go to last post
2 104
problem sending Access data to Word MailMerge by jillc
Using Access 2003 the following code used to work. The user would click a button, Word and then the MailMerge original doc would open, and then the user...
May 10th, 2007 09:59 AM
by jillc Go to last post
0 113
How to Exclude one data entries if one field is "full" by Russell Pascoe
Hi there! I run a property business. I have a database of tenants in my properties. I print a report that I call a Contact Information Report. I would like...
May 10th, 2007 09:41 AM
by Stefan Hoffmann Go to last post
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...
May 10th, 2007 09:40 AM
by Wei Lu [MSFT] Go to last post
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...
May 10th, 2007 09:02 AM
by Wei Lu [MSFT] Go to last post
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...
May 10th, 2007 02:51 AM
by Nick CWT Go to last post
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 Go to last post
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...
May 9th, 2007 11:04 PM
by Carl Rapson Go to last post
1 93
Can Access Repeat the first few fields on each page? by Brian Drab
We are creating a report that has way too many fields of data than will fit on a 8 1/2 x 14 legal paper (even with shrinking down to the smallest readable...
May 9th, 2007 11:03 PM
by Carl Rapson Go to last post
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...
May 9th, 2007 10:57 PM
by Carl Rapson Go to last post
3 106
Queries - stop repeating? by [email protected]
I have the following query (for example): countofstates color 3 red 8 blue 7 ...
May 9th, 2007 10:42 PM
by Al Campagna Go to last post
1 80
How can I insert a calculated field from FORMS to a REPORT? by sean
Hello, Say I create a table with three fields and label them a, b and c. I then create a form where the user inputs a number for a and b. The c field then...
May 9th, 2007 10:19 PM
by Marshall Barton Go to last post
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 Go to last post
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...
May 9th, 2007 07:34 PM
by Marshall Barton Go to last post
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...
May 9th, 2007 06:15 PM
by getitright Go to last post
0 84
Post New Thread


Display Options
Showing threads 11101 to 11120 of 28846
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:15 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.