Dear Forum,
I have a datebase that excludes weekends. However I have been asked to create a query that includes weekends to allow for 365 day average of the data.
The small snipet below is the main query to return everything (havent put in a date range as yet). Anyone got any idea's how to do this please.
SELECT EXTRACTDATE, CURRENTACCOUNT FROM CLIENTACCOUNTTRENDS
Many thanks
Mark
I have a datebase that excludes weekends. However I have been asked to create a query that includes weekends to allow for 365 day average of the data.
The small snipet below is the main query to return everything (havent put in a date range as yet). Anyone got any idea's how to do this please.
SELECT EXTRACTDATE, CURRENTACCOUNT FROM CLIENTACCOUNTTRENDS
Many thanks
Mark