I.T. Discussion Community!
-Collapse +Expand
Access
Search Access Group:

Advanced
-Collapse +Expand Access To/From
To/FromCODEGuides
-Collapse +Expand Access Store
PRESTWOODSTORE

Prestwood eMagazine

April Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyMicrosoft Access BoardMS Access Interactive Topic   Print This     

Mathematical data in a report..

Mathematical data in a report.. in MS Access Interactive topic (part of our Microsoft Access group).

Quick Search: Mathematical   Mathematical data   Mathematical data report  
gsempcb
Tyler, TX USA
Hello, I'm using Access 2003, and I have a few questions on a specific report I'm working on, but the first question isn't specific to the report I'm working on--it's a broad question about reports in general.

(1. Again, I'm working on a report that someone else built in the past. Therefore, I wanted to know what's a good way to see the queries/ or tables (the sources of data) at a glance from report Design view? What's a good way to see where everything comes from that Access pulls from in order to generate the report? Is "Object Dependencies" the best bet, or is there anything else?)

2. This report pulls from 2 tables and a query. With the report I'm working on, the report accumulates all of the hours spent on all projects in a given time period worked on, groups by a specific employee, and throws out a total of all hours the given employee spent on all jobs at the bottom section of the report. In the report's current state, each project is assigned and identified by an individual, specific project ID. So, just, each record and entry for a certain project includes a number under "Hours Spent", and it gives a figure of time that was spent on the project. But the problem is that project ID's repeat. That is, multiple records exist for the same project, and so there are different "Hours Spent" figures for each record, each time that work on the given project was entered into the database. This causes those who see the report to have to manually find and add up all the time spent on a given project. What needs to change is that the report needs to list a project only once and accumulate the Hours Spent on that project, and just update that number whenever data is entered, rather than just stick another entry on there. What is a way I could configure the report to do an addition of all of the hours spent based on project ID so that each project is listed only once with a single TOTAL of hours spent, as opposed to being in there numerous times with different hours spent each time the data was entered? Thanks for any help anyone can offer.
 
How I'd like it to look:
 Posted 12 years ago (Thread Starter)
Comment Quote
About gsempcb -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #12925, 4 replies
Thread Started 7/9/2008 12:13:16 PM
View Counter=3008
Last Reply Posted 7/16/2008 9:44:30 AM)
Location=Tyler, TX USA 
Joined=12 years ago   MB Posts=24  
Moderator
Mike Prestwood
Prestwood IT
Prestwood IT office in Citrus Heights, CA

Hi TJ,

Glad you got those working and that you came back and let us know. Much appreciated. I asked one of my Access coders to take a look but he was busy and couldn't get to it. We do need Access moderators out here. Right now it's just a member help member board.

Take care,

--
Mike Prestwood
Prestwood IT Solutions

 Posted 12 years ago
Comment Quote
About Mike Prestwood -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Mike Prestwood

Mike Prestwood is a drummer, an author, and creator of the PrestwoodBoards online community. He is the President & CEO of Prestwood IT Solutions. Prestwood IT provides Coding, Website, and Computer Tech services. Mike has authored 6 computer books and over 1,200 articles. As a drummer, he maintains play-drums.com and has authored 3 drum books. If you have a project you wish to discuss with Mike, you can send him a private message through his PrestwoodBoards home page or call him 9AM to 4PM PST at 916-726-5675 x205.

Web Presence
Facebook, Prestwood IT Facebook page -- fan page. (Visit Me)
Twitter, Follow Prestwood IT on Twitter. (Visit Me)
LinkedIn, Prestwood IT company page on LinkedIn. (Visit Me)
YouTube, Prestwood IT YouTube Channel (Visit My Channel)
Website, My drum website where I sell my drum books. (http://www.play-drums.com)

Post ID #12929 (Level 1.1)  Reply to 12925
Thread Started 7/14/2008 6:38:35 PM
Location=Prestwood IT office in Citrus Heights, CA 
Joined=20 years ago   MB Posts=1410   KB Posts=1805   KB Comments=69   BLOG, Topics=4  
gsempcb
Tyler, TX USA

Great, I've gotten all five of these reports working very well. Basically what helped most playing around with the grouping--either initially in the wizard, or right-clicking in design-view and clicking "Sorting and Grouping". Something else that helped was just playing around with/just using trial and error with the different divisions (headers and footers, etc.) of the report. Tryin sum formulas in this particular grouping, and if that didn't work, trying it in another division. Sometimes I'd need to go into the right-click, "Sorting and Grouping", and look at the two field properties "Group Header" and "Group Footer" and enable/disable them to accomodate what I was trying to do. So, it's working well.

 The only question I have now is, I've got this single form that's got 5 different buttons that trigger those 5 reports I was just talking about (and then some criteria at the top of the form like a date range and title). Two of those reports require the user to use a combobox and choose a "Team Leader" (which is just a name), and then the report gives some data based on that criteria. Now it's not that the reports and combobox don't work right now--they do! And very well, I might add. The only thing is, this combobox draws the "Team Leader" names from a query I have set up--it's a query with one field, the "Team" leader. Now because of this, many of the names repeat. Now I guess this is because the query pulls the team leaders from a table, and the table might have had various entries designating a specific team leader each time. Thus here in my drop-down menu on my form, I get all of my team leaders' names and that's great, but it's just, each one may be on there 10 or 15 times. And I get the same data when I choose the name, and the report does well and good--it's just, I'd like the combobox to have each team leader's name only once. Any ideas? I'm wondering if it's just a simple "Don't allow duplicates" option that I'm not seeing somewhere, but I fear it may be more involved than that.

 Posted 12 years ago (Thread Starter)
Comment Quote
About gsempcb -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #12927 (Level 1.2)  Reply to 12925
Reply Posted 7/14/2008 3:04:50 PM
Location=Tyler, TX USA 
Joined=12 years ago   MB Posts=24  
gsempcb
Tyler, TX USA

-_- never mind--fixed that, too. Changed the regular query to a "Totals Query". All is well.

 Posted 12 years ago (Thread Starter)
Comment Quote
About gsempcb -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #12928 (Level 1.3)  Reply to 12925
Reply Posted 7/14/2008 3:09:09 PM
Location=Tyler, TX USA 
Joined=12 years ago   MB Posts=24  
Most Recent Post
gsempcb
Tyler, TX USA

Now I've got a rounding problem..?

Okay, got another report; in it are 3 text boxes. 2 of them are from a query that gets data from a table, and one's a calculated textbox:

[one of those fields] - [the other one]


Now the first two seem to pull the data correctly, and the third one seems to calculate correctly, so all that's good.

Problem comes in with how they display the numbers. There's some rounding or something going on somewhere, and I cannot figure out how to fix it. Like here's a snapshot of an example:

http://www.rjbfabrication.com/probwithprojlist.png

The first record is ok, as you can see, since there's no rounding. But the second one--not so good. I tried messing with the properties with all of the boxes, some of the boxes: I tried changing the "Format" property to "General Number", I tried changing the decimal places to "3" instead of "Auto", and I've tried toggling through all those with different combinations, and different textboxes being changed and some left alone etc. etc., and nothing seems to be working. Any ideas?

 Posted 12 years ago (Thread Starter)
Comment Quote
About gsempcb -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #12931 (Level 1.4)  Reply to 12925
Reply Posted 7/16/2008 9:44:30 AM
Location=Tyler, TX USA 
Joined=12 years ago   MB Posts=24  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P184A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #12925 Counter
3008
Since 7/9/2008

Follow PrestwoodBoards on: 


©1995-2020 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech