asked on

Access report details

Dear Experts,

There is MS ACCESS report based on 2 tables: tbl_task (parent) and tbl_subtask)child.
Report presentation grouped by task.
Some tasks have subtasks, then its fine. Both task and subtasks visible on the report.
Some tasks do not have subtasks. Then group is not visible on report.
Is there a way to see the group title even if its empty?

BRGDS,

Eric Sherman

The Report Object can only group on what's in you underlying table ... if the task is not there it would be impossible to group on it. I've done this in the past by making a table with all the possible tasks in it and creating a relation to your subtask table. Then group on the task field in that unique listing all possible task.

Just an idea.

ET

PatHartman

Typically tasks would be the main report and subtasks would be a subreport. If you are using only a main report make sure that the join between tasks and subtasks is a left join. That will return tasks even if they don't have subtasks.

Nikolay DMITRIEV

ASKER

Good day,

What is "left join"? I did not catch:(

Eric Sherman

Join you tables such that all records from the tasks table are included even if there is no matching subtasks. That's what I was referring to in my original post. You don't want to join where the join field i.e. TaskID has to be present in both tables.

ET

ASKER CERTIFIED SOLUTION

PatHartman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Nikolay DMITRIEV

ASKER

Thanks. Comprehensive. Clear. Works great.