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
