Search results for query: *

Skip, Thanks! that worked for me.

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

Thanks you both. I must of copied and pasted the code incorrectly I did have DELETE * in there but fixing the null did the trick.

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

That was it! Thank you so much.

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

Got it! I understand now how it will work. Thank you both so much for the help and happy holidays!

Skip, What is the Andy Table?

Thanks Skip! I going to go at this with a different approach. I have striped of the letter there by just creating a numerical value. If I have table1 that contains "startnumber" and "Endnumber" and lets say the startnumber is 1401 and the endnumber is 1501. How do I create a query that will...

That's an idea! I will try this to see if this will work for what I need. Thank You and Happy Holidays!

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

Wow...I should have proof read my question. I have a command button in my subform which filters the records within. I would like to take that filter out of the subform and place it onto the mainform and still have it work the same way filtering records in the subform. How do I accomplish this...

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

Thank you all so much...It was the braces I was missing.

I am still receiving the error message. See attachment.https://files.engineering.com/getfile.aspx?folder=804ad33c-d500-4432-a94e-48b4df625165&file=Error.png

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

Thank you for your reply. You were correct in I was missing the other function. Once inserted, the query produced the desired results.

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