General :: How To Set Monthly Depreciation - Calculate Current Value

Jan 19, 2015

Is it possible to set an access database to take a depreciation value of lets say 10.00, and subtract this from the current value every month?

So far my database has a form where you can input the depreciable life, purchase price, current value and total depreciation. However the date and amount of depreciation has to be added manually into a data table for the text boxs to calculate how much it has depreciated and the current value.

View Replies


ADVERTISEMENT

General :: Calculate Deposit Amount For Current Month - DSUM With Multiple Criteria

Mar 23, 2013

I am trying to get deposit amount for the current month but results are in accurate i am using this

DSum("[Amount]","[income]"," [trans_type] = 'deposit'" AND "Month([dep_date]) =" & Month(Now()) AND " Year([dep_date]) =" & year(Now()))

View 3 Replies View Related

Queries :: Calculate Fee For Each Student On Monthly Basis

Jul 23, 2013

Me having a db which is having a student table which is keeping all student info, second i have a Van table which is keeping van info. I wanted to know how it is possible to calculate monthly van fee for each student on monthly basis which db do it itself based on system date/time and calculate monthly required fee for each student. I also would like to know that if a student do not pay in a month then checking the next month or checking unpaid student through date criteria it displays all due amount may be in sum.

View 2 Replies View Related

Queries :: Running Total To Calculate Uptime Monthly

Jul 1, 2013

I am having trouble with this running total. Let's say I have a well. I am trying to create a running total that calculates the total Uptime (or hours operational) for each well every month.

I attached a PDF with an example of what I am working with.

View 10 Replies View Related

Modules & VBA :: Monthly Payment - Create A Worksheet Which Calculate Balance

Mar 3, 2014

I'm currently stuck on trying to create a worksheet which calculate the balance remaining at the end of each Monthly Payment Period.

Monthly Payment Period: 1 to 300

Initial Balance: balance outstanding at the beginning of the Monthly Payment Period.

Interest: calculated by multiplying the Initial Balance by the APR (5%) divided by 12

Balance Remaining: calculated by adding the Interest and subtracting Total Monthly Payment.

The final Balance Remaining should be exactly £0.00.

View 1 Replies View Related

Forms :: Worksheet That Calculate Balance Remaining At The End Of Each Monthly Payment Period

Mar 3, 2014

I'm currently stuck on trying to create a worksheet which calculate the balance remaining at the end of each Monthly Payment Period.

Monthly Payment Period: 1 to 300

Initial Balance: balance outstanding at the beginning of the Monthly Payment Period.

Interest: calculated by multiplying the Initial Balance by the APR (5%) divided by 12

Balance Remaining: calculated by adding the Interest and subtracting Total Monthly Payment.

The final Balance Remaining should be exactly £0.00.

View 6 Replies View Related

How To Calculate The Accumulate Value Of The Current Field

Jan 21, 2005

If I have the field name as below:

Oil quantity
Accumulate Oil quantity
Date
Recordnumber


I want to get value of "Accumulate oil quantity" of current record to be equal to sum of "Oil quantity" from first record till the current record:

Let say
after I input "oil quantity" in the record # 1 ,2 & 3
The "Accumulate oil quantity" of record value show below:

"Accumulate oil quantity" of record#1 = "Oil quantity" of record#1
"Accumulate oil quantity" of record#2 = "Oil quantity" of record#1 + "Oil quantity" of record#2
"Accumulate oil quantity" of record#3 = "Oil quantity" of record#1 + "Oil quantity" of record#2+"Oil quantity" of record#3

Anyone know , please help
Thank you so much

View 1 Replies View Related

How To Calculate Current Balance On Hand

Sep 3, 2012

my details input as per below;

