Search results

Hi All Is there something I can write in to a query which will tell me whether the 1 April 2006 appears in between two dates (which are entered by a user?) For example, if they put the first date (which is one field) as 25/3/06 and then they put the end date (which is another field) as 4/4/06...

Formula Hi Sorry - I see what you mean; I want to count the number of days if they fall between the [First Day] and the [Actual Last Day]? Maria

Here it is: =Count(IIf([Calendar Date]>=[First Day] and <=[Actual Last Day]) ??? Maria

Hi Stopher OK I have put the function into a module....where do I put the fields in that I want it to analyse? thanks m

Hi Stopher Your last paragraph is correct: e.g. someone could be off ill from 20 Nov to 5th Jan, and I want to know (for a report on the section that that person works for) - how many days were lost in December for any employees in that section. M

...sorry...I have put the function code into a module called "Days between"; I have set up a new query (which includes the info that I want to query) - how do I refer to that function (e.g. that is in the module?) M

Hi Gemma I am on Access 97 - do I put this code into an update query? Maria

Hi I have a table which has a start date and an end date on it: e.g. 25/10/06 to 3/11/06. I want to set up a query to calculate the number of days between those two dates, but only for the month of October: so it would only come to 7 days (not 10 days). How do I do this please?? Also...

Hi Gemma I have finally cracked it - have done a query that relates the number of hours worked per week by the employee: so that if they are off for 8 days, I change that into weeks, and then multiply the number of weeks by the number of hours an employee works per week - that seems to work...

Hi again Gemma I wonder whether I can write some sort of formula like this: MonFTE: iif (a date between the startdate & enddate = "Monday" and isnotnull([MonHours]), "1") and then do the same for tues - sun; the only thing I don't know how to write is the bit about picking up the date as...

Hi Gemma You have blown my mind :) I sorta understand what this does, but I need the result to print out in a report - not sure how I can do this.... Will keep trying!! Thanks again :) Maria

Whoops! Hi Gemma Sorry - didn't realised you had replied - was looking at page 1! Anyway: yes, the database needs to look at more than one person, and there are only going to be a few different work patterns - e.g. Mon to Fri; and then part-time hours (not sure what they are) etc. The...

Re: How to do this - produce the day Hi Gemma I have set up a calendar table, which produces the day from the 1/1/04 to the end of 2007 - that should do for now! So: how do I link this "calendar" table in a query to the table which contains the start & end date of a period of sickness, so...

Hi Neil Thanks :) my database has to be slightly more complex though; because we do have some staff that work Saturdays, some that work Mon-Fri etc. I do have a record (on the employee table) which says which days they work. So: what I need is a query that will check, for example, if...

Hi Gemma! Yes, I do need a query that produces all of the dates from my calender between [startsickdate] and [end sick date] - do you know how I would do this? I need to know the actual days involved in order work out whether we are losing money or not: if they were off ill on a Saturday and...

Hello again OK: got the table set up which says what day each date is. Now: If someone is off sick from the 25th to the 27th Oct, how do I get the system to produce a result to tell me what days the 25th, 26th and 27th are? Where the only things inputted are the first and last days of...

Hi again Thought I knew how I could get the table of dates to work....but I clearly don't If I put in as the first date 1/1/04, how do I get the table to auto populate (e.g. with new records) all the dates up to an including today.....and then to produce what days they were? So the table...

Hi guys! Thanks for putting your heads together on this! So: If I create a query which lists all of the dates of the year, which then automatically produces the day....what then...? Maria

Hi Lightray I can see how this works, but I am wondering how, for example, if I have a long sickness period: e.g. from 19/9/06 to 21/11/06, although I can get the system to tell me what day the 19/9 and the 21/11 was, how can I get it to tell me what all the days in between are? Is there some...

Hi I have a table which keeps a record of days off sick. The table has the field [First Day] = the first day they were off sick, in a dd/mm/yy format and a [Last Day] = last day they were off sick, again in the same date format. I need to have a query that will produce the actual day, and...