Prev: envahissement
Next: Wrap Text in Access Form Pivot table
From: Nancy Tang on 7 May 2010 05:06
I would like to generate report for those who late to work. But the database
time is in text format, so i change it to short time using code as below. Is
it correct ? & how do i set a calculation for total time late in HH:MM:SS
as my working time is 09:00

Format(IIf(IsNull([dbo_Punctual.TrTime]),#12/30/2010#,[dbo_Punctual.TrTime]),'Short Time') AS [TRANSACTION TIME]
From: maheshkumargupta on 7 May 2010 05:13

"Nancy Tang" <NancyTang(a)discussions.microsoft.com> wrote in message
news:F1A7B165-2340-4BF7-8447-5C38B1D63EAA(a)microsoft.com...
>I would like to generate report for those who late to work. But the
>database
> time is in text format, so i change it to short time using code as below.
> Is
> it correct ? & how do i set a calculation for total time late in
> HH:MM:SS
> as my working time is 09:00
>
> Format(IIf(IsNull([dbo_Punctual.TrTime]),#12/30/2010#,[dbo_Punctual.TrTime]),'Short
> Time') AS [TRANSACTION TIME]

From: Douglas J. Steele on 7 May 2010 06:27
Try

Format(IIf(IsNull([dbo_Punctual.TrTime]),#12/30/2010#,CDate([dbo_Punctual.TrTime])),'Short
Time') AS [TRANSACTION TIME]

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Nancy Tang" <NancyTang(a)discussions.microsoft.com> wrote in message
news:F1A7B165-2340-4BF7-8447-5C38B1D63EAA(a)microsoft.com...
>I would like to generate report for those who late to work. But the
>database
> time is in text format, so i change it to short time using code as below.
> Is
> it correct ? & how do i set a calculation for total time late in
> HH:MM:SS
> as my working time is 09:00
>
> Format(IIf(IsNull([dbo_Punctual.TrTime]),#12/30/2010#,[dbo_Punctual.TrTime]),'Short
> Time') AS [TRANSACTION TIME]


 | 
Pages: 1
Prev: envahissement
Next: Wrap Text in Access Form Pivot table