Sure, sorry about that.

Sample Data would be:

Tenant abc has lease charges of 4571.81 from 01/01/2006 - 11/21/06.

This same tenant has a new lease charge of 4652.01 beginning on 11/22/06 and Ending...

O.k. Peter,

I am stuck now. I have the following: I am counting moveins and moveouts. For my beginning number I am getting repetitious counts. For example, if someone moves...

Peter, can I ask another question I just encountered. My dates are as follows:

8/18/06 - 8/24/06,

8/25/06 - 8/31/06,

9/01/06 - 9/07/06, etc.

What if I wanted to start the next...

Thanks so much for the reply. Both methods work wonderfully!

Thanks a lot. That works great for the weeks. I have been trying to incorporate a count (basically) in another column into that statement. How would I do something like...

Thank you. Remi - there is no date field to use in the table in which I need to pull the info from. This table is set up by a...

Sure,

Table 'b' contains a primary key, a revision handle, an account handle, and 20 fields with budget amounts stored for expenses and revenue. There is no date stored in...