glennolsen
March 2nd, 2006, 09:14 PM
Hello,
Crystal reports newbie. I have a DB app that we have been entering records into since 9/1/2005. Very easy to create reports that total fields for selected records. However, I need to add to the field totals a past total figure. Or more plainly, a pilot gets hired and starts January 1, 2006. We enter all of his flight information for each flight that he flies with us since 1/1/2006. It is easy to sum up total flight time since January 1, 2006. However, the pilot has 3000 hours of flight time prior to 1/1/2006. I have this data entered in a table in the database. I need to know how to get Crystal Reports to query the second table and then add the prior time to get total flight time for a pilot? Any ideas???
Glenn
Crystal reports newbie. I have a DB app that we have been entering records into since 9/1/2005. Very easy to create reports that total fields for selected records. However, I need to add to the field totals a past total figure. Or more plainly, a pilot gets hired and starts January 1, 2006. We enter all of his flight information for each flight that he flies with us since 1/1/2006. It is easy to sum up total flight time since January 1, 2006. However, the pilot has 3000 hours of flight time prior to 1/1/2006. I have this data entered in a table in the database. I need to know how to get Crystal Reports to query the second table and then add the prior time to get total flight time for a pilot? Any ideas???
Glenn