473,837 Members | 1,677 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Need to separate different dates wihtin a report

I have a database that records a part no, a scrap reason, the cost of
scrapping that item, and the date. I need to porduce a report that
will show up to a weeks worth of data at a time, but I need each dates
scrap amout totaled and each day to be separated on the report. I am
self taught at access and still a beginner, so please be gentle on
your replys.

Thanks for your time in advance...
Nov 12 '05 #1
4 2481
"Brian Coy" <br******@acces sky.net> wrote in message
news:ac******** *************** ***@posting.goo gle.com...
I have a database that records a part no, a scrap reason, the cost of
scrapping that item, and the date. I need to porduce a report that
will show up to a weeks worth of data at a time, but I need each dates
scrap amout totaled and each day to be separated on the report. I am
self taught at access and still a beginner, so please be gentle on
your replys.

Thanks for your time in advance...


In design view of the report bring up the Sorting and Grouping dialog and
add an entry for your date field. Add Group Headers and Footers as
necessary and in either of them you can put a TextBox using =Sum([scrap
amount]) to give you the total for that date. You can also use the
"ForceNewPa ge" property for the Group Footer to indicate that you want each
date's data to start on a new page.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 12 '05 #2
DFS
"Brian Coy" <br******@acces sky.net> wrote in message
news:ac******** *************** ***@posting.goo gle.com...
I have a database that records a part no, a scrap reason, the cost of
scrapping that item, and the date. I need to porduce a report that
will show up to a weeks worth of data at a time, but I need each dates
scrap amout totaled and each day to be separated on the report. I am
self taught at access and still a beginner, so please be gentle on
your replys.

Thanks for your time in advance...


Brian,

You're recording the correct pieces of data, so all you need is a report to
show the daily total. Hate to say "check the Help" but if you play around
with the Report Wizard, it'll do exactly what you want automatically. All
you need is a scrap date group and a scrap date total.

If you're just curious about the daily scrap totals, and don't want to see
the details of each item scrapped every day, run this query:

SELECT ScrapDate, Sum(ScrapCost) as DailyScrapCost
FROM Table
GROUP BY ScrapDate;
If you want to see, high to low, the most "expensive" scrap reason, try
this:

SELECT ScrapReason, Sum(ScrapCost) as DailyScrapCost
FROM Table
GROUP BY ScrapReason
ORDER BY Sum(ScrapCost) DESC;
If you want to see scrap totals by month, try this:

SELECT Format(ScrapDat e,"m") AS Month, Format(ScrapDat e,"mmm") as MonthName,
Sum(ScrapCost) as MonthlyScrapCos t
FROM Table
GROUP BY Format(ScrapDat e,"m"), Format(ScrapDat e,"mmm")
ORDER BY Format(ScrapDat e,"m")



Nov 12 '05 #3
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You need 2 Groups in the report: Days and Weeks. In the Sorting and
Grouping dialog box set the Field/Expression to the scrape date and
the Interval to Week. Enter the scrape date under the first date and
change the Interval to Day. For each grouping set the Group Footer
property to Yes.

In the report's Detail section you can put the individual items that
are scrapped each day. In the Day Footer section You'd put the a
Control with a ControlSource like this:

Control Source: =Count(*)

Do the same for the Week footer. This will keep a count of the number
of items per day and per week.

The report sections should look like this:

Report Header
Page Header
Detail
Day Footer
Week Footer
Page Footer
Report Footer

HTH,

MGFoster:::mgf
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP8uQYIechKq OuFEgEQK3AgCdEE 6JyY3YVQa/CAJSyIgv8JKgn7E AnjZm
qP2/szNVwPVusgAH1FY xr1wC
=AGPh
-----END PGP SIGNATURE-----

Brian Coy wrote:
I have a database that records a part no, a scrap reason, the cost of
scrapping that item, and the date. I need to porduce a report that
will show up to a weeks worth of data at a time, but I need each dates
scrap amout totaled and each day to be separated on the report. I am
self taught at access and still a beginner, so please be gentle on
your replys.

