I am trying to create a report that will give me q total count by
month to date, and then another by year to date. Example:
Discharges By Type Month To Date Year To Date
Voluntary Quit 8 18
Involuntary Quit 2 11
Successful Completion 28 37
The "to date" value is supplied by the user at runtime. I know how to
do each type in seperate subreports that sit side by side, but they
would be autonomous. When one report had a value that the other did
not (for example, if there were no Voluntary Quits in a month, but
there were some for the year), the report rows wouldn't line up. Does
anyone know of a way I could get BOTH values in a single corsstab?
Any direction would be appreciated.
Catherine 2 2517 Ca************* **@yahoo.com (Catherine) wrote in
news:7e******** *************** **@posting.goog le.com: I am trying to create a report that will give me q total count by month to date, and then another by year to date. Example:
Discharges By Type Month To Date Year To Date Voluntary Quit 8 18 Involuntary Quit 2 11 Successful Completion 28 37
The "to date" value is supplied by the user at runtime. I know how to do each type in seperate subreports that sit side by side, but they would be autonomous. When one report had a value that the other did not (for example, if there were no Voluntary Quits in a month, but there were some for the year), the report rows wouldn't line up. Does anyone know of a way I could get BOTH values in a single corsstab?
Any direction would be appreciated.
Catherine
I wouldn't consider using a crosstab. I'd just build two summary
queries, one returning the dischargetypes and yeartodate counts,
and the second for the monthly counts, then create a third query
that left joins the one with more categories to the one with
less, since the month is a subset of the year.
If you have a situation where you have holes in both queries,
create a union of all the categories and left join to each count
query.
--
Bob Quintal
PA is y I've altered my email address.
Do a Right Join (or Left Join, depending on what order to reference the
queries) between the two queries. Obviously YTD will include everything MTD
does plus, probably, more, so you want the option that includes ALL records
from YTD and only those records from MTD where the joined fields are equal.
--
Doug Steele, Microsoft Access MVP http://I.Am/DougSteele
(no e-mails, please!)
"Catherine" <Ca************ ***@yahoo.com> wrote in message
news:7e******** *************** **@posting.goog le.com... I am trying to create a report that will give me q total count by month to date, and then another by year to date. Example:
Discharges By Type Month To Date Year To Date Voluntary Quit 8 18 Involuntary Quit 2 11 Successful Completion 28 37
The "to date" value is supplied by the user at runtime. I know how to do each type in seperate subreports that sit side by side, but they would be autonomous. When one report had a value that the other did not (for example, if there were no Voluntary Quits in a month, but there were some for the year), the report rows wouldn't line up. Does anyone know of a way I could get BOTH values in a single corsstab?
Any direction would be appreciated.
Catherine This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Luis |
last post by:
Hi,
I am trying to create a stored procedures (SQL 7.0), to provide data
in
a crosstab format.
(I'm using Crystal Reports 8.5, but the Crosstab capabilities are
terrible, so I have to do as much as possible on the SQL side)
I have a table with the following fields:
Year (int)
|
by: Helpdesk Man |
last post by:
Hello SQL and Crystal Reports friends,
I am trying to make a report and need some help please.
It is a helpdesk database. Jobs are logged, and then closed. Each of
these events is timestamped in the database in the date fields
“DateLogged” and “DateClosed”
Jan Feb Mar Apr
|
by: Paula |
last post by:
I need to do a summary using a crosstab query. The data has a Date field
(Not named "Date"). I can do the Row Heading and Value but am having trouble
with the Column Heading. The summary Columns needs to read like:
Sept01 to Aug02 Sept02 to Aug03 Sept03 to Aug04
Can anyone give me a recommendation on how to get from the Date field to
these Column Headings? I then would like to set criteria where I can select
something that...
|
by: KevLow |
last post by:
Hi,
Hope some kind soul can help me out here..
I'm trying to programmatically modify the column headings of a crosstab
query such that it can be dynamic based on user specified period (Month
Year to Month Year)
So far i have tried to use the following code:
//
|
by: Tina |
last post by:
My employer tracks productivity/performance of clinicians (how much
they
bill) each week, its averages for the month, and the 6 months.
These averages are compared to their expected productivity.
However, the expectation changes - it may be 60% for a while, then
change to
50%. Initially, I was averaging the expectation, along with the
productivity, but what I'm being asked is to look at the average
productivity/performance compared to...
| |
by: bruce24444 |
last post by:
What I have is a database which tracks assigned files to a certain people which is generated by a form and then recorded into a table. Table are as follows “Staff” “Loss_Type” and “Claims_Assignment”.
From this “Claim_Assignment” table I have created separate queries that provide reports sorted by certain predetermined dates. IE: week, month, year
I have designed (2) crosstab queries from the “Q:Claims_Assign_Year” to return results...
|
by: bruce24444 |
last post by:
First of all I'm new to the forum and am working on my first database. So far I think I've done not too bad but have hit a stumbling block for which I'm not sure how to get around.
What I have is a database which tracks assigned files to a certain people which is generated by a form and then recorded into a table. Tables are as follows “Staff” “Loss_Type” and “Claims_Assignment”.
From this “Claim_Assignment” table I have created separate...
|
by: m.wanstall |
last post by:
I have a crosstab query that compiles data for Months of the year. I
have a stacked select query on top of that crosstab query that uses
the latest 2 months data and exports it to a fixed length flat file.
Ideally I would like to be able to just select the Last 2 Columns of
the Crosstab query as inputs to the Select query WITHOUT having to go
in month after month and manually change it...
I may be asking a bit much here but is there a...
|
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: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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: 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: 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...
| |