Overwie

[Sgt_Bear]

Hello

I have the following problem. I have a Budget Database created where i can set the vaule of my bankaccount and made a form where i can type the cost of anything and select a category of the cost e.g. Vehicle, House or something else.

Now i wanna to create a Site where i can see the summary of costs for every category. I wanna have one per month. e.g. Vehicle cost of August 11 = 1500$, and one for the Year e.g. Vehicle costs until now = 10000$

How can i make something like that? Can somebody help me?



If you need more details, tell me.

Thanks
Sgt_Bear

[June7]

What do you mean by Site?

Build a report using Grouping & Sorting with summary calcs. Access Help has guidelines on building reports using these features.

[Sgt_Bear]

I mean like a Form, i would like to display a category and see a summary of every single month. and at the bottom i wanna have a field with the total summary of the year.

Like this:

 
Category (dropdown) : e.g. Vehicle
 
January:
February:
March: 
...
...
 
Total 2011:

[dreday]

If you want to do it in a form you'll need to get a query that does the total for each month and bind it to a continuous form that shows the month and total. To get the year total you'll need an unbound textbox in the form header or footer with a default value of the sum([whatever your price textbox is called])

[Sgt_Bear]

Thank you. So now i have createt a Query who make's totals for each month's. But can you tell me how i can make a Form who doesn't display the records whit the arrows on the bottom? I wanna to have a field to select de Type of Cost in a Dropdown, and then the content is called up. How can i make this?

[dreday]

Yeah, they are called navigation buttons. There is a form property for this, set it to No or Off and the arrows will disappear.

You can also make the control source of a dropdown box the same query and set the display column to which ever field you want to appear in the dropdown. In the OnChange or AfterUpdate event you can program your form filter. Something like:

me.filter = "Month =" & [dropdown name]

Hope this helps