AnsweredAssumed Answered

How to create script that will return monthly sales

Question asked by JeffAbuya on Nov 30, 2017
Latest reply on Nov 30, 2017 by JeffAbuya

I have a database that I need to search for current month or prev. month sales. Manually I go to my layout called [MONTHLY/QTRLY SALES with totals] enter FIND mode and type "*" in my [JOB,ORDER NO.] field to return only records that contain a job number. I then select the [INVOICE DATE] field and enter mm/dd/year...mm/dd/year and hit enter. I would like to have two buttons to return this automatically if possible, one button for the current month and one button for prev. month. I am still a beginner, so any help would be great. Using Filemaker Pro 10.

Attachments

Outcomes