General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only