W
WildlyHarry
I have a table that contains transactions amounts, transaction codes, and
dates. I have created a Cross Tab query that that has the Transaction Code
and the Row Heading, the Date as the Column heading, and the Transaction
Amount as the value (summed). My goal is a to produce a query that shows the
Sum Transaction amount by code and date. The issue I have is that when I
have a duplicate transaction amount on the same day, which is very frequent,
the Transaction Amount does not sum all of the duplicates. If the amounts
are different, they are added. If they are the same, the query only displays
in the first one from the table. How can I get it to sum all transactions
for that date and code regardless of amount? Thanks in advance for you help.
dates. I have created a Cross Tab query that that has the Transaction Code
and the Row Heading, the Date as the Column heading, and the Transaction
Amount as the value (summed). My goal is a to produce a query that shows the
Sum Transaction amount by code and date. The issue I have is that when I
have a duplicate transaction amount on the same day, which is very frequent,
the Transaction Amount does not sum all of the duplicates. If the amounts
are different, they are added. If they are the same, the query only displays
in the first one from the table. How can I get it to sum all transactions
for that date and code regardless of amount? Thanks in advance for you help.