Combine 2 field in 1 row

QuChe Yvonne

Registered User.
Local time
Yesterday, 16:38
Joined
Oct 17, 2012
Messages
11
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]
 
Your Report/Form :confused: 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.
 
I had make a query for this both table.

Just want to combine the currency beside unit price in 1 box in the report
 
You will need to use something like;
Code:
[Bank code].[Currency] & [Product].[Unit Price]
 

Users who are viewing this thread

Back
Top Bottom