Monthly Expense Query

Jul 31, 2006

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?

View Replies


ADVERTISEMENT

Expense Report--expense Reocurrences

Aug 4, 2006

I have an expense report I am trying to create. Expenses are 1 of 4 things (monthly, quarterly, semiannually, or annually occuring). If I enter a record say today:
8-04-2006--Window cleaning--$400.00--yearly

Is there a way to get it to automatically re-occur on the same day next year. (I want it to automatically reapply itself next year, not today showing next year. does this make sense?)

I want it to show up as a new record tho

View 3 Replies View Related

Append And Update Expense Query

Aug 7, 2006

I have an expense table and I want the expenses to be written to a new table every month, quarter, half-year, or year depending on what the user has selected. I want to group the expenses somehow and I want it to show all monthly expenses, then show which ones have +1 month. All those will get put into a append query and added to a new table that stores all the expenses from hence forth.

Alright, I have started to figure it out ( a problem from earlier) but I think I need some help. I want an if statement but I am not familiar with date functions. In an append query I want to look at my original table and add records if it is past a certain date.
For a monthly expense (entry date is 01/01/2006)

If (dateentered) month, +1
Then write the record.

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

Expense Sheet Problems

Jun 22, 2005

Hi, AM very new to Access and currently (trying) to creating a DB to safe me time filling out my expense forms manual. (dark ages pen & paper) :confused:

I've used the same table/fields that this form would required if I was filling it in by hand. Am I able to create drop down box's with prefix information in these table/field? can you do this on Access if so how would you do this?

I would also like to calculate the mileage using the info from drop down boxes ie from leeds (value of 2) to Manchester (value of 10) based on standard mileage I can claim for (0.10p) = (£2.00) in my remarks field I would wont to be able to prefix this i.e 20 (being the value of 2x10) miles each way @ 0.10p (being the set mileage)?

Am trying to use the same form that I would fill in manual. But having difficulties trying to fit this in forms. I've changed the paper layout & margins etc but still missing about a inch of information that's required on this form :confused:

The form will only allow you to fill in 11 lines of info b4 you need to fill out another form
How would your database know when to create a new form when the 11 field/lines have been filled with data?
How do you add up your columns?
How would you bring a balance b/fwd to you next sheet leaving only 10 lines of info to be inputted?


Any help with the above or any direction or further informatin required would be much appreciated

Thank you

DragonJJ

View 2 Replies View Related

General :: Personal Expense Ledger - Adding Values In A Listbox

Mar 5, 2013

I am working on a personal expense ledger. On a particular field that is labeled [expense/income], and a field labeled [amount]. the [expense/income]field is a listbox field "with expense and income as the values. Here is what i want to do. when i select income from the listbox i want it to sum the total in the amount] field, and if i select expense i want it to subtract the total in the [amount] field. i hope i explain it correctly.

View 4 Replies View Related

Forms :: Adding All Invoices For Expense Together And Display Total Amount

Sep 25, 2013

I have a subform in columns that has a list of invoices bound together by the site number on the form there is a Expense code that runs 51 to 95.

On another tab I want to add all the invoices for a expense code together and display the total amount

Below is an example of invoices

IDSite CodeInvoice DatePOInvoiceContractorInvoice AmountExpense Code
10289S20/09/2013 346603410Dj Commercial Cleaning Ltd 25.2362A
20289S28/09/2013 346061141Platinum Landscapes 240.0055A
30289S03/09/2013 353112021Clean And Green 167.0063A
40289S02/08/2013 353112015Clean And Green 174.0063A
50289S19/08/2013 111115271Southern Electric 189.5679A
60289S19/08/2013 346061121Platinum Landscapes 240.0055A
70289S02/06/2013 353112009Clean And Green 160.0063A
80289S02/05/2013 353112003Clean And Green 181.0063A

I want it to display on another tab

51 General Expenses £452.36
55 Gardens £1523.65

and so on

whats the best way to do this?

View 2 Replies View Related

How Can A Create A Monthly Query ?

Jul 27, 2007

Hi guys,
Can someone please tell me if there is any way to create a query that gives me ... lets say a sum of smth monthly.
I'd like to create a crosstab query to have at
rows : names
columns : months
values : sum of smth (kilometers for drivers)

Thankyou in advance

View 3 Replies View Related

Monthly Query Update

Jan 8, 2008

Hello;

