Error message in query for quotient calculation

  • Thread starter Thread starter chase
  • Start date Start date
C

chase

Have the following query set up to calculate the data in
one field (A) to be divided by data in another field (B)
and the results (C) be displayed in my table.


(column 1) (column 2) (column 3)
field: A B C
table: table name table name table name
Update to: [A]/

When I 'run' the query, I get an error message 'Ambiguous
field reference '[A]'. Tried several different other
expressions including the one suggested by Access Error
3079 but none have worked. Any solution would be
appreciated.
 
It often helps if you paste your exact SQL in the posting. Do you have two
tables in your query that share the same field name [A]?
Is there a reason for storing a value that can be calculated?
 
Duane,
There is only one table. The data is downloaded from the
Internet and is constantly changing. The data does not
have the calculation A/B. So, I have decided to copy the
data to an Access file where I can do the calculation.
Once I get an expression to work, I plan to save the
query so that it can be used for all future data that I
download.
Thanks.
-----Original Message-----
It often helps if you paste your exact SQL in the posting. Do you have two
tables in your query that share the same field name [A]?
Is there a reason for storing a value that can be calculated?

--
Duane Hookom
MS Access MVP


Have the following query set up to calculate the data in
one field (A) to be divided by data in another field (B)
and the results (C) be displayed in my table.


(column 1) (column 2) (column 3)
field: A B C
table: table name table name table name
Update to: [A]/

When I 'run' the query, I get an error message 'Ambiguous
field reference '[A]'. Tried several different other
expressions including the one suggested by Access Error
3079 but none have worked. Any solution would be
appreciated.
Click to expand...



.
Click to expand...
 
Nothing you have stated suggests a reason for your error. I asked for you to
paste your SQL view in a posting. Are both A and B numeric? Does either
field contain Nulls? Is B ever 0?

--
Duane Hookom
MS Access MVP


Chase said:
Duane,
There is only one table. The data is downloaded from the
Internet and is constantly changing. The data does not
have the calculation A/B. So, I have decided to copy the
data to an Access file where I can do the calculation.
Once I get an expression to work, I plan to save the
query so that it can be used for all future data that I
download.
Thanks.
-----Original Message-----
It often helps if you paste your exact SQL in the posting. Do you have two
tables in your query that share the same field name [A]?
Is there a reason for storing a value that can be calculated?

--
Duane Hookom
MS Access MVP


Have the following query set up to calculate the data in
one field (A) to be divided by data in another field (B)
and the results (C) be displayed in my table.


(column 1) (column 2) (column 3)
field: A B C
table: table name table name table name
Update to: [A]/

When I 'run' the query, I get an error message 'Ambiguous
field reference '[A]'. Tried several different other
expressions including the one suggested by Access Error
3079 but none have worked. Any solution would be
appreciated.
Click to expand...



.
Click to expand...
Click to expand...
 
Back
Top