Unanswered: First Database/Report Running into issues
I have built most of the database/report already and I am having an issue with one of the fields. This is my first time doing something like this.
On the spreadsheet everyone is duplicated on multiple lines and the data is repeated. I created a distinct query to pull from on the report but the issue seems to be there is a random 0 down one of the columns and instead of pulling the number from the row below, it just pulls the 0. I was using the following string "=[Standard Supp Life - EE 1X ee cost per pay] & [Standard Supp Life - EE 2X ee cost per pay] & [Standard Supp Life - EE 3X ee cost per pay] & [Standard Supp Life - EE 4X ee cost per pay] & [Standard Supp Life - EE 5X ee cost per pay]".
Is there anyway to add a but skip "0" to it?
FYI - No changes can be made to the spreadsheet and someone will be importing new fields that will likely have that "0", I need to fix it on the report end. (Hope that makes sense).