Search results

Ok... rephrasing my problem... I have a function below which I call up as follows.. CountWeeks([Date Excluded],[Number of Days]) (thanks to Mile - o-phile) I have just created a table called tblholidays which has a start date, an End date and Due Back date field.. as an example school finishes...

CountsWeeks function continued Mile-O-Phile, Don't know if you can help me... continuing on from the last one if the Number of Days +Date excluded is greater than 18th July then Excluded until is 1st september and the Due back date is 2nd of September Any Ideas? Exclusions Team are going...

Thank you Sometimes I am so stupid I suprise myself.. why is it that it is the really obvious things that become the biggest of obstacles?? Thanks for all your help my report is now looking glorious and in Alphabetical order as well!

I have just created a report with a Group header on FullName which I have taken from a query FullName:[Forename]&" "&[Surname] However I want the report to sort by Surname then Forename, which I have done in the query. But because I have used FullName as a group header it is sorting that...

Thanks for your help... it worked brilliantly!

Gonna Cry without Some help

Head is now Mush right gonna explain again..... Okay this database is for pupils who have been excluded.. on my Form I have the following fields Date Excluded Number Of Days Date Due Back The Date Excluded is set to todays date cause they are usually excluded the day the record is created...

3 day weekend I would love to have three day weekends.. I was being a dope but not too much of one cause Monday is a bank Holiday so I wouldnt want to count that either... ;)

Is there anyway for a date field to only look at Week Days ignoring weekends and Bank Holidays? I work in a school and I have a field for todays date which is automatic and then I have a field for Number of Days where I put a Number in the third field is a due back date field which is...