Combine 2 field in 1 row (1 Viewer)

[QuChe Yvonne]

I wish combine 2 table field into 1 field in the report

Bank code
ID Bank Currency
1 UOB RM
2 PBB RM
3 UOB USD

Table Product
ID Product Unit Price
1. AAA 6.40
2. BBB 3.00

Report as :
Product Price
AAA RM6.40
BBB USD3.00
Not working with this : =[Bank code][Currency] &""&[Product][Unit Price]

 

[John Big Booty]

Your Report/Form can only have one table as it's Record Source, so what you need to do is create a query to bring together the elements from your various tables. You can then either combine your two field within the query itself our on the Report./Form

Also avoid using spaces and other special characters in object and control names. Limit yourself to alpha and numeric characters and the underscore.

 

[QuChe Yvonne]

I had make a query for this both table.

Just want to combine the currency beside unit price in 1 box in the report

 

[John Big Booty]

You will need to use something like;

[Bank code].[Currency] & [Product].[Unit Price]