RE: [Emerald] Simple Query

Nathan Haywood ( nhaywood@whro.org )
Fri, 21 Jan 2000 22:47:59 -0500

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Humberto Guzman: "[Emerald] Simple Query"
Next message: wilson@dagupan.com: "RE: [Emerald] URGENT: Billing Oddities"
Maybe in reply to: Humberto Guzman: "[Emerald] Simple Query"

UPDATE MasterAccounts
SET Active = 0
WHERE DateAdd("d", (Overdue + Extension), maExpireDate) < GetDate()

-----Original Message-----
From: Humberto Guzman [mailto:emerald@sysop.com.mx]
Sent: Friday, January 21, 2000 8:49 PM
To: emerald@iea-software.com
Subject: [Emerald] Simple Query

Hello,

I am trying to find a query to change all expired accounts to inactive
ones...

Any help :)

Thanks!
HG

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart

Previous message: Humberto Guzman: "[Emerald] Simple Query"
Next message: wilson@dagupan.com: "RE: [Emerald] URGENT: Billing Oddities"
Maybe in reply to: Humberto Guzman: "[Emerald] Simple Query"