Monthly Expense Query

[twychopen22]

I have attatched a word document showing values and what I need. I want to create queries (monthly, quarterly, semi-anually, yearly). I am working with the monthly right now and if I can figure that out I am assuming I will be able to figure the others out the same way. For the monthly report I want to divide the quarterly amounts by 3, semi yearly amounts by 6, and yearly amounts by 12. Then I want their respective values to appear in the monthly statement. How do I do this?

 

[Lister]

Write a Function and set the values of the Check Boxes as criteria with in a Select Statment to devide the value into which ever amount is True.

Yes I could write the function for you but come on put some effort in.

You should look at Functions and Select Case statments. The rest is easy.
You should also look at doing this per item in a form, not through a query window when it gose live for your users.

See how you get on.