M
marf
I have a TblProjects that contains details referring to a project. I have
another table called TblProjectUpdates that contains weekly updates for each
project, the realationship is one-to-many, because each project has many
updates.
This is what I need to do:
How do I create a report that retrieves information from the TblProjects
(Name, Date, #, EndDate, etc) and ONLY the last entry in TblProjectUpdates
(each entry has a date field for when the update was entered). I want to
create a report that shows the Project Info plus the Project Update Info.
Also, some projects may not have an update for that week, but I would still
like to show the last entry that does exist...
another table called TblProjectUpdates that contains weekly updates for each
project, the realationship is one-to-many, because each project has many
updates.
This is what I need to do:
How do I create a report that retrieves information from the TblProjects
(Name, Date, #, EndDate, etc) and ONLY the last entry in TblProjectUpdates
(each entry has a date field for when the update was entered). I want to
create a report that shows the Project Info plus the Project Update Info.
Also, some projects may not have an update for that week, but I would still
like to show the last entry that does exist...