Search results for query: *

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...

Hi, I am using V10. Under tblProjects, I have CustomerName ProjectNum PrintVolumn ABC 123AC 20,000 This same Project would show multiple times under the tblProjectBusinessType since it has different BusinessTypes (Development, Installtion, and Testing). I...

I tried to register the U2ltech1.dll and I got this message, "U2ltech1.dll was loaded but the DllRegisterServer entry point was not found. This file can not be registered". The UFLTECH1.DLL gave me this, "UFLTECH1.DLL is not an executable file and no registration helper is registered for...

Hi, I am using v.10 and I have downloaded ufltech1.exe and stored it under C:\Crystal\ufltech1. Here I have 4 files: ReadMe.txt, U2ltech1.dll, Uflcode.exe and UFLTECH1.DLL. Based on ReadMe.txt, I have created a new folder C:\WINDOWS\Crystal and copy the U2ltech1.dll and UFLTECH1.DLL to this...

I am using SQL Server 2000.

Hi, I tried with the below sql SELECT First(Name) AS Name, First(Phone#) AS Phone#, ZipCode From tblTest GROUP BY ZipCode and it gives me this error message "FIRST is not a recognized function name". Do you have any idea. Thanks