Hello,

I'm trying to create a database for issue tracking and i can't seem to get subtotals to end up the way i want them too. I'm trying to create lists/records associated with a specific number but it ends up adding them together.

example: I have 4 & 5. 4 has 3 journals w/ decimal-time associated with it, 5 has 2 with decimal-time on it. Instead of grouping times for 4's together it subtotals everything together.

sql statement should look some what like this

select id#, sum(amountoftime), date

from table workdone

where id# = "4"

I believe FMP uses C#, but my C# is newb to non-existent.

Sorry if this doesn't make sense, but i'm pretty new to everything in general. Thanks for the help ahead of time.

Edited February 17, 200917 yr by Guest

Create a subsummary report grouped by whatever field that 4, 5 are entered into. You will need to sort by this field. If you use the wizard to create the report, it will prompt you to create a script.

Thanks a bunch it works the way i wanted it to now. The only thing that's not working right is the totals for a month. I'm trying things sorted my months, is this possible?

Yes just add another subsummary part that is grouped and sorted by the month.