Thanks for your reply.
I am unable to find any proper logic for my problem.
And well thats the problem:).
I am tried using "Quarter" function but it only gives
the the quarter number such as April is in 2nd
quarter.
Please help.
Shally.
--- Chris Maloney <[EMAIL PROTECTED]> wrote:
> Considering you didn't paste any errors that you
> have received with this the
> first thing I suggest you do is change the name of
> your date field from
> 'Date' to something else like 'myDate'. 'Date' is a
> reserved word in SQL and
> frequently causes problems because Access will not
> warn you of this when you
> are creating a table.
>
> Chris
>
> -----Original Message-----
> From: Shally [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 26, 2001 10:05 AM
> To: CF-Talk
> Subject: Report
>
>
> Hi Every one,
> I have an access table having 3 fields Date,
> Quantity
> and Amount.
> I am working on a report where I have to calculate
> the
> Quantity and Amount on quarterly bases for last year
> and this year.
> I tried using the function "Quarter" but an unable
> to
> reach any solution.Please help!!
>
> Thanks in advance
> Shally.
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
