Concatenating in SQL

[JerSand]

This is a novice's question; the only queries I've created have been through QBE.

I have two tables: APPLICAT and FINANCE. Among the fields in APPLICAT is a text field called "Applicat_Grant." Among the fields in FINANCE are text fields called "Grant" and "Grant_Supp," and a currency field called "Amount."

I'm told that in order to correctly extract Amounts, I must concatenate FINANCE's Grant and Grant_Supp fields WITHIN AN SQL STATEMENT and then create a relationship between the concatenated field and the Applicat_Grant field.

I have no idea how to proceed. I've dived into manuals on SQL and ACCESS, but it will take me a long time to figure this out. I'd be grateful for explanations/solution(s) from more skilled ACCESS users.

Thanks.

JerSand

 

[culshaja]

You would use a query to create a column with the convcatednated feilds. You would then use this query in the new query and join the concatednated feild in the first query to the table in the secod query. It is basically using a view in a join/query.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[JerSand]

Thanks for the instruction, James. I'll give it a try.

Jerry