Count Duplication Help

  • Thread starter Thread starter Andy Paris
  • Start date Start date
A

Andy Paris

Hi..

I am newbie to access and i am willing to learn. I have a small database
and i have a field Box Identification Number which can be duplicate
number with another box. I want to count those that have the same Box
Identification Number as 1.

Can some one help me??
Thanks

Any help would be greatly appreciated..
 
Hi,


DCount("*", "TableNameHere", " [Box Identification Number] = 1 " )


should return the numbers of records having the value of 1 in their field
[Box Identification Number].


SELECT [Box Identification Number], COUNT(*)
FROM tableName
GROUP BY [Box Identification Number]


as SQL text in a query (in SQL view) would produce a query giving how many
times each [Box Identification Number] is used (when switched in data
view). Switch in design view to see how you could have built the query,
graphically.


Hoping it may help,
Vanderghast, Access MVP
 
Michel said:
Hi,


DCount("*", "TableNameHere", " [Box Identification Number] = 1 " )


should return the numbers of records having the value of 1 in their field
[Box Identification Number].


SELECT [Box Identification Number], COUNT(*)
FROM tableName
GROUP BY [Box Identification Number]


as SQL text in a query (in SQL view) would produce a query giving how many
times each [Box Identification Number] is used (when switched in data
view). Switch in design view to see how you could have built the query,
graphically.


Hoping it may help,
Vanderghast, Access MVP




Andy Paris said:
Hi..

I am newbie to access and i am willing to learn. I have a small database
and i have a field Box Identification Number which can be duplicate number
with another box. I want to count those that have the same Box
Identification Number as 1.

Can some one help me??
Thanks

Any help would be greatly appreciated..
Click to expand...
Click to expand...
Thanks for your fast reply my friend.
But i think i did not explain it very well.

i am giving you an example what i have.

BOX IDENT Nos are like these:

AA1
AA1
AA2
AA3
AA3 ETC ETC

The thing is those that are duplicate like AA1 and AA3 in the example ,
will count them as 1 box. The AA2 wil count as 1 box also.So in this
example the result will be 3 boxes.

Any help pls
thanks again
Regards
 
In the top pane of the query, right click and choose properties

Set "unique values" to "yes".

let me know

--
"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video


Andy Paris said:
Michel said:
Hi,


DCount("*", "TableNameHere", " [Box Identification Number] = 1 " )


should return the numbers of records having the value of 1 in their field
[Box Identification Number].


SELECT [Box Identification Number], COUNT(*)
FROM tableName
GROUP BY [Box Identification Number]


as SQL text in a query (in SQL view) would produce a query giving how many
times each [Box Identification Number] is used (when switched in data
view). Switch in design view to see how you could have built the query,
graphically.


Hoping it may help,
Vanderghast, Access MVP




Andy Paris said:
Hi..

I am newbie to access and i am willing to learn. I have a small database
and i have a field Box Identification Number which can be duplicate number
with another box. I want to count those that have the same Box
Identification Number as 1.

Can some one help me??
Thanks

Any help would be greatly appreciated..
Click to expand...
Click to expand...
Thanks for your fast reply my friend.
But i think i did not explain it very well.

i am giving you an example what i have.

BOX IDENT Nos are like these:

AA1
AA1
AA2
AA3
AA3 ETC ETC

The thing is those that are duplicate like AA1 and AA3 in the example ,
will count them as 1 box. The AA2 wil count as 1 box also.So in this
example the result will be 3 boxes.

Any help pls
thanks again
Regards
Click to expand...
 
scubadiver said:
In the top pane of the query, right click and choose properties

Set "unique values" to "yes".

let me know
Click to expand...
Thanks I will let you know for sure.
 
Back
Top