AnsweredAssumed Answered

creating report by date

Question asked by zackdenzer on Sep 17, 2010
Latest reply on Sep 20, 2010 by philmodjunk

Title

creating report by date

Post

This is my script which creates a report with all the last order date of each company from the database. I want to create a neat report which separates them into categories of; More than 1 month since last order, more than 3 months since last order, and more than 6 months since last order. Also right now the perform find simply omits all records before jan 1 2008. However, I would like it to find all records within 2 years of the current date, and omit all records after current date.

Also I wanted to create a button which would go to the order in another layout pased off the purchase order number.

Zack

full_report.PNG

Outcomes