Code Forums - View Single Post

redhead · 09-16-2004, 10:13 PM

I took the liberty to move this thread, since I found it of very little use in the feedback section.

To me it looks like some VB program, but without the [ code][/ code] tags surrounding it I can't realy read the code that well.

Code:

... IIf([Invoice_Date]<Now()-30 And [Invoice_DATE]>Now()-60,[Invoice_Amount],"")
         AS Greaterthan30,
    IIf([Invoice_Date]<Now()-60,[Invoice_Amount],"") 
         AS Greaterthan60 ...

Thats the SQL-limitation, you are trying to fetch from the same field into two different arguments.

This sounds alot like some homework...

09-16-2004, 10:13 PM	#2 (permalink)
redhead Newbie Join Date: Jun 2002 Location: Denmark Posts: 1,711	I took the liberty to move this thread, since I found it of very little use in the feedback section. To me it looks like some VB program, but without the [ code][/ code] tags surrounding it I can't realy read the code that well. Code: ... IIf([Invoice_Date]<Now()-30 And [Invoice_DATE]>Now()-60,[Invoice_Amount],"") AS Greaterthan30, IIf([Invoice_Date]<Now()-60,[Invoice_Amount],"") AS Greaterthan60 ... Thats the SQL-limitation, you are trying to fetch from the same field into two different arguments. This sounds alot like some homework... __________________ Don't worry Ma'am, We're university students, We know what We're doing. ----- If you pull the pin, Mr.Grenade would no longer be your friend. ----- 01000111 01101111 00100000 01000011 00100000 00100001