There's a bit of everything in here, but most of it relates to getting data into reports. 
- means I have question 
Should be enough for everyone to have a go.
Overview:
In a "Key Activity Form" the user enters an activity (eg. finalise planning layout).
The database automatically fills the "Opened" field with the date the record is created Question 1 - how?
When the activity is started the user fills in the "Start Date" field.
When the activity is complete the user fills in the "Completed" field.
There are two reports: Future Activities and Previous Period Activities.
Activities that are OPENED, but not started or completed, slot into the Future Activities Report. I just have to filter the table against that report, right? Or do I have to create a query?
Activities that are OPENED and STARTED, go into the "Activities Previous Period Report".
Activities that are OPENED, STARTED and CLOSED, also go into the "Activities Previous Report" IF they were closed in the past month, otherwise they don't appear on the report. I'm guessing this might be easiest to run through a query to feed the report?
Because its possible (and highly likely) that users will accidently put a date in the wrong field, I also need to have a "clear" button next to both the "STARTED" and "COMPLETED" boxes on the form, to ensure the filtering into the reports works properly. Haven't got a clue where to start with this one.
- means I have question Should be enough for everyone to have a go.Overview:
In a "Key Activity Form" the user enters an activity (eg. finalise planning layout).
The database automatically fills the "Opened" field with the date the record is created
Question 1 - how?When the activity is started the user fills in the "Start Date" field.
When the activity is complete the user fills in the "Completed" field.
There are two reports: Future Activities and Previous Period Activities.
Activities that are OPENED, but not started or completed, slot into the Future Activities Report.
I just have to filter the table against that report, right? Or do I have to create a query?Activities that are OPENED and STARTED, go into the "Activities Previous Period Report".
Activities that are OPENED, STARTED and CLOSED, also go into the "Activities Previous Report" IF they were closed in the past month, otherwise they don't appear on the report.
I'm guessing this might be easiest to run through a query to feed the report?Because its possible (and highly likely) that users will accidently put a date in the wrong field, I also need to have a "clear" button next to both the "STARTED" and "COMPLETED" boxes on the form, to ensure the filtering into the reports works properly.
Haven't got a clue where to start with this one.
