Hi, All,
I am working with an Access project. I create the form based on the stored procedure, but I couldn't get form, just return the message: "The stored procedure is successfully but not return record" Why? How should I do?
The following are my stored procedures:
declare @nTotalRecs int
select @nTotalRecs = count(mode) from Complaints
select Complaints.mode as Category,
count(Category)*100/@nTotalRecs as Percentage
from Complaints where complaints.mode is not null
group by mode
Any help? Many Thanks.
Jing
I am working with an Access project. I create the form based on the stored procedure, but I couldn't get form, just return the message: "The stored procedure is successfully but not return record" Why? How should I do?
The following are my stored procedures:
declare @nTotalRecs int
select @nTotalRecs = count(mode) from Complaints
select Complaints.mode as Category,
count(Category)*100/@nTotalRecs as Percentage
from Complaints where complaints.mode is not null
group by mode
Any help? Many Thanks.
Jing