sum function error

MS Office Access

    Sponsored Links


  • 1. ListBox - Default Value = Max in box
    I have a listbox that is populated with the following query. SELECT [tbl_Plog_CR_Import].[CR Number], [tbl_CR_Costs_Schedule].[CR Batch] FROM tbl_Plog_CR_Import INNER JOIN tbl_CR_Costs_Schedule ON [tbl_Plog_CR_Import].[CR Number]=[tbl_CR_Costs_Schedule].[CR Number]; How would I go about setting the default value to the max number in the listbox. I realise I could do this by putting some code in the Form's Load event but was wondering if there was another method. TIA Andi
  • 2. Add a new record to related table on opening subform
    I'm not sure how to title this, but the problem is straightforward enough - I have a main project table (with an autonumber field as the primary key) and several related tables that are linked together referencing that project number. I have forms that I use to enter data in these related tables - they had been sub-forms, but I had to break them out as they were getting too large to be usable in a tabbed format. I've got the forms opening now using command buttons, and they are only opening related records, as they should - but when there are no related records (i.e. I haven't added an evaluation to the project yet) the new record that it shows doesn't have the project number populated. This is a major usability issue, and so I've got to get it working fast - it's been suggested by a user that 'maybe you can have it make a new record if there isn't one' but if there are records, we don't want blank ones created. Any suggestions??
  • 3. Email current record
    Hi I have a form and I would like to email the current record I am looking at. I have a report which it would use for the email but I can't get it to work. Can anyone help? This is what I have been working on Dim strWhere As String If Me.Dirty Then 'Save any edits. Me.Dirty = False End If Dim stDocName As String strWhere = "[Reference Number] = " & Me.[Reference Number] stDocName = "rptnewsletterdatabase" DoCmd.SendObject acReport, stDocName, , strWhere Thanks Colin
  • 4. find button in form
    I would like to make a button that could be used in a form to find records, friendly enough that untrained users could make use of the feature. I would like to create a button that does a "find in form", provided the user isn't already trying to do a find or filter. I would like a second button that would apply the filter created when the user entered data in the "find in form", and a third button that would eliminate the filter. In FileMaker Pro, I used one button for the first two functions with a script that was equivalent to if not in Find mode, enter "Find by Form" mode; else perform the find to filter the dataset to matching values. I know this can be done using the built-in user interface in Access, but it would be nice to create user-friendly buttons with words rather than symbols that untrained users do not understand. It seems easy, but none of my attempts work. Any suggestions? thanks Twas

sum function error

Postby U3RldmU » Thu, 24 Jan 2008 11:25:25 GMT

Hi sorry if this is a repost. My last effort seems to not show in the list so 
here goes again.
I have a main form and it contains a subform
on the subforms footer it has a sum function to calculate the total.
somtimes this produces an error and goes on endlessly calculating for some 
reason I cannot figure out. Mostly it works fine but once the error happens I 
have to close the program to make it work again.
if I use the subform on its own and not within the main form the sum works 
fine every time.
any help most apreciated as its so strange.
IM using Vista and access 2003
Steve - from a land down under

Re: sum function error

Postby Marshall Barton » Fri, 25 Jan 2008 01:35:17 GMT

Your earlier post showed up fine here and I responded there.
If you still have trouble finding it, try searching Google
Groups for the thread.

MVP [MS Access]

Re: sum function error

Postby . » Fri, 25 Jan 2008 23:01:19 GMT

dans l'article  XXXX@XXXXX.COM , Steve ?
 XXXX@XXXXX.COM  a 閏rit le 23/01/08 3:25?

Similar Threads:

1.Sum Function Error

I have a form containing a textbox with a control source of:


When records contain the data that is used by this function, the text box 
correctly displays the sum.  But, when any single piece of data is not 
contained in a record, the sum is not displayed, but is replaced with the 
word "Error".

Instead of the word "Error", I would rather have the textbox display "0".

Sure would appreciate this groups advice.

Thank you,

2.Sum function error

Hi All, I'm calculating a subtotal in a form using and expression calculated
in a query ([Subtotal_Sales]). The textbox which is showing this expression
is located in the foot header. the problem is that when I place it in the
report's header it works, but when I put it in the foot header is gives me
an #Error.
This textbox has the following expression in its control property:
*The Subtotal_Sales data is sorted by Seller in the report.

What's wrong?

3.Error on SUM( ) function

We converted Access 97 to 2002. One of the form has 
details section and form footer with totals using 
=SUM(Column1) function. Some times the total works fine 
and some times display error. The message display on the 
total field is #Error.  Any ideas?

4.Sum function in Access Project Form gives #error

Access 2003 Project / Windows XP SP1 / SQL Server 2000

For some reason I keep getting error messages on summed columns.  I am 
basically creating a form from a stored procedure.  I then add a cell to the 
footer with the following formula "=sum([coamt])".  On some forms it adds 
correctly, but when the form is automatically or manually refreshed it turns 
to "#error" and on other forms I get "#error" immediately.  

Any help would be appreciated,

5.Sum function generating syntax error.



generates a syntax error when put in as a control source for an unbound
textbox in the footer of a subform, whereas:


is perfectly acceptable.

Any ideas why?

Thanks in advance,


6. Sum function on subform error

7. Summing Text fields using NZ function causing error

8. Printing #Error# on sum function in report

Return to MS Office Access


Who is online

Users browsing this forum: No registered users and 72 guest