Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Show records that count 0
None of these worked. Any other ideas?- dafarm
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Show records that count 0
Neither of those worked. Here is the output: DSLAM CountOfDSLAM FORMAT PORTID ALRDDSL 16 REACH BRDGDSL 10 REACH CHIMDSL 5 REACH CHOCDSL 6 REACH CLTNDSL 2 ADSL CLTNDSL 8 REACH CRABDSL 25 REACH CULPDSL 2 REACH...- dafarm
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Show records that count 0
Here is the code: SELECT dbo_ALLDSLAMS2.DSLAM, Count(dbo_ALLDSLAMS2.DSLAM) AS CountOfDSLAM, dbo_ALLDSLAMS2.FORMAT, dbo_ALLDSLAMS2.PORTID FROM dbo_ALLDSLAMS2 GROUP BY dbo_ALLDSLAMS2.DSLAM, dbo_ALLDSLAMS2.FORMAT, dbo_ALLDSLAMS2.PORTID HAVING (((dbo_ALLDSLAMS2.PORTID)<"0" Or...- dafarm
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
