Search results

  1. R

    Looking up Rate info based on a Date

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

    Code Review - Looking for constructive feedback

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

    Splitting string on the last delimeter

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

    Query needed to return last, or next to last, value based on date...

    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...
Back
Top Bottom