Concatenate Unbound

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Well I tryed to Concatenate inside of a quiry, but the problem still is
there. What am I doing wrong.

I am new so please understand.
I have a report with 8 different textbox's (unbound) inwhich it checks for
information and places an X in the textbox(s). I first put all in the name
header, but would only receive one X per name(record from the parent table).
So I put all textbox(s) in the detail part and it worked for the X(s) exspect
that I am
getting blank lines when there is no X(s)(X(s) are checked from a
Combobox(s) agaisnt the child table). I used the can shrink, in both
the Detail section and each textbox in that section, but it still shows up
with the blank lines and waste to much paper.

Right now the report looks like:

A B C D E F G H
John smith X
X
X
X

X
X
X
Joe Smith





X



I would like it to look like:

A B C D E F G H
John Smith X X X X X X X
Joe Smith X
and so on:

Please can someone help
Thank You!!!!
 
You should really explain how the Xs get put into the text boxes since they
are unbound.
However, you could create a group header on the name field. Make it the same
height as the detail section. Then add code to the On Format event of the
detail section:
Me.MoveLayout = False
 
I am sorry I don't understand, I currently have all the Skil(s) grouped
together. and the Xs are put on the report by the qruery(SQL statment).
SELECT DISTINCTROW [LAST_NAME] & ", " & [first_name] AS Name,
tblPersonnel.SALUTATION, tblPersonnel.STATUS, tblPersonnel.SSN,
tblPrsExpertise.TEXT, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo2]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo2])=([Text]),"X","
") AS Skil1, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo3]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo3])=([Text]),"X","
") AS Skil2, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo4]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo4])=([Text]),"X","
") AS Skil3, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo5]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo5])=([Text]),"X","
") AS Skil4, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo6]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo6])=([Text]),"X","
") AS Skil5, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo7]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo7])=([Text]),"X","
") AS Skil6, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo8]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo8])=([Text]),"X","
") AS Skil7, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo9]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo9])=([Text]),"X","
") AS Skil8
FROM tblPersonnel RIGHT JOIN tblPrsExpertise ON tblPersonnel.SSN =
tblPrsExpertise.SSN;

Thank You! Duane Hookom
 
Are you sure your report controls are unbound? It looks like they are bound
to columns from your query like: SKil1, Skil2, Skil3,... If they have a
control source, they are bound.

Do you not understand how to add code to an event in a section of a report?

--
Duane Hookom
MS Access MVP


Amour said:
I am sorry I don't understand, I currently have all the Skil(s) grouped
together. and the Xs are put on the report by the qruery(SQL statment).
SELECT DISTINCTROW [LAST_NAME] & ", " & [first_name] AS Name,
tblPersonnel.SALUTATION, tblPersonnel.STATUS, tblPersonnel.SSN,
tblPrsExpertise.TEXT, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo2]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo2])=([Text]),"X","
") AS Skil1, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo3]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo3])=([Text]),"X","
") AS Skil2, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo4]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo4])=([Text]),"X","
") AS Skil3, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo5]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo5])=([Text]),"X","
") AS Skil4, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo6]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo6])=([Text]),"X","
") AS Skil5, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo7]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo7])=([Text]),"X","
") AS Skil6, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo8]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo8])=([Text]),"X","
") AS Skil7, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo9]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo9])=([Text]),"X","
") AS Skil8
FROM tblPersonnel RIGHT JOIN tblPrsExpertise ON tblPersonnel.SSN =
tblPrsExpertise.SSN;

Thank You! Duane Hookom

Duane Hookom said:
You should really explain how the Xs get put into the text boxes since
they
are unbound.
However, you could create a group header on the name field. Make it the
same
height as the detail section. Then add code to the On Format event of the
detail section:
Me.MoveLayout = False
Click to expand...
Click to expand...
 
Yes I know how to add code, what I do not understand is: you could create a
group header on the name field. Make it the same height as the detail
section. By this do you mean for me to leave the name(bound textbox) in the
Name header section and have all the skil(s) in the detail section? And the
name(bound textbox) is in the grouping sorting area with it as the group
header. Thank You for any help!

