Duplicate field query 1

[Xzibit7]

I have a table "tblDevice" which has a field "CBID#" which has duplicate entries. I am trying to count the number of duplicates for each CBID# and then just make a table that just shows the individual CBID#'s and each ones number of duplicates.

I have used the SQL statement

Select CBID#, count(*) From tblDevice group by CBID#


This however does not work as I always get "a syntax error in date in query expression CBID#" message. Any help would be appreciated. Thanks

 

[HarleyQuinn]

Try wrapping CBID# in brackets as it's a field with a special character in the name, e.g.

[CBID#]

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[Xzibit7]

Thanks I ended up justing taking out the # sign and it worked perfectly.