What application are you using for this SQL, Access, Excel, Crystal?

Thanks for checking in BL.
Access. Running on Server 2008
Live and Development environment are identical. Server 2008.
Since the Access code works on the development environment, I'm wondering
if I cleared all the users, and restarted the live MAS server if maybe something
may clear, and it might work.

Also, I ran this specific code on the live system about three weeks ago, and it worked.

Thanks for checking in BL.
Access. Running on Server 2008
Live and Development environment are identical. Server 2008.
Since the Access code works on the development environment, I'm wondering
if I cleared all the users, and restarted the live MAS server if maybe something
may clear, and it might work.

Also, I ran this specific code on the live system about three weeks ago, and it worked.

Create a SQL Specific Pass Through Query on the CI_Item table and then create another query against that query and do the Count thingie in there.