A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

error in the report when no data



 
 
Thread Tools Display Modes
  #1  
Old April 30th, 2010, 05:27 AM posted to microsoft.public.access.reports
associates
external usenet poster
 
Posts: 132
Default error in the report when no data

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
  #2  
Old April 30th, 2010, 08:16 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default error in the report when no data

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.

--
Duane Hookom
Microsoft Access MVP


"Associates" wrote:

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

  #3  
Old May 4th, 2010, 01:43 AM posted to microsoft.public.access.reports
associates
external usenet poster
 
Posts: 132
Default error in the report when no data

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

"Duane Hookom" wrote:

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.

--
Duane Hookom
Microsoft Access MVP


"Associates" wrote:

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

  #4  
Old May 4th, 2010, 04:17 AM posted to microsoft.public.access.reports
Duane Hookom[_4_]
external usenet poster
 
Posts: 316
Default error in the report when no data

"Error in the report" where? What control? What section? What control
source?


--
Duane Hookom
MS Access MVP


"Associates" wrote in message
...
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

"Duane Hookom" wrote:

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.

--
Duane Hookom
Microsoft Access MVP


"Associates" wrote:

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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:11 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.