Search results for query: *

I need some assistance with this query and I am not sure how to go about it. I need to create a query that will fill the same "Code" where it is Null just like the lower screenshot.

I need some help in figuring this out. is there a way to input a number for example "51424303" and it would return a Job_ID of 1939706. Can this be done with a query and if so how? Job_ID Range1 Range2

Hi, I am receiving the error: "Specify the Table containing the records you want to delete." When i try to run the query below. Any suggestions on what I am missing here? DELETE PT_102_Employee_Attendance_Table.[DateofOccurrence], * FROM PT_102_Employee_Attendance_Table...

Need some help here. Why is this not working? DELETE FROM HR_021_Isolates_Records_For_Anniversary_Reset_Table WHERE HR_021_Isolates_Records_For_Anniversary_Reset_Table.Code="Unpaid" AND HR_021_Isolates_Records_For_Anniversary_Reset_Table.UTimeTaken=Null AND...

I have this query and it worked fine except until I add one more criteria "J.Code1" to the statement below and now I am receiving a syntax error message. I am not sure how to fix this. SELECT R.PID, R.Total AS RTotal, L.Total AS LTotal, F.Total AS FTotal, J.Total AS JTotal FROM...

Hello Everyone! I am not sure if this is possible but I have to two fields which have a datatype of ShortText. The Fields are called StartNumber and EndNumber. The startnumber will always start with the letter "A" as in this example "A1971400" and the end number "A1971500". Is it possible to...

Is there a way to disable the Client Settings "Confirm" for the queries? I have multiple users and I have to do this manually for each time a new user logs into a windows machine. It would be nice I I could do this once per machine and all three check boxes are disabled for all users. Thanks...

I am having some trouble referencing a subform using the string below... If Not IsNull(Me.[txtFilteraccountrep]) Then strWhere = strWhere & "(Forms.F_012_Won_Loss_Form.Form.[AccountRep] Like ""*" & Me.txtFilteraccountrep & "*"") AND " End If lngLen = Len(strWhere) - 5 If...

I need some help with an INNER JOIN error, I am receiving a syntax error message (Missing Operator) and I don't know where I faulted. SELECT A.CountOfJobName, A.Status, A.AccountRep, A.Company, A.JobName, A.DateYear, A.NewDateStamp AS STAGE_01, B.NewDateStamp AS STAGE_02, C.NewDateStamp AS...

Hello, I am looking for a way to add a number to a specified date. When added it will predict a future date that would have excluded weekends. I found this function on the web but I am not sure how to use it or if it will work with what I am working on. I added the below function to...

I am having trouble figuring out on how to accomplish this, I have a table with the below information. Is it possible to pull the HRS and AMT onto the same record for each SubNo? Of course, I would have to rename the fields for LOTCLEAN AS LHRS and LAMT and FINAL GRADE to FHRS and FAMT. SubNo...

Hello All, I am using the function below that was written by Thom Rose to calculate the number of days between two dates. The query results look like this: CTC-RG RG-LC1 LC2-FG 34 23 22 #Error 67 31 21 #Error 2 65 34 4...

I have a report that I would like to group by the week and I am not sure how to go about doing this. The report would use the [StartDate] field for sorting by the week and then subtotaling the [HRS] and providing a count for the amount of records within a weeks period. The out come should...

I have a problem with this query. Whe I added the third IIF statement for SubPreFix "3090" I received the following error "The expression you entered exceeds the 1,024 character for the query design build" I have more IIF statements I need to add. Is there a way to add these additional IIF...

I need some help again once again. I have query which is based of a table called Jobtbl. My Table looks Like this.. JobNumber PhaseNumber CTCDTE FINISHDTE 302334 1 1/25/07 3/2/07 334455 2 3/5/07 3/8/07 312345 3...

Hi everyone, I have query which pulls information from table that contains the following fields jobnumber, phase1, phase2, phase3 and phase4. The query displays the information in the following way. JobNumber Phase1 Phase3 Phase3 Phase4 302012 1 302012 2...

I have main form that used to enter new clients. I would like to be able to enter zip code in the CLZIP textbox and afterupdate, if the CLZIP matches the zip code from the T-103 table it would then populate an unbound textbox "txtemail" on the main form with the assigned email address for that...

I have one option group on my form and I would like to add another. The form is based of a query. I want the user to be able to select either "Open", "Closed" or view "Both" from the first option group. The second option group the user would select either "Warranty", "Billable" or "Both". The...

Hi, Is there a way to have a query count the number of records in a table based on the ID field (auto number) and then display that count as Mycount? ID Mycount 12 1 13 2 14 3 15 4 16 5

Hi, I need some help here. I am trying to insert "NORDNUM" field from table2 into table1 NORDNUM field. I have tried doing this, but it will only insert the matched ORDNUM. Any Ideas? UPDATE Table1 INNER JOIN Table2 ON Table1.ORDNUM = Table2.ORDNUM SET Table1.NORDNUM = Table2.ORDNUM...