Search results

Question: I have a yearly listing crosstab. User can transfer/export a one year or multiple year listing of sales and cost of sales to Excel. After my transferspreadsheet cmd, I have a formatExcel procedure that will format the header, change the columns to 'comma' format, and add a total row...

I have a form right now with 2 textboxes (FromDate / ToDate). Based on the dates, the VBA coding currently pulls all activity between the dates. Since the dates can be of one or more years, I'm not familar with creating dynamic reports that will be flexible to accommodate total sales numbers...

I'm trying to create a dynamic report where a user would select a date range of sales activity from a separte form. If a user selects a 2 year period, I want a report to populate with two columns of activity (ex. 2010 vs. 2011). If a user selects a 3 year period, I want the same report template...