Combining fields in report

[BrianM2]

I have been combining a number of query fiields in a report field. In the main it has gone well. I am finding however that in each case (this report has 3 such fields) there is one query field which will not function. If I insert it I get an "Error" output.

I have checked that all fields are text, even though in one case, numerics seem to in without a problem, and can find no obvious entry errors.

This has not stopped me getting a report out because I simply put the field in on its own but it is annoying to say the least!!

Has anyone got any ideas?

BrianM2

 

[andrew93]

Have you considered combing the fields in the query and then referring to the combined field in the report? Is this an option?
Andrew

 

[BrianM2]

Andrew

Thank you for the response.

I had tried using a query to do this but could not get it to work. However in view of your comment had another go and was successful. I just wasn't handling the query correctly.

So everything is working but I would still like to know why it did not work in the report!

Regards


Brian