hi-
i have a simple table. i have 3 fields, id, indate, and outdate. i
want to group these fields in my report by month. for example, for
february 2004, i want to display all the ids and dates for those
records with indates during the month of february. i'm trying to get
my report to look kind of like this...
MONTH CASEID INDATE OUTDATE
January 2004 1 1/10/04 1/24/04
2 1/15/04 2/10/04
TOTAL = 2
February 2002
1 2/1/04 2/15/04
45 2/5/04 2/22/04
8 2/22/04 2/24/04
TOTAL = 3
is there a way or function in the report wizard to group by months?
thanks,
miguel 3 1698
Use the Month function, the Year function, or Format, or all of them, to
extract the Month in the Query which you use as RecordSource for the Report.
Use the Report's Sorting and Grouping to group on Year and Month, and to
sort on Year and Month Number.
Larry Linson
Microsoft Access MVP
"Miguelito Bain" <mi***********@ hotmail.com> wrote in message
news:1b******** *************** ***@posting.goo gle.com... hi-
i have a simple table. i have 3 fields, id, indate, and outdate. i want to group these fields in my report by month. for example, for february 2004, i want to display all the ids and dates for those records with indates during the month of february. i'm trying to get my report to look kind of like this...
MONTH CASEID INDATE OUTDATE
January 2004 1 1/10/04 1/24/04 2 1/15/04 2/10/04
TOTAL = 2
February 2002
1 2/1/04 2/15/04 45 2/5/04 2/22/04 8 2/22/04 2/24/04
TOTAL = 3
is there a way or function in the report wizard to group by months?
thanks,
miguel
On 23 Feb 2004 19:43:16 -0800, Miguelito Bain wrote: hi-
i have a simple table. i have 3 fields, id, indate, and outdate. i want to group these fields in my report by month. for example, for february 2004, i want to display all the ids and dates for those records with indates during the month of february. i'm trying to get my report to look kind of like this...
MONTH CASEID INDATE OUTDATE
January 2004 1 1/10/04 1/24/04 2 1/15/04 2/10/04
TOTAL = 2
February 2002
1 2/1/04 2/15/04 45 2/5/04 2/22/04 8 2/22/04 2/24/04
TOTAL = 3
is there a way or function in the report wizard to group by months?
thanks,
miguel
The second step in the process allows you to create up to four grouping
levels. Once a level is defined, you can click on "Grouping Options" to
further define them.
--
Mike Storr www.veraccess.com
You want to list the case under the month heading if any part of that case
falls within the month.
The case should show under the month if:
- the case starts before the month ends, AND
- the case ends after the month starts.
To achieve this, you need a table of months (tblMonth) this this field:
MonthStart Date/Time
Create a query into tblMonth and your existing table.
No join between the 2 tables.
In the Criteria row under INDATE:
< DateAdd("m", 1, [MonthStart])
In the Criteria row under OUTDATE: = [MonthStart]
If you wish to filter the query to particular months, filter on
tblMonth.MonthS tart.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Miguelito Bain" <mi***********@ hotmail.com> wrote in message
news:1b******** *************** ***@posting.goo gle.com... hi-
i have a simple table. i have 3 fields, id, indate, and outdate. i want to group these fields in my report by month. for example, for february 2004, i want to display all the ids and dates for those records with indates during the month of february. i'm trying to get my report to look kind of like this...
MONTH CASEID INDATE OUTDATE
January 2004 1 1/10/04 1/24/04 2 1/15/04 2/10/04
TOTAL = 2
February 2002
1 2/1/04 2/15/04 45 2/5/04 2/22/04 8 2/22/04 2/24/04
TOTAL = 3
is there a way or function in the report wizard to group by months?
thanks,
miguel This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: amber |
last post by:
Hello,
I have a report in VB.NET/Crystal Reports.
I have a criteria form that users select between 2 different types of
grouping (group by category or group by year).
Can I programmatically change the grouping of a single report, based on the
user's selection?
Or do I have to create another report, with different grouping, and call it
when user selects different grouping?
Thanks,
amber
|
by: Stephen |
last post by:
I have the following xslt and I am trying to use two levels of
grouping. I am first grouping on the report category, then on the
report type. The problem is I am sure I have to apply some sort of
filter on the report type group to limit the records returned to the
current report category. Any help is appreciated.
<?xml version='1.0' encoding='utf-8' ?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
version="1.0">...
|
by: Brian Coy |
last post by:
I am creating a database to track scrap on a daily basis at my plant.
I have to provide a weekly scrap report with the amount of each part
scrapped per day. I have the basic database set up, and am trying to
generate a report. I have created a report that will show all the
data. But I need to show either an empty group for the data on days
that there is no scrap or a comment relating as much.
My report is set up with a weekly...
|
by: Alicia |
last post by:
Yes, but will that skip a week and group by the date for me? I
basically wanted something that would do a count of the dates, then
group them by their week name..
BEFORE:
Resource Date Total number of times that date Appeared
(Count)
4/3/03 4
4/4/03 2 (note 4/4/03 showed up twice)
|
by: ahaque38 |
last post by:
Hello.
Using A2K SP3, I am having the following problem with a report using
"Sorting and Grouping".
I have recently added a grouping in the reports for
"Category2<>'CONTRACTS'".
I have reports at the plan (overall totals), department and division
levels which have sorting and grouping implemented with this new
| |
by: Peter Bailey |
last post by:
I have a query that returns , and :
12/05/04 3 Wednesday
13/05/04 0 Thursday
and so on
what I would like to do now is count the number of bookings by week so from
monday to friday from the first date get the sum of bookings.
|
by: Mike MacSween |
last post by:
tblCourses one to many to tblEvents.
A course may have an intro workshop (a type of event), a mid course
workshop, a final exam. Or any combination. Or something different in the
future.
At the moment the printed output is usually going to Word. It's turning into
an unholy mess, because I'm having to prepare umpteen different Word
templates, and the queries that drive them, depending on what events a
course has.
|
by: John |
last post by:
I'm building a report where each row represents one month and its 1 to
5 weeks. A report query groups the source table date into a "month and
year" expression. A subreport links to the main report using the
query's "month and year" expression.
Problem is I can't figure out how to group the source table's dates
into a "Mmmm yyyy" and then link the subreport to the relevant week of
that "Mmmm Yyyy".
source table:
|
by: CoopEng |
last post by:
Hey Team,
Here's one for you all to ponder. In Access 2003, I'm updating a Operations Database for a manufacturing plant. The data is of production runs for the plant. So there are start date's and start times for each run. For example on monday march 10 there could have been entries like 5:00 - 13:00 (..data from shift), 13:00 - 21:00 (data from shift).. etc.
The report that i'm working on displays all production runs between two dates....
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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...
| |