Recent content by MANDI201

Mail merge from Access Hi Thanks for your reply but I must be having a blonde moment - on the command button there does not appear to be anything except "Run Word" - no mention of merge am using Access 2000. If I try to use a hyperlink when it opens Word the source data seems to be missing...

Hi, I want to have a button or hyperlink on a form in access which will open a word document and populate with specific records from my access database. Is there an easy way of doing this. The specific record will change depending on what information I need printed on the word document. Any...

Cracked it! Thanks 4 tip I did query with 3 total columns one for HOL one for Flex and one for SICK it then adds up each one separately. Great! Total Days Hol:Iif(([Reason for absence]="holiday",Ii(([half-day]=yes),"-0.5,"-0")+)[date_end]-[date_start]))+1 I repeated this formula for the...

Multiple totals Thanks will try that. I presume I would need to do 2 different queries giving me 2 totals to work from. Will I be able to put this into a form to show the totals? I will try thanks for your help. MANDI

Hi, Thanks for your help so far has helped a lot. I have been tasked with setting up a database to record holiday and sickness. I want to be able to total these independantly of each other. I am using a pick list to chose from holiday or sick with a total of days taken but I am unable to get...

Dates Tried your suggestions but it kept giving me the wrong figures? Can Access not determine "if empty" add a figure or "if not null" - 0.5 from my total? Would like something like Days taken:([date_end]-[date_start]+1-if [half_day] is not null then -0.5 if [half_day]=null then -0 In...

These dates are "optional" and will only be filled in if the patient becomes sick during the time that she is on the ward. I still need to record the total days that the patient is on the ward minus any days that they are "unfit". Should the patient not become "unfit" then these dates will not...

Dates seem to be the bain of my life at the moment I have to calculate the amount of time that a patient is spending on a ward when they are fit enough to go home. This I managed by using =Now()-([DATE MEDICALLY FIT]) Now they need to calculate the amount of time they are spending in the...

Thanks for your help... I went in and removed the new Half Day field from the query and re-added it again and low and behold the form now lets me tick the boxes! The form calculates the amount of days taken on the form in form footer can I modify this to make it take into account the half days...

In Controlsource I do have set to Half Day? but still wont let me tick it. Think I must have my thick head on today? sorry to be such a pain. Y cant staff be sensible and have WHOLE days off! MANDI:o

DATES Thanks for your help but when i added the tick box to my table it allowed me to tick the box but then when I added the same box to my FORM it wont allow me to tick the box? I am totally confused now.:confused: Any suggestions be gratefully received? think Im going mad MANDI

Hi this will probably be a very easy one for you clever people but I am having problems with my Holiday Database. I can get it to add up the amount of days that people have off until some bright spark wanted 1/2 a day off! tried putting in an am/pm field but then I would have to put the...

Thanks Thanks very much.... wont do that again in a hurry!

Help.. I have somehow locked myself out of Access everytime I go to access a database it is now asking me to LOGON and give Password. I have never put password protection on My Access icon? I did try to put a security on a small database but I can access this via a colleagues "ID". Any...

Help - silly problem I am sure easy for someone to solve but I am having trouble converting a date field into an age field not experienced enough to use VB managed to get query to show age by taking dob year away from current date but if person born tommorrow will still show same age as a person...