Query by Quarters and Monthly

[3063]

I have a form that utilizes the fOSUserName command to pull in the network Id into a table, along with the current date and month. I have two tables that are joined as one to many, which have the following fields, fname,lname,lanid,department. On the Many, I have lanid, date, month. My question is - I have some departments that need to sign forms quarterly, such as Accounting and some departments that need to sign forms monthly, such as the Computer Department. My question is - what would be the best to setup my queries? And should I setup a field in my table to distinquish between the departments that need to sign quarterly and monthly? I do not want to use the beginning date and ending date function for the quarterly reports. Eventully, would like to create a button a form to pull quarterly reports. Any help would greatly be appreciated.

 

[lameid]

If you just want to pull reports monthly for the monthly departments and quarterly for the quarterly departments AND the user is going to know when to run the reports, then I would simply flag the departments with a field monthly or quarterly. Actually, I would porbably have a table that shows each report and another that shows each department with each report it gets and set up monthly and quarterly there. That way Accounting may have to report Time and Attendance monthly and review some acceptable use policy quarterly (or whatever you need done).

That said, it then becomes up to you whether to include the monthly reports with the quarterly by using criteria to give you both or to just run them completely separate.