Search results

You are right about the 25 if statements of course, and the problem is that there are five other indicators in the risk assessment matrix too, such as Anit social behaviour or mental health. It works well on paper as we use a grid to arrive at a score, but on the database this makes for 125...

this is what I have. =IIf([Offending Consequence] = 1 And [Offending Likelihood]=[A], “Very Low”, False) What have I done wrong? The error just says Check constraint in the dialog box and name? in the field on the form. cheers for your help

Yes, a drop down box, sorry.

I used the look up wizard to write in the values 1 to and a to e

Hi, I have two fields in my form, one called Offending Likelihood, in which I have a list from which the inputter can choose numbers 1 to 5 and a field called Offending Likelihood from which the inputter can choose the letters A to E. I have an another box called Offending Score in which I would...

Hi, I have a form in which I am trying to build a matrix scoring system and need some help please. I have two fields one called Offending Consequences and one called Offending Likelihood. The first field is limited to a list 1 to 5 and the second to a list A to E. What I want to do in a...

Hi All, I have a number field and I want the numbers all to be either whole numbers or to end in .25, .5 or .75. How do I write a validation rule that ensures that only these numbers are entered? thanks Hazell

Table: Courses ID Number Date Course Attended Completed? Table: Tracking Active? Sample Data 1301 01/01/13 Woodwork Yes Active 1302 01/02/13 Customer Service Yes Active 1303 14/02/13 Woodwork No Active...

This is what I have written, but it doesn't work. Any help please. I am trying to find out the percentage of those completed a course as a percentage of those who are active and I entered this in the expression builder but I got a message back that says I cannot use aggregate functions...

the actual question is: # and % of young people completing courses that they started aged 15-18 by course title. I have the number, but now I need to work out the percentage. thanks

My monitoring report is huge, with loads of different questions, most of which don't make any sense whatsoever - statistics for statistics sake, really. So, to make it easy on myself I have developed a query that matches each of the questions, so that I just have to run the query and fill in the...

Oh, well, the queries are designed to match my monitoring form, which asks the same question in a million different ways. I agree that it would be much easier to do it differently and I have said so (at length) to our funders, but they are having none of it, I'm afraid

Ok, the first query goes something like this: Case Number, DOB, Age Diff, Active? And the criteria is Between 15 and 18 and Active is Yes. The total number only appears in data sheet view and not in design view And the second query goes something like Case Number, Course...

Hi, I have written a query to find the number of students we have on our books who are between 15 and 18. The query lists the students and gives the total number in data sheet view. Now I have written another query which looks at the number of students between 15 and 18 who have completed a...

Works perfectly now. thank you all so much

I think I must be putting it in the wrong place. I have the form open but it is not clicked on to any item on the form. then I clicked on the ellipsis in the ONCurrent property box and put it in the expression buider. Is this right. Sorry for being dim

Private Sub Form_Current() Select Case Me.Score Case Is < = 13 Me.Level = "Below Entry Level 3" Case 14 To 32 Me.Level = "Entry Level 3" Case 33 To 52 Me.Level = "Entry Level 2" Case 53 To 65 Me.Level =...

I'm not sure. Message just says I may have entered an operand without an operator

Just exactly what was written above

Apparently I have invalid syntax. I copied and pasted the code in. Any suggestions. thanks for your help. I would be lost without you