Greetings,
I am creating a frequency report. I have 41 records, each record has sub-records from a source table. I am trying to detemine the frequency that each sub-record appears in a main record. So, if a sub-record appears 5 times, the formula would be 5/41=0.12.
The frequency calculation I currently have is residing in the footer of a report listed by sub-record. The footer displays sub-record name, total observations, and the frequency. The problem is that I can't get the denominator constant. I want the denominator to be the max number of records, but as it is in the footer, it is using the highest record that the sub-record appears in. Thus, if sub-record A appears five times, but the highest value is in record number 13, the calculation becomes 5/13=0.38; when the desired is 5/41=0.12.
Is there a way to point the denominator to the total records, rather than it looking at the highest sub-record value?
Thanks for any help!
3  1938  NeoPa 32,564
Recognized Expert Moderator MVP
Please do not *BUMP* your thread before at least 24 hours have passed.
Our experts and members offer their time voluntarily and do not deserve to be treated with impatience by those who may benefit from their efforts.
MODERATOR.
PS. As many look out for threads with no replies, you may well, ironically, have caused those same experts to bypass your thread.
NeoPa 32,564
Recognized Expert Moderator MVP
Getting back to your question :
Can you post the table MetaData of your data. I didn't find your explanation very clear as to how the data works together.
Here is an example of how to post table MetaData : Table Name=tblStudent - Field; Type; IndexInfo
-
StudentID; Autonumber; PK
-
Family; String; FK
-
Name; String
-
University; String; FK
-
Mark; Numeric
-
LastAttendance; Date/Time
Also, what are the (relevant) controls (particularly their formulas) that are in your report? Perhaps your problem is simply accessing the wrong item in your formula, but we can't tell without seeing it.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: DS |
last post by:
How do you get a sumon a calculated field in a detail section on a
report? I have a group footer that I need the sum on.
Thanks
DS
|
by: Trevor Best |
last post by:
I have a report that's fairly simple, page headers and footers, detail
has a subreport in (can vary in length). The customer wanted a signature
block for them, their client and 3rd party. This was no problem, couple
of boxes and labels in the report footer.
Now customer wants this signature block on the foot of page 1 (stoopid
IMO as that...
|
by: Mike |
last post by:
Hello All,
I have a report based upon a query. I have added a control to report
footer that calcs the total cost of the inventory: =SUM().
When this total calculation is NOT on the report, the report displays
as it should in ascending order by inventory number (inv_num).
1102
1103
|
by: manning_news |
last post by:
I've got a report that's not sorting correctly. I build a SQL
statement and assign it to the recordsource in the Open event, sorting
the data the way the user chooses. The user can choose up to 3 sorts
using a form that opens before the report opens.
When the report previews, it ignores the users' sort request and always
sorts by the...
|
by: pat |
last post by:
I'm working on a report.
I have two categories (groups) with a field labeled "Amount Funded." I
want to create a subtotal column (for each group) that subtracts the
"Amount Funded" from a number ($60,000.00 and $140,000 respectively),
and a "grand available total" that subtracts the total "Amount Funded"
from $200,000.00. How do I build...
| | |
by: Jimmy |
last post by:
Is there a way to force access to wait a specified time before making a
calculation?
On my report there is a subreport with a number of calculation on it. One if
which is a count of certain records using a text control with a running sum.
When I display the subreport on my main report, I can see the correct count
but when I make a reference...
|
by: Micheal |
last post by:
Greetings Access Group,
Being relatively new to Access, I try to work through problems on my own and have been very successful, although I have a conundrum that I have been working on for two days (total 10 hours) and I have yet to resolve it. please excuse me for my lack of terminology, I will try to provide you with the best of information.
...
|
by: JCMcAbee |
last post by:
Hello. Access 2003. I hope this makes sense. I request assistance with the following calculation problem:
In a grouped(?) footer of the report I have the following calculations in text boxes, and they are working well:
Column1: =Sum()
Column2: =Sum()
Column3: =Sum()
Column4: =(Count()+Count()+Count()-Count())/4
Column5: ...
|
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. ...
|
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...
|
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...
| | |
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...
|
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...
|
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...
|
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...
|
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...
|
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: 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...
| |
