Forum Discussion

Rhothgar's avatar
Rhothgar
Icon for Helper IV rankHelper IV
2 years ago

Unable to get this result when I copy code into another query! Code here is in PROPER format!!

Hi all  Finally worked out how to provide sample data. Basically, I started a new example and the code below gives me the result I want. However, when I copy code into another query, it does...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Using <> null was probably your issue. That usually gives you an error.

 

--Nate

 

--Nate 

  • Rhothgar's avatar
    Rhothgar
    Icon for Helper IV rankHelper IV
    2 years ago

    I'm not convinced it was. I tried all manner of operators but it simply wouldn't work. 

    I've got a lot more tinkering to do as the system it is being exported to gave a few errors. 

    I need to try and work out how I can export items that are over 300cm girth ( using (2 x (H + W))+ L  from height, width and length data) into one worksheet and discard anything below and then vice versa on the other worksheet.

     

    It's a work in progress. 😁