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 Replies


ADVERTISEMENT

General :: Finding Customer Who Spent The Most

Sep 2, 2014

I am working on a database at the moment to try and find the customer that has spent the most money. At the moment i can only get the customers that have placed the most orders. I have a dispatch table that consists of all the orders and a customer table that are linked using a Customer Number. Each order has a dispatch number because one customer can buy more than one product per order. Like i said at the start I'm trying to find the customer that has spent the most money but the top 10 would be better.

View 7 Replies View Related

Record Time Spent Task?

Jul 9, 2014

I am using the Issues Template Database and would like to add a function to it.

I would like to record each time spent task/ action when working on an issue.

For example:
Tasks
- Email
- Phone Call
- Report

So, say I wanted to add one Report- time taken 30mins and record that then on an another day, Email- 10mins So record each task and time taken.

View 1 Replies View Related

Working Out Total Time Spent (In A Query)

Apr 8, 2008

In My Db I have TblSupportTickets and a Table which records support ticket activity. When adding a new activity detail to the Db it automatically records when the FrmActivityDetail opens and on closing, it records the time the Form was closed. So in TblSupportTickets which relates by ID to TblSupportTicketActivity on a one-to-many relationship.

I then created a query with SupportTicketID, TimeOpen, Time Closed. SupportTicketID criteria is Forms.FrmSupportTicket.txtSupportTicketID

This lists all the time open's and timeclosed's for that support ticket.

how can I work out the total time spent on that support ticket?

View 5 Replies View Related

General :: How To Get Total Spent Hours In Office For The Employee

Jan 28, 2014

I am facing one problem while calculating the number of hours an employee spent in the office. Each employee will have a swipe card and the swipe data is stored in an .mdb file. Some employees will have different shifts and may come after 6pm and will go next day 5 am , while calculating their spent hours getting the problem. The swipe data is stored in IOData table , I wrote a simple query below to get the data., it is calculating correctly for the employees who come in between 11AM to 8PM but who are coming after 6PM and going next day , facing problem. Time is storing in 24 hour format in table with Status as Entry,Exit . There may be any no.of exits and entries , so i took min and max of the time in the below query.

I am attaching the mdb file data in an excel sheet(Master_Data.xls) and also the data of the below query(Swipe_Data.xls) and highlighting the employee for which we got problem.

SELECT HD.JobTitle, HD.HolderName, IO.IODate,IO.IOStatus, min(IO.IOTime), max(IO.IOTime), DateDiff("n", min(IO.IOTime), max(IO.IOTime)) AS Minutes, [Minutes] 60 & Format([Minutes] Mod 60, ":00")
FROM HolderData AS HD, IOData AS IO
WHERE HD.HolderNo = IO.HolderNo and
HD.DepartmentNo IN ('0008', '0009') and
IO.IODate between #01/20/2014# and #01/24/2014#
GROUP BY HD.JobTitle, HD.HolderName, IO.IODate,IO.IOStatus;

View 3 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 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 1 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

Queries :: Tracking Time Spent On Customers Records Based On Date Of Entry

Apr 17, 2014

I have two tables, One table containes customer name, etc., tblcustomers the other table contains the tbltimelog, log of activity start time end time. No issues. I want to generate a form based on the dateofentry for the time record. I am not able to get a summary lets say I spent 20 hours on ABC and 20 hours on CBS. If I spent 3 different days on ABC and 6 different days on CBS it will not add them together it will list it ABC 3 times and CBS 6 times. I have tried the distinct function but it doesn't work because the date is distinct. Is there a way to do this as an SQL or whatever. Thinking I could just create a new table and calculating the totals but that seems to be a waste.

View 3 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







Copyrights 2005-15 www.BigResource.com, All rights reserved