Access Report

[greenbg via AccessMonster.com]

How do you remove fields from a report when it not needed. I tried the below
command and it did no worked. this report is made from a query..

=IIf([MTEAM-14]<>" ", [MTEAM-14], RTrim( [MTEAM-14]))



thanks..

 

[Duane Hookom]

This doesn't make much sense. Would your field [MTEAM-14] actually contain a
single space? Or, would the field be empty? If you want to find out if the
field is empty, use something like:
=IIf(IsNull([MTEAM-14]), .... , ....)
Whether or not the field is null, you seem to be returning the same result.

How about some sample data as well as a better description of what you are
attempting to accomplish?

 

[greenbg via AccessMonster.com]

Duane
First of all thanks for your reply..I have 14 fields in this report all
fields will not have data in them all the time but will be used at some point.
mteam-1 and mteam-2 only one with valid data, the rest is empty. See below
example:

Current Output
mteam-1 mteam-2 mteam-3 mteam-4 . . . . . . . . .



mteam-14
------------------------------------------------------------------------------
----------------------------------------------------------
Wishing For:
mteam-1 mteam-2
------------------------------------------------------------------------------
---------------------------------------------
--- = detail break

This doesn't make much sense. Would your field [MTEAM-14] actually contain a
single space? Or, would the field be empty? If you want to find out if the
field is empty, use something like:
=IIf(IsNull([MTEAM-14]), .... , ....)
Whether or not the field is null, you seem to be returning the same result.

How about some sample data as well as a better description of what you are
attempting to accomplish?

How do you remove fields from a report when it not needed. I tried the below
command and it did no worked. this report is made from a query..

=IIf([MTEAM-14]<>" ", [MTEAM-14], RTrim( [MTEAM-14]))

thanks..

 

[Duane Hookom]

Your most recent posting doesn't seem to relate well to your first. Can you
tell us what you are attempting to do in your report? Are you trying to hide
headers where there is no data in a column/field?

Do you have a good reason for multiple similar fields? This seems
un-normalized.

Can you provide more specifics?

--
Duane Hookom
Microsoft Access MVP

Duane
First of all thanks for your reply..I have 14 fields in this report all
fields will not have data in them all the time but will be used at some point.
mteam-1 and mteam-2 only one with valid data, the rest is empty. See below
example:

Current Output
mteam-1 mteam-2 mteam-3 mteam-4 . . . . . . . . .



mteam-14
------------------------------------------------------------------------------
----------------------------------------------------------
Wishing For:
mteam-1 mteam-2
------------------------------------------------------------------------------
---------------------------------------------
--- = detail break

This doesn't make much sense. Would your field [MTEAM-14] actually contain a
single space? Or, would the field be empty? If you want to find out if the
field is empty, use something like:
=IIf(IsNull([MTEAM-14]), .... , ....)
Whether or not the field is null, you seem to be returning the same result.

How about some sample data as well as a better description of what you are
attempting to accomplish?

How do you remove fields from a report when it not needed. I tried the below
command and it did no worked. this report is made from a query..

=IIf([MTEAM-14]<>" ", [MTEAM-14], RTrim( [MTEAM-14]))

thanks..

 

[greenbg via AccessMonster.com]

Duane
I am tracking projects with the month, start date, end date and the
individuals assigned to the project. There will be anywhere between 1 and 14
individuals assigned to the project. I have a query that groups all of this
information together. My problem is when I generate a report the same amount
of space between each project regardless whether I have one individual or 14
individuals. I was hoping that there was a way to remove the extra space from
the report that is not needed. Is that possible??

Your most recent posting doesn't seem to relate well to your first. Can you
tell us what you are attempting to do in your report? Are you trying to hide
headers where there is no data in a column/field?

Do you have a good reason for multiple similar fields? This seems
un-normalized.

Can you provide more specifics?

Duane
First of all thanks for your reply..I have 14 fields in this report all

[quoted text clipped - 28 lines]

 

[Duane Hookom]

The best solution is to remove all of the "individuals assigned" fields and
create a related table where each assigned individual creates its own record.
If you have 5 individuals assigned to a project, you would create 5 records
in the "ProjectIndividuals" table.

--
Duane Hookom
Microsoft Access MVP

Duane
I am tracking projects with the month, start date, end date and the
individuals assigned to the project. There will be anywhere between 1 and 14
individuals assigned to the project. I have a query that groups all of this
information together. My problem is when I generate a report the same amount
of space between each project regardless whether I have one individual or 14
individuals. I was hoping that there was a way to remove the extra space from
the report that is not needed. Is that possible??

Your most recent posting doesn't seem to relate well to your first. Can you
tell us what you are attempting to do in your report? Are you trying to hide
headers where there is no data in a column/field?

Do you have a good reason for multiple similar fields? This seems
un-normalized.

Can you provide more specifics?

Duane
First of all thanks for your reply..I have 14 fields in this report all

[quoted text clipped - 28 lines]

thanks..

 

[greenbg via AccessMonster.com]

Thanks....

The best solution is to remove all of the "individuals assigned" fields and
create a related table where each assigned individual creates its own record.
If you have 5 individuals assigned to a project, you would create 5 records
in the "ProjectIndividuals" table.

Duane
I am tracking projects with the month, start date, end date and the

[quoted text clipped - 19 lines]