Duane Hookom said:
Are you sure your report controls are unbound? It looks like they are bound
to columns from your query like: SKil1, Skil2, Skil3,... If they have a
control source, they are bound.

Do you not understand how to add code to an event in a section of a report?

--
Duane Hookom
MS Access MVP


Amour said:
I am sorry I don't understand, I currently have all the Skil(s) grouped
together. and the Xs are put on the report by the qruery(SQL statment).
SELECT DISTINCTROW [LAST_NAME] & ", " & [first_name] AS Name,
tblPersonnel.SALUTATION, tblPersonnel.STATUS, tblPersonnel.SSN,
tblPrsExpertise.TEXT, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo2]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo2])=([Text]),"X","
") AS Skil1, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo3]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo3])=([Text]),"X","
") AS Skil2, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo4]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo4])=([Text]),"X","
") AS Skil3, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo5]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo5])=([Text]),"X","
") AS Skil4, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo6]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo6])=([Text]),"X","
") AS Skil5, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo7]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo7])=([Text]),"X","
") AS Skil6, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo8]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo8])=([Text]),"X","
") AS Skil7, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo9]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo9])=([Text]),"X","
") AS Skil8
FROM tblPersonnel RIGHT JOIN tblPrsExpertise ON tblPersonnel.SSN =
tblPrsExpertise.SSN;

Thank You! Duane Hookom

Duane Hookom said:
You should really explain how the Xs get put into the text boxes since
they
are unbound.
However, you could create a group header on the name field. Make it the
same
height as the detail section. Then add code to the On Format event of the
detail section:
Me.MoveLayout = False

--
Duane Hookom
MS Access MVP
--

Well I tryed to Concatenate inside of a quiry, but the problem still is
there. What am I doing wrong.

I am new so please understand.
I have a report with 8 different textbox's (unbound) inwhich it checks
for
information and places an X in the textbox(s). I first put all in the
name
header, but would only receive one X per name(record from the parent
table).
So I put all textbox(s) in the detail part and it worked for the X(s)
exspect
that I am
getting blank lines when there is no X(s)(X(s) are checked from a
Combobox(s) agaisnt the child table). I used the can shrink, in both
the Detail section and each textbox in that section, but it still shows
up
with the blank lines and waste to much paper.

Right now the report looks like:

A B C D E F G H
John smith X
X
X
X

X
X
X
Joe Smith





X



I would like it to look like:

A B C D E F G H
John Smith X X X X X X X
Joe Smith X
and so on:

Please can someone help
Thank You!!!!
Click to expand...
Click to expand...
Click to expand...
 
Exactly what you said.

I have a tendency to think you are over-engineering this solution but I'm
not certain.

--
Duane Hookom
MS Access MVP


Amour said:
Yes I know how to add code, what I do not understand is: you could create
a
group header on the name field. Make it the same height as the detail
section. By this do you mean for me to leave the name(bound textbox) in
the
Name header section and have all the skil(s) in the detail section? And
the
name(bound textbox) is in the grouping sorting area with it as the group
header. Thank You for any help!

Duane Hookom said:
Are you sure your report controls are unbound? It looks like they are
bound
to columns from your query like: SKil1, Skil2, Skil3,... If they have a
control source, they are bound.

Do you not understand how to add code to an event in a section of a
report?

--
Duane Hookom
MS Access MVP


Amour said:
I am sorry I don't understand, I currently have all the Skil(s) grouped
together. and the Xs are put on the report by the qruery(SQL
statment).
SELECT DISTINCTROW [LAST_NAME] & ", " & [first_name] AS Name,
tblPersonnel.SALUTATION, tblPersonnel.STATUS, tblPersonnel.SSN,
tblPrsExpertise.TEXT, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo2]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo2])=([Text]),"X","
") AS Skil1, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo3]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo3])=([Text]),"X","
") AS Skil2, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo4]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo4])=([Text]),"X","
") AS Skil3, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo5]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo5])=([Text]),"X","
") AS Skil4, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo6]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo6])=([Text]),"X","
") AS Skil5, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo7]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo7])=([Text]),"X","
") AS Skil6, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo8]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo8])=([Text]),"X","
") AS Skil7, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo9]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo9])=([Text]),"X","
") AS Skil8
FROM tblPersonnel RIGHT JOIN tblPrsExpertise ON tblPersonnel.SSN =
tblPrsExpertise.SSN;

