Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-10-2020, 11:57 PM
applicious applicious is offline Multiple Options Not Displayed using IF Windows 10 Multiple Options Not Displayed using IF Office 2019
Novice
Multiple Options Not Displayed using IF
 
Join Date: May 2020
Posts: 4
applicious is on a distinguished road
Question Multiple Options Not Displayed using IF

Hi everyone,
I've been battling for days to try get this to work correctly, but can't find the problem.

Use case...


The user captures information into an external form which then uses the attached Word mail merge template to produce a proposal consisting of up to four individual solar system quotes.

The attachment has had all the personal and business info removed. I've left the four tables that should produce the various solar system quotes together with the IF statements.

There are potentially up to 4 different quoted solar system options that should appear in the final document. Each option 1, 2, 3 and 4 should display depending on the number of options initially selected in the external form by the user.
So if the user selects "number_of_options" to be "3" then they would fill out the information for 3 different solar systems and the end result will be a proposal with the 3 quotes displayed while not displaying the 4th quote. If they select 2 options in the form then only 2 quotes should show and so forth.

PROBLEM....
I can't get the IF statements to work so that if the Number of Options is for example "3" then only display the first table (Option 1), the second table (Option 2) as well as the third table (Option 3).

As soon as I have more than 2 options then the "middle" option(s) is(are) missing.

So if I select that I want 4 options to show, only table 1 and table 4 are displayed and tables 2 and 3 in between are missing. Had I selected 3 options than option 2, in between, will not be displayed in the final document.

I've tried multiple times and various ways to copy and paste working code in one table to the inner tables, rewrote each manually from scratch, etc, etc. But I cannot get them to display based on the Number of Options field's input.

Any suggestions or help is much appreciated.

Thank you
Andre
Attached Files
File Type: docx SM8-Solar-Quotes-Query.docx (39.5 KB, 7 views)
Reply With Quote
  #2  
Old 05-11-2020, 12:50 AM
macropod's Avatar
macropod macropod is offline Multiple Options Not Displayed using IF Windows 7 64bit Multiple Options Not Displayed using IF Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Try the attached. There were numerous minor field syntax & formatting issues with your fields.
Attached Files
File Type: docx SM8-Solar-Quotes-Query.docx (56.5 KB, 10 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-11-2020, 01:04 AM
macropod's Avatar
macropod macropod is offline Multiple Options Not Displayed using IF Windows 7 64bit Multiple Options Not Displayed using IF Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Cross-posted at: Multiple Options Not Displayed using IF - Microsoft Community
For cross-posting etiquette, please read: Excelguru Help Site - A message to forum cross posters
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 05-20-2020, 04:55 PM
applicious applicious is offline Multiple Options Not Displayed using IF Windows 10 Multiple Options Not Displayed using IF Office 2019
Novice
Multiple Options Not Displayed using IF
 
Join Date: May 2020
Posts: 4
applicious is on a distinguished road
Thumbs up Thank you!

Thank you Paul, worked perfectly.
Apologies for not knowing about the cross posting.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Options Not Displayed using IF Preparing a drop down with options to complete multiple fields ajb Word 8 03-24-2018 12:56 AM
contents not displayed Rectorth Word 0 02-10-2018 04:06 PM
MS Excel - SQL Data Query Connection to MS Project - Resource Displayed in Multiple lines not in one AKent Excel 3 08-26-2015 01:34 PM
Multiple Options Not Displayed using IF Menu and formatting options not displayed at the top of my document tubefeed Word 3 03-14-2015 05:47 AM
'this image cannot currently be displayed' eNGiNe Word 0 02-02-2012 07:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:16 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft