Re: Total of a field , without relationship
no can do.
I you want to visually see a total on a report, then look at the report. but if you need an actual field, you would need to make a dummy table just to hold the Total(s) that you want.
For example, new table called Sales Totals. make a single record in it. It will be [Record ID#] of 1.
Then lock it down so no one cal add another record.
Then on the sales table make a formula numeric field with a formula of 1. It will calculate, not surprisingly to 1.
Then make a relationship based on that field and make your Totals Summary field(s) and then look them up back down to the Sales table.
There is no =SUMIF like Excel has.
I you want to visually see a total on a report, then look at the report. but if you need an actual field, you would need to make a dummy table just to hold the Total(s) that you want.
For example, new table called Sales Totals. make a single record in it. It will be [Record ID#] of 1.
Then lock it down so no one cal add another record.
Then on the sales table make a formula numeric field with a formula of 1. It will calculate, not surprisingly to 1.
Then make a relationship based on that field and make your Totals Summary field(s) and then look them up back down to the Sales table.
There is no =SUMIF like Excel has.
