Search results

Hi Smiler I am trying to sum the ullage column(F) for the month to date and the year to date where the date of the statistic (Column A) is less than or equal to the date selected on the report page. Any help you can provide would really help. Still trying to get the sumproduct suggestion to...

Hi there I have a table that has statistics in it by date. I have simplified below. The yearNum, MonthNum and WeekNum are just forumla driven off the date. The report is a variance report "as at" the date the user enters: Report for week ending: 17/05/2009 The reports are variance reports...

Hi I have two tables, one is an extract from an FMIS that shows the actual exchange rates that occurred when transactions are entered, the other table shows sales according to the sales system (a separate system). The FMIS data may refer to many days' sales transactions that have been...