Thank You! Duane Hookom

:

You should really explain how the Xs get put into the text boxes since
they
are unbound.
However, you could create a group header on the name field. Make it
the
same
height as the detail section. Then add code to the On Format event of
the
detail section:
Me.MoveLayout = False

--
Duane Hookom
MS Access MVP
--

Well I tryed to Concatenate inside of a quiry, but the problem still
is
there. What am I doing wrong.

I am new so please understand.
I have a report with 8 different textbox's (unbound) inwhich it
checks
for
information and places an X in the textbox(s). I first put all in
the
name
header, but would only receive one X per name(record from the parent
table).
So I put all textbox(s) in the detail part and it worked for the
X(s)
exspect
that I am
getting blank lines when there is no X(s)(X(s) are checked from a
Combobox(s) agaisnt the child table). I used the can shrink, in
both
the Detail section and each textbox in that section, but it still
shows
up
with the blank lines and waste to much paper.

Right now the report looks like:

A B C D E F G H
John smith X
X
X
X

X
X

X
Joe Smith





X



I would like it to look like:

A B C D E F G H
John Smith X X X X X X X
Joe Smith X
and so on:

Please can someone help
Thank You!!!!
Click to expand...
Click to expand...
Click to expand...
 
Well that kind of works, but now the detail is one line down. Were the next
line is another record. example:
A B C D E F G H
John Smith
Joe Smith X X

it should be that John Smith has the Xs like:


A B C D E F G H
John Smith X X
Joe Smith

I have the name(bound textbox) set to: can shrink= no; can grow = no; dups =
no
in a grouping and sorting as a group header.

Thank You for any help!

Duane Hookom said:
Exactly what you said.

I have a tendency to think you are over-engineering this solution but I'm
not certain.

--
Duane Hookom
MS Access MVP


Amour said:
Yes I know how to add code, what I do not understand is: you could create
a
group header on the name field. Make it the same height as the detail
section. By this do you mean for me to leave the name(bound textbox) in
the
Name header section and have all the skil(s) in the detail section? And
the
name(bound textbox) is in the grouping sorting area with it as the group
header. Thank You for any help!

Duane Hookom said:
Are you sure your report controls are unbound? It looks like they are
bound
to columns from your query like: SKil1, Skil2, Skil3,... If they have a
control source, they are bound.

Do you not understand how to add code to an event in a section of a
report?

--
Duane Hookom
MS Access MVP


I am sorry I don't understand, I currently have all the Skil(s) grouped
together. and the Xs are put on the report by the qruery(SQL
statment).
SELECT DISTINCTROW [LAST_NAME] & ", " & [first_name] AS Name,
tblPersonnel.SALUTATION, tblPersonnel.STATUS, tblPersonnel.SSN,
tblPrsExpertise.TEXT, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo2]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo2])=([Text]),"X","
") AS Skil1, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo3]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo3])=([Text]),"X","
") AS Skil2, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo4]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo4])=([Text]),"X","
") AS Skil3, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo5]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo5])=([Text]),"X","
") AS Skil4, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo6]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo6])=([Text]),"X","
") AS Skil5, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo7]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo7])=([Text]),"X","
") AS Skil6, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo8]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo8])=([Text]),"X","
") AS Skil7, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo9]) And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo9])=([Text]),"X","
") AS Skil8
FROM tblPersonnel RIGHT JOIN tblPrsExpertise ON tblPersonnel.SSN =
tblPrsExpertise.SSN;

Thank You! Duane Hookom

:

You should really explain how the Xs get put into the text boxes since
they
are unbound.
However, you could create a group header on the name field. Make it
the
same
height as the detail section. Then add code to the On Format event of
the
detail section:
Me.MoveLayout = False

--
Duane Hookom
MS Access MVP
--

Well I tryed to Concatenate inside of a quiry, but the problem still
is
there. What am I doing wrong.

