help with reports

[dangtran09]

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

 

[mdemarte]

grouping

You want to group your items together, using a Select Query where you Total. Based on your sample data, it should be sorted by Award Number, by Mod, using these values:

First value of Award Number
First value of Award Date
Last value of Completion Date
Sum of Dollar Value

Then, use these to create your report.

HTH