combining fields in a report

  • Thread starter Thread starter Max
  • Start date Start date
M

Max

This is likely very simple but I am having trouble
combining two fields in a report. I have two text fields:
[RFI No] and [Additional Response]. [Additional
Response] is sometimes null. In the report I would like
to show the [RFI No] and insert the [Additional Response]
after. [Additional Response] is a two character code. Any
ideas...

Thanks.
 
This is likely very simple but I am having trouble
combining two fields in a report. I have two text fields:
[RFI No] and [Additional Response]. [Additional
Response] is sometimes null. In the report I would like
to show the [RFI No] and insert the [Additional Response]
after. [Additional Response] is a two character code. Any
ideas...

Thanks.
Click to expand...

Do you wish a space between the 2 fields?
In an unbound control:
=[RFI No] & " " & [Additional Response]

No Space between them?
=[RFI No] & [Additional Response]

Make sure the name of the control is neither "RFI No" nor "Additional
Response"
 
a "#Error returns with the recommended code (=[RFI No]
& " " & [Additional Response])....?

-----Original Message-----
This is likely very simple but I am having trouble
combining two fields in a report. I have two text fields:
[RFI No] and [Additional Response]. [Additional
Response] is sometimes null. In the report I would like
to show the [RFI No] and insert the [Additional Response]
after. [Additional Response] is a two character code. Any
ideas...

Thanks.
Click to expand...

Do you wish a space between the 2 fields?
In an unbound control:
=[RFI No] & " " & [Additional Response]

No Space between them?
=[RFI No] & [Additional Response]

Make sure the name of the control is neither "RFI No" nor "Additional
Response"
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
a "#Error returns with the recommended code (=[RFI No]
& " " & [Additional Response])....?
-----Original Message-----
This is likely very simple but I am having trouble
combining two fields in a report. I have two text fields:
[RFI No] and [Additional Response]. [Additional
Response] is sometimes null. In the report I would like
to show the [RFI No] and insert the [Additional Response]
after. [Additional Response] is a two character code. Any
ideas...

Thanks.
Click to expand...

Do you wish a space between the 2 fields?
In an unbound control:
=[RFI No] & " " & [Additional Response]

No Space between them?
=[RFI No] & [Additional Response]

Make sure the name of the control is neither "RFI No" nor "Additional
Response"
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
Click to expand...

Did you start with an unbound control?
If not, did you make sure the name of the control is not the same as
the name of a field in the expression?
 
Back
Top