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

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

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

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)

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

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

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

Below is an example of what I have for my Employees Table: Name SSN Phone# ZipCode Smith 123-45-8856 (817) 377-8825 76017 Mary 123-45-8857 (972) 422-1526 76015 Peter 123-45-8858 (972) 422-1528 76018 Paul 123-45-8859 (972) 422-1521...

Hi, Below is what I have for my Employees Table: Name SSN Phone# ZipCode Smith 123-45-8856 (817) 377-8825 76017 Mary 123-45-8857 (972) 422-1526 76015 Peter 123-45-8858 (972) 422-1528 76018 Paul 123-45-8859 (972) 422-1521 76017 Steve 123-45-8855 (972) 422-1522 76015 John...

Hi, I have tblProjects and tblStatus. Under tblStatus, the same project# shows multiple times since there are more than 1 statuses entered. Please see below Proj# StatusDate EmployeeName 8170JC 03-Jan-06 Web 8170JC 04-Jan-06 ABC 8170JC 09-Jan-06 CDE 8176DG 06-Jan-06 Web 8176DG 06-Jan-06...

Hi, I am trying to calculate the NETWORKDAYS and it works fine on my computer, which I have Excel 2000. However, it doesn't work on the other machine that has Excel 2002. What should I do to have this fixed? Thanks so much

Hi, I am using CR10. I have a report that I group by Requester and below is my sample data that appears under my Requester Group: RequesterName TRequest Tcancelled #OfOrders 2005 Robert Mack 10 2 8 2006 Robert Mack 7 2 5 However, on my...

Hi, I have SQLquery = SQLquery &"("Not IsNull (tblProjects.ProjectCompletedDate)" & "Or Not IsNull (tblProjectBusinessTypes.CompletedDate)" )as [CompletedDate], " It give me this error "compile error: expected end of statement". Basically, I want CompletedDate to include if IsNull...

Hi, I have this formula: =LEFT(A1,2) I was able to use on one machine; however, when I tried this same formula on a different machine, instead of returning 2 fields on A1, it returns me =LEFT(A1,2). Do you have any idea why. I think it has to do something with the settings. Thanks so much!

Hi, I have this formulas: IF(NETWORKDAYS(NOW(),Info!D34) < 5,0.2,0) Currently, my Info!D34 is 7/14/2006 10:00:00 AM. I would like to do something like if the time is after 5:00PM and before 11:59PM, then it would be the next day. In this case, my formulas would be something like < 6...

Hi, Below is what I have for my lookup: Column A Column B JobName Two Sides B&W 2HD top Column D Column E One Side B&W Folded 1 One Side B&W Pad in 100s 5 Two Sides B&W 3HD left Two Sides B&W 3 Two Sides B&W 2HD top 500 One Side B&W 3HD...

Hi, Below is the structure of my tblWBS. WBSNum Description COS 101 Training 1 104 Admin 0 502 File Testing 1 On my tblProjectTimes, some of my field names are ProjectTimeID ProjectNum WBSNum Hours Billable. ProjectTimeID is the primary key and it is automatic increment by 1. When...