Jump to content

Totals and Finds


BobWeaver
 Share

This topic is 7224 days old. Please don't post here. Open a new topic instead.

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 ]

Link to comment
Share on other sites

  • Newbies

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))

SUM_ALL(Summary(Quantity))

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

Link to comment
Share on other sites

This topic is 7224 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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