about
:
"How many complaint he is complaited in this monh. disply complaint_no, Date, Client_nm, Problem,Remark, Complate_dt in Report"
Would require a report with the fields from the table like:
complaint_no, Date, Client_nm, Problem,Remark, Complate_dt
When placing a button on a form you can add the specific Client_nm to filter the report with.
To count per Client use a groupby query like:
-
select Client_nm Count(*) As CountOfComplaints from tblYours Group by Client_nm;
-
And define the report based on this query.
Nic;o)
