Search results

Thank you! It works like a charm!

Hi, all are Text, Except the Dates fields (DateEff, DateExp) Year = Text ProducerID = Text DateEff = Date DateExp = Date

Hello, Thanks for Module, I'm getting an error "Run-Time error '3464': Data Type mismatch in criteria expression. Module: Public Function fnGap(pID As String, pYear As Long, pDateExp As Date) As Integer Dim rs As Dao.Recordset Set rs = DBEngine(0)(0).OpenRecordset("Select Top 1 DateEff From...

Yeah I tried that, but with 90,000 records with different Producer IDs is difficult to pinpoint which records have gaps. For example , if the Producer ID is not the same, it would calculate a Gap between the new and previous row.

Hello , I have some data that needs has two dates Date Effective and Date Expiration with a Producer ID (PK). I need a query to search the Producer ID and find date gaps between these two Date Fields (date Eff), (Date Exp). Can someone guide me how to do this in a query? I have like 90,000...

Sorry I'm lost, So if I wanted to update my table to show no lapses, how can I achieve this?

I think the issue I'm having is finding lapses. My qryLapse, AA018 has a lapse between 1/1/2014- 8/19/2014, I would need a query to find those and create a new table. Sorry I was not been clear enough. ABSID Year Contract Eff Exp AA018 2008 M06 1/1/2008 1/31/2008 AA018 2009 PRDCR 1/1/2009...

I attached a screenshot of the starting data. The result I would need which I cannot create is something like this: State ABSID Year Contract Eff Exp CA AA007 2007 FB 7/1/2007 11/23/2015 Something like this to modify AA007's...

Here you go, The database has a unique ID, State, Eff, Exp, Contract Type.

tblContract.Eff and tblContract.Exp are the date fields A Contract might Eff: 1/1/2015 and Exp: 12/31/2015 The Next Contract is Eff: 2/1/2016 to Exp: 12/31/2016 For the Same ABSID A001, I would need to pull those with a Lapse between 1/1/2015 and 12/31/2016.

Hello Guys, I have an access database that we use for billing. The issue I am having is finding gaps in dates so we don't bill for that period. So if I had a lapse within the Contract Eff Date 8/1/2007 and the Last End Date 12/31/2016 I would need to pull that data. Can anyone help me...

Hello, I have a form that has two fields that create a condition for another field, It works when I use 1 statement alone, not two . Any ideas why? Thanks Private Sub Jurisdiction_AfterUpdate() If Jurisdiction.Value = "California" AND BusinessUnits.Value = "M" THEN CaseID.Value = " " End If...

Hello, My Text File has header fields like this: "ProducerId"|"BusinessUnits"|"DateEff"|"DateExp"|"Extra"| The data values are separated by | into a web database. For Example: "001"|"Any"|"01012015"|"01312015"|| Question is I need to create several access tables by importing this format...

The reason is the report is pulled manually from a website on a daily basis. If the data changes daily we have to at least create a temporary table and a history table.

Well I was thinking more of Bumping these two reports to find duplicates and then deleting the results. Problem is when I run DELETE QUERY I get this message "Could not delete from specified tables. SELECT CMPreport.*, tblMASTER.SPS FROM CMPreport INNER JOIN tblMASTER ON CMPreport.SPS =...

Hello, The Master table has all those records of daily feed reports we already completed. Once a record from the daily feed table is completed, I delete it from the daily report and append them to the Master Table. So the next time I import new records into the daily feed report I bumped it...

Hello, I have a report with 2 access tables (1 Master table and another a daily feed table) The Master table keeps a log of all incoming records. (once append it to this table, should not show in future reporting) The Daily feed information within the last 48 hours. (uploaded from an excel...

That SQL Statement works like magic!!! I have a question for you, in Queries the more criteria you muster, the less the query works? SELECT CMPreport.SPS, CMPreport.Name, CMPreport.AZ_PT, CMPreport.AZStatus, CMPreport.CA_PT, CMPreport.CAStatus, CMPreport.OR_PT, CMPreport.ORStatus...

Seems that when I have to query "Passed" and "Between Date()-2 And Date()" Plus "False" for all three states, the query does not work.

Hello, I have a report database that provides my company with clients that took our training modules and notify us of which clients completed our trainings. The clients can complete training in 3 States and "Passed" means they are good to go. I download an excel report daily and import it to...