Auto month field creator (or similar?)

[paulmcdonnell]

Hi guys,

I have a situation where clients have certain items issued out to them on a certain regular basis.

I have a form which sets these frequencies so for example documents a,b,c are issued monthly,weekly,qtrly respectiviely

I also need a log which tracks when and how these documents are issued, and also provides the comming periods issue to be updated.

The idea I have is that a period report ie weekly and monthly summarises these clients who have their frequencies that match the report. So each client will apear on the report with the report type that needs to be issued.

If a clients frquency is set to monthly then when a report is printed at the begining of the month this client will be picked up.

The PROBLEM I have is that I want to be able to project the next date that a report is required e.g "next report - 01 August 2002"

I also need an entry in a table that puts this date in there So when the information is sent, the user can updated the field to confirm the request as been filled.

In summary - How would you get a collection of selected tables to automatically create an entry each month with the name of that month?


Hope you can help, and understand....


Cheers
Paul

 

[BLeslie88]

Question...

Do you want this done at run-time when the user makes the entry or at a later time updating the whole table...?
You can use the current date fucntion in short form...
Such as : 06/21/02 or what ever date format your pc is set at...
Point being use the mid, left, right function to get the month and store it in it's own field... Reason for my question is because you can run a update query that would do this or you could also do at runtime while user are processing their requests...

Hope this helps....
Regards,