| 
 | 
First, thanks to all of you for helping me with this issue.
No, I have not been successful using query to get the # days calculated. 
All due to the field format.   I have tried every flavor and then some.
I gotta say I sure have learned alot about query.  I was success ful in 
getting the day to the right 8 char but after I got it to charactor day 
could not get it back to numeric date format.
Gail Crane
Johanson Manufacturing Corp.
phone 973-334-2676
gcrane@xxxxxxxxxxxxxxx
rob@xxxxxxxxx
Sent by: midrange-l-bounces@xxxxxxxxxxxx
03/03/2003 11:44 AM
Please respond to Midrange Systems Technical Discussion
 
        To:     Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
        cc: 
        Subject:        Re: Query calc # days
Gail,
Any of these suggestions work?
Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.