Dcount problems using variables 1

[JimmyFlynn]

Hi!

This works ...

dim myresult as integer
myresult = dcount("[myfield]","mytable","[myfield]=12345&quot

This doesn't!

dim myresult as integer, mysearch as integer
mysearch = 12345
myresult = dcount("[myfield]","mytable","[myfield]=mysearch&quot

I get all sorts of sytax errors or type mismatch errors depending on how I syntax the criteria bit of the code. I've tried every symbol on the keyboard to try and get it right but "Failed" is not in my vocabulary.

Can anybody please guide me as to the correct syntax for using a variable on this occasion ... and before you ask "myfield" is an integer only field.

Jim

 

[Junior1544]

try this...

myresult = dcount("[myfield]","mytable","[myfield]=""mysearch""&quot

just an idea...

--Junior

JHauge@jmjpc.net
Life is change. To deny change is to deny life.

 

[JimmyFlynn]

Hhhmmmm ....

Run-time error '3464':

Data type mismatch in criteria expression

This seems to say that mysearch and myfield are not compatible ... checked the table and the filed property is set to integer???

Any other ideas?

Jim

 

[JimmyFlynn]

Cracked it!!!!!!!!!

myresult = dcount("[myfield]","mytable","[myfield]=" & mysearch)

just a little ampersand makes all the difference B-)

Jim

 

[Junior1544]

there ya go
JHauge@jmjpc.net
Life is change. To deny change is to deny life.