J
Jedster
I am trying to create a report based on a flat file to show the total sales
figures for each day of the week, initially where the data has been grouped
by 'section' and then 'subsection'. The problem I am finding is that I
cannot seem be able to specify different criteria within the same line of a
report, and then tie that in with the way that the data has already been
grouped.
I have so far created seven fields on a line to display total sales for each
day of the week and I then tried creating queries and subreports using the
formulae 'Weekday(Sales)=1' through to 7, so far without any real success. I
am not aware of any way of specifying a 'Where' clause within a 'Sum'
function on a text box, I don't think I can use SQL here to achieve the
required result, either.
I'd therefore appreciate any assistance anyone can offer as I'm now left
rather short of ideas!
Thanks in advance.
figures for each day of the week, initially where the data has been grouped
by 'section' and then 'subsection'. The problem I am finding is that I
cannot seem be able to specify different criteria within the same line of a
report, and then tie that in with the way that the data has already been
grouped.
I have so far created seven fields on a line to display total sales for each
day of the week and I then tried creating queries and subreports using the
formulae 'Weekday(Sales)=1' through to 7, so far without any real success. I
am not aware of any way of specifying a 'Where' clause within a 'Sum'
function on a text box, I don't think I can use SQL here to achieve the
required result, either.
I'd therefore appreciate any assistance anyone can offer as I'm now left
rather short of ideas!
Thanks in advance.