Codings Help?

[sreekandan]

Hi everybody,
Im doing project in VB6 and Ms Access as backend.
In that, While i am running the project, if the person signIn then the System Time store into the database table.Once if the person do not SignIn the date will not be stored into the table.Now i have the doubt is how can I get that particular leave date automatically if the person hasn't been SignIn.

[hariharanmca]

Hi everybody,
Im doing project in VB6 and Ms Access as backend.
In that, While i am running the project, if the person signIn then the System Time store into the database table.Once if the person do not SignIn the date will not be stored into the table.Now i have the doubt is how can I get that particular leave date automatically if the person hasn't been SignIn.

You have to store date instead of Time Because you are looking for '
Now i have the doubt is how can I get that particular leave date automatically ' and use DateDif function