Tip Bank

‘ convert a date value into a string in the format’ YY years, MM months, DD days, HH hours, MM minutes, SS.HH seconds)’ you can also opt for time short

Private Declare Function GetLongPathName Lib “kernel32” Alias _ “GetLongPathNameA” (ByVal lpszShortPath As String, _ ByVal lpszLongPath As String, ByVal cchBuffer As Long) As LongConst MAX_PATH = 260′ Convert a short

Private Declare Function GetShortPathName Lib “kernel32” Alias _ “GetShortPathNameA” (ByVal lpszLongPath As String, _ ByVal lpszShortPath As String, ByVal cchBuffer As Long) As LongConst MAX_PATH = 260′ Convert a long

Question: I have upgraded from Outlook Express to Outlook 98. Previously I was able to leave messages to a particular e-mail recipient on the server. With Outlook 98 I no

Question: I am having trouble getting the following type of join to work. I have three tables: Application, College_hist, and School_Info. Application has student ID numbers that identify the person

Question: I need to know how to write SQL to ask for a date range and run the query on that range. Can you help me? Answer: I think it

Question: I have two columns in a table called “bak”: distance, and trig. The distance value is equal to 1/trig. When I perform the following query: update bakset distance =

Question: How do I do a “group by” SQL statement? I want to return all rows and columns with ** records. Here is the data sample: columnA columnB columnCAAA 2334

Question: How do I merge two values from separate fields using SQL? An example would be taking the LastName field and placing it before the FirstName field like this: “LastName,