I hadn't thought of that. Seems like a good idea. I'll try it. Thank you Rafael
----- Original Message ----- From: Mike yearwood To: [EMAIL PROTECTED] Sent: Tuesday, October 02, 2007 2:07 PM Subject: RE: grid footers Hi Rafael > Message: 8 > Date: Tue, 2 Oct 2007 12:45:10 -0300 > From: "Rafael Copquin" <[EMAIL PROTECTED]> > Subject: grid footers > To: [EMAIL PROTECTED] > Message-ID: <[EMAIL PROTECTED]> > Content-Type: text/plain; charset="us-ascii" > > I am building a complicated information system which involves creating a grid with a variable number of columns. > > I need to generate totals of those columns and show them in labels > > But when the user navigates the grid to the right, and some columns on the left disappear and new ones appear on the right, I would like the bottom labels to move in sync with the columns. > Simplest thing of all. Do a query to generate your cursor. Do a union query to generate the sums. Add a field set to .f. on the summary record. Show the cursor in the grid and use when() in the textboxes to disable access to the summary record. Mike [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

