Search results

  1. D

    If statement to change caption in label

    Hi I am designing a holiday planner within my database which shows employee's holiday booked, cancelled and declined. I found a very helpful demo database which I have slightly amended to suit what I need, but I am having problems changing the caption labels to value's within the recordset...
  2. D

    Force Uppercase in Report label

    Hi I have the following code of my holiday calendar however I would like to convert the month into uppercase. I know about the 'Ucase' function but I am fairly new to this and have tried to place this within the code but with no success:- With theReport...
  3. D

    DateDiff Maximum Return Problem

    Hi New to these forums but having a problem......... I have a query which looks at an employee's start date, and then at todays date and returns the number of weeks they have been employed. However I need to limit this to 52 week, shoudl they have been employed for longer than on year, how can...
Top Bottom