Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: wattyl
  • Content: Threads
  • Order by date
  1. wattyl

    Date add

    I Have three boxes on a form 1. Number of years (not constant) 2, Start Date ("dd"mmm"yy") 3. End Date ("dd"mmm"yy") The end date should = Start date + box1 The figure in box 1 is always different for each record.ie 12 15 16 20 Can anyone help with...
  2. wattyl

    Subtract from date in query to give date three months prior

    Hi There, Have set up database and used DAteAdd("d",3,[Table Name]![Finish Date]), how do I use this to subtract three months from the Finish Date. Any help appreciated. Wattyl
  3. wattyl

    How do I cut and paste to new sheet from working roster

    Hi there i am running an excel work roster and am having difficulty extracting shifts to a printable sheet how do i cut and paste from the rosters to this sheet. All help appreciated
  4. wattyl

    Count of records by location monthly

    Hi Out there, I have a problem in that I have a table with the following columns : Location Client and then 9 columns which are combo boxes that input High,Medium or Low. I require to retrieve a monthly return by location of the Highs Mediums and Lows for those locations on a...
  5. wattyl

    Using date add in form Date/timebox

    I have a form with 4 date boxes the first box is the initial date and the other three are phased at 3days,6months and 1year using the date add() inthe control source inthe box optionson the form. but using this leaves only the initial date on the corresponding table with the projected dates...
  6. wattyl

    extract monthly dates using a query to a table

    Hi out there, How can i find records that are due updates in a certain month using a query. The query has Location/Number/Name and the due date as column headings but I cant work out the criteria required to extract the due dates anybody any ideas
  7. wattyl

    aggregated needs count of from table by location

    I have a table for aggregated needs, there are 9 headings and each heading is scored High, Medium or Low This table has 5 areas that require an aggregated needs total monthly and they can be called A, B, C, D, and S. it is set out in the following manner Location -heading x9 - score x3 per...

Part and Inventory Search

Back
Top