Search results

Thanks for the advice. I seem to be getting a little lost. There can't be a score of > 72, though I suppose it should perhaps say error if you try to enter anything higher than 72. Also, I am trying to enter this code into the Level box on the BS Literacy form. Is this right? Should I be...

I may not be entering it in the right place. I clicked on the ellipsis in the on click section of the event property box and copied it in there. Is this right or have I done something silly? thanks for your help

Still struggling with this, if anyone can help. this is what I have written, based on the previous advice: Private Sub Form_Current() Select Case BS_Literacy.Score Case Is < =13 BS_Literacy.Level = "Below Entry Level 3" Case 14 To 32...

thank you so much for your help

I have never done this and would need some step by step instructions if anyone can help. How would I formulate the statement and where would I put it?

Hi, I am trying to get a form to display certain information based on the data in another box. I have to input some exam results and want to assign a level to them. So, if they score < 13, the result would read "Below Entry 3" if between 13 and 21 "Entry 3" etc If this was a spreadsheet I would...

Hi all, Hope you can help. I am trying to create a form where I store the literacy and numeracy results of a group of students. So far I have designed a form which gives me a tick box as to whether the test they took was literacy or numeracy, then a box where I enter the score. Literacy tests...

Hi, I have built a query that lists all the members in a group aged 15 to 18. Now I need to build another query that counts a subsection of that group (the number who gained employment in the quarter) and express this as a percentage of the whole of the 15 - 18 group. I presume I can use the...

Finally got it! thanks so much for your help

Pretty sure that it is me that is not being clear. I have tried to implement what you suggested, but I can't get it to work. I have a field on the table that says the date that the member joined, and I need to extract all the members who joined within a three month period, as well as those who...

Thank you for that. I understand the principle of that. I have now set out the form for the start and end of the monitoring period. How should I set out the query if, for example I wanted to find all members who joined after the start of the period. I tried putting in >= StartDate in the...

Hi, I have written a large number of queries to gather data for a quarterly monitoring form. How do I replace the dates to update them for next quarter. For example I have written a query which counts the number of new members who started in the period 01/04/2013 to 31/07/2013. How can I change...

Drat! Should have remembered the 0. Thanks so much guys you've saved me hours of headscratching

Hi all. I am writing some queries with a fairly complicated naming system and have hit a snag. The naming goes like this: QM H 1 32 etc etc QM H 2 32 etc etc down to QM H 10 32 etc etc And the query jumps up the list of queries. How can I get access to recognise it as 10 and not 1.0. I...