Recent content by qlan

Hello, Below is my sql expression. However, it gives me this error message, "Error in compling SQL Expression: Query Engine Error: DAO Error Code: 0xd1a Source: DAO.Database Description: At most one record can be returned by this subquery." SELECT tblEmployees.EmployeeID FROM tblEmployees...

Thanks LB, it works.

Hello, I have 3 field names: tblLostTime.Sick tblLostTime.Lost and tblLostTime.Late 20 10 5 For some reasons, I could not sum all the fields together. What I'm trying to achieve is 35 hrs, which is 20+10+5. Below is the formula I have Sum...

For some reasons, mine did not give me 11-Jan-07. It gives me 11/17/07 using nthsmallest(3,{tblStatus.EnteredDate},{tblStatus.ProjectNum}). Any help is greatly appriciated.

I am sorry. What I need is to select the 3rd records from the earliest date NOT the 3rd Date. For example, based on the below sample data: StatusID ProjectNum EnteredDate 43719 9244KK 11-Jan-07 43729 9244KK 11-Jan-07 43730 9244KK 11-Jan-07 43742 9244KK 12-Jan-07 43806 9244KK 17-Jan-07 43910...

Hello, This is some of the data in my tblStatus: StatusID ProjectNum EnteredDate 43947 9311DL 29-Jan-07 43960 9311DL 29-Jan-07 44175 9311DL 08-Feb-07 43961 9312JR 29-Jan-07 43986 9312JR 30-Jan-07 43968 9312JR 30-Jan-07 44022 9312JR 31-Jan-07 44024 9312JR 31-Jan-07 44109 9312JR 05-Feb-07 44268...

Formula: split({tblLostTime.Late},".")[1] The error I have is "a string is required here". What is it that I am missing? Thanks so much.

The link shows me how to convert hours, minutes, seconds to one common time field. However, the data I have in the database does not separate hours, minutes, or seconds. It is all in one field. For example, there is a 1 hour and 30 minutes of Sick Time, under the Sick Time column in our...

Hi, This is what I have in my database, 03/31/2006 1.00 04/30/2006 5.55 05/31/2006 1.45 09/30/2006 1.15 When I do the sum, what I got is 9.15 Hrs. What can I do to get 9:55 instead? Thanks

Hi, Would someone understands why there is a +6 in this formula and what does it do. Thanks so much in advance for your help. =VLOOKUP(A2,A6:P79,G2+6,TRUE)

I did a test with this simple query in Access: SELECT Max (tblStatus.EnteredDate) FROM tblStatus where tblStatus.Projectnum = '2019VN'; It gives me the last Status EnteredDate of 11/09/2006, which is correct according to our records. However, in VB Codes, If I Do SQLquery = "SELECT Max...

Hi, Below is what I have for my Event Procedure: Private Sub LastUpdate_Click() On Error GoTo LastUpdate_Click_Error Dim MyStr As String DoCmd.Hourglass True If CritStr = "" Then MsgBox "Please SEARCH the projects first before Sorting!" Else MyStr = CritStr & "ORDER BY...

I am sorry! I am very new to these formula. Below is what I came up with. However, after I do Ctrl+Shift+Enter, it did return any record. =IF(Sheet1!C2:C24 = "ED", Sheet1!A2:A24, ""). Basically, what I am trying to do is that if Column Name "Analyst" C2 to C24 = ED then show me all the...

Hello, Below is one of the sheets in my workbook, Date Log # Analyst Product Q1 Q2 Q3 Q4 Comments 8-Sep 12365 ED HP 3 4 5 4 8-Sep 12366 ED DEL 5 4 4 4 11-Sep 12367 ES Printer 4 5 5 4 Very...

Hello, I am using V10. Currently, I grouped the report by Receive Date. If I receive 2 projects in Jan, 4 in Feb, 5 in April, and 6 in July. My report would show Jan-06 2 Feb-06 4 Apr-06 5 Jul-06 6 How I can make it to show: Jan-06 2 Feb-06 4 Mar-06 0 Apr-06 5 May-06 0 Jun-06 0 Jul-06 6...