Ben:
Amount paid varies based on a number of factors. Years paid is the number
to determine paid length of membership -- all numbers are stored as
years/integers.
I'm joining with WHERE DuesAdmin.membersID = Primary.MembersID
H.
> -----Original Message-----
> From: Braver, Ben: [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, December 19, 2000 4:53 PM
> To: CF-Talk
> Subject: RE: (SQL) Date column x year column
>
> Howard,
>
> I don't think you want to "multiply" date x years-paid -- wouldn't you
> want
> to use DateAdd to calculate an expiration date based on the amount paid?
>
> Also, how are you joining the primary and dues admin tables?
>
> Ben
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