I am new so please understand.
I have a report with 8 different textbox's (unbound) inwhich it
checks
for
information and places an X in the textbox(s). I first put all in
the
name
header, but would only receive one X per name(record from the parent
table).
So I put all textbox(s) in the detail part and it worked for the
X(s)
exspect
that I am
getting blank lines when there is no X(s)(X(s) are checked from a
Combobox(s) agaisnt the child table). I used the can shrink, in
both
the Detail section and each textbox in that section, but it still
shows
up
with the blank lines and waste to much paper.

Right now the report looks like:

A B C D E F G H
John smith X
X
X
X

X
X

X
Joe Smith





X



I would like it to look like:

A B C D E F G H
John Smith X X X X X X X
Joe Smith X
and so on:

Please can someone help
Thank You!!!!
Click to expand...
Click to expand...
Click to expand...
 
I should have thought this through better. Use a Group Footer rather than
Header for the name.

--
Duane Hookom
MS Access MVP
--

Amour said:
Well that kind of works, but now the detail is one line down. Were the
next
line is another record. example:
A B C D E F G H
John Smith
Joe Smith X X

it should be that John Smith has the Xs like:


A B C D E F G H
John Smith X X
Joe Smith

I have the name(bound textbox) set to: can shrink= no; can grow = no; dups
=
no
in a grouping and sorting as a group header.

Thank You for any help!

Duane Hookom said:
Exactly what you said.

I have a tendency to think you are over-engineering this solution but I'm
not certain.

--
Duane Hookom
MS Access MVP


Amour said:
Yes I know how to add code, what I do not understand is: you could
create
a
group header on the name field. Make it the same height as the detail
section. By this do you mean for me to leave the name(bound textbox)
in
the
Name header section and have all the skil(s) in the detail section?
And
the
name(bound textbox) is in the grouping sorting area with it as the
group
header. Thank You for any help!

:

Are you sure your report controls are unbound? It looks like they are
bound
to columns from your query like: SKil1, Skil2, Skil3,... If they have
a
control source, they are bound.

Do you not understand how to add code to an event in a section of a
report?

--
Duane Hookom
MS Access MVP


I am sorry I don't understand, I currently have all the Skil(s)
grouped
together. and the Xs are put on the report by the qruery(SQL
statment).
SELECT DISTINCTROW [LAST_NAME] & ", " & [first_name] AS Name,
tblPersonnel.SALUTATION, tblPersonnel.STATUS, tblPersonnel.SSN,
tblPrsExpertise.TEXT, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo2])
And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo2])=([Text]),"X","
") AS Skil1, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo3])
And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo3])=([Text]),"X","
") AS Skil2, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo4])
And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo4])=([Text]),"X","
") AS Skil3, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo5])
And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo5])=([Text]),"X","
") AS Skil4, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo6])
And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo6])=([Text]),"X","
") AS Skil5, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo7])
And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo7])=([Text]),"X","
") AS Skil6, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo8])
And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo8])=([Text]),"X","
") AS Skil7, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo9])
And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo9])=([Text]),"X","
") AS Skil8
FROM tblPersonnel RIGHT JOIN tblPrsExpertise ON tblPersonnel.SSN =
tblPrsExpertise.SSN;

Thank You! Duane Hookom

:

You should really explain how the Xs get put into the text boxes
since
they
are unbound.
However, you could create a group header on the name field. Make it
the
same
height as the detail section. Then add code to the On Format event
of
the
detail section:
Me.MoveLayout = False

--
Duane Hookom
MS Access MVP
--

Well I tryed to Concatenate inside of a quiry, but the problem
still
is
there. What am I doing wrong.

I am new so please understand.
I have a report with 8 different textbox's (unbound) inwhich it
checks
for
information and places an X in the textbox(s). I first put all
in
the
name
header, but would only receive one X per name(record from the
parent
table).
So I put all textbox(s) in the detail part and it worked for the
X(s)
exspect
that I am
getting blank lines when there is no X(s)(X(s) are checked from a
Combobox(s) agaisnt the child table). I used the can shrink, in
both
the Detail section and each textbox in that section, but it still
shows
up
with the blank lines and waste to much paper.

Right now the report looks like:

