Sum fields depending on date

[Vegard]

This question needs an expert... I think!

On a form. Three different orders.. Prestudy, Fixed Price and Reimbursable.

POrder ($ for Prestudy) PDate (date for expected order)
FOrder - FDate
ROrder - RDate

Ok. now the question.

I want to create a report that sums POrder, FOrder and ROrder depending on their dates. Let's say POrder and ROrder are expected i Quarter2 and FOrder in Quarter3.

How can I create a report for just POrder and ROrder (quarter 2)

vegard.

 

[RV]

>Three different orders.. Prestudy, Fixed Price and Reimbursable<

Can you tell which columns and which table(s) your form is based on?

RV

 

[Vegard]

My form is based on tblProspect. I've just called the three different ordertypes by changing the first letter of the field. POrder for Prestudy order etc..
PDate for date for expected order for POrder

It's not really three different orders, but it's three stages of the main order.

I'm really cracked up now.. Can't really see how this is suppose to work.

Vegard.