Oma,
You have a handle on what I am trying to do so I might as well talk actual
instead of colq,colc, etc. It will be less confusing on my end.
Yes, your column, report, and table assumptions are correct. Actuals are -
COLUMNS
typeid TYPE
prjqty QUANTITY
trarate COST
prjdate DATE
REPORT Prints
prjdate prjqty trarate vtotal (which is (prjqty*trarate))
TABLE Contains
typeid (which contains A, B, C, .......?)
YOUR QUESTIONS
1. Define the date range that is required? Sorry, guess I don't understand
this.
2. Are the between dates defined by entry before the report is run? The
between dates for printing/viewing would be defined at time of running the
report and would be in the range of dates in prjdate.
3. Are between dates part of the where for printing the report? Yes.
Jim
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Oma Cox
> Sent: Wednesday, June 06, 2001 8:02 PM
> To: [EMAIL PROTECTED]
> Subject: RE: Report Totals
> <I failed to mention that I need to meet the where condition "between two
> dates" where the computation is performed for both A and B
> rather than use
> all values for A and B types from the table, and I haven't been able to
> figure out how to incorporate such a condition into the vtot variable
> calculation>
>
>Jim
> Don't give up yet! I've have a few questions!
> Are these conditions right?
>
> You have a table with ColT,(Type),ColQ(Qty),ColC(Cost),ColD(Date)
> You have a report that print ColD,ColQ,ColC,Vtotal(ColQ*ColC)
> You have in the table ColT has values A & B etc.
>
> Define the date range that is required?
> Are the between dates defined by entry before the report is run?
> Are between dates part of the where for printing the report?
>
>
> Fishing?
> (I'm off my porch)
>
> Oma
>
>
>
