Query problem

[puppychew]

I think I got it - If I do a group by and enter "first" for the date group and in the criteria put "is not null", I will get not get duplicate projects. Then I can do a sum for the amount column.

[jbarrum]

ah, then I think your former suggestion was correct. Build your summary query based on a query that excludes recoreds who's date is null.

[puppychew]

I think I got it now. If I do a query with "first" as a group and "is not null" I will get what I need with the sum of the amount.

Would like to add a running total column - is that possible?

[jbarrum]

Then your former idea was correct. Build a query excluding those records with no date and them build your summary query off of that query.

[puppychew]

great - thanks for your help!

[jbarrum]

you're welcome