Search results

Raskew, I really appreciate your help, but could you please explain that piece of a code a bit more? I'm currently using: Available Days: DateDiffExclude2([Sickness]![Start Date],IIf(IsNull([Sickness].[End Date])=True,Date(),[Sickness].[End Date]),[«pexclude»]) [«pexclude»] should this input...

Thanks for this guys, you've been a massive help, gonna try and implement this now. Will post again when I (hopefully) I get things working!

Yes, very much used to using Java as a coding language, finding VB very picky by comparison! :confused: Thanks for that! :D On another note, I have yet another problem (I know I'm a whiner...wouldn't normally ask, but I am on a bit of a schedule). How can I calculate the total number of...

Available Days: WorkingDays([Sickness].[Start Date], IIf([Sickness].[End Date]=Null,Date(),[Sickness].[End Date])) >>WorkingDays(StartDate As Date, End Date As Date) This is my query equation thingy at the minute. Where WorkingDays is a custom function (borrowed from another website, credit...

Basically I started using access a few days ago, as a computer science student it's been fairly easy and I have a good understanding so far. However, I'm finding it very difficult to calculate data. In particular sick days. I have a part time database to input that includes the following...