Search
	
	    
	
        
		
        
	
        
		        
	        
		        - 
		        
		            
			        
				        James,
[quote user="jnoneiliv1"]I think answering this question in terms of typical SQL statement logic might help clear things up.[/quote]
While it's helpful to answer in terms of SQL statement logic, we're not writing a SQL statement so I wanted to try and explain what distinct means outside a SQL statement.
[quote ...
			         
			        
		         
		         
	        
		        - 
		        
		            
			        
				        Rolf,
Just wanted to let you know this issue was resolved.  You'll have to log out/in again, make sure you're on the April version of Method and make sure you republish the screen.
~Chad
			         
			        
		         
		         
	        
		        - 
		        
		            
			        
				        Hi Bill,
Do you mind telling me the steps you're taking in Method to get to that report? It sounds like its a custom report? The only other time I've seen this (I think) is if there is some report object that goes beyond the report margins. 
In the meantime, I'm going to try this in a couple of my accounts as well.
			         
			        
		         
		         
	        
		        - 
		        
		        
 
	        
		        - 
		        
		            
			        
				        OK, I have a question about using 2 cells as the parameters for a SQL Statement.
This code is not working because it is not recognizing STARTDATE and ENDDATE as parameters:
 
    Dim STARTDATE As Date
    Dim ENDDATE As Date
    STARTDATE = Range("B1").Value
    ENDDATE ...
			         
			        
		         
		         
	        
		        - 
		        
		            
			        
				        Hey Matt
In these situations we've found that starting from the last action and working up allows you keep adding the same position number.
 
			         
			        
		         
		         
	        
		        - 
		        
		            
			        
				        Matt, 
We'll take this suggestion into consideration and see if and how it would be best to make this area of Method easier. Thanks for the hijack.
			         
			        
		         
		         
	        
		        - 
		        
		            
			        
				        So somehow all a sudden my route list is printing one stop per piece of paper printing on 13 pages now instead of 3 and i cannot for the LIFE of me see what was changed, all my page breaks are set to none i've changed them all around since then but can't figure out why it's creating all this dead space.
 
			         
			        
		         
		         
	        
		        - 
		        
		            
			        
				        That worked.
 
Thanks!
			         
			        
		         
		         
	        
		        - 
		        
		            
			        
				        [quote user="Old Sales Guy"]How can I get this to work?[/quote]
Log out of Method and on the login screen click the Switch to April version link.  The HTML editor was upgraded in the most recent version of Method.  Check the April release notes to see other changes and enhancements made.
~C
			         
			        
		         
		         
	        
		         
	        
        
			   
         
        
	 
	
	
 
                                         | 
                                     
                                 
                             | 
                             |