Sherri
|
| Posted: 10/06/2004, 8:36 AM |
|
I currently pull a record count, using this code, and display it in a label:
Q_PostMigrationCompleted.DBTotal.Value = Q_PostMigrationCompleted.DataSource.Recordset.RecordCount
Here's what I need to do - pull a count of records that have "Windows 95" in the Pre_OS Field.
How can I do this?
Thanks!
|
|
|
 |
Joe
|
| Posted: 10/08/2004, 7:59 AM |
|
GRID.LABEL.Value = CCdlookUp("COUNT(FIELDNAME)", "GRID", GRID.DataSource.Where & " AND FIELD=Windows 95" , DBConnection1)
Hope this helps, This is done is ASP
|
|
|
|
Joe
|
| Posted: 10/08/2004, 8:01 AM |
|
Sorry i forgot an " before Windows 95
FIELD = "Windows 95"
|
|
|
|
Leo
|
| Posted: 10/08/2004, 8:03 AM |
|
You only need to use 'Windows 95 ' not "Windows 95"
|
|
|
|
|