Thanks for your time in advance...


Nov 12 '05 #4
Thanks to everyone for their help, somehow I missed that option in the wizard...
Nov 12 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
1817
by: Deano | last post by:
OK, I've been taking the detour from hell trying to sort this and after taking a walk I think I need a rethink. I have a report for a single employee that includes a subreport which lists courses taken by that person. I ask the user for Start and End dates to allow them to see only courses that fall into that date range. I'm then trying to open the report to show the current employee with a list of courses that fall within the date...
1
3345
by: Richard Hollenbeck | last post by:
Hello Newsgroup. You have all been very helpful in the past and I thank you. I try to ask relevant questions so that they don't just benefit me, but also benefit the group. I'm currently overwhelmed by useless examples across the web on how to make "dynamic crosstab reports" without myself having a basic understanding about how to retrieve and assign recordsources, etc., from fields in a query to fields in the report. I see all these...
4
1527
by: Nip | last post by:
I am trying to make a database for my test participants. I have 10 participants and have a table with them called participants which includes an auto number ID and then the participant number and start date. Now I want to rank these participants. So I have created 3 more tables one is called rankdescription and includes 5 ranking descriptions which all 10 participants will have to rank. The 2nd table is rankdate and includes 8...
3
3175
by: ChadDiesel | last post by:
Hello everyone. I need some advice on table structure for a new project I've been given. One of our customers sends us an Excel spreadsheet each week containing their order. Currently, someone formats the spreadsheet, prints it out, and manually picks out the products we need to ship. I want to import this into an Access table. Basically, the sheet with some data examples looks something like this: ...
2
2089
by: Bill | last post by:
I have a 200 record database that includes a date/time field, AnnivDate, for a wedding anniversary. AnnivDate has nulls and some incorrect year data. I have been creating the Access database using data imported from an Excel file and the person entering into Excel only cared about the month and day portion and Excel added the current year to the field value. I want to produce a report that shows upcoming anniversaries using a parameter...
4
2384
by: jdph40 | last post by:
I enter data into a database that resides on our network. Other employees can print reports from the database, but they have no way of telling if I've entered all the data. For instance, on Mondays, I have to enter 3 days of data - Friday, Saturday, and Sunday. Last Monday, an employee came to me questioning the results on his report. He had requested data from the weekend: Friday through Sunday. But when he printed the report, I had...
2
1758
klarae99
by: klarae99 | last post by:
Hello, I am working in Access 2003 on an inventory database. Right now I am working on a report which will be used to fill in forms that our state requires periodically to collect taxes. Right now I have a query that determines the items that have sold between two dates and calculates the Gross Sales, Tax Collected and Sales Including Tax. This query is set up with the following SQL: SELECT tblCat.Categories, tblCat.TaxRate,...
3
1362
by: Allen Browne | last post by:
"Tony Toews " <ttoews@telusplanet.netreplied in message news:g075f4pkmg4uc5hk0ohdjfcaeph6ff963f@4ax.com... Tony, I did one of these recently, and asked the client, "Could there ever be a case where you need to store both (i.e. hours of operation and miles travelled)? The answer was no, so we just called the field MeterReading (Double), and added a MeterTypeID field to the VehicleType table. The real fun comes when you have to project...
9
1846
by: sparks | last post by:
Right now I had to build a report that allowed the people to check for gross outliers in their data input. short I am looking at 2.5* std dev + - anyway I used 2 dummy variables in the query the report is tied to. start date and end date. This pops up an input box for these values and they put in 11/01/08 and 11/31/08 and it runs the report showing the outliers. I watched and everyone is looking at month not date Now I was thinking...
0
9852
marktang
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...
0
9696
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,...
0
10902
Oralloy
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...
1
10642
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,...
0
9420
agi2029
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...
1
7824
isladogs
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...
0
7014
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();...
0
5680
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...
3
3128
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.