Microsoft Access Forums - Reports

Group Totals Based On Values

Poida3934 — Tue, 21 May 2013 02:54:16 GMT

I am an infrequent access user, and have a totalling problem. I have a query which pulls out a list of students, and the colleges they are going to, as well as their gender (M/F, nothing in between!). I'm trying to produce a report that basically shows me the following, but can't figure out the appropriate function/formula to tally the genders seperately :

Smith College Male : 15 Female : 12
Jones College Male : 11 Female : 9

Totals : Male : 26 Female : 21

Thanks in advance! :)

Format$ date...

1Giggles — Mon, 20 May 2013 19:36:58 GMT

Access 2007 SP 3, Windows XP Version 2002 SP3

I have a calculated field ([SendDate]) in a query that calculates a specific date by adding 10 days to it ([DOD]+10). The report based on this query is grouped by month by week on SendDate: Format$([SendDate], "mmm", 0,0)

The report is then sorted by [SendDate], then by [DOD], and last by [Pt].

On the printed report each week is separated nicely. However, I'd like for it to show Saturday as the first day of the grouping (instead of the last day of the grouping). How do I accomplish this without too much code? Isn't there a simple way of doing this on the "Design View" layout of the form?

Thanks so much!

Report with Multiple Grouping and specific range on 1 group

jnielsen — Fri, 17 May 2013 06:38:51 GMT

Hi All. New to the forums and I've ran into some trouble with a project i'm working on.

I have a project that has a road with several segments that make up the road. I also have some records that are right of way distances by milepost that need to fall within each section and display under that segment of road. I think what I need to do is something with the grouping but I cant figure out what i'm doing wrong. I've attached a sample database with the information and the report I would like to setup as well. Also attached is what the report would look like.

Currently it seems to work except it shows multiple copies of records under each segment and they don't fall within the segment for each road.

I'm not an expert but I have played around with access for awhile now and then. Any pointers or ideas on how to get it to work correctly?

Thank you,

Jason

Attached Files

REPORT.pdf (60.4 KB)
Test Database.mdb (364.0 KB)

Create 280 of the permutations of the same report for printing

bgreg00 — Fri, 17 May 2013 02:38:29 GMT

Hello,

I'm using a bit of software developed in access for the statistical analysis of data. I am a new access user.

There is a single report in the access database that I would like to run for 280 different data inputs. It is the same report, only the inputs change. If I did this manually, I would have to select each of the 280 data sets in a drop-down menu and then print off each one of the reports individually to a pdf creator.

In my limited knowledge, it seems like I need a macro to both select the different data inputs and run the report over and over again. Somehow these reports would all have to be combined into a single printable report at the end.

I realize this is a vague inquiry, but, honestly, any help to send me down the right path would be appreciated. Thank you!

-Ben:confused:

"Hit counter" on Report

sevanty7 — Thu, 16 May 2013 15:05:12 GMT

I currently have a textbox that search for related records. Once the records are found it runs a report and displays information of each related record.
What i would like to have it somehwere on the page header of the report a small box that displays the number of records displayed below.

is there a count function or code i can do to make it do this?
Thanks for any help!

[Solved] Report Control Source Manipulation

justphilip2003 — Thu, 16 May 2013 03:10:16 GMT

I am searching for the proper (if possible) control source code to (1) print "Yes" when the table field is "True" and use case values 1 to 5 to insert a different phrase for each number. I gather that "If Then logic" isn't used in "Expression Builder"! Also is there a similar technique for Queries? TIA Phil

[Solved] Grouped field header on report

Glenn_Suggs — Wed, 15 May 2013 12:37:27 GMT

Hi all. I'm trying to display a grouped field header at the top of every page since the group may extend for many pages and I want the user to be able to tell what group they're looking at even if they open to the middle of the report. It works fine to put the group value somewhere in the page header, but this doubles up on the first page since the same value is also in the first group on the first page. So for example the first page has "Group Header 1" in the page header and "Group Header 1" also in the group header itself. How can I prevent the group header from displaying only on the first group of the first page? Thanks in advance...Glenn

Running Sum divided by Month Total

kwooten — Tue, 14 May 2013 20:47:03 GMT

