Re: Syntax

[david blocker]

Title: Syntax

Herbert   1.  I THINK what you're describing is a situation where you are printing data from ONE table, but need a condition for printing rows based on data in a second table. is that right?  Can you tell us what table the report is based on?  I assume since you are trying lookups into the TENANT table that the report is NOT based on it.   If it IS based on TENANT, then the correct approach to print a report only for those records where the site is VACANT would be:   PRINT reportname WHERE VACANT = 'YES'   To print for those records which are NOT vacant:   PRINT reportname WHERE VACANT <> 'YES' OR VACANT IS NULL   IS NULL means it's blank, which is not the same thing as no equal to YES!   If the report is NOT based on TENANT, then I need to see the structure of the two tables to help you.  At the R> prompt, type LIST TENANT to show the structure of the TENANT table and include that in your email, and LIST tablename where tablename is the table the report is based on, and send that as well!   If I've misunderstood you, and you want to print ALL the records, but have the word "VACANT" appear next to those that are vacant, let me know and I'll tell you how!   2.  I'm unclear on the second one. Do you want R:Base to calculate for you the number of days between start and end dates and show that in a report?  Can you be more specific?   David Blocker   ----- Original Message ----- From: Herbert Hemberger To: [EMAIL PROTECTED] Sent: Sunday, September 30, 2001 12:36 AM Subject: Syntax 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. Herb