Lynn Pettis (4/16/2013)
Sapen (4/16/2013)
I am trying to convert into the below formatweek number,
average of sunday,
average of monday,
average of tuesday,
average of wednesday,
average of thursday,
average of friday,
average of saturday,
The averages are nothing but average of ccdata for that week on that specific day
How do I compare the results returned from a query to what you posted above? There is nothing there to validate that what a query returns is what you expect based on the sample data you provided.
Hi Lynn,
Please find the output format with data attached. Thanks a bunch for the help in advance.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams