Search results

Big oof!!

Yes, this is what I've discovered. I found myself telling my boss "Yeah, I got into excel, but it's ugly, less user-friendly, and now we can’t do x, y and z ."

My company has been trying kill off its use of Access for over 10 years now. Every time a new IT executive comes in, they decree that access will be eliminated. The only thing that has prevented this from happening is the company-wide question “Well, what do you want us to use instead?” Once...

The four dates indicate when four different categories were worked for each record (person.) So a record may indicate John Doe was reviewed for category 1 (Date1) on 1-15-2016 and then reviewed for category 3 (Date 3) 6-12-2016, the expected result would be 1-15-2016.

Good day. I have a table with four date fields, of which at least one field will have a date. I'm trying to write an IF Then statement on a query that will find the earliest date in all four fields. I started off with ... MinDate...

Bumping since I'm still having this issue. Hoping a new set of eyes will help.

Thank you. The actual table and field names have no spaces. I'm going to correct that above.

Hello everyone. I have a list (table) that I've created in sharepoint 2010. I link to the sharepoint table with Access 2010 to update mass amounts of items at once. Some of the queries have no problem updating the sharepoint items, but other queries require me to "Enter Paramater Value." I...

Hi, I've seen a few posts regarding Sharepoint. Any chance of getting a Sharepoint section under "Apps and Windows"?

Bingo, Thank you. I do wonder though, regading "Though it may need to be a more realistic date"... I've worked for the same company for almost 20 years, and it's the only corporation I"ve worked for. They've always defaulted "active" records (term date - "00000000") to 12/31/9999. Is there a...

[Solved] Converting Text Dates using CDate() and Querying on the Converted Date Hello. I receive a text file with [Original Coverage Effective Date] and [Original Coverage Term Date]. The dates are in YYYYMMDD format. I need to run a query that pulls records that are active ([Original Coverage...

Hello. I know how to use the Find Duplicates wizard to find records with duplicate values in a field. But I need to create a query that identifies duplicate values in one field, but differing values in another. Example: RecID Color Shape 1 Black Round 2 Blue...

Bumping, perhaps someone can take another look. Thanks.

Checked out the link provided by spikepl. I see how it could be helpful in other scenarios where all records must be compared against each for "clashes". However, my scenario only requires that records for one person be compared.

Thank you spikepl. I need to determine which records have overlapping date ranges (for each customer only.) Checking out your link now.

Hello. Scenario: Customers have been enrolled with a company for different service packages on and off over a period of years. Problem: The customer table contains bad data in that the service periods are not accurate. No service period should overlap. Goal: I need to identify records with...

Again, thanks for the above. Due to time constraints I ended up cheating. In a query I created a "key" field that was a result of concantotating three fields that made each batch of records unique. Then I filtered the query for line segment 001, and made a table based on those results...

Thanks RG. This is a good start.

Cheers all. I received a table that broke a text field into several columns (text1, text2, etc.) Furthermore, once a certain textfield number (Text14) was reached, the programmer created a new record to continue the text...so text that would have gone into Text 15, went into a new record's...

Thanks vbaInet; that's exactly what I was hoping for.