Dayo Atewologun's Groups

SQL Tricks and Tips

14 members
Managing Foreign Languag…

5 members

View All

Dayo Atewologun's Page

Gifts Received

Dayo Atewologun has not received any gifts yet

Give Dayo Atewologun a Gift

Latest Activity

Dayo Atewologun left a comment for Barry Williams

August 30, 2009

Barry Williams left a comment for Dayo Atewologun

August 30, 2009

Dayo Atewologun commented on Barry's group 'SQL Tricks and Tips'

Hi, Please can anybody help out with an SQL syntax to use on an ms access table contain data fo all employee in format below Staff No Direction DateClocking 03769 I 09/09/1989 19:15:00 03769 O 10/09/1989 07:02:00 I want an SQL syntax to produce the…

August 30, 2009

Dayo Atewologun joined Barry's group

SQL Tricks and Tips

I have been using SQL for about 10 years, and have acquired a list of useful Tricks, Tips and Work-Arounds.This Group will share Best Practice in SQL.

August 30, 2009

Dayo Atewologun commented on Barry's group 'Managing Foreign Languages in a Database'

Hi, Just going through barry's comment of January 30, 2009 at 10:53pm on foreign language issue, this has been my passion recently and am very much interested in the topic. I have visualised - even attempted - scenerio where all texts such as error…

August 15, 2009

Dayo Atewologun joined Barry's group

Managing Foreign Languages in a Database

We will discuss aspects of managing Foreign Languages in order to achieve consensus on Best Practice

August 15, 2009

Barry Williams left a comment for Dayo Atewologun

August 4, 2009

Dayo Atewologun left a comment for Barry Williams

August 2, 2009

Dayo Atewologun is now a member of The Database Answers Community

Welcome Them!

August 2, 2009

Profile Information

What aspect of Databases is of particular interest to you ?

Ms Access and SQL Server

Please tell me something about your situation

I'm interested in learning about Databases

Where are you living ?

Lagos, Nigeria

Comment Wall (2 comments)

You need to be a member of The Database Answers Community to add comments!

Join this Ning Network

At 9:44am on August 30, 2009, Barry Williams said…: Hi Dayo

I find it's impossible to reply easily to your comment in the Discussion Group so I am sending you my Comment this way.

The solution is to join the table to itself and match on Employee number.
In Access, it would look something like this :-
Create Query I_View
SELECT StaffNo As I_StaffNo, DateClocking As TimeIn
FROM Table
WHERE Direction = 'I'

Create Query O_View
SELECT StaffNo As O_StaffNo, DateClocking As TimeOut
FROM Table
WHERE Direction = 'O'

SELECT I_StaffNo As StaffNo, TimeIN, TimeOut
FROM I_View, O_View
WHERE I_StaffNo = O_StaffNo

HTH

Barry

At 3:56pm on August 4, 2009, Barry Williams said…: Hi
You can download the two Databases you mention at numbers 44 and 62 on this page :-
http://www.databaseanswers.org/database_downloads.htm

I would recommend the Employees Leave Records Database as a nice easy one to get started.
You ask "How can your site be usefull for my type," - it depends what you are looking for.
I have 21 Tutorials on my Web Site but these are about Databases and not about development :-
http://www.databaseanswers.org/tutorials.htm

What specific kind of advice are you looking for ?

For development my starting point is a Microsooft product called Visual Web Developer, which you can download from this page :-
http://www.microsoft.com/express/vwd/

You can also download ten of my Databases from the Microsoft web site :-
http://www.microsoft.com/sqlserver/2005/en/us/express-starter-schemas.aspx

HTH

Barry