Z
zSplash
I want to get input for query criteria. Here's the code I'll use to get the
input:
Dim BegD As Date, EndD As Date, Inv As String
BegD = InputBox("Enter beginning date", , "010105") 'Date)
EndD = InputBox("Enter ending date", , "123105") 'Date)
Inv = Left(LCase(InputBox("Enter investigator's first name", ,
"Peter")), 1)
...
Now, how do I insert the variables' values into the criteria of the query?
TIA
input:
Dim BegD As Date, EndD As Date, Inv As String
BegD = InputBox("Enter beginning date", , "010105") 'Date)
EndD = InputBox("Enter ending date", , "123105") 'Date)
Inv = Left(LCase(InputBox("Enter investigator's first name", ,
"Peter")), 1)
...
Now, how do I insert the variables' values into the criteria of the query?
TIA