Access MS Access Time & Billing "total payments" question

S

sklnxbones

Joined
Jun 28, 2012
Messages
1
Reaction score
0
I have downloaded the MS Access Time & Billing Template from Microsoft. I have started to add data. I have 2 clients I am billing for. I have been using the template for two months (2 billing cycles) Here is my question...

When I run an Invoice it shows all the amounts billed, minus the payments, then the amount owed. The math is correct but I don't like the way it looks.

I want to only show the amounts for the current billing cycle. I have tried to filter by current month only and it still shows all the billable amounts, minus the payments, then the total...

Can any one tell me how to get ONLY the billable amounts for one month, and remove the previous months billable amounts and payments????

Thanks so much,

Sklnxbones (Skull & Cross Bones)
 
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Example database or spreadsheet for Billing Projections by month? 1
Show Billing Period 3
Remaining Balance Query 2
Access Default Microsoft Access Order Entry database issue 0
Need help inserting comment box into Access invoice report 1
Access MS Access - Is this possible? 1
Errors in Report total fields 19
Designing a Query or Text Box 5

Top