I have a database which contains a schedule for about 500 different construction projects, there are some sites (about 40) which have multiple projects associated with them, example; one project occurs say 12/6/11 and the next occurs on 11/11/11. I would like to be able to create a report which will generate all the data associated with the second date after the date of the original project has expired.
So, I would like a report that contains all data and then exclude the data for the dates that have already passed.
It will be hard to help you if you don't provide a description of the table(s) involved in the process you describe (Table name, Columns names, Data types, at least).
All the data I need for this report is kept in the same table "tblSchedule".
The fields I would like to include are:
SiteFitOutType (number - combo box)
SiteSecondActivity (number - combo box)
I also have two unbound textboxes which calculate the financial year and qtr of the scheduled dates.
So yeah, I currently have a report that contains all that data, but if possible I would like the second activity part of the data to only appear once the original scheduled date has passed.