Forum Discussion
Bills Paid Database
This is my code exactly:
<
SELECT b.Description, b.BillerID, b.Amount, b.DueDay
FROM Bills AS b LEFT JOIN Payments AS p ON b.BillerID = p.BillerID
WHERE ((((SELECT DateAdd("m",1,DateSerial( Year(MAX(PaidDate)), Month(MAX(PaidDate)), b.DueDay)) FROM Payments GROUP BY p.paiddate))<=(SELECT TOP 1 IncomeDate FROM IncomeSchedule WHERE IncomeDate >= Date() ORDER BY IncomeDate))) AND (p.BillerID Is Null);
>
I’d like to fix this query. I have been using Mint.com to stay on top of my bill payments.
However, I realize that sometimes, a bill that’s due will not come up in the bills due list, which is an unfortunate thing and makes me lose trust in the that application.
Try compressing the accdb into a ZIP file for upload.
Here it is. Please let me know if there are any issues with opening it.
Okay, sometimes it helps to see actual data, along with samples of what you want to see as the output. That way we can possibly see details that might be missed in a summary of the sort we can put into a description.
You can attach a sample accdb with sanitized data for that purpose.
Hi George:
(I tried to upload the database, but I get the following error: "The attachment's billssanatized20201029.accdb content type (application/msaccess) does not match its file extension and has been removed.").
I tried to respond earlier, but I was not feeling well, and my response did not go through correctly.
The query I'm trying to correct is called "QueryInProcess". With this query, I'd like to analyze at "Bills", "Payments", and "IncomeSchedule" tables and return all Bills that are due and unpaid (or overdue) between current date and the next payday (see "IncomeDate" field in the "IncomeSchedule" table).
If I can figure this out, I'll get a better idea of how much discretionary income I have left until next pay check.
A sample output (not actual data) would look like this:
<<Description>> <<BillerID>> <<Amount>> <<Due Day>> Card 1 1 $30 31 Phone 2 $50 1
