Search results

Hello So currently im working in migrating data from two Regions (East, West) same data fields but the date ranges (Eff, Exp) either could overlap or not. Im trying to build a query to identify overlapping dates and insert them in order (Oldest to Newest date). Any help would be appreciated it...

Hi, I have a question. How can I achieve this on a query, If the "Vendor", "State" and "Contract" are the same between multiple rows, Return the Minimum "Eff" per Contract and give it an expiration date. If there is another "Contract", then the Expiration Date has to be a Date prior (See...

Hello, I have a problem keeping up all night, I have to find the Status of each Producer ID found on the tblStatus per Date Range. So the results I am looking for is I'm able bring over the Status from my TblStatus.Status to tblProducer.Status by Date Range criteria. Can anyone help with this...

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

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

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

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

Hello, I want to create a query with multiple conditions. See attachment..Basically if the person Passes any of this trainings they need to show up in my query..how do you do it? SELECT tblMasterUsers.userid, tblMasterUsers.Licenses, tblMasterUsers.firstname, tblMasterUsers.lastname...

hello, Here is my code, I have a check box "Complete" that when selected i want only those records where the Complete field (check box) is True..if else only those completed field is False..How do I use this in VBA? Also I have several conditions on the tblUsers that I want to show on my check...

Hello, I need help desperately:( I have 2 tables (tblUser) and a Linked Excel spreadsheet (CMPReport) . "I attached a relationships screenshot" TblUser has all users register to our site. CMPReport has all Training (4-5 Certificates) those users need to complete and has to be uploaded...

Hi, so here is my situation. I have 2 tables tbluser and tbltraining, the user table has all people register to our site and training table all training information( they must complete 3 modules at any given date). The tbltraining is a linked excel spreadsheeet because it changes daily and I...

Hello, I have a question, I want my form frmintake to lookup with values from another table and populare county once the zip codes has been entered. I have a table called tblintake and another tblcounty. tblintake has zip codes entered manually tblcounty has zip codes and counties for...

Hello, I have a database designed in 2003 that I want to be able to click on a command button "cmdsentemail" and populate a text in the body of a new Email in Lotus Notes 8.5; Can someone provide the code so I can format it and work around to help me with my problem, I have a table called...

Hi, Im new to Access Security, I created a DB for for about 12 people and I just set up the security using the Wizard. Some could not access and are getting this error message, I use this the following path for admin only, but I want to give view rights to others. Im lost:banghead: "C:\Program...

Hello, I am delighted to find an active access community. My name is Enrique and I work in Sales Support. I live in the Los Angeles Area in Calif. I'm still going through early stages of Computer Science at Pierce College, but I learn a great deal about programming.