Count certain record in a table and show it in a form

Applications Grid / Reports
#1

Dear all ,

Please help :
I have one simple table with fields ID, Name and Date,
I want to count the record which Date <> null
How to do it ?
How to show it in a form?
Is it possible to show it in the same page with a grid ?

Thank you,
Best Regards
wayans

#2

Re: Count certain record in a table and show it in a form

Hi wayans,

Try this SQL, for example, I am using MySQL:

SELECT COUNT(*) FROM YourTableName WHERE `Date` IS NOT NULL;

Sincerely,
Masino Sinaga

#3

Re: Count certain record in a table and show it in a form

But I do not now how to put the SQL code in a form , I am really new with SC,
Where to start the implementation of the code ?
How to display it in a form ?

Thank you,
wayans

#4

Re: Count certain record in a table and show it in a form

Sorry,

but you should go through the basics !

In form under SQL you could insert the WHERE value !