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: *

  1. MrHeynow

    How create ranges for multiple dates associated with single record or AccountID in a table or query

    Majp Thank so very much for your help! Testing for a bit but looking good...
  2. MrHeynow

    How create ranges for multiple dates associated with single record or AccountID in a table or query

    I see, ok I remedied the primary key issue thanks now I get an error Run-Time error'94': Invalid use of Null Which happens at "AssignedTo = RS_Source!AssignedT" of this snippet of code Do While Not RS_Source.EOF CurrentAcct = RS_Source!AccountID StartRange = RS_Source!AssgDate...
  3. MrHeynow

    How create ranges for multiple dates associated with single record or AccountID in a table or query

    I did? How ? and can I alter that?
  4. MrHeynow

    How create ranges for multiple dates associated with single record or AccountID in a table or query

    Thanks so much MajP Okay so I did create the suggested query and limited it to 100 records and with the code pasted at the end of this post, it returns 16 records but the first time it was and the last time assigned not each time it was assigned ...Rob For example for these AccountId's...
  5. MrHeynow

    How create ranges for multiple dates associated with single record or AccountID in a table or query

    Stops at "Set RS_Source = CurrentDb.OpenRecordset(StrSql, dbOpenForwardOnly)" missing a table? Public Sub FillRanges() Dim RS_Source As DAO.Recordset Dim StrSql As String Dim NextAcct As String 'modify if this is a number Dim CurrentAcct As String Dim StartRange As Date Dim...
  6. MrHeynow

    How create ranges for multiple dates associated with single record or AccountID in a table or query

    MaJP Darn, I cannot get this code to complete, its shows the first 30 rows but if I try to goto last record or try to make a table, it hangs SELECT A.AcctID, A.AssignedTo, A.AssgnDate AS StartRange, (Select min (b.AssgnDate) as EndRange from Acctinfo as B where A.acctID = b.acctID...
  7. MrHeynow

    How create ranges for multiple dates associated with single record or AccountID in a table or query

    MaJP At the end of the range it should be treated as through today or now. I think you got something here I will work with this over the next couple days. I truly appreciate your and Skip's efforts and this site. Rob
  8. MrHeynow

    How create ranges for multiple dates associated with single record or AccountID in a table or query

    MajP Yes exactly, 3632, since the next record is not assigned until 10:13 to 95590. Rob
  9. MrHeynow

    How create ranges for multiple dates associated with single record or AccountID in a table or query

    Yes and likely to grow, both are. One table/query that has the accounts assigned to various AssignedTO's at various dates and times in one table/query (150K) Lets call it "All_Assgnd_1" In another table/query that have AccountID's with an event with various Dates and times (25) lets call it...
  10. MrHeynow

    How create ranges for multiple dates associated with single record or AccountID in a table or query

    i'm needing to query about 25K AccountID's with various dates and times against these 150k Assigned dates and times. And wanting to know to whom it was assigned to for each date and time. Rob
  11. MrHeynow

    How create ranges for multiple dates associated with single record or AccountID in a table or query

    Thanks for your comments Skip and Andy Any AccountID can be assigned any number of times and there about 150k lines currently.I think I need to create ranges between the the each date and time and AccountID to help me to query whom an account was assigned at any given time. I have two examples...
  12. MrHeynow

    How create ranges for multiple dates associated with single record or AccountID in a table or query

    Is there a way to create ranges for multiple dates associated with single record or AccountID from a query/table so that one could later evaluate a date of another table or query to to say that AccountID 100000001004 at 7/18/2017 10:11:00 AM was AssignedTo 3632. Three columns in the current...
  13. MrHeynow

    Create a new field based on values above select rows

    I see what I did and this does precisely what I needed Thanks so Much! [thumbsup2]
  14. MrHeynow

    Create a new field based on values above select rows

    I gathered t. = table but is there a query needed ? I dont think I'm understanding.... (SELECT TOP 1 Field2 FROM Imp q WHERE Field1="Record" AND q.ID>t.ID) AS Expr1 FROM Imp AS t
  15. MrHeynow

    Create a new field based on values above select rows

    Yes, however it would suplly an Auto Numbered field where as the initial table would now appear like. ID Field1 Field2 1 A03 Sugar 2 N03 12.3 3 B03 Jack 4 B04 Armstrong 5 Record 12333 6 A03 Butter 7 N03 1.75 8 B03 Sally 9 B04 Jones 10 C06 Akron 11 Record 12356 12 A03 Green 13 N03 15 14 B03...
  16. MrHeynow

    Create a new field based on values above select rows

    No, it's an imported two field comma delimited text file.
  17. MrHeynow

    Create a new field based on values above select rows

    Is this even possible? I want to make a new table with three columns from the data sampled in Field1 and Field2. Two columns are to be the same, the third column is to be the record number found below the data and to the right each appearance of the word “Record” in Field1 in found in Field2...
  18. MrHeynow

    VBA, Make table query

    So I thought… I would change .. strSQL = "SELECT Arrier_Open1.* INTO [tbl" & !Arrier_Name & "] FROM Arrier_Open1 WHERE (((Ar_Code)=" & """" & !Arrier_Nbr & """" & "));" Which immdediate’s to SELECT Arrier_Open1.* INTO [tblAm Buckets] FROM Arrier_Open1 WHERE (((Ar_Code)="1")); To...
  19. MrHeynow

    VBA Make table query

    So I thought… I would change .. strSQL = "SELECT Arrier_Open1.* INTO [tbl" & !Arrier_Name & "] FROM Arrier_Open1 WHERE (((Ar_Code)=" & """" & !Arrier_Nbr & """" & "));" Which immdediate’s to SELECT Arrier_Open1.* INTO [tblAm Buckets] FROM Arrier_Open1 WHERE (((Ar_Code)="1")); To...
  20. MrHeynow

    VBA Make table query

    Golom, you are patient, thank you. SELECT Arrier_Open1.* is an instruction to select all fields from the table Arrier_Open1. Correct, selecting the table Arrier_open1, as the table housing the fields I want used in making the new table. Which is to be limited by the Arrier_Nbr and produce the...

Part and Inventory Search

Back
Top