Combine field

[shijuantony2002]

I have two fields in a query, say one field name is "A" which is an output of another query linked to it and other field name is also "A" which is also an output of another query (other than above) linked to it.

Now since both the field name are same "A" am not able to combine these two fields with this expression ,

NameToDisplay:[A]+[A]

Any suggestion as i dont want to change the field name.

 

[Mike375]

Try

Queryabc.A and Queryxyz.A in your expression

 

[MSAccessRookie]

I have two fields in a query, say one field name is "A" which is an output of another query linked to it and other field name is also "A" which is also an output of another query (other than above) linked to it.

Now since both the field name are same "A" am not able to combine these two fields with this expression ,

NameToDisplay:[A]+[A]

Any suggestion as i dont want to change the field name.

Since MS Access sees no difference between a Table and a Query, you can treat the two Queries as if they were two Tables, and include the Query name as part of the Column specification.

NameToDisplay:[Query1].[A]+[Query2].[A]

 

[shijuantony2002]

Thanks both, it didnt showed up with syntax error, but when i run the query it shows blank. Individually it shows up with the required output.

Pls help!! I feel its very close to what i require.

Had attached the db. You can refer the query named "Master Summary...."

 

[khawar]

Use & instead of +

for example

[table1].[A] & [table2].[A]

 

[shijuantony2002]

Excellent!!! this worked.... thankss..