Thanks in advance for your help! Questions are written in bold. I am not familiar with code so if it must be added, please let know where exactly it must be added (on click, on exit, etc.)
I have a tbl [tblTasksReceived]. Key fields include: [task id], [task requestor], [task start date]. There isn't any field to mark tasks as incomplete; it is assumed that the data in the table is incomplete.
There is another tbl [tblTasksCompleted]. Key fields include: [completed task id], [task id] (same as task id as above), [task completed by], [date completed]. I have set up a behind the scene field [task completed] (which doesn't appear on reports) as a yes/no field that marks all items in the table as completed. Incomplete data is determined if the Task ID in this tbl IsNull.
I then merge the data based on [task id] to give me the full data. I use the [task completed] to query out (in another query) the completed items. And a separate query for incomplete.
I have the reports driven by a form. The query is linked to the form by [forms][formname][field] to select the "main" query field [task requestor]. That works. How do I end a date prompt in the form/query so that the dates entered in the form will show up on the report? This is important to the main user.
Is there a way to design the form/corresponding data so that the incomplete tasks and completed tasks can be shown as options on the form to select which data set? I already have the date range and [task requestor] fields I also need to be able to select both sets of data for a combinded report where the completed tasks would be one group and incomplete tasks another group. Thanks a bunch!
I have a tbl [tblTasksReceived]. Key fields include: [task id], [task requestor], [task start date]. There isn't any field to mark tasks as incomplete; it is assumed that the data in the table is incomplete.
There is another tbl [tblTasksCompleted]. Key fields include: [completed task id], [task id] (same as task id as above), [task completed by], [date completed]. I have set up a behind the scene field [task completed] (which doesn't appear on reports) as a yes/no field that marks all items in the table as completed. Incomplete data is determined if the Task ID in this tbl IsNull.
I then merge the data based on [task id] to give me the full data. I use the [task completed] to query out (in another query) the completed items. And a separate query for incomplete.
I have the reports driven by a form. The query is linked to the form by [forms][formname][field] to select the "main" query field [task requestor]. That works. How do I end a date prompt in the form/query so that the dates entered in the form will show up on the report? This is important to the main user.
Is there a way to design the form/corresponding data so that the incomplete tasks and completed tasks can be shown as options on the form to select which data set? I already have the date range and [task requestor] fields I also need to be able to select both sets of data for a combinded report where the completed tasks would be one group and incomplete tasks another group. Thanks a bunch!
