Ok I'm stuck. I used a bit of a work around to get the results that I am looking for.
I have individually tested these lines of code below. The first two work interdependently, but my attempt at getting them both continues to fail. I either get a "Missing Operator" error or "Expected List Separator error.
I have been testing them individually by commenting the inoperative one out. For the actual desired DCount result, I must capture both inputs, but I cannot seem to figure out where I have gone wrong. :banghead:
I am certain it has something to do with the way I am attempting to input it, too many or too few characters. Any help here is appreciated.
I have individually tested these lines of code below. The first two work interdependently, but my attempt at getting them both continues to fail. I either get a "Missing Operator" error or "Expected List Separator error.
Code:
cnt = DCount("[Logpg]", "tbl_Log_Pages", "[tail] = '" & t & "'") 'This code works as a stand alone
'cnt = DCount("[Logpg]", "tbl_Log_Pages", "[trick] = '" & param & "'") 'This code works as a stand alone
'cnt = DCount("[Logpg]", "tbl_Log_Pages", "[tail] = '" & t & "'" And "[trick] = '" & param & "'") 'This is not working
I have been testing them individually by commenting the inoperative one out. For the actual desired DCount result, I must capture both inputs, but I cannot seem to figure out where I have gone wrong. :banghead:
I am certain it has something to do with the way I am attempting to input it, too many or too few characters. Any help here is appreciated.