Search results

Many thanks again Khawan and for the amended sample with the workdays. I must admit I have been busy on another topic/project and will look through your code in more detail when I return. Thanks again for everyone who has contributed - much appreciated.

Thank you so much Khawar - just what I was looking for. You read my post exactly. I havent been to this site for sometime as I havent used Access for a while but nice to know I can get something unusal fixed. Nanliam, a word. Thanks for attempting to help me but your bluntness was something I...

Right! I will be coding it and have already been looking at looping for each month and have already thought of the Calendar Table option too. Also looking at whether a cross tab query can be developed too... Think I'm getting there but will play around with it over the next few days.

So..... not practical to split range into two periods as users will be entering one date range over multiple months period as per my first thread.

Just looked at your code DCrake and noted that it only gives the number of days between the range of dates which is fine but what I'm after is the number of days for each month within the range eg. April 08 = 6 days May 08 = 16 days Thanks.

Thanks Many thanks for your help. As I havent had the need to use these forums for sometime, I wasnt aware that it had been posted many times before. Thanks again for both responses.

Hi, I need to be able to count the number of workdays for each month between any given range of dates. Example.... If a date range of [startdate] 23/04/2008 - [enddate] 22/05/2008 I need to know how many workdays there were in April and also May separately. Workdays are Monday - to Friday...

Thanks, have'nt used Access for sometime and have forgotten parts of it. I have used the query as above as sourcedata and tried to convert the date calculation from a variant to date using CDate but in the second query it only recognises literal dates entered as a range rather than a range...

I developed a query that calulates when a contract is reviewed i.e 5 weeks and 9 weeks after the commencement date. These are called CDE1 and CDE2. This works well and the CDE1 and CDE2 dates are displayed ok. The query above is: SELECT Contract.ContractNo, Contract.APSNo, Contract.Firstname...

Problem now resolved - managed to create two separate queries Grouped by FacilityCode and used the Left Join on the facilitycode - works well. Thanks for your assistance again Vince :D

Vince, thanks your code had helped and now I can access each individual month Hours and Total LTIs for each facility. My next trick to show a combined TotalHours and LTIs for each facility for a range of dates entered by the user eg (1/07/2004 - 31/10/2004) Facilitycode TOTALHOURS FOR...

Thanks Vince, Got the following SQL which seems close to what I want except that only shows LTIs equal to the date rather than all LTIs in the same month and year as the Hours Date. In other words I want them to be joined and grouped by the same month and year by HoursDate and IncidentDate...

I have two tables: Hours & Incident Hours HoursDate FacilityCode Hours Incident IncidentDate FacilityCode LTI (Yes/No) field How can I join these two tables on the facilitycode so that they are group together by Month on the Hours Table. In other words I want to display all...

Date Formats Thanks have looked at this but I think I might in hindsight keep the date in dd/mm/yyyy format for ease of entry.

I based a query on a date field that I formatted to "mmm,yyyy". When I enter a search date range from eg July,2004 to Sept, 2004 it returns all months starting with "J" to "S" rather than the calendar months. I know that the format function does return a string but how can I change this so that...