Search results

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

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

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