Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: serino
  • Content: Threads
  • Order by date
  1. serino

    Help with a 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.
  2. serino

    Find a number between two sets of numbers.

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

    Delete From Table

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

    Delete with WHERE Clause.

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

    Help with SQL inner join statement

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

    Adding Records between two ranges

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

    Client Settings.

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

    Referencing a subform

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

    Help with INNER JOIN error

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

    Add a number to a specified date to predict a future date

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

    Help with Query.

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

    Microsoft cant append all records due to a type conversion failure.

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

    Grouping Records in a report from Monday through Saturday.

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

    IIF statement producing error message.

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

    Calculating Workdays

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

    Query Question

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

    Need some help with populating a textbox

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

    Select Case Statement Help!

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

    A field to display mycount

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

    Insert data from Table1 one field into Table2

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

Part and Inventory Search

Back
Top