NickS Posted March 13, 2005 Author Posted March 13, 2005 I am trying to create a calc field or sum field that would add the total points for each racer in a bike race. Each individual race results are reached thruogh sorting. I have attached the file. Any help would be appreciated.
NickS Posted March 13, 2005 Posted March 13, 2005 I am trying to create a calc field or sum field that would add the total points for each racer in a bike race. Each individual race results are reached thruogh sorting. I have attached the file. Any help would be appreciated.
NickS Posted March 13, 2005 Author Posted March 13, 2005 I am trying to create a calc field or sum field that would add the total points for each racer in a bike race. Each individual race results are reached thruogh sorting. I have attached the file. Any help would be appreciated.
dkemme Posted March 14, 2005 Posted March 14, 2005 No file came through but in general this is a good use for a summary field. An example use would be for a table with many records with a field for Point (number) and RacerID (number) you could create a summary field sum (Point). Then you would perform a find for the data you wish, sort by RacerID, create a field that would give you a page break for each unique RacerID, place summary field in a subsummary part choosing the option for page break after each RacerID, find the records you wish to view/print, sort by the field selected in the subsummary part and print or view in preview mode. Enclosed is simple example to get you started.
dkemme Posted March 14, 2005 Posted March 14, 2005 No file came through but in general this is a good use for a summary field. An example use would be for a table with many records with a field for Point (number) and RacerID (number) you could create a summary field sum (Point). Then you would perform a find for the data you wish, sort by RacerID, create a field that would give you a page break for each unique RacerID, place summary field in a subsummary part choosing the option for page break after each RacerID, find the records you wish to view/print, sort by the field selected in the subsummary part and print or view in preview mode. Enclosed is simple example to get you started.
dkemme Posted March 14, 2005 Posted March 14, 2005 No file came through but in general this is a good use for a summary field. An example use would be for a table with many records with a field for Point (number) and RacerID (number) you could create a summary field sum (Point). Then you would perform a find for the data you wish, sort by RacerID, create a field that would give you a page break for each unique RacerID, place summary field in a subsummary part choosing the option for page break after each RacerID, find the records you wish to view/print, sort by the field selected in the subsummary part and print or view in preview mode. Enclosed is simple example to get you started.
NickS Posted March 14, 2005 Author Posted March 14, 2005 Thanks for your help. I know a about where you are, I spent some time in Scottsbluff Nebraska some years ago. I am not sure why I can not seem to get the files to up load to the forum. I have tried sit and zip. I will send it again.
NickS Posted March 14, 2005 Author Posted March 14, 2005 Thanks for your help. I know a about where you are, I spent some time in Scottsbluff Nebraska some years ago. I am not sure why I can not seem to get the files to up load to the forum. I have tried sit and zip. I will send it again.
NickS Posted March 14, 2005 Author Posted March 14, 2005 Thanks for your help. I know a about where you are, I spent some time in Scottsbluff Nebraska some years ago. I am not sure why I can not seem to get the files to up load to the forum. I have tried sit and zip. I will send it again.
dkemme Posted March 15, 2005 Posted March 15, 2005 I'm able to download my attachment fine, but no luck with NickS's.
dkemme Posted March 15, 2005 Posted March 15, 2005 I'm able to download my attachment fine, but no luck with NickS's.
dkemme Posted March 15, 2005 Posted March 15, 2005 I'm able to download my attachment fine, but no luck with NickS's.
Recommended Posts
This topic is 7286 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 accountSign in
Already have an account? Sign in here.
Sign In Now