Forum Discussion
Bills Paid Database
Hi there: I’m using Access 2016. I started database for bill payments. In that database i have a first table called Bills where I have fields concerning my bills, including a BillID field, DueDate,...
Thanks! That certainly works better than anything I’ve been able to come up with on my own.
However, for some reason it is not returning all expected records.
So far, I only notice my mortgage Bill is missing from the results. It is due on the 1st of each month. And my next payday is on September 3rd. So, the mortgage bill should be showing up in the results, but doesn’t.
However, for some reason it is not returning all expected records.
So far, I only notice my mortgage Bill is missing from the results. It is due on the 1st of each month. And my next payday is on September 3rd. So, the mortgage bill should be showing up in the results, but doesn’t.
The last time I paid it was on September 1, 2020.
Here it is. Please let me know if there are any issues with opening it.
Try compressing the accdb into a ZIP file for upload.
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 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.
- Can somebody answer my question.
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. 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);>
- Actually, I realized that the results of this query only includes bills for which there is no previous payment history at all.
- Also, how do I handle the situation when I add a nee bill that doesn’t have any payment history?
