I have a cross tab query that shows activity on a order over a period of time. Right now I have to export this to excel and add a column on the end with the countif function to see if there was any change in value vs the lastest value. For example, I use the countif function to check the string of values to see how many match the most recent value. If more than one matches the most recent, then that means there wasn't activity between periods.
Is there a way to add this functionality to the cross tab query so I can put it into a form? Thanks for your help. I always give reputation points for help. Thanks
Brennan
Is there a way to add this functionality to the cross tab query so I can put it into a form? Thanks for your help. I always give reputation points for help. Thanks
Brennan
