error in the report when no data

  • Thread starter Thread starter Associates
  • Start date Start date
A

Associates

Hi,

I was wondering if I can get some help with Access report question.

In an Access report, There is a number of headers namely Agenda Header, Task
Header and SubTask Header. I got error in the report when SubTask is empty or
no value. What I would like to be able to do is to be able to generate a
report without errors even when SubTask has no record or data.

Wonder if anyone might want to help me work around this.

Any help would be appreciated.

Thank you in advance
 
We can't see your data, your control sources, the report section, or your
error message. You might get a perfect solution that meets your needs if you
provide more information.
 
Thank you Duane for your reply.

Sorry that i did not supply enough info for you to help me out.

Basically, I am creating a database for our meeting minutes. It consists of
four tables namely meetingminutes, agenda, tasks and subtasks.

Table meetingminutes has the following attributes:
MM_ID (autonumber & PK), MM_No (text), Agendas (text), DateMinutes (date/time)

Table agenda has as follows
agenda_ID (autonumber & PK), agenda_No (text), agenda_items (text), MM_No (FK)

Table tasks has attributes as follows
task_ID (autonumber & PK), task_No (text), task_items (text), actioner
(text), MM_No (FK) and agenda_No (FK)

Table subtasks has as follows
STask_ID (autonumber & PK), STask_No (text), STask_items (text), actioner
(text), MM_No (FK), agenda_No (FK) and task_No (text)

In the report, the control source is based on a query that is created by
linking those four tables together via their Foreign Keys.

So in the report, i get errors when there is no data in the SubTasks.
However, if i manage to put in data in the agenda, tasks and subtasks tables,
I can get the report open up nicely with no errors.

There will be an occasion when a meeting minute has data filled up to Tasks
and has no items for SubTasks.

Hope my explanation would help you to help me.

Please let me know if you need any more info from me.

Thank you in advance
 
Back
Top