On DisplayOnly forms that generate reporting data I usually put a button called "Generate" on the form. That way I can separate the report parameters from the output. I know ... really old school ... but it works Fred
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Monday, June 11, 2007 3:45 PM To: [email protected] Subject: Re: Dates in a SQL Query ** Thanks Fred! One more question, this is a display form, other than "Lose Focus" what other "Execute On" value can I use to show that one of the date fields have changed? Lisa ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Monday, June 11, 2007 4:01 PM To: [email protected] Subject: Re: Dates in a SQL Query ** Create 2 Display Only Integer fields on your form (zInt1 and zInt2) Set zInt1 = $Start Date$ Set zInt2 = $End Date$ Then use the 2 Integer fields in your SQL Fred ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Monday, June 11, 2007 1:35 PM To: [email protected] Subject: Dates in a SQL Query ** I have a simple count SQL query that sets a field on my form: SELECT COUNT(SURVEY_NUMBER) from TEIS_SURVEY_CALCULATIONS Where AVGSCORE_7 > 0 I would also like to query it more by adding date fields. I have a start and end date on my form, but how do I translate this into at SQL Query? I know if I simply do this: SELECT COUNT(SURVEY_NUMBER) from TEIS_SURVEY_CALCULATIONS Where AVGSCORE_7 > 0 and EXP_DATE >= '$Start Date$' and EXP_DATE < "$End Date$' I'm not going to get what I need. My EXP_DATE field is truly just a date field, not Date/Time We are using AR System 6.3 AR User 6.0 Oracle 9i and Sun Solaris. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
