in ms access I found this way:

DateAdd("d",0,DateDiff("d",0,[AdmDt]))+DateAdd("d",0-DateDiff("d",0,[AdmTm]),[AdmTm])

Thx.

Min and max function is working fine. I have problem to write in sql. thx.

I expect out come will be DiagnosisandProc has record come out if the date in the range. If not, I will have error message for the end user as no...

I am in the same mental state, too. Go back to work.Cheer.

I do not think I need to worry about single digit since I convert to int already. Thx.

well , I think if there 100%. then it will different. Thx.

yes.

select convert( int, (replace(score, '%','') )) as TScore from [Quiz log]

right now I need to just extract the TScore >80 . but when I

tried

select...

I posted that question and found the solution myself. I tried to change the field name. it did not work. Thx.

I do not know how many lines I will have .

I googled and found this function. It solve my problem. thx.

Public Function PassbackAnyword(pstrText As String, pintword As Integer,...

I did that vb.net with the split function. It is easy. right now I do not want to install application. Thx.

My database is in MS ACCESS.

There are no such function exist.

ROW_NUMBER() OVER (ORDER BY N) AS ItemNumber,

SUBSTRING(@pString, N, CHARINDEX

thx. I think I need to get the table date as mm/dd/yy first.

I modified the string as

SELECT

*

FROM

...

thx,

data in the table is

AARON ADAN

AARON BRIDGES

A DIX

A GERALD

A HUSSAM

A JAMES, III

HUSSAM Jr

HUSSAM Jr.

A JAMES Sr.

I want to get the data

as

AARON

AARON

DIX

GERALD

HUSSAM

JAMES

HUSSAM

HUSSAM

JAMES

Thx.

the application has been around for long time and it used by the nuns and those are just part of the functionality of the application-enhancement I do not want...