Darin Spence wrote: > > Is there a quick query that can be written to change the payment date on all > payments made today? I need the payment date to be 6/2/99 instead of > 5/28/99. > > Basically, because of the long weekend, we want all of our payments that > were put in today to look like they were put in on 6/2/99 so Emerald matches > up with out deposit that goes to the bank. Our next deposit is 6/2/99.
Update Payments
Set Date = '6/2/99'
Where Date = '5/28/99'
--
Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com