Advertisement

1 - 10 of 25 containing alltags:("count function") (0.001 seconds)
Is their any built in function of ASP to count records and if not what is the best way to accomplish this? I tried using rs.Fields.Count but this gives me the field count going across ...
Zones: ASPDate Answered: 03/03/2005 Grade: A Views: 0
Hello, I have a report with a few different status' for a many deals. There is around 30 or so deals and each has it's own status. I want to count the number of status' for each status and ha...
Zones: MS AccessDate Answered: 12/28/2005 Grade: A Views: 0
Hi, i got 1 row of records which field name called QTY, which content 0,1000.....and so on. I just want to count the QTY which is content "0" How am i going to write at Control Source? =C...
Zones: MS AccessDate Answered: 04/18/2006 Grade: B Views: 0
Hi guys, How do i use the count function here? select COUNT (distinct e.description), e.description AS [Entity],           ap.description AS [Accounting Period],             tc.description AS...
Zones: MS SQL ServerDate Answered: 05/24/2006 Grade: A Views: 0
Hi , why does the below query take nearly 42 seconds with just 100,000 records? The final database will have nearly 700,000 records The client want the count to be in 2-3 seconds? SELECT     CO...
Zones: SQL Server 2005Date Answered: 10/12/2007 Grade: A Views: 0
I have a field thats property is a number that can contain 0, 1, 2, or 3. In the report footer I have a field which is =count(*) that shows how many records I have. I would like to put in the repo...
Zones: MS Access, Access Coding/MacrosDate Answered: 11/05/2007 Grade: A Views: 0
I want to use the count function in a report that will count only if certain critera exist. Excel has the countif function that works great in excel but does not work in Acess. I want to count a fi...
Zones: MS AccessDate Answered: 05/19/1999 Grade: A Views: 0
I have a subform on a form that gives a listing of reasons a person takes of work. I need to be able to count the number of times a person is late. example: Date      Hrs  Reason Code Comment ...
Zones: MS AccessDate Answered: 02/03/2000 Grade: A Views: 0
*** SOLVED!!  SEE BOTTOM FOR SOLUTION *** I have created a report in MS Access and would like to count the number of check boxes (checked or Value = True) in the detail section of the report and...
Zones: DatabasesDate Answered: 01/10/2003 Grade: B Views: 0
Hi... I have 3 JV codes, and want to *merge* them into ONE code so that the code do the THREE jobs: Let me explain: ALL of the codes has something to do with Pop-Up windows... now... ...
Zones: JavaScriptDate Answered: 04/25/2003 Grade: A Views: 0