Hello,
I was hoping someone would be able to help me or even tell me if this is possible.
I have a database which contains a schedule for about 500 different construction projects, in which there are some sites (about 60 for now) which have multiple projects associated with them, example; one project occurs 12/6/11 (SiteScheduleDate) and the next occurs on 11/11/11 (SiteSecondActivityDate) in the same site.
I'm currently using separate reports
Report 1
SiteName (text)
SiteAddress (text)
SiteLeaseExpiry (date/time)
SiteStatus (number - combo box)
SiteFitOutType (number - combo box)
SiteScheduleDate (date/time)
Report 2
SiteName (text)
SiteAddress (text)
SiteLeaseExpiry (date/time)
SiteStatus (number - combo box)
SiteFitOutType (number - combo box)
SiteSecondActivity (number - combo box)
SiteSecondActivityDate (date/time)
- All of this data is stored in that same table (tblSchedule)
What I'm hoping to do is merge the two reports together and have a single report that will replace the fields highlighted red with the fields highlighted blue once the SiteScheduleDate has passed or SiteStatus has been changed to 'completed'.
And to make things more difficult I know next to nothing about coding, I'm assuming this will need some code. I will be doing a course in VBA but not until early next year. So any help will be greatly appreciated as you will make me look like a god in my bosses eyes.
I hope that make sense and thanks for your time.