goldenjammy

LosOjos and VikPaw - so many thanks for your assistance, and your continued responses. We've just moved to SIMS and the use of this site will become invaluable, I guess. The { IF statement } works and thanks for the advice: I'm going to put a few points here that I found issues and then anyone reading at a later point will be able to do check boxes based on a value entered. 1. You must have "View Field Codes" set so that you can enter the formula/function - press Alt-F9 for this, or insert from the AllCommands 2. The formula to use is {IF {=SUM(ABOVE) } = 1 "TICK" "" } 3. Make sure you use Insert FORMULA into the Table as it gives the correct curly brackets (otherwise they're see as text and not a function} 4. When Run from SIMS, do as a Word Export and then for each report generated then you'll need to do Ctrl-A (Select All) and then Update All Fields. That seemed like a lot of work for the 1500 pupils we have (1500+ File Opens and then Update All). So: Because ALL Macros are Enabled I have added a Macro which Updates the Codes automatically - avoiding 1500+ repetitions by me. This Macro also allows the PDF Export to be done and having the tick in the right place. The AutoOpen Macro is this, Go to View - Macros and Create a New Macro (I called mine AutoOpen). Don't delete any of the ones which appear there. Sub AutoOpen() ' AutoOpen Macro ' Macro created date by G Lewis to Update Fields on Open ' Dim aStory As Range Dim aField As Field For Each aStory In ActiveDocument.StoryRanges For Each aField In aStory.Fields aField.Update Next aField Next aStory End Sub Once again thanks to 2 people for helping along the way - I will endeavour to assist others in the future.

I'm having a problem with the IF statement. The Sum(ABOVE) works fine but there seems to be an issue with the IF statement and maybe I've got the wrong syntax structure for it. { IF { = SUM(ABOVE) } = 1 "X" "Y" } It looks right but it's not beiong resolved regardless of the use of SIMS, at present.

I'll have a go at that this morning after a couple of lessons. I'd had a thought about that overnight, but wondered whether WORD would be able to calculate the IF statement after inserting the data, otherwise some 'UPDATE FIELD' would be required. I'll get back to you about how it works. My fallback alternative, that I thought about last night, is to output ALL Aspects to Excel and do a Mail Merge from that, as the IF statement (Rule) works in that form.

I want the IF statement to work. I have a number entered for 'Effort'. In my Word Report I have a table with phrases that equate to the values 1-5. My aim of the IF statement is to have it give a tick next to the phrase the value equates to: High standard of Effort Good Effort Satisfactory Effort Poor Effort No Effort mde If the aspect value is 1 then the tick will appear next to the HIgh Standard phrase etc...... It works fine if I do a mail merge from Excel or Access, but the SIMS merge of data does not work it seems, which is causing big issues.

Has anyone used an IF statement in the Report. In Word you can do an IF statement with a normal Mail Merge, but I'm having a problem with thew one from SIMS in an individual report. Staff enter 1 - 5 for Effort then I use a rule to decide which Box should be selected. I enter the formula into the rules (by doing alt-F9 or Show Codes) then enter the formula { IF {<> } = 1 "X" "" } then change the check to check for a value 2 in a different box. { IF {<> } = 2 "X" "" } Please add any comment/experiences/advice/solutions you have for me to do this for our school reports.