VBA Select Query Help Needed
Posted on 2013-12-12
I have two tables in MSAccess
-Jobs [ JobID, JobDesc]
-JobsCompleted[JobID, JobTime, JobResult (Boolean)]
My goal is to create an MS Access Continuous Form with the following structure:
[Job Desc1] [JobResultToday] [JobResultYesterday] [JobResultTwoDaysAgo]
[Job Desc2] [JobResultToday] [JobResultYesterday] [JobResultTwoDaysAgo]
Where each result is a checkbox. Is there anyway to craft a query that produce this type of result?
I tried using the Form_Current() and changing the color of the checkboxes (couldn't change the 'check', and found it changed the color of all rows, not just the one I'm looking at.
Any other thoughts?