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,...
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 |
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.