Hello all
Have any of you encountered issues whereby you have to hit REFRESH button twice in order for a cell to return the valid value you are looking for?
I have a report, hit refresh, zero value in cell. Hit refresh again and the value I know then appears.
Never had this before in all my years of using Jet ;)
Hello Nick -
While I have not seen that, I would think that the most likely cause would be some issue with the connection to the database (speed, dropped packets, etc.).
Regardless, I would run this one by Jet Global Tech Support. Since it sounds like you can easily reproduce the issue, they may have you create a detailed log file to identify what's going on behind the scenes.
Hello Harry Many thanks for the reply, I'll take a look and run it past JCT ;)
Kind regards
Nick
Have stuck "EVAL" function into the actual query itself and has done the trick. Usually have to put this in on dates driven off the OPTIONS tab.
