Concatenation for JulieD or any other Guru

I found some direction in an older thread from JulieD to Dave about
concatenating. I've tried to apply it to my report but have been unsuccesful.
Here's JulieD's post followed by my challenge:

Hi Dave

you're definitely on the right track ... i find it always easier to base a
report on a query and do the concatenation there .. to concatenate in
a query you go to a blank column, type a name for the new field in, followed
by a colon and a space and then the fields e.g
fullname: FName & " " & SName

in a report, you need to do this in the control source of an unbound text
box
=FName & " " & SName

Hope this helps
Cheers
JulieD

What I'm doing is concatenating txtCodeID and CorrugatedStyles. The query I
made works fine but my unbound text box in my report isn't:
=[txtCodeID] & " " & [CorrugatedStyles]

When I leave design mode the "Enter parameter" dialogue boxes appear for
txtCodeID and CorrugatedStyles.

What am I doing wrong?

As JulieD said, you will find it easier to create the calculated field in
the query.

Type this into a fresh column in the Field row in query design:
CodeCorrStyle: Trim([txtCodeID] & " " & [CorrugatedStyles])
Check that it works correctly in the query.
Then in your report, set these properties for your text box:
Name CodeCorrStyle
Control Source CodeCorrStyle


If you want to do it in the report instead:
1. Make sure that you have text boxes for txtCodeID and for CorrugatedStyles
on the report. (You can set their Visible property to No.

2. Check the Name of the text box that contains the concatenation. It must
not be the same as the name of any field in the report's RecordSource. For
example, it cannot be named txtCodeID.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"JohnLute" wrote in message
...
I found some direction in an older thread from JulieD to Dave about
concatenating. I've tried to apply it to my report but have been
unsuccesful.
Here's JulieD's post followed by my challenge:

Hi Dave

you're definitely on the right track ... i find it always easier to base a
report on a query and do the concatenation there .. to concatenate in
a query you go to a blank column, type a name for the new field in,
followed
by a colon and a space and then the fields e.g
fullname: FName & " " & SName

in a report, you need to do this in the control source of an unbound text
box
=FName & " " & SName

Hope this helps
Cheers
JulieD

What I'm doing is concatenating txtCodeID and CorrugatedStyles. The query
I
made works fine but my unbound text box in my report isn't:
=[txtCodeID] & " " & [CorrugatedStyles]

When I leave design mode the "Enter parameter" dialogue boxes appear for
txtCodeID and CorrugatedStyles.

What am I doing wrong?

Thanks for the fast response, Allen!

I did everything and again, the query works fine. However, I still get the
"Enter parameter" dialogues.

???

"Allen Browne" wrote:

As JulieD said, you will find it easier to create the calculated field in
the query.

Type this into a fresh column in the Field row in query design:
CodeCorrStyle: Trim([txtCodeID] & " " & [CorrugatedStyles])
Check that it works correctly in the query.
Then in your report, set these properties for your text box:
Name CodeCorrStyle
Control Source CodeCorrStyle


If you want to do it in the report instead:
1. Make sure that you have text boxes for txtCodeID and for CorrugatedStyles
on the report. (You can set their Visible property to No.

2. Check the Name of the text box that contains the concatenation. It must
not be the same as the name of any field in the report's RecordSource. For
example, it cannot be named txtCodeID.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"JohnLute" wrote in message
...
I found some direction in an older thread from JulieD to Dave about
concatenating. I've tried to apply it to my report but have been
unsuccesful.
Here's JulieD's post followed by my challenge:

Hi Dave

you're definitely on the right track ... i find it always easier to base a
report on a query and do the concatenation there .. to concatenate in
a query you go to a blank column, type a name for the new field in,
followed
by a colon and a space and then the fields e.g
fullname: FName & " " & SName

in a report, you need to do this in the control source of an unbound text
box
=FName & " " & SName

Hope this helps
Cheers
JulieD

What I'm doing is concatenating txtCodeID and CorrugatedStyles. The query
I
made works fine but my unbound text box in my report isn't:
=[txtCodeID] & " " & [CorrugatedStyles]

When I leave design mode the "Enter parameter" dialogue boxes appear for
txtCodeID and CorrugatedStyles.

What am I doing wrong?

Open the report in design view, and open the Field List (View menu).
Do txtCodeID and CorrugatedStyles appear in the Field List?
Exactly like that? No spaces?
Have you created text boxes for them?
Do the text boxes have the same name, or are they called something like
Text63?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"JohnLute" wrote in message
...
Thanks for the fast response, Allen!

I did everything and again, the query works fine. However, I still get the
"Enter parameter" dialogues.

???

"Allen Browne" wrote:

As JulieD said, you will find it easier to create the calculated field in
the query.

Type this into a fresh column in the Field row in query design:
CodeCorrStyle: Trim([txtCodeID] & " " & [CorrugatedStyles])
Check that it works correctly in the query.
Then in your report, set these properties for your text box:
Name CodeCorrStyle
Control Source CodeCorrStyle


If you want to do it in the report instead:
1. Make sure that you have text boxes for txtCodeID and for
CorrugatedStyles
on the report. (You can set their Visible property to No.

2. Check the Name of the text box that contains the concatenation. It
must
not be the same as the name of any field in the report's RecordSource.
For
example, it cannot be named txtCodeID.


"JohnLute" wrote in message
...
I found some direction in an older thread from JulieD to Dave about
concatenating. I've tried to apply it to my report but have been
unsuccesful.
Here's JulieD's post followed by my challenge:

Hi Dave

you're definitely on the right track ... i find it always easier to
base a
report on a query and do the concatenation there .. to concatenate in
a query you go to a blank column, type a name for the new field in,
followed
by a colon and a space and then the fields e.g
fullname: FName & " " & SName

in a report, you need to do this in the control source of an unbound
text
box
=FName & " " & SName

Hope this helps
Cheers
JulieD

What I'm doing is concatenating txtCodeID and CorrugatedStyles. The
query
I
made works fine but my unbound text box in my report isn't:
=[txtCodeID] & " " & [CorrugatedStyles]

When I leave design mode the "Enter parameter" dialogue boxes appear
for
txtCodeID and CorrugatedStyles.

What am I doing wrong?

Here's what I have (I've changed some of the names):

qryPKCGStyles
Field Name: CodeCGStyle: Trim([txtCodeID] & " " & [CorrugatedStyles])

Works fine.

rptPKCorrugated
Has txtCodeID and CorrugatedStyles exactly in the Field List.
Has unbound text box with Name: CodeCGStyle and Row Source: CodeCGStyle.
Has text boxes for txtCodeID and CorrugatedStyles of the same name.

I hope this helps!

Thanks!


"Allen Browne" wrote:

Open the report in design view, and open the Field List (View menu).
Do txtCodeID and CorrugatedStyles appear in the Field List?
Exactly like that? No spaces?
Have you created text boxes for them?
Do the text boxes have the same name, or are they called something like
Text63?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"JohnLute" wrote in message
...
Thanks for the fast response, Allen!

I did everything and again, the query works fine. However, I still get the
"Enter parameter" dialogues.

???

"Allen Browne" wrote:

As JulieD said, you will find it easier to create the calculated field in
the query.

Type this into a fresh column in the Field row in query design:
CodeCorrStyle: Trim([txtCodeID] & " " & [CorrugatedStyles])
Check that it works correctly in the query.
Then in your report, set these properties for your text box:
Name CodeCorrStyle
Control Source CodeCorrStyle


If you want to do it in the report instead:
1. Make sure that you have text boxes for txtCodeID and for
CorrugatedStyles
on the report. (You can set their Visible property to No.

2. Check the Name of the text box that contains the concatenation. It
must
not be the same as the name of any field in the report's RecordSource.
For
example, it cannot be named txtCodeID.


"JohnLute" wrote in message
...
I found some direction in an older thread from JulieD to Dave about
concatenating. I've tried to apply it to my report but have been
unsuccesful.
Here's JulieD's post followed by my challenge:

Hi Dave

you're definitely on the right track ... i find it always easier to
base a
report on a query and do the concatenation there .. to concatenate in
a query you go to a blank column, type a name for the new field in,
followed
by a colon and a space and then the fields e.g
fullname: FName & " " & SName

in a report, you need to do this in the control source of an unbound
text
box
=FName & " " & SName

Hope this helps
Cheers
JulieD

What I'm doing is concatenating txtCodeID and CorrugatedStyles. The
query
I
made works fine but my unbound text box in my report isn't:
=[txtCodeID] & " " & [CorrugatedStyles]

When I leave design mode the "Enter parameter" dialogue boxes appear
for
txtCodeID and CorrugatedStyles.

What am I doing wrong?

John, I'm not sure what else to suggest. Unless it's a spelling error...

Perhaps you could create another report, with just those 3 field. If that
works, then add the other fields, as well. Once you have it working, delete
the broken one and save this one in its place.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"JohnLute" wrote in message
...
Here's what I have (I've changed some of the names):

qryPKCGStyles
Field Name: CodeCGStyle: Trim([txtCodeID] & " " & [CorrugatedStyles])

Works fine.

rptPKCorrugated
Has txtCodeID and CorrugatedStyles exactly in the Field List.
Has unbound text box with Name: CodeCGStyle and Row Source: CodeCGStyle.
Has text boxes for txtCodeID and CorrugatedStyles of the same name.

I hope this helps!

Thanks!


"Allen Browne" wrote:

Open the report in design view, and open the Field List (View menu).
Do txtCodeID and CorrugatedStyles appear in the Field List?
Exactly like that? No spaces?
Have you created text boxes for them?
Do the text boxes have the same name, or are they called something like
Text63?


"JohnLute" wrote in message
...
Thanks for the fast response, Allen!

I did everything and again, the query works fine. However, I still get
the
"Enter parameter" dialogues.

???

"Allen Browne" wrote:

As JulieD said, you will find it easier to create the calculated field
in
the query.

Type this into a fresh column in the Field row in query design:
CodeCorrStyle: Trim([txtCodeID] & " " & [CorrugatedStyles])
Check that it works correctly in the query.
Then in your report, set these properties for your text box:
Name CodeCorrStyle
Control Source CodeCorrStyle


If you want to do it in the report instead:
1. Make sure that you have text boxes for txtCodeID and for
CorrugatedStyles
on the report. (You can set their Visible property to No.

2. Check the Name of the text box that contains the concatenation. It
must
not be the same as the name of any field in the report's RecordSource.
For
example, it cannot be named txtCodeID.


"JohnLute" wrote in message
...
I found some direction in an older thread from JulieD to Dave about
concatenating. I've tried to apply it to my report but have been
unsuccesful.
Here's JulieD's post followed by my challenge:

Hi Dave

you're definitely on the right track ... i find it always easier to
base a
report on a query and do the concatenation there .. to concatenate
in
a query you go to a blank column, type a name for the new field in,
followed
by a colon and a space and then the fields e.g
fullname: FName & " " & SName

in a report, you need to do this in the control source of an unbound
text
box
=FName & " " & SName

Hope this helps
Cheers
JulieD

What I'm doing is concatenating txtCodeID and CorrugatedStyles. The
query
I
made works fine but my unbound text box in my report isn't:
=[txtCodeID] & " " & [CorrugatedStyles]

When I leave design mode the "Enter parameter" dialogue boxes appear
for
txtCodeID and CorrugatedStyles.

What am I doing wrong?

Thanks, Allen.

Maybe here's the problem: the unbound text box in the report needs to
display a record from tblPKCGPhysicalAttributes.Style.

This field is a combo box and queries
tblPKCGStyles.txtCodeID.CorrugatedStyle. It's Bound Column is 1 and so it
saves the value in txtCodeID. For example, record 205050 has 0201 saved as
it's style.

My report needs to display the 0201 value and it's Corrugated Style. In this
case, it would be 0201 RSC - Regular Slotted Container.

Does this help? Am I way off track?


"Allen Browne" wrote:

John, I'm not sure what else to suggest. Unless it's a spelling error...

Perhaps you could create another report, with just those 3 field. If that
works, then add the other fields, as well. Once you have it working, delete
the broken one and save this one in its place.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"JohnLute" wrote in message
...
Here's what I have (I've changed some of the names):

qryPKCGStyles
Field Name: CodeCGStyle: Trim([txtCodeID] & " " & [CorrugatedStyles])

Works fine.

rptPKCorrugated
Has txtCodeID and CorrugatedStyles exactly in the Field List.
Has unbound text box with Name: CodeCGStyle and Row Source: CodeCGStyle.
Has text boxes for txtCodeID and CorrugatedStyles of the same name.

I hope this helps!

Thanks!


"Allen Browne" wrote:

Open the report in design view, and open the Field List (View menu).
Do txtCodeID and CorrugatedStyles appear in the Field List?
Exactly like that? No spaces?
Have you created text boxes for them?
Do the text boxes have the same name, or are they called something like
Text63?


"JohnLute" wrote in message
...
Thanks for the fast response, Allen!

I did everything and again, the query works fine. However, I still get
the
"Enter parameter" dialogues.

???

"Allen Browne" wrote:

As JulieD said, you will find it easier to create the calculated field
in
the query.

Type this into a fresh column in the Field row in query design:
CodeCorrStyle: Trim([txtCodeID] & " " & [CorrugatedStyles])
Check that it works correctly in the query.
Then in your report, set these properties for your text box:
Name CodeCorrStyle
Control Source CodeCorrStyle


If you want to do it in the report instead:
1. Make sure that you have text boxes for txtCodeID and for
CorrugatedStyles
on the report. (You can set their Visible property to No.

2. Check the Name of the text box that contains the concatenation. It
must
not be the same as the name of any field in the report's RecordSource.
For
example, it cannot be named txtCodeID.


"JohnLute" wrote in message
...
I found some direction in an older thread from JulieD to Dave about
concatenating. I've tried to apply it to my report but have been
unsuccesful.
Here's JulieD's post followed by my challenge:

Hi Dave

you're definitely on the right track ... i find it always easier to
base a
report on a query and do the concatenation there .. to concatenate
in
a query you go to a blank column, type a name for the new field in,
followed
by a colon and a space and then the fields e.g
fullname: FName & " " & SName

in a report, you need to do this in the control source of an unbound
text
box
=FName & " " & SName

Hope this helps
Cheers
JulieD

What I'm doing is concatenating txtCodeID and CorrugatedStyles. The
query
I
made works fine but my unbound text box in my report isn't:
=[txtCodeID] & " " & [CorrugatedStyles]

When I leave design mode the "Enter parameter" dialogue boxes appear
for
txtCodeID and CorrugatedStyles.

What am I doing wrong?

Is tblPKCGPhysicalAttributes in the query for the report?
If not, add it so you can get the Style field into your report.

You don't want a combo on your report. It's not easy to drop them down in a
report, on screen, or on paper. :-)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"JohnLute" wrote in message
news
Thanks, Allen.

Maybe here's the problem: the unbound text box in the report needs to
display a record from tblPKCGPhysicalAttributes.Style.

This field is a combo box and queries
tblPKCGStyles.txtCodeID.CorrugatedStyle. It's Bound Column is 1 and so it
saves the value in txtCodeID. For example, record 205050 has 0201 saved as
it's style.

My report needs to display the 0201 value and it's Corrugated Style. In
this
case, it would be 0201 RSC - Regular Slotted Container.

Does this help? Am I way off track?


"Allen Browne" wrote:

John, I'm not sure what else to suggest. Unless it's a spelling error...

Perhaps you could create another report, with just those 3 field. If that
works, then add the other fields, as well. Once you have it working,
delete
the broken one and save this one in its place.

"JohnLute" wrote in message
...
Here's what I have (I've changed some of the names):

qryPKCGStyles
Field Name: CodeCGStyle: Trim([txtCodeID] & " " & [CorrugatedStyles])

Works fine.

rptPKCorrugated
Has txtCodeID and CorrugatedStyles exactly in the Field List.
Has unbound text box with Name: CodeCGStyle and Row Source:
CodeCGStyle.
Has text boxes for txtCodeID and CorrugatedStyles of the same name.

I hope this helps!

Thanks!


"Allen Browne" wrote:

Open the report in design view, and open the Field List (View menu).
Do txtCodeID and CorrugatedStyles appear in the Field List?
Exactly like that? No spaces?
Have you created text boxes for them?
Do the text boxes have the same name, or are they called something
like
Text63?


"JohnLute" wrote in message
...
Thanks for the fast response, Allen!

I did everything and again, the query works fine. However, I still
get
the
"Enter parameter" dialogues.

???

"Allen Browne" wrote:

As JulieD said, you will find it easier to create the calculated
field
in
the query.

Type this into a fresh column in the Field row in query design:
CodeCorrStyle: Trim([txtCodeID] & " " & [CorrugatedStyles])
Check that it works correctly in the query.
Then in your report, set these properties for your text box:
Name CodeCorrStyle
Control Source CodeCorrStyle


If you want to do it in the report instead:
1. Make sure that you have text boxes for txtCodeID and for
CorrugatedStyles
on the report. (You can set their Visible property to No.

2. Check the Name of the text box that contains the concatenation.
It
must
not be the same as the name of any field in the report's
RecordSource.
For
example, it cannot be named txtCodeID.


"JohnLute" wrote in message
...
I found some direction in an older thread from JulieD to Dave
about
concatenating. I've tried to apply it to my report but have been
unsuccesful.
Here's JulieD's post followed by my challenge:

Hi Dave

you're definitely on the right track ... i find it always easier
to
base a
report on a query and do the concatenation there .. to
concatenate
in
a query you go to a blank column, type a name for the new field
in,
followed
by a colon and a space and then the fields e.g
fullname: FName & " " & SName

in a report, you need to do this in the control source of an
unbound
text
box
=FName & " " & SName

Hope this helps
Cheers
JulieD

What I'm doing is concatenating txtCodeID and CorrugatedStyles.
The
query
I
made works fine but my unbound text box in my report isn't:
=[txtCodeID] & " " & [CorrugatedStyles]

When I leave design mode the "Enter parameter" dialogue boxes
appear
for
txtCodeID and CorrugatedStyles.

What am I doing wrong?

Yes - tblPKCGPhysicalAttributes is in the query. I'm getting the impression
that I can't do what I'd like which is to get the Style field in the report
to concatenate and display both txtCodeID and CorrugatedStyle. In the current
design it only displays txtCodeID.

"Allen Browne" wrote:

Is tblPKCGPhysicalAttributes in the query for the report?
If not, add it so you can get the Style field into your report.

You don't want a combo on your report. It's not easy to drop them down in a
report, on screen, or on paper. :-)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"JohnLute" wrote in message
news
Thanks, Allen.

Maybe here's the problem: the unbound text box in the report needs to
display a record from tblPKCGPhysicalAttributes.Style.

This field is a combo box and queries
tblPKCGStyles.txtCodeID.CorrugatedStyle. It's Bound Column is 1 and so it
saves the value in txtCodeID. For example, record 205050 has 0201 saved as
it's style.

My report needs to display the 0201 value and it's Corrugated Style. In
this
case, it would be 0201 RSC - Regular Slotted Container.

Does this help? Am I way off track?


"Allen Browne" wrote:

John, I'm not sure what else to suggest. Unless it's a spelling error...

Perhaps you could create another report, with just those 3 field. If that
works, then add the other fields, as well. Once you have it working,
delete
the broken one and save this one in its place.

"JohnLute" wrote in message
...
Here's what I have (I've changed some of the names):

