Kumba1
Technical User
- Aug 29, 2002
- 94
I want to be able to use an SQL String in a dlookup function, but how would I do this? Dlookup("[outputfield]","sqlstring","criteria"
?
?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Use an SQL String inside dlookup function?
- Thread starter Kumba1
- Start date
- Status
i dont you can use a sql string but you can create a query and use the query name
if you want your query to be dynamic do this
dim mydb as databsae
set mydb=currentdb
mydb..querydefs("queryname".sql="select........from table where.....;"
Dlookup("[outputfield]","queryname","criteria"?
if you want your query to be dynamic do this
dim mydb as databsae
set mydb=currentdb
mydb..querydefs("queryname"
.sql="select........from table where.....;"Dlookup("[outputfield]","queryname","criteria"
?- Status
Similar threads
- Locked
- Question
- Locked
- Question