Search results for query: *

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

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

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

Hi Ken, Will try your solution Many thanks. Wattyl

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

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

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

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

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

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

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

Tremendous it works a treat, many thanks for your help [bigglasses]

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

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