qryPKCGStyles
Field Name: CodeCGStyle: Trim([txtCodeID] & " " & [CorrugatedStyles])

Works fine.

rptPKCorrugated
Has txtCodeID and CorrugatedStyles exactly in the Field List.
Has unbound text box with Name: CodeCGStyle and Row Source:
CodeCGStyle.
Has text boxes for txtCodeID and CorrugatedStyles of the same name.

I hope this helps!

Thanks!


"Allen Browne" wrote:

Open the report in design view, and open the Field List (View menu).
Do txtCodeID and CorrugatedStyles appear in the Field List?
Exactly like that? No spaces?
Have you created text boxes for them?
Do the text boxes have the same name, or are they called something
like
Text63?


"JohnLute" wrote in message
...
Thanks for the fast response, Allen!

I did everything and again, the query works fine. However, I still
get
the
"Enter parameter" dialogues.

???

"Allen Browne" wrote:

As JulieD said, you will find it easier to create the calculated
field
in
the query.

Type this into a fresh column in the Field row in query design:
CodeCorrStyle: Trim([txtCodeID] & " " & [CorrugatedStyles])
Check that it works correctly in the query.
Then in your report, set these properties for your text box:
Name CodeCorrStyle
Control Source CodeCorrStyle


If you want to do it in the report instead:
1. Make sure that you have text boxes for txtCodeID and for
CorrugatedStyles
on the report. (You can set their Visible property to No.

2. Check the Name of the text box that contains the concatenation.
It
must
not be the same as the name of any field in the report's
RecordSource.
For
example, it cannot be named txtCodeID.


"JohnLute" wrote in message
...
I found some direction in an older thread from JulieD to Dave
about
concatenating. I've tried to apply it to my report but have been
unsuccesful.
Here's JulieD's post followed by my challenge:

Hi Dave

you're definitely on the right track ... i find it always easier
to
base a
report on a query and do the concatenation there .. to
concatenate
in
a query you go to a blank column, type a name for the new field
in,
followed
by a colon and a space and then the fields e.g
fullname: FName & " " & SName

in a report, you need to do this in the control source of an
unbound
text
box
=FName & " " & SName

Hope this helps
Cheers
JulieD

What I'm doing is concatenating txtCodeID and CorrugatedStyles.
The
query
I
made works fine but my unbound text box in my report isn't:
=[txtCodeID] & " " & [CorrugatedStyles]

When I leave design mode the "Enter parameter" dialogue boxes
appear
for
txtCodeID and CorrugatedStyles.

What am I doing wrong?

John, if the Style field is in the report's query, and it shows in the
FieldList for the report, I don't understand why you cannot drag it from
there onto the report, and concatenate it into another calculated control.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"JohnLute" wrote in message
...
Yes - tblPKCGPhysicalAttributes is in the query. I'm getting the
impression
that I can't do what I'd like which is to get the Style field in the
report
to concatenate and display both txtCodeID and CorrugatedStyle. In the
current
design it only displays txtCodeID.

"Allen Browne" wrote:

Is tblPKCGPhysicalAttributes in the query for the report?
If not, add it so you can get the Style field into your report.

You don't want a combo on your report. It's not easy to drop them down in
a
report, on screen, or on paper. :-)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"JohnLute" wrote in message
news
Thanks, Allen.

