Theres two problems i have.
1) Theres a question i have to answer in a mock is that the company does invoices every month but i need it for to select invoice and then select the month whcih would then give you the invoices for the selected month.
2) The first is adding the number of outstanding invoices in the report footer in the Invoice. I use this text box = IIf(Min([Date])<Date()-30,"Please Pay Up","") to calcualte if the invoice had been outstanding for over 30 days but i need the report footer of this invoice (not invoice list) to calcualte the number of outstanding invoices
2  1649 
actually for question 2 would i do a count for the amount of people on the invoice and then - the amount that have paid
 MMcCarthy 14,534
Recognized Expert Moderator MVP
Theres two problems i have.
1) Theres a question i have to answer in a mock is that the company does invoices every month but i need it for to select invoice and then select the month whcih would then give you the invoices for the selected month.
Not sure exactly what you mean but a query to create all invoices for the current month would mean have the Invoice Report record source set to a query based on the orders table something like the following. -
SELECT OrderID, CustID, CompanyName, OrderDetailID, Qty, (Qty * OrderDetailID * CostPerQty) As Amount
-
GROUP BY OrderID, CustID, CompanyName, OrderDetailID, Qty;
Then in the Invoice report create a group level for OrderID and put Comany Name in this Header.
Then in the Footer create the total calculated control
2) The first is adding the number of outstanding invoices in the report footer in the Invoice. I use this text box = IIf(Min([Date])<Date()-30,"Please Pay Up","") to calcualte if the invoice had been outstanding for over 30 days but i need the report footer of this invoice (not invoice list) to calcualte the number of outstanding invoices
You will need a textbox with the following control source. -
=DCount("[InvoiceNum]", "tblInvoices", "[CustID]=" & Me.CustID & " AND [Paid]=False")
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Luis |
last post by:
My project is to make a calander which will print out every month depending
on the year leap year or not) and the first day of the year. this is what i
have so far, but i don't know how to go about making it go to a new line
when the end od the current line is reaxched. Please take a look at my code,
and tell me if you have suggestions. It has no comments, and is pretty raw,
i am to the point of ust printing only 1 month, not all 12 yet....
|
by: Abhas |
last post by:
> > Hi, this is Abhas,
> > I had made a video library program in C++, but was facing a problem.
> > After entering 12 movies, i cannot enter any more movies.
> > Something gibberish comes instead.
> > Can somebody please tell whats wrong??
> > This is the code : :
#include<fstream.h>
#include<conio.h>
|
by: desi90 |
last post by:
Hi,
I have a following report created from a table
REGION Issue count
South C1 3
South C2 1
West C1 4
North C1 2
North C2 5
East C1 1
|
by: Burghew |
last post by:
Thanks for the previous replies.....
What I need is to generate invoices for customers whom we rent out
equipment.
I will be choosing the date and year say for December 2005 print the
invoices for customer A or B or .../ for all the equipments they have with
them.
This Dec 2005 must be selected by the user through a combo box. I have no
idea on how to keep the combo populated with Months + years so that users
can choose the corresponding...
|
by: adamdistefano1 |
last post by:
Hello,
I am a total noob when it comes to access and VBA, i was wondering if you guys could help me with a few things.
Firstly, im creating an invoice application in access. I need some help with the following problem.
I have a 'Customer Database', and a 'Product database' named respectivly, i have developed both of these fine. What my plan is, is to have a sheet that has a selection for the data in the invoice required to be generated...
| | |
by: uninvitedm |
last post by:
Heya
I've got a table of invoices, which have dates and customer_id's. What I need to get is the number of occurances for this customer for a 12-month range window. For example, if there's an invoice for october for a certain customer - i want to count how many other invoices appear are for this customer in the 12 months from that invoice date. Similarly, if there's an invoice in november, that should show the number of occurences 12 months...
|
by: caze |
last post by:
Hi,
This website is great, I can't seem to figure out one thing. I have a lease database and I want to calculate the invoice month on the fly in a form, this is the code at the moment
=DateAdd("m",Nz(,0),Nz(,0))
But it doesn't keep recurring to give me a date of 2008.
An example of a record:-
Start Lease Date - As a Date (15/07/1983)
Frequency of Payment - In Months (12)
|
by: tasawer |
last post by:
Hi,
I am looking for guidelines to create a monthly recurring invoice using the following criteria.
We manage vehicles for Rental companies and therefore we require to invoice same amount each month. (monthly fee is based on 28-day month)
Invoice report must show vehicle reg, date vehicle acquired (or discharged) and management fee for each vehicle,
at the moment we have a set number of vehicles to manage but in future, a new vehicle...
|
by: alwaali |
last post by:
Hi
I need help please
This is my project and i need a help to solve it with you
A page of text is to be read and analyzed to determine number of occurrences and locations of different words. The results of the analysis are to be stored in a suitable data structure. The main task in this project is to design a suitable ADT (call it WAnalysis) to store the results and enable the following operations to be performed as fast as possible:...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
