Search results for query: *

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

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

I did? How ? and can I alter that?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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