Recent content by serino

It worked! Thank you for you help on this. Have a great weekend.:)

Thank you for patience and your help! Now i am receiving the following error.

I placed the code on the event procedure for a command button and I received an error "Object Required" for "MyDB". If I create a lookup table as you suggested how do incorporate that lookup table i.e table2 into this code?

1. Imported data from excel into a table. 2. Yes on Primary key. 3. I did not use an orderby. This is the query: SELECT Import_PT1_Table.PID, Import_PT1_Table.Code, Import_PT1_Table.Serial FROM Import_PT1_Table;

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.

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