Recent content by derekstewart

Hi all. I have a document library that houses contracts. The library contains a column for contract #. I link them to a LIST of related contract information using a hyperlink column in the LIST. Each time a contract is added to the library, we filter on contract #, copy the URL, go to the...

Thanks Skip. Worked like a charm. Really appreciate it. Derek

Hi all. I have information about 2000+ vendors in the following format Vendor Name Address Type Vendor ABC 123 Washington Pl X, Y, Z, The Type can contain up to 25 total values. We recieved this from a dept that has keyed all the types into a singe cell...

Thanks. I appreciate the help. D

I have several switchboards tied together and each has multiple buttons that trigger queries. Each of these queries requires user input in the facility column [Enter Facility Name]. I would like to create a combo box on the main switchboard that allows the user to select the facility. Then I...

I actually started working on that when a search on datediff turned up nothing. Got it working perfectly now. Thanks for your help. D

It does not matter that they fall on non working days. Good point though. This solution worked great. My only question CautionMP is what do I use for the term for 180 days? I use q for 90 and yyyy for annual but what about biannual? Thanks for the help. D

I would just like a working query at this point. I can get it into a report after if need be. Thanks. D

I have a start date and end date for a contract and need to track the dates a rebate should be sent to us. Rebates can be quarterly, biannually or annually. As an example if we have a contract that starts on Jan 1 2007, ends in March 31, 2009 and has a quarterly rebate I would expect 9 rebates...

Thanks Adalger. How do I get it to create the review dates only of the amount of periods I have? I have other contracts that are 5 years long and need to be reviewed every 180 days so that is 10 periods. Each contract has a varying duration and number of periods. Thanks. D

I have a database that contains a contract effective date, and end date and an associate review period, either 90, 180 or 365 days. I have (([enddate]-[effective date[/[perioddays] that tells me how many times to review over the life of the contract. Now I just need to know the expected dates...

I have an excel file that uses category codes to classify products. It lists the category, the manufacturer and then all products that fall within that category for that manufacturer. Each of the products is entered into the same cell, seperated by commas. A user would open excel, do a ctrl f...

I'm not too savy with coding but i do see what you are doing . Do I need to declare rsa and rsb? I reworked things a bit too. I'm comparing the table against a query that pulls data from table b. This table also functions as a change log, so making it a query will allow it to only compare...

I have and Access Database I use for Job Requests. There are two main tables. A requestor enters data in a form that ties to the 30 different fields in the first table. The requests often change midstream, so I have an update button tied to a macro which appends the old data prior to an...

Thanks. Worked pefectly. Appreciate the help with my method block. D