Can't quite get this syntax to bring in the required information.

  • Thread starter Thread starter Sharlene England
  • Start date Start date
S

Sharlene England

I want to have the user type into cell A1 then the query will get the
correct information.

The following works:
"SELECT JOB_NO.CUSTCODE, JOB_NO.JOB_NO" & Chr(13) & "" & Chr(10) & "FROM
`K:\DATA\DBDATA\JOBDATA`\JOB_NO.DBF JOB_NO" & Chr(13) & "" & Chr(10) &
"WHERE (JOB_NO.JOB_NO=50068)")


but now I want to replace the 50068 above with a cell reference to the value
in cell A1.

I've tried and tried and can't get this to work.

Any help would be greatly appreciated.

Thanks.
 
Sharlene said:
The following works:
"SELECT JOB_NO.CUSTCODE, JOB_NO.JOB_NO" & Chr(13) & "" & Chr(10) & "FROM
`K:\DATA\DBDATA\JOBDATA`\JOB_NO.DBF JOB_NO" & Chr(13) & "" & Chr(10) &
"WHERE (JOB_NO.JOB_NO=50068)")

but now I want to replace the 50068 above with a cell reference to the value
in cell A1.
Click to expand...

"SELECT JOB_NO.CUSTCODE, JOB_NO.JOB_NO" & Chr(13) & "" & Chr(10) & _
"FROM `K:\DATA\DBDATA\JOBDATA`\JOB_NO.DBF JOB_NO" & _
Chr(13) & "" & Chr(10) & "WHERE (JOB_NO.JOB_NO=" & Range("A1") & ")"

In more recent versions of Excel you can give your query a "parameter" which
you can specify as coming from a range - and even have the query re-run
automatically when the value in the range changes. Select a cell in your
query results and try Data / Get External Data / Parameters

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup
 
Back
Top