Hello every one I’m back again for advice, I have two problems at this moment and I don’t seem to get out of them.
1.) Basically I try to archive to bring only the Vacant Units in to a Report form. So far I get all the Units Vacant or not together. I do have a column named Vacant and it is manually entered as “Yes” if applicable. I have used several different approaches but with no avail including the two variables below.
Vunit = unit in Tenants where Unit=Unit and Vacant = 'yes'
Vvacant = Vacant in Tenants where Vacant=Vacant and Vacant = ‘yes’
2.) I have two columns let’s call them BeginningDate and EndDate and I like to get the Days prevailing between the two dates. The purpose of this exercise is to calculate Interest on a deposit which we are obliged to do by law.
I have been following your e-mails very closely and it appears to me what I have as problems they seem to be the basics and very minor in comparison to the ones which are being discussed and frankly way over my head. I sure hope I won’t be a pain to this group with my beginner’s questions.
Thanks again for any assistance you might have for me.
