yes. thanks.

Thanks. the hire date and term date is for rehired.

I will like to simply the other thing. It is hard to explain the whole intention of my coding. Thx.

That is the reason. ..

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

ALTER PROCEDURE [dbo].[SumCertification]

as

delete from tblNursingCertificationReport

declare @emplid char( 11 )

insert into tblNursingCertificationReport ([Name]

,[EmpID],LName ) SELECT distinct ...

problem solved. Thx.

yesm

yes.

Thanks. you are right. I could not recall + sign any more after no coding for a while.

the only different answer is A, B, C, D, E, F . Question from 1 to 15. Thanks/.

The where condition and group by is not the same. Thanks.

thanks.

Thank you for catching the mistake. But the in the database. The quiz log have field score. The data should be 80% or Waived 10% something like...

In MS Access, do not have the function convert. Thx.

thanks. I found my own solution before any one posting.My application is in MS ACCESS . No ranking in MS ACCESS. So skt5000

will not able to be tested....

I need the [highlight=#ffff11]ECDNo.[/highlight]