1) table 'Receiving' (Part#,Qty received,date received)

2) table 'Issuance' (Part#,Qty issued, date issued)

How to calculate current stock on-hand?

*previously this report are using ms excel table. i just tried to convert into access since i will have a better view, will a separate form to fill up, will have a report to pull in(hopefully... current on hand )

View 11 Replies View Related

Modules & VBA :: Calculation - Subtract Monthly Installment From Loan Amount On Monthly Basis

Apr 22, 2015

I have a query for loan calculation, fields are;

Loanamount
loandate
monthlyinstalment

what i want is that query to start subtracting lmonthlyinstalment from loanamount on monthly basis

View 3 Replies View Related

Queries :: Take Current Date And Calculate Last Day Of Last Month?

May 16, 2013

Is there a way to take today's date and calculate the last day of the last month? Without the user needing to enter any parameters. In other words, if I ran the query today with this criteria, it would only show information for April 30, 2013. Is that possible?

View 3 Replies View Related

Queries :: How To Calculate Current Stock (Actual Quantity)

Oct 18, 2014

I have a query (Inventory Transactions Extended) in which i am trying to caculate current stock.

I have a form (Inventory Transactions Form) where i either add or remove Inventory Items.

I have used this statement to create a new field (Actual Quantity) to calculate current stock based on stock been added and removed:

Code:
Actual Quantity: IIf([Transaction Types].[Add/Remove]="Addition";[Inventory Transactions]![Quantity];-([Inventory Transactions]![Quantity]))

for some reason it does not work. It is not calculating current stock. If i remove stock it shows a negative amount based on the amount i removed, and when i add stock it shows a positive amount based on what i added

I have attached a sample.
[ATTACH][/ATTACH]
Sample.accdb

View 2 Replies View Related

General :: Setting Monthly Reminder Using Outlook

Jun 22, 2015

I'm working on an access database and I need to connect that database to the reminder function of Outlook.

At first, I set the reminder precisely six months before the due date, everything was okay and the reminder worked. But after some revision required by my supervisor, I need to set the reminder based on month (not exactly on the due date), so the tasks which have due dates in the same month will be wrapped into a single reminder. The reminder also should be appear in every two weeks. Here's the code I've been worked on :

Code:
Private Sub Expired_AfterUpdate()
Dim outLookApp As Outlook.Application
Dim outLookTask As Outlook.TaskItem
Set outLookApp = CreateObject("outlook.application")
Set outLookTask = outLookApp.CreateItem(olTaskItem)

[Code]...

I put this code on the AfterUpdate event in the column containing the due date. How should I rearrange the code so it would be able for the reminder to appear based on the month? (just consider that the reminder will be active six months before due date).

View 4 Replies View Related

General :: Crosstab Average Monthly Demand

Jul 29, 2014

My database has a crosstab query that counts the number of hits by month. I have two columns that are named "Count of Material"(Frequency) and "Sum of ordered Qty"(Total ordered). I need add a colum to find the Average Monthly Demand by dividing the Total ordered/Frequency/number of months in the query. I have tried everything to make it work but can't.

View 8 Replies View Related

Queries :: Calculate New Fields Based On Current And Prior Year-end Numbers

May 6, 2013

I am creating a Make Table Query and calculating new fields based on current and prior year-end numbers. If the prior year-end number does not exist (Is Null), I want the use the current rate or calculate the change in rate. I have typed the below in the Field Box:

CHG_IN_PGM_RATE: IIf(([P0_10 Tbl - AM PYE PTD Detail w Rates]![PTD_PYE_PGM_RATE]) Is Null,([MASTER LIST CURRENT]![PTD_PM_PGM_RATE]),(([MASTER LIST CURRENT]![PTD_PM_PGM_RATE])-([P0_10 Tbl - AM PYE PTD Detail w Rates]![PTD_PYE_PGM_RATE])))

However, when running the query, I get the attached error message.

The screenshot will also show how the two tables are joined.

View 2 Replies View Related

IIF Statement - Calculate Value Based On Comparing Current Date To Dates In Fields

Jun 27, 2013

In my table I have the following 4 fields with the associated date field:

Bronze: 11/1/2013
Silver: 5/1/2014
Gold: 11/1/2014
Platinum: 5/1/2015

I am trying to calculate a value based on comparing the current date to the dates in these fields. I am using the below formula. However, using 6/27/2013 as the current date, my formula keeps resulting in "Bronze" when it should result in "Standard" Am I doing something wrong?

=IIf(Date()<[Bronze],"Standard",IIf((Date()>=[Bronze]) And (Date()<[Silver]),"Bronze",IIf(Date()>=[Silver] And Date()<[Gold],"Silver",IIf(Date()>=[Gold] And Date()<[Platinum],"Gold","Platinum"))))

View 5 Replies View Related

General :: Database That Track Monthly Metrics Of Employees

Jun 15, 2014

I'm developing a database that tracks monthly metrics of employees. These employee are at several different locations.

Here's what I would like:

A table of the employees and their location.

A table of the metrics.

A form that you can select an employee and it would autofill the location and then you could fill out the metrics.
the ability to change an employee's location without it effecting past records.

A report, by month and location of the employee's metrics. (pretty sure I can do this on my own, just can't get to this point.)

I've tried to use a auto lookup query but that then changes the employees location on past records.

View 4 Replies View Related

General :: Changing Existing Database From Overall To Monthly Records

Nov 8, 2013

I'm altering a database to have certain fields be recorded monthly.For example: instead of a client's file having "Total X Purchased" it would now be "Total X Purchased - Jan", "Total X Purchaed - Feb".

I want to spin the monthlies out of the master clients table & in to ex. tbl_clientsJan, tbl_clientsFeb, etc. but still have them linked; & have a "Totals" table that aggregates data from all of the tables (adds them up).

I have an existing form, & I was thinking of just creating tabs for the months & subforms in each with their sources as the month tables, & removing the fields that don't change month-to-month (e.g. client name), with relationships between them. I would start by copying all of the master table data in to the month tables & allowing edits from there.

the company doesn't track when the transactions occurred; I'm unable to group them along those lines.I'm new to Access & don't want to make a mistake.

View 9 Replies View Related

General :: Production Schedule Output To Monthly Calendar

Apr 13, 2013

I need to make a report that shows a work schedule for 10 employees. I need it to print in a monthyly calendar format with horizontal lines to show start and end date and time. I need it to show that there is or is not any overlap for that machine."

