Javier, You are the man!!! Thank you. This works well. Dan
At 09:45 AM 12/12/02 -0600, you wrote:
Dan: Create variables in your form that check the date and display the variables in the form: -- Convert your current dates to Julian, as it gives a negative number for NULL and you do not have to mess with NULL comparisons -- The next 4 variables should be INTEGER v_rough = (JDATE(your_rough_date)) v_und = (JDATE(your_underground_date)) v_duct = (JDATE(your_ductwork_date)) v_final = (JDATE(your_final_date)) -- The next 4 variables should be TEXT v_x_rough = (IFGT(.v_rough, 0, 'X', ' ')) v_x_und = (IFGT(.v_und, 0, 'X', ' ')) v_x_duct = (IFGT(.v_duct, 0, 'X', ' ')) v_x_rfinal = (IFGT(.v_final, 0, 'X', ' ')) If you use a default date for your variables (i.e. 01/01/1900), when you enter the data, then you could use: v_x_rough = (IFEQ(your_rough_date, '01/01/1900', ' ', 'X' ) ) and so on... Display the values for v_x_rough, v_x_und, v_x_duct and v_x_final on yout form, if they have a valid date, they will display an "X" if not a " " (blank) I hope this is what you were looking for. Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln., Suite #14 Olathe, KS 66062-4571 (913)829-0888 (913)649-2904 FAX -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Dan Champion Sent: Thursday, December 12, 2002 8:48 AM To: [EMAIL PROTECTED] Subject: "if succeeds" Hi, I am looking for the equivalant of the "if fails use default" option you get when placing a column on a form. Presently if you place a column on a form, you get a popup asking what to use if the lookup fails. You can set a default value. I would like to be able to set a default value if the lookup succeeds. Instead of showing the data found in the column. IE the feilds below are date fields, but all I want to know is if the fields have data in the table or not. I don't want the dates to show, just a simple X to show that they have data. Inspections: Rough, Underground, Ductwork, Final X X Is there a way to do this? Thanks Dan Champion P.O. Box 223 Grandville, MI. 49428-0223 www.championsolutions.net ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
Dan Champion P.O. Box 223 Grandville, MI. 49428-0223 www.championsolutions.net ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
