"LF" <lf****@gmail.comwrote in
news:11**********************@s13g2000cwa.googlegr oups.com:
ManningFan,
Forgive my limited knowledge, but how would such a query be
structured?
Would I somehow have a record for each project in addition to
a record
for each task? Right now my query has a record for each task,
but there aren't separate records for the projects.
Thanks.
Proper database theory says you have one table that contains
project information, and a separate table that contains task
info, ....
You create a relation between the projects and tasks based on
the project ID which defines the project, and is in the tasks
table as a 'foreign key'.
This way, you get the power of having info related to project,
like start/end dates, manager, customer, only entered once, and
a change like a contract end date change is still visible
against all the tasks.
So you should have a projects table, as well as the tasks table.
You can cheat, however, by making a SELECT DISTINCT type query
to extract each unique project, and use that instead of a table,
for now. just join that query back to the tasks table, setting
to join type to left outer. that's the one that would say select
all records from PROJECTS and only records tfom TASKS where the
Project ID is equal, when you double-click the join line in the
upper pane of the query builder. .
ManningFan wrote:
>If you set up the query behind the report properly, it's a
pretty simple request.
LF wrote:
Hello,
I have a database with a table of projects and a table of
tasks (each project can have multiple tasks). I have a
report that has a group header for the project name, etc.,
and then the tasks appear in the Detail section.
Is it possible to have the project information in the group
header show up on the report even if there are no tasks
(i.e., no records in the Detail) for that project? How
would I do that?
Thanks for any help.
--
Bob Quintal
PA is y I've altered my email address.
--
Posted via a free Usenet account from
http://www.teranews.com