It has been a while since I have created a DB and I get some of this okay. So far I think I need three tables. One is the machines. Two is the product schedule (how long it takes to produce X number of products). The last would be work orders and that pretty much covers the data.

I think most of the data can be maniputated by queries and that is even done on the report. The report as we all know is the reason for a database. If it was just about the data it would be simpler to do a spreadsheet. It could get fancy and make a pivot table. That output can be a calendar of sorts.

View 2 Replies View Related

Queries :: Include Date Criteria In User Defined Function That Calculate End Of Current Month

Jul 22, 2014

I have written a user defined function that calculates the end of the current month. This I named EndOfThisMonth. It works well as a function. Now I would like to use it as date criteria to include in a query. The function is included as such EndOfThisMonth().

The field on which this function is to enter as a criteria is another calculated date function called Due.

When I run this query I get an error message saying Undefined Function 'EndOfThisMonth' in expression.

View 3 Replies View Related

General :: Payment Database - Monthly / Annual Renewal Popup Message

Mar 20, 2013

I am creating payment database for a community gym, the data will be created on a data sheet.

There are 2 payment types monthly and annual (these are on a dropdown box with their own id number).

I have a joining date and a paid date, but reflected against the payment type ie 31 days or 365 days.

I have been trying to do something along the lines of:

if [monthly] (is selected) (so this would call up a 31days) date() is > [joining date] then give message to renew and same kinda thing for annual.

View 1 Replies View Related

General :: Monthly Cleaning Program - Crosstab Query To Generate A Report

Jun 12, 2012

I want to create a report for the Monthly cleaning plan of a hotel. For each day, how many rooms need new sheets, how many need new towels etc.

At this point I can generate a report for any given day.

This could be an example of what I want to achieve

Code:
------------ Date | Date+1 | Date+2 | Date+3
New Sheets 2 1 0 2
New Towels 1 3 0 1
Full Clean 0 1 2 0

"Date" is a date tat you can set, after which you'll get the following 30 days("Date+1","Date+2" etc)

I thought that a CrossTab query would give me what I want,but using the wizzard I can't get the result that I want.
Haven't worked with crosstab queries before so maybe I'm doing something wrong, or maybe this isn't even possible with a crosstab query.

View 4 Replies View Related

General :: How To Calculate Time

Feb 22, 2013

i have 3x time fields in a table i.e time received, time started, time completed i need to accurately caculate the time between time received and time completed. whenever the time goes past 00:00 it seems to add 24 hrs to my calculated time is there a macro or code that i can use to rectify this problem?

View 6 Replies View Related

General :: How To Calculate Next Month

Aug 27, 2013

I have an birthday report for the current month (august) and would like to make a button on the report that can calculate next month (september) and shows birthdays for that month. how to calculate next month?

View 7 Replies View Related

General :: Calculate Days Using 2 Arguments

Dec 18, 2012

I have a database to monitor incoming emails from our contractor & my superior wants it to have control like the following situations:

1. If no respond yet, to calculate today's date minus received date
2. If responded, to calculate respond date minus received date

If i use the following expression, it does not relate to if the emails have no respond yet or have been responded.

IIf(IsNull([Reply Date]),DateDiff("d",[Due Date], Now()))

View 4 Replies View Related

General :: How To Calculate Fields With Restrictions

Apr 10, 2015

Here is an explanation of my database and what I am trying to accomplish. The tables and their fields I have in the database are as follows .....

EmployeeT
EmployeeID - Primary Key - Number (not an autonumber because they are county assigned)
LastName - Text
FirstName - Text
EmailAddress - Text
JobTitle - Text
MobilePhoneNumber - Text
Notes - Memo

[Code] .....

All users will interface with a form that will fill in data on the TransactionT table. I would like the data that is being input into the TransactionT.Quantity field to change the data ItemT.ESBuildingQty or ItemT.D3Qty based on which is chosen from StockLocation (they will only be able to choose either "ES Building" or "D3" when inputting the data).

For example, if the stock amount at the ES building of a particular item is 3 and the stock amount of that same item at D3 is 1 and a user inputs that a quantity of 3 of a specific item are taken from ES Building and Added to D3, I want the new values of ESBuildingQty to be 0 and D3Qty to be 4.

View 11 Replies View Related

General :: Calculate Average (Blank Vs Zero)

Feb 19, 2013

Currently using a lot of Power Pivot Tables which in part calculate "averages" - but when the data comes form a Query that contains a calculated field using the iff() funtion such as: Outcome: iff(Status = "P", 1,0) we end up with a lot of zeros that create a problem in calcuating a true average. In the following example 2,3,0,1,0,0 the average is "1" but if the zeros were blank the average would be "2" because the blank cells would not be counted.

Is ther a way to have something like: Outcome: iff(status = "P",1,"blank") but what I want is ether 1 or a blank cell, NOT TEXT. If we use "" for the false outcome we still have cells that look blank but are in fact text cells and are counted in calculating average.

View 6 Replies View Related







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