Maybe here's the problem: the unbound text box in the report needs to
display a record from tblPKCGPhysicalAttributes.Style.

This field is a combo box and queries
tblPKCGStyles.txtCodeID.CorrugatedStyle. It's Bound Column is 1 and so
it
saves the value in txtCodeID. For example, record 205050 has 0201 saved
as
it's style.

My report needs to display the 0201 value and it's Corrugated Style. In
this
case, it would be 0201 RSC - Regular Slotted Container.

Does this help? Am I way off track?


"Allen Browne" wrote:

John, I'm not sure what else to suggest. Unless it's a spelling
error...

Perhaps you could create another report, with just those 3 field. If
that
works, then add the other fields, as well. Once you have it working,
delete
the broken one and save this one in its place.

"JohnLute" wrote in message
...
Here's what I have (I've changed some of the names):

qryPKCGStyles
Field Name: CodeCGStyle: Trim([txtCodeID] & " " &
[CorrugatedStyles])

Works fine.

rptPKCorrugated
Has txtCodeID and CorrugatedStyles exactly in the Field List.
Has unbound text box with Name: CodeCGStyle and Row Source:
CodeCGStyle.
Has text boxes for txtCodeID and CorrugatedStyles of the same name.

I hope this helps!

Thanks!


"Allen Browne" wrote:

