RE: Getting/manipulating data for multiple records, multiple tables

2000-10-27 Thread Andy Ewings
PROTECTED]] Sent: 27 October 2000 13:29 To: CF-Talk Subject: RE: Getting/manipulating data for multiple records, multiple tables Let me reply to my own question (copied in full at the bottom of this message) to try and refine the problem. I've been continuing to work on this and maybe this

Re: Getting/manipulating data for multiple records, multiple tables

2000-10-27 Thread pan
From: "Paul Sinclair" <[EMAIL PROTECTED]> > I'm having trouble figuring out how to use a SQL select statement to get > data for multiple records from multiple tables and then do some math on each > of the individual records for . > > I have a db with results from an annual golf event. There are

RE: Getting/manipulating data for multiple records, multiple tables

2000-10-27 Thread Paul Sinclair
Let me reply to my own question (copied in full at the bottom of this message) to try and refine the problem. I've been continuing to work on this and maybe this is a better way to start asking my question: tblOne year player points 1997 john 15 1997 pete 12