Hi All,
Now it's my turn to ask for your help.
In attached db there's a query "qAppsList" based on table "Apps". Query returns calculated field FullPath2 and in that field I'm using a function retFullPath() I created. For some reason it returns #Error in most rows apart from one and I can't understand why. There's now visible difference between this row and others, at least nothing I can spot. So I need someone to spot it for me please. It's probably something trivial and stupid but I'm fighting it for the last hour or so and no win so far. :banghead:
View attachment dbsample.zip
Edit:
Great, as soon as I posted this I found a reason for #Error. One of the parameters was null in all records except of last one... Stupid me.
Now it's my turn to ask for your help.
In attached db there's a query "qAppsList" based on table "Apps". Query returns calculated field FullPath2 and in that field I'm using a function retFullPath() I created. For some reason it returns #Error in most rows apart from one and I can't understand why. There's now visible difference between this row and others, at least nothing I can spot. So I need someone to spot it for me please. It's probably something trivial and stupid but I'm fighting it for the last hour or so and no win so far. :banghead:
View attachment dbsample.zip
Edit:
Great, as soon as I posted this I found a reason for #Error. One of the parameters was null in all records except of last one... Stupid me.
Last edited: