Concatenate fields

[aaf6701]

Good Morning. I have a table that has bank number in column a and branch number in column b, I need to create a new column c which is the bank number concatenated to the branch number.

Example
Bank Branch BankBranch

10 80 1080

Thanks,
Alan

 

[straybullet]

This sort of thing would normally be done "as needed" and not stored in a table. For instance in the underlying query for a report, adding a field to the design view such as this - txtBankBranch:[txtBank]&[txtBranch]will produce the results you desire while leaving both Bank and Branch available for sorting/grouping (this can also be done by creating a text box on the report with the following control source =[txtBank]&[txtBranch]).

Let them hate - so long as they fear... Lucius Accius

 

[aaf6701]

Straybullet,

Thanks for your reply. Unfortunately, I am not an proficient access user. I prefer excel. But I need your help to walk me through adding this field in the query.
Sorry to sound so pathetic.
Thanks for your help.
Alan

 

[dhookom]

As per straybullet's reply, create a new column in your query with a field expression of:
txtBankBranch:[txtBank]&[txtBranch]
You may need to replace "txtBank" with your actual field name (same for txtBranch). This will create a value that can be displayed in your report or form.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]