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!

Register Log in
  • Congratulations Rhinorhino 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: *

  1. wattyl

    Date add

    Ken, I have a query and tried to use "DateAdd("y",NoOfYears,[StartDate])" as you suggested. I used -3 as the "NumberOfYears" to subtract but this is not subtracting the three years , instead it only gives a subtraction of 3 days on my end date from start date...
  2. wattyl

    Date add

    Having problem running this code. Is there any way I can do this using a query and placing the code in the "Field Box" of the query
  3. 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...
  4. wattyl

    Subtract from date in query to give date three months prior

    Hi Ken, Will try your solution Many thanks. Wattyl
  5. 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
  6. wattyl

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

    The areas i am trying to print is to produce a weekly list of personel from the roster to cover different positions and shifts. Instance 1 Monday - friday early shift for seven staff Instance 2 Monday-Friday late shift for seven staff instance 3 Weekend shift for 8 staff Instance 4 weekend shift...
  7. 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
  8. 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...
  9. wattyl

    aggregated needs count of from table by location

    Hi There, The table has 6 headings lets call them item 1, Item2 and so on. Each heading is classified with a high ,medium or low result in a text box for individual clients i.e. client 1 item 1 H,M or L item 2 H,M or L item 3 H,M or L etc. These...
  10. wattyl

    aggregated needs count of from table by location

    Any help , I need to produce an aggregated needs table showing High, Medium or low categories form a table using a query on a monthly basis. The table has five categories which are marked High, medium or low , has anyone an idea that could help me to set up the query I would require to reurn a...
  11. 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...
  12. wattyl

    extract monthly dates using a query to a table

    Tremendous it works a treat, many thanks for your help [bigglasses]
  13. 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
  14. 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