creating report by date
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.