Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: mackymacmac
- Order by date
-
SQL: How can I make two value from two record to appear in one line.
Thanks KenReay for your response. Actually the table i've shown is the real table itself. One field for the [name] and the other one is the [timestamp]. I named the table [Log]. I want a query that would display the 1st [timestamp] occurence as LogIn and the 2nd or the last [timstamp] occurence...- mackymacmac
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
SQL: How can I make two value from two record to appear in one line.
I have a table [LOG] with no pkey on it. Records inside are as follows: [Name] [TimeStamp] Juan 3/29/2008 7:50AM Macky 3/29/2008 8:00AM Juan 3/29/2008 9:00PM Macky 3/29/2008 5:00PM Is there a SQL command that would display the result like this... [Name] [LogIn]...- mackymacmac
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
