August 28, 2021

Lost Your WordPress Password? Here Are Six Quick & Beginner-Friendly Solutions to Your Problem

We know the struggle of having 20 social media accounts, from personal to business ones, emails, sites, and so on. Especially nowadays, once you are logged in on your smartphone, you do not need to...

The post Lost Your WordPress Password? Here Are Six Quick & Beginner-Friendly Solutions to Your Problem appeared first on 85ideas.com.

August 28, 2021

Get Net Income from Income and Expenditure Tables by Date

I want to be able to write an SQL statement that pulls the sum of revenue and expenditure for each day and gets net income for each day with the distinct dates available in the Income and Expenditure tables. I have tried the following statement, but I'm not getting the desired result. I'm using MS Access.

SELECT
    Income.IncomeDate,
    SUM(Income.AmountPaid) AS IncomeAmount,
    Expenditure.ExpenseDate,
    SUM(Expenditure.TotalAmount) AS ExpenseAmount,
    IncomeAmount - ExpenseAmount AS NetIncome
FROM Income FULL OUTER JOIN Expenditure ON Income.IncomeDate=Expenditure.ExpenseDate
GROUP BY Income.IncomeDate
ORDER BY Income.IncomeDate