DCount in text box with SQL backend

[sqlJunior]

I used the following DCount function in an Access text box:

=DCount("[TagNo]","[Product]","[TagNo] &quot

What syntax do I use to make this work now I have upsized to SQL backend?

 

[BruceBell]

Well, I know more knowlegeable people than I will respond, but don't you need some kind of criterion in the last spot of that expression? I usually write these expressions like this
=DCount("[TagNo]","[Product]","[TagNo]=forms!frminputbox![TagNoinTextbox]&quot

where the "forms!frm...." is a reference to text box on a form where the user has entered a value that you want to count. You could put any kind of criterion there.

 

[sqlJunior]

Thanks BruceBell but there is no input required from the user as the textbox is to display a total of the TagNo's in the Product table.

 

[DseeDm]

Hi,

I'd try:

=DCount("[TagNo]","Product&quot



- DCD

 

[sqlJunior]

Hi DseeDm

Thanks for your input but I tried and it doesn't work.

Is it possible that SQL Server doesn't support the DCount function?