Compile error.in query expression Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I received the above compile error in the following query:

Expr1: Round([AuxDatosParaRegistrosDeResult]![HandicapExacto],1)

The above field is a numeric double field coming from a linked table, so I
cannot modify this table.
I have checked the references, but it did not work.
This error occurs with other functions like CCur...
Please be aware that my knowledge of Access is really basic!!
Many thanks,
 
If [AuxDatosParaRegistrosDeResult] is a form, then you should probably
have:

Forms![AuxDatosParaRegistrosDeResult]![HandicapExacto]
 
I would try
--Replace the ! with a .

Expr1: Round([AuxDatosParaRegistrosDeResult].[HandicapExacto],1)

If this occurs with other functions then I would double-check the references.
 
[AuxDatosParaRegistrosDeResult] is a table linked from another database.
--
ICruz


[MVP] S.Clark said:
If [AuxDatosParaRegistrosDeResult] is a form, then you should probably
have:

Forms![AuxDatosParaRegistrosDeResult]![HandicapExacto]

--
Steve Clark, Access MVP
http://www.fmsinc.com/consulting
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

ICruz said:
Hi,

I received the above compile error in the following query:

Expr1: Round([AuxDatosParaRegistrosDeResult]![HandicapExacto],1)

The above field is a numeric double field coming from a linked table, so I
cannot modify this table.
I have checked the references, but it did not work.
This error occurs with other functions like CCur...
Please be aware that my knowledge of Access is really basic!!
Many thanks,
Click to expand...
Click to expand...
 
Thanks for the reply, but it did not work.

Regarding the references, I would need some help. I did not find any
'missing' reference. The ones I have are:

VBA
Microsoft Access 9.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.1 Library

I tried to uncheck, save and check them back again but I still receive the
same compile error. And yes, it happens with other functions...


--
ICruz


John Spencer said:
I would try
--Replace the ! with a .

Expr1: Round([AuxDatosParaRegistrosDeResult].[HandicapExacto],1)

If this occurs with other functions then I would double-check the references.
Hi,

I received the above compile error in the following query:

Expr1: Round([AuxDatosParaRegistrosDeResult]![HandicapExacto],1)

The above field is a numeric double field coming from a linked table, so I
cannot modify this table.
I have checked the references, but it did not work.
This error occurs with other functions like CCur...
Please be aware that my knowledge of Access is really basic!!
Many thanks,
Click to expand...
Click to expand...
 
Back
Top