Search results

Thank you so much. I had to change the count to count the rowid because the end date was null (that was my fault in my original SQL query), but once I did that it worked great. Thank you again.

Can someone please help me? I have a table that hold territory assignments with a start dt and end dt. This table will help us determine when a certain user was assigned to a territory and should receive credit for work done on that territory during the date range based on the start and end...