Search results

Report totalling problem:) Got a cracker of a problem here... Morning by the way:) right I have report called Weekly DFL report... basically kids start of with a total of 20 points which is held in tblTotalDfl for every DFL slip issued they lose/gain points... the max points they can have is...

Report totalling problem:) Got a cracker of a problem here... Morning by the way:) right I have report called Weekly DFL report... basically kids start of with a total of 20 points which is held in tblTotalDfl for every DFL slip issued they lose/gain points... the max points they can have is...

Yes... is this where you tell me that you are a too??:) Thanks again for all the help today... I was a gibbering wreck at work! If you are ever in Birmingham UK... I'll buy you several drinks p.s. Got a cracker of a problem for you tomorrow:) p.p.s and I'm not kidding either!

Did anyone ever tell you that you are the most wonderful job life-saver I have ever had the pleasure to converse with:) Are you married? Thank you ever so much!!! (incase you havent already realised.... it is now working!)

right imported your holiday dates database into mine... and put the dates in... How do I call the function now? i used to call it =CountWeeks([Date Excluded],[Number of Days]) have tried calling =CountDays([Date Excluded],[Number of Days]) But neither works...... (so close yet so far....:))

just one more thing.... (promise) (i hope) How does it know to look at tblholidays for these dates???? or have you called it something else? and what should the date field be called that holds holiday dates to make it all work?

Ok let me get this striaght... instead of having a holiday start date and a holiday end date... I have one field callled??????? and I put each holiday date in tblholidays manually? this correct?

Totally in a mess here... if you get chance can you have a look at it? I have no understanding whatsoever when it comes to VbCode.. I dont undestand how the function works... so cant fix it! Totally at a loss over what to do....this is way out of my league :( my table is called tblholidays and...

I now have a runtime error 6 when it reaches intDays = intDays + 1 in the function: CountDays??

I have compile error coming up.... Have replaced the coding with the new one... But cant see how it is checking tblholidays for dates between start date and end date???

Holidays CONFUSED! Hi Milo-o-phile ... Right finally got around to sorting this holiday thing. I now have a table called tblHolidays with Startdate and end date but not quite sure how to get it to ignore dates between the the start and end date..

Wonderful! That works fantastically!!!! Some times you lot are so clever it must suprise yourselves!

Put all my fields in but... it doesnt appear to have done anything?

I have a rather complex report, the report is based on number calculation... I want the report to either shade the field or colour it.. if the number in the field is negative... is this possible? If not I am going to have to scrap 6mths work!! Please help!!

Ignore Previous Sorry.. just me being not very clever.. Its working brilliantly now.. thanks everyone for your help!

Hi Rich.. That worked perfectly... But for some reason it wont put in the post town? Any Ideas =[Home Salutation] & Chr(13) & Chr(10) & [Address] & Chr(13) & Chr(10) & IIf(IsNull([Address- District]),"",[Address- Town] & Chr(13) & Chr(10)) & [Address- Post Code]

Hi this isnt working its does the first line Address1 but is failing at the Address2 which is blank... Any other ideas?

Address (cont.) Will this put the address on seperate lines? How do I put this in my report??

Hi I am doing letters through reports in Access.. with fields Address 1, address 2, district, town.. If a field is blank I do not want a space... I have put in =Trim([Address1]) on all the fields... I have set all the fields to Can grow = yes and can shrink = yes. But still I am getting blanks...

I work as part of a the LEA's Exclusions Team... and have a database where I log all the exclusions to send letters to parents.. The function below works perfectly.. it takes the date excluded and depending on the number if days I exclude them for it returns the date that the student is due...