A B C D E F G H
John smith X
X
X
X

X

X

X
Joe Smith





X



I would like it to look like:

A B C D E F G H
John Smith X X X X X X X
Joe Smith X
and so on:

Please can someone help
Thank You!!!!
Click to expand...
Click to expand...
Click to expand...
 
Great the problem I had is corrected thanks to you Duane Hookom. Thank You
very much.. you were very helpful..

Duane Hookom said:
I should have thought this through better. Use a Group Footer rather than
Header for the name.

--
Duane Hookom
MS Access MVP
--

Amour said:
Well that kind of works, but now the detail is one line down. Were the
next
line is another record. example:
A B C D E F G H
John Smith
Joe Smith X X

it should be that John Smith has the Xs like:


A B C D E F G H
John Smith X X
Joe Smith

I have the name(bound textbox) set to: can shrink= no; can grow = no; dups
=
no
in a grouping and sorting as a group header.

Thank You for any help!

Duane Hookom said:
Exactly what you said.

I have a tendency to think you are over-engineering this solution but I'm
not certain.

--
Duane Hookom
MS Access MVP


Yes I know how to add code, what I do not understand is: you could
create
a
group header on the name field. Make it the same height as the detail
section. By this do you mean for me to leave the name(bound textbox)
in
the
Name header section and have all the skil(s) in the detail section?
And
the
name(bound textbox) is in the grouping sorting area with it as the
group
header. Thank You for any help!

:

Are you sure your report controls are unbound? It looks like they are
bound
to columns from your query like: SKil1, Skil2, Skil3,... If they have
a
control source, they are bound.

Do you not understand how to add code to an event in a section of a
report?

--
Duane Hookom
MS Access MVP


I am sorry I don't understand, I currently have all the Skil(s)
grouped
together. and the Xs are put on the report by the qruery(SQL
statment).
SELECT DISTINCTROW [LAST_NAME] & ", " & [first_name] AS Name,
tblPersonnel.SALUTATION, tblPersonnel.STATUS, tblPersonnel.SSN,
tblPrsExpertise.TEXT, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo2])
And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo2])=([Text]),"X","
") AS Skil1, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo3])
And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo3])=([Text]),"X","
") AS Skil2, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo4])
And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo4])=([Text]),"X","
") AS Skil3, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo5])
And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo5])=([Text]),"X","
") AS Skil4, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo6])
And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo6])=([Text]),"X","
") AS Skil5, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo7])
And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo7])=([Text]),"X","
") AS Skil6, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo8])
And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo8])=([Text]),"X","
") AS Skil7, IIf(Not
IsNull([Forms]![frmExperienceFilter]![frmPersExperience]![Combo9])
And
([Forms]![frmExperienceFilter]![frmPersExperience]![Combo9])=([Text]),"X","
") AS Skil8
FROM tblPersonnel RIGHT JOIN tblPrsExpertise ON tblPersonnel.SSN =
tblPrsExpertise.SSN;

Thank You! Duane Hookom

:

You should really explain how the Xs get put into the text boxes
since
they
are unbound.
However, you could create a group header on the name field. Make it
the
same
height as the detail section. Then add code to the On Format event
of
the
detail section:
Me.MoveLayout = False

--
Duane Hookom
MS Access MVP
--

Well I tryed to Concatenate inside of a quiry, but the problem
still
is
there. What am I doing wrong.

I am new so please understand.
I have a report with 8 different textbox's (unbound) inwhich it
checks
for
information and places an X in the textbox(s). I first put all
in
the
name
header, but would only receive one X per name(record from the
parent
table).
So I put all textbox(s) in the detail part and it worked for the
X(s)
exspect
that I am
getting blank lines when there is no X(s)(X(s) are checked from a
Combobox(s) agaisnt the child table). I used the can shrink, in
both
the Detail section and each textbox in that section, but it still
shows
up
with the blank lines and waste to much paper.

Right now the report looks like:

A B C D E F G H
John smith X
X
X
X

X

X

X
Joe Smith





X



I would like it to look like:

A B C D E F G H
John Smith X X X X X X X
Joe Smith X
and so on:

Please can someone help
Thank You!!!!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top