Counting Records in SQL (1 Viewer)

[exaccess]

What is the best way to attack the problem. Here is sample code, which was working yesterday and after the addition of a column to the underlying table to day does not work.

I = DCount("Language", "[" & Orig & "]", "[Language] <> 'X'")

Here I is integer counter, Language is the name of field . Orig is the underlying table name. Help please

 

[Minty]

You are making that more complicated than it needs to be. Try

I = DCount("Language", "Orig", "[Language] <> 'X'")

 

[exaccess]

You are making that more complicated than it needs to be. Try

I = DCount("Language", "Orig", "[Language] <> 'X'")

Sorry for coming back after days but I had to rush to another project. May be I mislead you Orig is a variable which can take the name of a table. This construction does not work.

 

[Minty]

Okay Try this

Dim sTableName as String
sTableName = Orig

i = Dcount("language",sTableName,"[Language] <> 'X'")

 

[Gasman]

Minty,

Wouldn't

i = Dcount("language",Orig,"[Language] <> 'X'")

work just as well?

 

[Minty]

It might but I wanted to ensure it was a string value, I should have added a debug in there to make the point I guess...

 

[exaccess]

Thanks Gasman and Minty. I will try the second version soon and come back .

 

[Gasman]

It might but I wanted to ensure it was a string value, I should have added a debug in there to make the point I guess...

Ah, I see.
Thanks for explaining. I would never have thought of that.

 

[exaccess]

Ah, I see.
Thanks for explaining. I would never have thought of that.

Minty and Gasman many thanks. Both versions work like charm.
Thanks

 

[Pat Hartman]

Best practice is to use only the letters a-z and A-Z and numbers 0-9 and the underscore "_" in your table and column names. Then you don't need to ever worry about when you might need those pesky square brackets.