Results 1 to 2 of 2
  1. #1
    yohansetiawan is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    24

    Question Totals feature can't count Sum on this field

    I have a form on database sheet model that contains this fields:

    -Product Name
    -Price
    -Quantity
    -Totals =>> control source is ==>> =[Price]*[Quantity]

    When I use Totals feature it can't count Sum on my "Totals" field that contain =[Price]*[Quantity] on control source.
    It restrict me only can Count on this field, another field like Quantity nor Price is fine with Sum, Avrg, etc like usual.


    How do I get Sum from this "Totals" field??

  2. #2
    yohansetiawan is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    24
    I'm sorry.
    This is ridiculous question
    My problem solved with making query then attach it to form.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Cumulative totals: Cannot edit a field in recordset
    By Persist in forum Programming
    Replies: 4
    Last Post: 03-11-2012, 06:38 PM
  2. Totals in Datasheet View only shows COUNT
    By nypedestrian in forum Forms
    Replies: 6
    Last Post: 08-26-2011, 08:23 AM
  3. Query Results "Count Totals"
    By tipopilotas in forum Queries
    Replies: 1
    Last Post: 03-26-2010, 10:36 PM
  4. help with totals for count text boxes
    By gacapp in forum Reports
    Replies: 10
    Last Post: 07-22-2009, 11:26 AM
  5. Replies: 5
    Last Post: 06-17-2009, 02:18 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums