How to total horizontally vs vertically

[williamr]

I have a table with 5 fields, a date and 6 currency fields. For each record I want to total the money spend. Like 02/02/2022 100-50-200-300-500-150. A field with 1300 I can total, say 12 records vertically for each field but can seem to make it work for each record.

Thanks


DKWID (Don't know what I'm doing)

[June7]

Arithmetic. F1 + F2 + F3 + F4 + F5 + F6.

However, arithmetic with Null returns Null. If any field is Null the expression will return Null. Can deal with null using Nz().

Nz(F1,0)

[ArviLaanemets]

This looks suspiciously like an Excel table ported into Access database!

Try instead a table structure like (I assume the date is unique in your table, so every combination of EntryDate and EntryType is unique):
EntryID, EntryDate, EntryType, Amount, where Entrytype determines, with which currency field in your current design the entry matches.
Using your example data:
1, 02/02/2022, 1, 100
2, 02/02/2022, 2, 50
3, 02/02/2022, 3, 200
4, 02/02/2022, 4, 500
5, 02/02/2022, 5, 150

Now, total of every EntryDate will be calculated as

SELECT EntryDate, SUM(Amount) As EntrySum GROUP BY EntryDate

Total of any combination of EntryType's will be calculated as:

SELECT EntryDate, SUM(Amount) As EntrySum WHERE EntryType IN (TypeLis) GROUP BY EntryDate
like
SELECT EntryDate, SUM(Amount) As EntrySum WHERE EntryType IN (1) GROUP BY EntryDate
or
SELECT EntryDate, SUM(Amount) As EntrySum WHERE EntryType IN (1,3,6) GROUP BY EntryDate

And forget about rows! In Access it is practically an undetermined value! In your example, you have date as ID, and in which row this date is displayed depends on lot of conditions!