Open the report in design view, and open the Field List (View
menu).
Do txtCodeID and CorrugatedStyles appear in the Field List?
Exactly like that? No spaces?
Have you created text boxes for them?
Do the text boxes have the same name, or are they called something
like
Text63?


"JohnLute" wrote in message
...
Thanks for the fast response, Allen!

I did everything and again, the query works fine. However, I
still
get
the
"Enter parameter" dialogues.

???

"Allen Browne" wrote:

As JulieD said, you will find it easier to create the calculated
field
in
the query.

Type this into a fresh column in the Field row in query design:
CodeCorrStyle: Trim([txtCodeID] & " " & [CorrugatedStyles])
Check that it works correctly in the query.
Then in your report, set these properties for your text box:
Name CodeCorrStyle
Control Source CodeCorrStyle


If you want to do it in the report instead:
1. Make sure that you have text boxes for txtCodeID and for
CorrugatedStyles
on the report. (You can set their Visible property to No.

2. Check the Name of the text box that contains the
concatenation.
It
must
not be the same as the name of any field in the report's
RecordSource.
For
example, it cannot be named txtCodeID.


"JohnLute" wrote in message
...
I found some direction in an older thread from JulieD to Dave
about
concatenating. I've tried to apply it to my report but have
been
unsuccesful.
Here's JulieD's post followed by my challenge:

Hi Dave

you're definitely on the right track ... i find it always
easier
to
base a
report on a query and do the concatenation there .. to
concatenate
in
a query you go to a blank column, type a name for the new
field
in,
followed
by a colon and a space and then the fields e.g
fullname: FName & " " & SName

in a report, you need to do this in the control source of an
unbound
text
box
=FName & " " & SName

Hope this helps
Cheers
JulieD

What I'm doing is concatenating txtCodeID and
CorrugatedStyles.
The
query
I
made works fine but my unbound text box in my report isn't:
=[txtCodeID] & " " & [CorrugatedStyles]

When I leave design mode the "Enter parameter" dialogue boxes
appear
for
txtCodeID and CorrugatedStyles.

What am I doing wrong?