Recent content by RocketRod

Its not the software. While you are developing your app make backup copies daily at a minumum, or more if you as you get significant functionality added (code developed).

I should have mentioned the table structure is defined by an off the shelf application we are using and I only showed the columns required to solve this problem. In addition, you would want two tables in this instance to normalize your data, otherwise a resource could only have a rate...

I am developing a report that calculates cost based on, Hours Worked * the effective Rate for the date the work was completed. The Hours Worked information resides in one table and the Rate information in another. I have written code to make this work using VBA, but was wondering if this could...

Thanks for the insightful and very constructive feedback. It is very helpful as its been over three years since I have done any developing, which was in VC++, and this is my first experience with VBA and SQL. Also after I posted this I have realized this could be down with queries only, but...

I have setup a small test database with which has three tables: RsrcHoursWorked - Contains information pertaining to hours worked by a resource in a given week (ADMUSER2_FINDATESSTART_DATE). Rsrcrate- Contains all of the available rates and there effective date for each resource...

Work great!! Thanks for the quick response!

I have a list of filepaths, one filepath in each cell. I want to extract the filename from the filepath and put it in a separate cell. Text to Columns will not work since I am only wanting to split the text after the last '\' and the filepaths vary in length. Before: Col1...

I have the following tables: Rates and SelectedDates, which are structured as follows. Rates: RateID, EffectiveDate, Rate SelectedDates: Date. Table is bound to a combobox in which user selects one or more dates, mm/dd/yyyy, which is the same format as Rates.EffectiveDate. I need a query to...