i have a query that has a series of data associated with a days of the week. how do i write an if statement that only returns data if it is a saturday or sunday - ie i only want value if true data returned, if the value is false, i would not like any data, nor 0s returned. thereby essentially filtering on a criterium, without the filter??
many thanks for any help
Bookmarks