I am trying to do a running sum divided by the month total. The month total is a baseline and the running sum is for # of hours. I am trying to do cumulative hours per person. I had the Dsum formula working correctly but can seem to get it to divide by the reporting months baseline.. any ideas?

=(DSum("[Training]","Relationship Mgt","[HRP LNAME]='" & [HRP LNAME] & "' AND [Month Number]<=" & [Month Number] & ""))/("[Portfolio Total]","Relationship Mgt","[HRP LNAME]='" & [HRP LNAME] & "' AND [Month Number]<=" & [Month Number] & "")

[Solved] File Path determines image imbeded in report - Not working

brharrii — Tue, 14 May 2013 13:41:31 GMT

I am using the following code to imbed an image on my report.

Code:

Option Compare Database

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

If IsNull(Me.ImagePath) Then

 Me.ImgPic.Picture = "O:\Bellingham\Intranet\Production\Labels\WIP\wip.bmp"

 Else

 Me.ImgPic.Picture = Me.ImagePath

 End If

End Sub

I've used it before and never had problems with it, but now it only works intermitently. For certain records it works fine, for others it gives me an error message that says that a custom macro failed to run and then when I push debug it displays my code and highlights the line:

"Me.ImgPic.Picture = Me.ImagePath"

I've verified that the path in ImagePath is correct on both records. What else could I be missing?

Thanks!

[Solved] What is a good title for this question?

libraccess — Mon, 13 May 2013 07:41:51 GMT

I have a form where there are 3 different functions by Employees, their names to be recorded.
OK so the tblActivity has 3 different FKs all to IDEmployee and so on the relationships the 2nd and 3rd FKs produce tblEmployee_1 and tblEmployee_2. All good so far. And on the form all is also good.
When it comes to the report and I want to display the 3 employees . So I'm thinking my query has all of tblActivity then I add tblEmployee 3 times then I'm sort of stuck. I could choose the fields from each table - but
I want to concantenate ExprNameBuilder: [Surname] & ", " & [NameFirst] for each of them but so far no go
Any ideas please

Team Rosters

TAD — Sun, 12 May 2013 05:17:27 GMT

I have 16 different reports for 16 different teams. The record source for each report is a query for each team . Each query refers to one huge student list that contains information about which sport the student plays, nationality, grade, address, etc. With 16 teams this method is still manageable, however I am thinking that there must be a better and easier way. These team rosters are like class lists for teachers in a school. In a big school of 50 to 100 classes, I can't imagine having to create a separate report and query for each class. Is there a way I can have 1 report which when run/opened (being new to access I don't know the terminology), will prompt me to enter team (eg. high school boys basketball) and also can retrieve the info straight from the main student data base, rather than having a separate query for each sport?

[Solved] Using "Count" function in a report footer

GraeagleBill — Sat, 11 May 2013 19:35:14 GMT

Is there a form of the count function wherein one can stipulate to not count duplicates? E.g., ControlSource of a text box =Count([LastName]) where it is possible that there are multiple records possible for the same last name. (Only want that name counted once)
Thanks,
Bill

Display and print group records in one page only?

wittybrent — Sat, 11 May 2013 10:25:32 GMT

Please kindly help me... on how to display and print each group by records in one page only.

Grouping Expressions

GraeagleBill — Fri, 10 May 2013 22:32:56 GMT

Can't seem to get group expressions correct. I need two groups:

[LastName] where [field1] = True (Sorted by last name)
[LastName] where [Field2] = True (Sorted by last name)

Then, how do I get to the section properties so I can specify NewRowOrCol for the second of the two groups.

Thanks,
Bill

Sub-report okay as stand-alone, but Filter expression errors when used as sub-report

GraeagleBill — Fri, 10 May 2013 18:54:15 GMT

I have a sub-report that formats and displays properly when run by itself. The On-Open code:

Private Sub Report_Open(Cancel As Integer)
Me.Filter = "[Provide Ride] > 0 AND [RetYear] = '2013'"
Me.FilterOn = True
End Sub

However, that same code gets an error at Me.Filter = "[Provide Ride] > 0 AND [RetYear] = '2013'" when I attempt to run the parent report.

I'm clueless as to what's different between the two.
Any ideas as to what causes the error?
Thanks,
Bill

Here's the error. (Too bad one can't paste images into a post)

RidesError.jpg

Attached Images

RidesError.jpg (20.0 KB)