Budget Calculator

Jul 1, 2005

I have a table that a created to calculate a running balance.

Fields look like this.

Desc = Text - Description of transaction
Type = Text - Combo Box Debit or Credit on Form
Amount = Currency - Obvious
Date = Date/Time - Obvious

I have two questions. In my form I have the combo box for debit/credit. I want to have the amount field to be either negative or positive depending upon what is selected for the type field.

Secondly, I would like to create a running amount. I have a field in my form for the amount. How would I link it up to create an amount.

Thanks

View Replies

Pop Up A Calculator

Jul 19, 2006

Is it possible for me to have a Query that pulls up the information I need and then it automatically starts up the windows calculator?

IE: information comes up then the calculator pops up so you can do calculations based on the information being shown.

View 3 Replies View Related

Modules & VBA :: Shell Function To Open Calculator

Dec 17, 2014

I want to open the Calculator by clicking a command button (using the On Click event).

I have tried the code below but can't get it working. What do I need to change?

Private Sub Command7_Click()
Dim RetVal As Integer
RetVal = Shell("C:Windowscalc.exe", 1)
End Sub

View 2 Replies View Related

Queries :: Incentive Calculator - Creating X Amount Of Rows In Append

May 12, 2015

View 4 Replies View Related

Budget Issue

Feb 3, 2008

Hello, I am using MS Access 2003 and creating a inventory management database for a Hotel Chain. However, i am a bit lost on creating a budget for each hotel in the chain, as each hotel has a bugdet of say �200,000, and each time an order takes place it must take this away. If anyone has any ideas...

Thanks

View 10 Replies View Related

Budget Less Spent

Dec 9, 2005

I am using Access 2003 and am in the process of building a database for the process of recording invoices there are three properties one of which has three schedules.

I have created a query that has budget amounts.

Another query that brings up the amount spent by code.

What I want to do is have the budget figures with the amount spent by code beside it, I can do this but it does not include any items which have zero spent in them so far.

Any pointers regardless of how simple they sound would be gratefully recieved I am newish to building databases.

Thanks

View 2 Replies View Related

Budget Management Program

Oct 12, 2005

I'm just wondering if anyone has made a very advanced budget management program using just access?? I tried to make one for myself but I just want it to advanced for my little knowledge of access. I would love to be able to keep track of all my expenses including everything bought from groceries to hair cuts. I would love to be able to take my receipt from walmart and enter everything bought and the price for each item. Then I would love to be able to at anytime search for soap and thing with soap in the Item name will be displayed with the location and the date and price. This way I can keep track not just what I spend on groceries but what I spend on mountain dew or what i spend on hamburger in a given time. This is just way to complicated for me! I hope someone can help me out here maybe give me a shell and let me try to fill in certain parts or if someone already has one that works kind of like this maybe i could just change a few things to the way i want it! I really appreciate this!!

Bass

View 4 Replies View Related

Tables :: Database To Track Budget Changes Within Organizations

Sep 19, 2013

I am new in Access 2010 and need table design schema. I am creating a database to track budget changes within our organizations.

1. We have 3 division (West, East and Central).
2. Each division will have 5 Organizations (Office, Campus, Operations, IT and HR)
3. Each Organizations will have multiple sub-organizations
4. The budget start with the sub-organizations - which is break down by cost center and sub cost center.

This is the design I came up.

tblFiscalYear
tblDivision
tblOrganizations
tblSubOrganizations
tblCostCenter
tblsubcostcenter (budget table)

tblDivision --1 to Many --> tblOrganizations

tblOrganizations --1 to Many --> tblsuborganizations

tblsuborganizations --1 to many --> tblCostCenter

tblCostCenter --1 to many --> tblsubcostcenter

Is there a better way to design this?

View 4 Replies View Related

12 Months Budget With Evenly Distributed Numbers

Jul 13, 2012

I am dealing with 12 months budget with all evenly distributed numbers. However, there are some departments have unevenly distributed numbers for 12 months. I would like to take out the rows with unevenly numbers. how should I do it? Or what criteria? I am a basic Access user.

View 1 Replies View Related

Aggregate Function In MS Access Does Not Work In Budget Program

Aug 3, 2013

I am trying to prepare a mini budget program in ms access for my personal use in my office , but every time i fail to do so, my tables are as under

Field Name Properties
Code ID AutoNumber
001 Cash
002 Bank
846 conveyence
dt: Date/time
Code text (list selected by drop-down list)
des Description
Bill currency
yearly Budget currency
quartlyBudget currency

Query Question:

Group Aggregate function in my Budget data base file

(A) (B) (C) (D) (E)
Code yearlyBudget quaterlyBudget quaterlyused Budget Available Budget
846 50000 12500 5000 7500
850 100000 25000 20000 5000

There are 100 entries in code no. 846 and 50 entries in code no.850 the above given amount is total of each code no.

My question is that how can i get result subtracting amount in column (D) from column (C) to get result in column (C)

Budget Available: in Code 846 i.e column (E)

View 3 Replies View Related

Forms :: Budget Tracking Database - Running Balance On Form

Mar 15, 2015

I have a database tracking a budget. It is like a cash boom. I have deposit and make payments. Supplier, invoice# etc. I would like my form to show a running balance of my deposits and expenditure.

View 3 Replies View Related

Tables :: Budget Database - Autonumber Field Is Not In Record Source Dropdown

Sep 20, 2012

I created a table in a budget database without a autonumber field. I then inserted a autonumber field after creating the form by inserting a row in the table which works fine in the table, now i want to use a text box on the form with BudgetID from the autonumber field to give me the total amount of records in the database but the autonumber field is not in the record source dropdown.

View 5 Replies View Related

Queries :: Create Update Query To Budget Table Using Access Design View?

Feb 17, 2015

trying to create an update query to Budget table using the Access Design View:

Field: PctSls (in tblBudget) Update to: [Expense] / [Sales]. The update query always returns 0. However, if I create a Select query using the same calculation, the correct results is displayed. PctSls is defined in the Budget table.

I haven't worked with Access (2003) for several years but this seems too simple to be causing me such frustration. (Was only a casual user even then).

View 6 Replies View Related