help with reports

[dang]

I have a table with the following field:

award number(text), mod number(text), award date(date), completion
date(date), dollar value(number), current mod value(number)

here are a few data inputs: (we have base contract and we have mods)

award number=ABC123
mod=0
award date=10/20/2004
completion date=9/30/2005
dollar value=$1000

award number=ABC123
mod=1
award date=11/20/2004
completion date=10/30/2005
current mod value=$250

award number=ABC123
mod=2
award date=12/20/2004
completion date=11/30/2005
current mod value=$400

award number=DEF456
mod=0
award date=12/20/2004
completion date=11/30/2005
dollar value=$400


------------------
ok, here is my question:

how do i produe a report that:

a) add up all the base contract (dollar value) and the mods (current mod
value)and come up with a total award value as one record?
b) update the completion date with the latest mod on that same record?
c) the award date should be the base contract award date on the same record


the report should look like this:

Award Number: ABC123
Award Date: 10/20/2004
Completion Date: 11/30/2005
Total Award Value: $1650

Award Number: DEF456
Award Date: 12/20/2004
Completion Date: 11/30/2005
Total Award Value: $400


does it make any sense? please help. thanks

 

[Martin J]

Make a query and use the summation button(looks like a sideways 'M') then put
award #, your 2 dates and amount as your 4 fields. in the total row group by
award the dates should be either min max or first last didn't totally
understand what you want there. Use sum for amount. Then use this query as
your record source.

HTH
Martin J