Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cross Tabbing
Message
From
13/04/2000 10:27:04
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Cross Tabbing
Miscellaneous
Thread ID:
00359263
Message ID:
00359263
Views:
41
I have a table that stores a job number, date, and how many hours were spent on the job number. I need to create a query that groups the job numbers by weekending dates(how many hours were spent each week for a given month). The headers of the cursor would be each Sunday of the month. I can generate these headers using an array but how do I fill in the cursor, grouping the individual dates under the appropriate headers? Thanks For your help.

God Bless,
S. Dyke
Next
Reply
Map
View

Click here to load this message in the networking platform