Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Find data entry changes from one day to the next day

Status
Not open for further replies.

kernal

Technical User
Feb 27, 2001
415
US
I'm using Crystal 9 with csv files. CLASS_csv and CLASS_NEW_csv. I'm trying to show what data entry changes were made.

Friday Data: CLASS_csv
class pattern_nbr days start_time start_date
101 1 M W 10:00 10/20/2014

102 1 T 09:00 10/21/2014
102 2 F 10:00 10/24/2014

103 1 M W 10:00 10/20/2014
=================================================
Monday Data: CLASS_NEW_csv
class pattern_nbr days start_time start_date
101 1 M 09:00 10/20/2014
101 2 W 10:00 10/22/2014

102 1 T F 09:00 10/21/2014

103 1 M W 10:00 10/20/2014
=================================================
I need the report to show:

class pattern_nbr days start_time start_date
NOW: 101 1 M 09:00 10/20/2014
101 2 W 10:00 10/22/2014
WAS: 101 1 M W 10:00 10/20/2014


NOW: 102 1 T F 09:00 10/21/2014
WAS: 102 1 T 09:00 10/21/2014
102 2 F 10:00 10/24/2014

I wouldn't want class 103 to show since there weren't changes.
=================================================
I have the CLASS_NEW_csv left outer joined = to CLASS_csv on the class field. I'm not sure how to go on from there (grouping, etc.)

Help is appreciated!

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top