With 1.7 million freelancers, we'll match you with the perfect talent.
The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
I have an audit table to monitor status changes for student records in a database. (sample audit log attached) With all changes to the status of a record, the "from" and "to" states are captured, along with a date/time and a couple of other bits. StudentID is the unique identifier for the student record. tblStatusLookup lists the string values for mem_from and mem_to (from/to states).
I would like a report and form to produce the following result:
1. A form that allows the user to select a series of states (from tblStatusLookup) that they would like to get a report on. Also start/end dates for the report range.
2. A report that uses the data from this form and presents the monthly summary (over the date range) for the selected states. A raw count of students in the particular state for a month is required, no student detail.
2a. If you can work a graph into the mix, that would be great. Not specifically required, just note whether or not this is in your bid.
If it is easier to s...
Sign in or Register to see more