queries/relationship expression problem

[AccessDevJunior]

hya,

I have a main table and 7 other tables related to to the main table by Reference Number, i have created a query based on each table as i require some of the fields as expressions.
The problem is i am having trouble being able to get the main table query expressions to calculate with the linked query expressions.

If anyone can help me get round this problem it would be a great help

 

[PHV]

If anyone can help me get round this problem
Which problem ? To do what ? With what ?
I'm afraid the crystal balls are in vacation in July.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[BNPMike]

Most likely you are not qualifying the names of the fields with the table names. Post the SQL here.

It's better to use the word 'join' rather than 'link'. In Access linking has a special meaning ie connecting to (usually remote, often heterogeneous) datasources via ODBC.