Jump to content
Sign in to follow this  

Totals and Finds

Recommended Posts

It depends where you locate the summary field on your layout. If you create a subsummary part sorted by Food, and put a copy of the SUM_ALL field there, and then add a grand summary part and put another copy of the SUM_ALL field there, then you can display all records, sort by Food, and the subtotal will appear in the subsummary part for each food, and a grand total will appear in the grand summary part. Check out the manual regarding layout parts (chapter 6).

[ January 10, 2002: Message edited by: BobWeaver ]

Share this post

Link to post
Share on other sites

I'm sure this is a silly question, but I'm majorly stuck. Say I have these fields:

Rec_ID (number, auto-serial)

Date (Date, creation date)

Food (Text)

Quantity (Number)

Month (Calculation, Month(Date))

Year (Calculation, Year(Date))


For simplicity’s sake, say the database is populated as so:

1, 9/01/2001, Apple, 10

2 , 9/01/2001, Apple, 10

3 , 9/01/2001, Apple, 10

4 , 9/30/2001, Orange, 10

If I do a FIND, searching for Apples, SUM_ALL returns 30 which is correct. What do I do if I want the search for only Apples, but want to see the whole year’s Quantity of all Foods(40 in this case)? I'm sure I'll need another field (Total_Quantity), but I don't even know where to start. Since SUM_ALL isn't a stored value, is there a way to store the Total_Quantity value? Thanks in advance

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.