I'm curious if this is possible:
I have a table set up with a list of items followed by a column for each month's quota that I manually update. I run a query from my production table and quota table that will list all my products I have a quota on followed by how many of each were produced in that particular month. In the query I point to the quota table's current month and the data from the production table is pulled by the following:
Produced: Sum(IIf([production]![status]=4 And [production]![fix date] Between #01-Jan-08# And #31-Jan-08#,1,0))

How can I write this same information to pull only Jan08 information without using the "Between #X# and #X#"?
In the same way, I would need to point to Jan08, Feb08, etc.. columns in my quota table automatically.

Any help would be GREATLY appriciated

View 8 Replies View Related

Running A Query Monthly

Oct 27, 2004

Hi all - I have an append query all set up and running but I can't figure out how to run it on a monthly basis. Could someone help me with the SQL to run the query on the 15th of every month at 7:00am? Thanks loads.

Dan

View 3 Replies View Related

Combine Monthly Product Sales Query

Feb 27, 2008

I was wondering if there is a way to combine sales by month for a year where it would show the product then for say January and the total sales and so on for each month.

View 7 Replies View Related

Queries :: Monthly Unpaid Students Finder Query?

Jun 23, 2013

i have 3 tables one for student information second for Van information and third is payment.

I want to know how to get the list of students not paid based on specific month which need to mentioned may b through a form.

View 1 Replies View Related

Queries :: Query Time Difference AND Monthly Totals

Mar 21, 2013

I am VERY, and I mean VERY new to Access. I've been racking my brain all afternoon and googling like crazy. I just completed two levels of training on Access 2010 and have never worked with the program before. I already set up my tables and now I am on to querying. I have a table with several columns, two of which are "Start Time" and "End Time". I already created a query using the DateDiff function to calculate the time difference for each record. It output a new field with the time difference in hours. Now, I want to sum the totals of the time differences by month and I cannot for the life of me figure it out. My new query has Date (m/dd/yyy) and Hours.

View 14 Replies View Related

Queries :: Create Query To Filter Customers When It Is Time Of Their Monthly Payments

May 21, 2014

I'm trying to make a query to filter or show only those customers when it is the time for their monthly payment.The query I have consists of four fields which are

1- Order ID
2- Payment
3- Date (Default value set to Date ())
4- Date for next time Payment (Default value set to date () + 30)

I made another field called "states". In this field I putted the following expression

Code:
IIf(([Date for next time Payment]-Date())= 0 "Should Pay";" ")

Then, I set the criteria for such field to "should pay" so that only customer "should pay" will appear in the query datasheet. However, this method has the following shortcomings:

1- It works only for one day (alert day) ,i.e., customers will filtered only when the expression is true.
2- Customers who have paid will still appear as a "should pay" until the day (the day that make the expression true) finish.
3- Customers whose pay late (maybe after 1 week) will disappear form the query datasheet after alert day finish.

To overcome the above shortcomings, i modified the expression to

Code:
IIf(([Date for next time Payment]-Date())<-1 And ([Date for next time Payment]-Date())>-15;"Should Pay";" ")

This method will extend the alert duration to 15 days, so the customers who haven't pay yet will appear in the query datasheet for 15 days. However, the customers who have payed will appear also, and that is the problem. The problem here is I can't compare the current payment date with previous one for one customer. method to create suitable expression, or even another query scheme ??

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

Monthly Report

May 10, 2005

ok i think i know what i need (searching the forums gave me the idea)


i have query that generates a report, i need this report to be flitered monthly

is it possible to have afield where i enter the month so when i press the monthly report button it just prints any entries in that month

please can someone oint me in the right direction.

View 2 Replies View Related

Monthly Invoice

Jun 28, 2006

Hi, I have Three tables
the first is a ContractTable
the second is a Monthly Invoice Details Table
and the third is a Detailed Payments table

Contract 1 -> Many Monthly Invoice 1 -> Many Detailed Payments

what I would like to do is ensure that there arent any duplicated Months for a Contract in the Monthly Invoice table

in other words For Contract 00023 I NEVER want it to have more than one invoice record for the month of JUNE 2006....

It may be easy but it has me all tied up, please assist.

View 4 Replies View Related

Monthly Statistics

Jan 13, 2006

I will try to explain my problem as best i can and would appreciate any thoughts other people have on it, it is surely similar in some degree to someone elses previous work!

I need to produce management information on a monthly basis, one example of this type of work are an employees one to ones.

table121 contains following fields, ID scheduledDate CompletedDate Completed(yes/no)

My report/query needs to group records by the month (which i do through formatting date fields to display mm/yy), count the number of scheduled one2ones, count the number of completed one2ones, display a %.

I have played around and got this to work using querys with grouping and sums.

My problem is if the schedule date and the completed date are in different months then all of the statistics become out of sync, particualy when there are more appraisals taking place than scheduled.
Any ideas?

View 2 Replies View Related

Monthly Costings

Mar 16, 2005

I am Trying To calculate Costs for a particular month how do i do this when taking into account that the months obviously hae different lenghts? I have the overall week cost but how do i do it for the month?

View 3 Replies View Related

Monthly Report

Aug 2, 2006

I am trying to create an inventory which list sales by month. I have created a crosstab query from the detail history table which works fine except I would like a record for each month whether there was sales or not. So on the report I would have all 12 months for each item with the months with no sales displaying zero.

Any suggestions?

Valerie

View 6 Replies View Related

Monthly Reports

Nov 26, 2007

I am having issues trying to run a query. What we have is a private club that keeps track of its members with an access 2007 database. What we need to do is to be able to print out new members monthly for a state audit. The way it is setup now, our members reports prints all of the members since day one. For example, we have a state audit coming up next month for November and we would only like to print out members that have joined during the month of November, but our report is printing out all of the members since we started in August.

We do have a date joined query. The fields we would like to print are: Date Joined, Member ID, FName, LName, City, State

Any help would be greatly appreciated, thank you.

View 8 Replies View Related

Monthly Printouts

Feb 21, 2008

HI THERE!

I'm having troubles creating a query that will be able to view/print out the current records in the next month.

For example:

From today's date (21/02/08), I want to print out a report of all the confirmed court cases from today until the next month.

And I could have an option of all the dates of specific months.

Is this possible?

Thanks guys.

View 10 Replies View Related

Linking Monthly Tables

Jun 8, 2005

Every month for my construction company, I receive a pay application that consists of the following:

1) about 100 "Line Items" (each one being a different type of work performed)

2) a Subcontractor associated with each line item (a line item may have only 1 Sub, but a Sub may be listed multiple times for different line items)

