12-31-2010, 01:54 AM #4 DCrake Administrator Join Date: Jun 2005 Location: Burnley, Lancashire Posts: 8,634 Covered by US Patent. Answer The most common reason we find is that the name of the text box control itself is the same as the name of a field in the record source of Access #type! Error Therefore one bad expression can cause other calculated controls to display #Error, even if those controls are bound to valid expressions.

Join our community for more solutions or to ask questions. #error Access Query When to summon Uber: travel from Opera to CDG Was Donald Trump's father a member of the KKK? Find More Posts by DCrake 12-31-2010, 01:55 AM #5 tinyevil777 Newly Registered User Join Date: Dec 2010 Location: Wales, UK Posts: 137 Thanks: 12 Thanked In reports Use the HasData property property, specifically for this purpose.

HomeOverviewWhat is Microsoft AccessObject TipsTablesQueriesFormsReportsMacrosQuick TipsNumbersQueriesVersion TipsAccess 97Access 2007-2010ResourcesTips via emailShare your secretsLearn VBAAccess to SQLWhats New! Ms Access #error In Sum Field Flaws in Microsoft Access Provided by Allen Browne, January 2008. This function's syntax is simple: Nz(expression, replacementvalue) where expression is the field or value being evaluated and replacementvalue is the value or text you want to display, or pass, when there's Posts: 26,373 Thanks: 0 Thanked 2,403 Times in 2,372 Posts Re: #error when trying to sum a total fyi: if you still want it on the page footer, see this link:

#error Access Query

Change the name of the text box to 'tebTelNo', say, and the Control Source expression to ="Telephone No: " & [tebTelNo] and the text box should behave. Delivered Daily Subscribe Best of the Week Our editors highlight the TechRepublic articles, galleries, and videos that you absolutely cannot miss to stay current on the latest IT news, innovations, and Ms Access #error For the control Source of the text box, you input ="Telephone No: " & [TelNo]. Access #error In Textbox Any idea why Access hates my control sources?

You currently have 0 posts. http://performancepccanada.com/error-in/computation-error-in-webi-report.php The query part is "removecrlf(Jobs.notes) as NotesClear" The report form field is populated with "NotesClear" the function "removecrlf(Jobs.notes)" is a triple replace function: replace(replace(replace(data,"i",""), chr(13), ""), chr(10), " ") 0 Question Where should this formula be? O/S Windows XP (SP3) & Windows 7 64bit Access 2003 (version 11.0) Access 2007 (version 12.0) Remember when posting sample databases you will get a better response if it is pre #error In Access Form

How was this bridge burning and collapsing scene filmed in Buster Keaton's The General? Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily. So, instead of: =Sum([Amount]) use: =IIf([Report].[HasData], Sum([Amount]), 0) If you have many calculated controls, you need to do this on each one. check over here Even = 1 spits out #Error!.

O/S Windows XP (SP3) & Windows 7 64bit Access 2003 (version 11.0) Access 2007 (version 12.0) Remember when posting sample databases you will get a better response if it is pre Ms Access If Error Generated Sun, 02 Oct 2016 16:18:19 GMT by s_hv987 (squid/3.5.20) {{offlineMessage}} Store Store home Devices Microsoft Surface PCs & tablets Xbox Virtual reality Accessories Windows phone Microsoft Band Software Office Windows means and Access doesn't want to tell me.

I just noticed a possibility, the control/text box name is the same as the record source "NotesClear".

This sort-of makes sense: if the controls don't exist, you cannot sum them. For instance, a calculated control in a form or report has the potential to return #Error if a value is missing. Posts: 26,373 Thanks: 0 Thanked 2,403 Times in 2,372 Posts Re: #error when trying to sum a total Yea, I got tired of having to type it all out when asked #name Error In Access share|improve this answer answered Oct 31 '13 at 15:26 Johnny Bones 5,46032048 add a comment| up vote -2 down vote right click on your AREA filed and select properties then go

When i run the report, in the footer, i want each record's value to be added up, thus giving me a total. Optimized for Microsoft Internet Explorer Home Products Services Learning Forum Contact Access World Forums > Microsoft Access Discussion > Reports #error when trying to sum a total User Name They should find it easy to follow (I hope). this content All rights reserved.

Posts: 26,373 Thanks: 0 Thanked 2,403 Times in 2,372 Posts Re: #error when trying to sum a total Oh, I thought you knew how to do that. Not the answer you're looking for?