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 Reverse Sort Order / Thread Starter Last Post Replies Views
#Error is returned on sum([FieldName]) by beh
I'm trying to get rid of the #Error on a sum field in an Access report. I've tried =Sum(IIf(IsNull(),0,)) and the nz function to no avail. It looks like to...
October 27th, 2008 07:18 PM
by beh Go to last post
3 97
#ERROR Issues division by Jay
I have this report on which I do a division between an embedded sub-form and a control on the main report. When the report is run most of the controls will...
August 19th, 2004 02:51 AM
by Allen Browne Go to last post
3 217
#Error Message by Anita
Good morning! I have a report (rptNFORespondentCourseTrainerDate) that is tied to a query (qryNFORespondentCourseTrainerDate). There are parameter questions...
August 2nd, 2007 03:12 PM
by Anita Go to last post
0 123
#Error Message by Nigel
I have created a calculation to count the number of people and placed it in the Name Footer: =count() and called the unbound box, CountNames. When there are...
January 6th, 2010 07:09 PM
by Clifford Bass via AccessMonster.com Go to last post
5 623
#ERROR Message by bladelock
I have code in a report text box that works great. Just one problem, If the field or fields is missing or doesn't have data the function will display and...
November 29th, 2005 02:54 PM
by bladelock Go to last post
2 198
#Error Message in Report by RMP
The query parameters correctly return no records. The report that is run based on this query returns #Error in the report controls. What is syntax to use so...
August 18th, 2006 02:58 PM
by Duane Hookom Go to last post
5 93
#Error Message in Report by Beth Eadie
I have a form, query, and report that I am trying to get to work. The form contains a combo box which lists many services that the user can choose from. ...
July 9th, 2008 02:51 PM
by Allen Browne Go to last post
1 150
#Error message in Switch statement by Wings
I have the following switch statement associated with the Control Source property of a field in my report: =Switch(=0,"Low",=1,"High",=2,"Auto") When I run...
December 9th, 2005 08:16 PM
by Duane Hookom Go to last post
3 91
#Error Message on Report by VR
I am sure that this question has been asked b4; however, i cannot seem to find the answer. So, if someone does not mind answering again for me i would...
October 16th, 2006 03:39 PM
by VR Go to last post
1 86
#Error on Calculated control - Need to test the HasData property? by Marianne
I have a report with 6 subreports. On the Main report in a group footer, I want to calculate a % based on totals (calculated controls) in the subreports. I...
March 1st, 2005 07:52 PM
by Ken Snell [MVP] Go to last post
5 184
#Error on Count(*) by christyh
Report contains field where the control source is =Count(*). When there are no records, #Error is returned. Is there a way to have "no records found" appear...
May 17th, 2006 09:05 PM
by christyh Go to last post
2 77
#Error on field by Andy G
I have this statement on a field in a report. =IIf((IsNull()),, & "/" & ) If the person doesn't have a minor then just list the major, if they do have a...
August 24th, 2004 12:37 AM
by Ken Snell [MVP] Go to last post
1 97
#Error on no data by Debbie D.
I have a report that works great when there is some information from the query that supplies the data. However, if there is no data available then the form...
September 18th, 2005 07:38 PM
by Debbie D. Go to last post
4 92
#error on printed reports by Eric
I'm getting '#error' showing on previewed and printed reports but only on 1 or 2 PC's. The problematic fields have calculations in the underlying query. ...
August 27th, 2004 05:08 PM
by Allen Browne Go to last post
1 82
#error on reoprts generated by Abualharith
This message Occurs when Running A user defined function that contains any sort of calculation eg caclulating Words per minute using TWO fields NO_Of_words &...
June 8th, 2009 02:49 PM
by Marshall Barton Go to last post
2 113
#Error on report by Allan Pratt
I have created the following expression: =+ totaling 2 fields, but when I look at the report, I get the #Error message for the field. What am I doing...
August 25th, 2004 11:54 PM
by fredg Go to last post
1 93
#error on some computers by JerryT
When i try to use the Sum(abs) in a report it works great on my system on the network But on some when it prints some totals are correcr but the grand total...
August 24th, 2006 02:14 AM
by Allen Browne Go to last post
9 109
#error or #name? in text box by Gntlhnds
I have a report that I want to access two different ways, one by clicking on a button on a form (the report gets it's data from the form and two subforms),...
May 1st, 2007 01:34 PM
by Gntlhnds Go to last post
1 72
#error returned from page subtotal by M'al
Hi, I want to subtotal data per page. It works correctly to subtotal the groups and the report, but the page subtotal returns #error for both count and...
September 29th, 2004 10:27 PM
by M'al Go to last post
2 214
#Error shows up when total is zero even with Nz function by Moe
what is wrong with this expression "=Nz(Sum(),0)" I also tried" =Nz(Sum(Nz(,0)),0)" How can we use "Sum" and Nz together? It works when the sum returns a...
(Multi-page thread 1 2)
January 30th, 2007 08:53 PM
by Moe Go to last post
10 194
Post New Thread


Display Options
Showing threads 81 to 100 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 05:33 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.