3) Amount of work performed (in $$) on that line item by that particular Sub during that pay period.

My boss wants a db to track all of this info. She thinks the best way would to create a new table for each Pay Application, every month. Basically, we would be starting from scratch every month with a blank table. But, I think it would work better if the months were linked to each other in some way.

I could have a field called "Pay_App" and enter 1 or 2, etc. on every row for every line item every month. But, then each month, I would be entering a 1 (or whatever the month is) for every single line item and that seems stupid. I want to be able to pull up the entire pay schedule for a particular Sub (all of his payments throughout the entire job). Is there a way to link the different pay application tables once the data has been entered? Or is there an easier way to do this? I would appreciate any help that can be provided. Thanks.

View 5 Replies View Related

How Do I Create Monthly Fees?

Sep 21, 2007

I have stuck in something and i hope someone will help me with this: I have created a DB which shows all the students of a musical school. Each student pays a monthly fee (sep-june, 10 payments per year). I dont want to create all these columns in my main table beacause it will be too crowded. The only thing I can think of is to create 10 different tables one for each month but i think it won't work well when I want to see how much a specific student pays.. any ideas? the information for each month that i want to have is the student first and last name, date of payment, level, fees amount and money paid (and perhaps month name..).
Thank you in advance guys!

View 6 Replies View Related

Update Record Monthly

Sep 23, 2007

I hope I can convey what I am trying to figure out. I am at a loss right now. I have a form where I input personnel information. One of the fields is for how many months experience they have with the program. What i would like is for this record to update itself every month. for example, if they initially had 2 months experience, I would enter 2. Every month therafter, that number with change to 3, 4, 5...etc. Not everyone comes to our section with the same experience, so most will have a different starting number.

This information would be seen on the personnel form, and in a report to show experience levels. Other than those two, it is not called upon.

Any suggestions would be so helpful!

Thank You!!

View 3 Replies View Related

Cumulative Monthly Totals?

May 31, 2006

Hi,

I'm trying to create an expression that will calculate cumulative monthly totals but my expression seems to only calculate totals for all months
e.g
MonthDirect DespatchesCum Direct Despatches
2006/031580 21867
2006/0410681 21867
2006/059606 21867

The expression I’m using is
Cum Direct Despatches: (Select Sum([Direct Despatches]) from QRY_DirectDespatches_ByMonth_ByModel)

The query should display the following results -
MonthDirect DespatchesCum Direct Despatches
2006/031580 1580
2006/0410681 12261
2006/059606 21867

I'm using Access 2002 on XP.
Can anyone please advise me where i'm going wrong?!
Thanks in advance for the response

View 3 Replies View Related







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