My DCount fuction is not working??

[rbasram]

I have a program that has to keep track of the count of the products meeting a certain criteria

the fuction is something like this.

dim total as integer

total = dcount("[number]" , " mytablename", "[number]=" myformfieldtxt)

txtsequence = taotal

What am I doing wrong...

 

[tempclerk]

You need to put the complete reference to the form's text box within the quotes.

 

[KarMac21]

Rsoor - Try this:

This will work only if your field [number] is defined as a Number field type.

total = dcount("[number]" , " mytablename", "[number]= " & myformfieldtxt)

If its defined as text try this:

total = dcount("[number]" , " mytablename", "[number]= '" & myformfieldtxt & "'&quot

Hope it helps - Shane

 

[rbasram]

Thank you so much My program really worked. Thanx a lot.