"Enter parameter value" issue

[Grumbler]

Dear Experts,

I haven't use MS Access for long time, so I guess my question is simple, but I can't find solution.

I have 2 simple tables and I'm trying to create a query which would contain a common column for both tables and a formula. The formula text is = [Table1_Field2] / [Table2_Field2]. But when I try to execute the query, Access demands to enter parameter value. Could you tell me what I do wrong.
Thanks in advance.

 

[statsman]

First make sure you have created a relationship between the two fiields in your query.
Second your coding in the query should read:
Variablename: ([Table1_Field2] / [Table2_Field2])

When you do arithmatic functions in a query, you need to create a variable with a unique name which contains the results of the arithmatic function (addition, division, multiplication or subraction). You can subsequently use the variable in reports ect.

 

[Grumbler]

I've made relation between the tables before. I have connected them by Key field.
I put coding as you have advised - Variablename: ([Table1_Field2] / [Table2_Field2])
But I've got the following error: The expression you entered has an invalid .dot or ! operatoror invalid parentheses
Did I take your advise yoo literally and made some mistake?

 

[mresann]

Perhaps:

VariableName: ([Table1].[Field2]/[Table2].[Field2])