Re: New Job & The Silence is Killing Me...

On Wed, 21 Jul 2021 at 03:34, Kurt at VR-FX wrote: > > And - for those that follow my Meanderings thru this thing we call life > - I was last working Tech support at Northrop-Grumman in Redondo Beach, > CA - and was there for like 1 year and 2 months. Well - I know moved > onto a New Gig - which m

Re: Data Manipulation, Pivot?

A possible solution: SELECT StoreFK;         ,EmployeeFK;         ,MIN(Sheetdate) AS WeekStart;         ,MAX(RosterStart1) AS RosterStart1 ;         ,MAX(RosterEnd1) AS RosterEnd1 ;         ,MAX(WorkStart1) AS WorkStart1 ;         ,MAX(WorkEnd1) AS WorkEnd1 ;         ,MAX(RosterStart2) AS RosterS

Data Manipulation, Pivot?

Hi, I haven't done a lot of VFP recently so I've forgotten some basics. I need to manipulate some data for reporting purposes. Here's some sample code:CREATE CURSOR TimeSheets ; (TimeSheetPK i,; StoreFK i,; Sheetdate d,; isRoster l) CREATE CURSOR TimeSheetDetails ; (TimeSheetDetailsPK i,; Tim