Running SQL querries

  • Thread starter Thread starter viper32_mvp
  • Start date Start date
V

viper32_mvp

I am trying to run a simple SQL query however i am getting an error
Data conversion error.

All i want is to run the query and show me the result
Please help


Set dbs = CurrentDb
Cell = Me![TxtCellID]


SQLStr = "SELECT URRC1_DY.CELL_ID, URRC1_DY.NODE, URRC1_DY.DAY,
URRC1_DY.TOT_RCXFHC, URRC1_DY.TOT_RCXFAC, URRC1_DY.TOT_RCXFBTS,
URRC1_DY.TOT_RCXFTRAN, URRC1_DY.TOT_RCXFRNCI, URRC1_DY.TOT_RCXFFBT,
URRC1_DY.TOT_RCXFAAL2, URRC1_DY.TOT_RCXFRNTI FROM URRC1_DY WHERE
(((URRC1_DY.Cell_ID) = '" & Cell & "'))ORDER BY URRC1_DY.DAY DESC"
Set qdf = CurrentDb.OpenRecordset("", SQLStr)
qdf.Execute
 
Is your Cell value numeric?

If so, modify your query by dropping the apostrophes in the where clause.

"WHERE URRC1_DY.Cell_ID = " & Cell & " ORDER BY URRC1_DY.DAY DESC"

HTH
Dale
 
Back
Top