Hi everybody,
The title probably won't do this post justice, so I apologize ahead of time. Here's what I'm trying to accomplish...I have a report currently that shows totals for a date range that the user enters through a form. Typically, the user will enter a fiscal quarter for the date range (max of 92 days), as that's our normal reporting period for this particular report. Just for reference, our fiscal year starts in September.
My requirements have changed and I'm being asked to not only provide the data for the date range that the user entered, but also for the other months not included in the date range, up to one year. So, if the user enter September 1, 2009 for the start date and November 30, 2009 for the end date, the report should return November 1, 2008 through November 30, 2009, preferrably with the date range parameter data highlighted or bolded.
I've got a parameter field in my query that pulls the parameter from the form, and I tried using DateAdd to calculate the dates, but it only recalculated how the dates are displayed instead of actually modifying the date range.
Is it possible to accomplish this or does anyone have a better approach for me to take?
Please let me know if more info is needed and, as always, thanks for all the help...
beacon
1  2538 
I'm sorry, the date that should be returned is wrong. It should say December 1, 2008 through November 30, 2009.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Matt |
last post by:
Hello,
I have a query that I would like to schedule in DTS. The criteria of
this query checks for records in the table that are within the current
quarter. Here is what I have.
WHERE submit_date BETWEEN '01/01/2005' AND '03/31/2005'
I would like to dynamically generate the Quarter End and Quarter
Beginning dates within my where clause based on the date that DTWS
|
by: Terencetrent |
last post by:
I have created a query that examines qarterly sales for 5 regions in
the country. The query contains data for the past 6 quarters for each
region and calculates the perecentage of total sales for the quarter
fo each region.
To help enhance the report I would love to include a comparison to of
current sales to previous quarter sales and a comparison of current
sales to sales a year ago. I am having a devil of a time creating a
query to...
|
by: Tony Williams |
last post by:
I have a database that hold s figures for each quarter. I want to create a
query whereby the user can ask for the running total of the data upto the
quarter they enter into a prompt. The database stores the quarter name in
txtmonthlabel (a date field) and the quarters totals in txtdomic (a number
field) EG If the user enters March 2004 they get figures upto March 2004, if
they enter June 2004 they get total upto June 2004, in other words...
|
by: PeteCresswell |
last post by:
The one I would up was a pivot table presentation"
Fund Year ReturnForYear ReturnForYearPlusPreceedingYear,
ReturnForYearPlusTwoPreceedingYears.....and so-forth.
But that design compromise has caught up with me as now I need rolling
quarterly and monthly returns in addition to just yearly returns.
Lottal records involved here....
|
by: PeteCresswell |
last post by:
A "quarterly return" is the decimal amount that an investment returned
over a given three-month period.
The periods end on Mar, Jun, Sep, Dec
Seems like there are a couple of ways to link a return with a quarter:
1) Year and quarter number. e.g. 2003-02 would be the second
quarter of 2003.
| | |
by: Dominique Vandensteen |
last post by:
I have a datetime and want to format it to "quarter year"
so 20 december 2003 should give: "4-2003"
is this possible?
I don't find a format character for quarter :-(
Dominique
|
by: RD |
last post by:
Say Company's financial year starts October First and say we are now March
17th. How do you determine which quarter of the Financial year - not the
actual year - March 17th is in.
Thanks for any help,
Bob
|
by: MikeSA |
last post by:
Hi
I a trying to create a chart that reflects monthly cumulative totals from a query.
The query fields show sales opportunities forecasted invoice date (OppForInvDate), Opportunity Description and Estimated Value of the opportunity (OppEstVal). All I want is to chart, cumulatively for each month, the totals for the month?
Why is it so difficult, or is just me?
Mike
|
by: lucky33 |
last post by:
I have a report that I am importing the data to an access database. I
know how to get the sum for the month to print my problem comes from
the Year to Date. What can I do to get the year to date figures to
print on the same page as the month to date?
Thanks
|
by: cbellew |
last post by:
Hi guys, i'm looking to create a report with a table showing totals (running and cumulative) of education sessions attend by the staff at a hospital.
I'm trying to get the table to show something like this:
Month/Year | No. of sessions in this month | Cumulative total
Jan 07 2 2
Feb 07 3 5...
|
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: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
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: 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...
| |
