Reports :: Report To Show Data Details Selectively For Each Field / Qualitative Data
Apr 16, 2014
I have data from a survey with qualitative responses. For a single qualitative question, I moved the ID & responses into a new table and categorized the response according to a bucket/theme, where each column is a new bucket. I now have 10 columns. Each response is represented in 1 or more columns. I used an excel formula to copy the response data into the column itself.
Example:
A1 // B1// C1 // D1// E1//... L1
ID // Response // Cats // Dogs // Elephants //.... Column 10
1 // I like cats // I like cats //(null)//(null)// ... (null)//
2 // I like cats and dogs // I like cats and dogs // I like cats and dogs //(null)//..//
3 // etc.
However, now I'm realizing that Access always wants to show data for all records, or at most I can limit using a WHERE clause in my query.I want to use Access to generate this report:
1. Section 1: Show all responses from the Cats bucket where there is data
2. Section 2: Show all responses from the Dogs bucket where there is data
3. and so on
I know how to do summary values, and I know how to do filtering that apply across the whole report, but this seems like more advanced filtering, where I want to see selective details differently for each field.
I have a report that shows all visit dates and the rep that did the visit. How do I only show the most current data. I use an append query to add records to a specific table. The report pulls from that table.
I have a sub report on my form to show all data needed for a delivery note.
these fields are :
House Type Plot No Product Delivery Note No
when i use my query to search orders in my subreport - it will show the required data but will also show data i didnt search for ? why is this?
Sometimes my search results in the subreport show further down the subreport than the irrelevant data - all i would like is for it to show the specific data not the irrellevant data.
I am creating a report that contains name andd birthdate on one line. I need to have up to seven lines in the report for some groups, but do not want to leave blank lines where no names exist. I am working in 2010 and have read about canshrink in 2007, is this approach availabel in 2010 and for date as well as text?
I've got a report that is displaying addresses which are all identified as 'public' or 'private'. I want to be able to display the 'public addresses' and leave the 'private' addresses blank (but still show other fields.. phone no.s etc). The field that the data appears in is Address 1 (for both public or private), depending on what the data entry clerk has selected as the preferred address (ie public or private).I've been playing with the Iif function, but have not had any success...
Address Type: Private or Public Address1: Address details
I have become stuck with an issue which I am sure is entirely my fault. I am trying to create/modify a macro for a field ([cx_ref]) on a report (Upholstery_orders), so that when a particular record is clicked, it uses the data in that specific record and field to open another report (works_orders), based on said data.
So far the only headway I could make was to create a macro that opened an intermediate form with a combo box displaying every record in [cx_ref]. I'm not a huge fan of this method as any user would have to either memorise then type, or scroll down thousands of records in order to locate the correct one, select it and then click a button to open the "works_order" report.
A macro (or code) that could take one from the original report, using the data in the 'clicked' box/field on the form, and open the second report without having the input the data again. Short of being able to do this, any way to simply export the selected field so that it appears on the intermediate form (without the need to select or type it again), be that in the combo box or in a box of its own.
I am in the process of making some changes to an inherited database. One of the things I need to do is to fix an issue with the reports. The reports have a field which asks for the data range (from xx/xx/xx to xx/xx/xx) as soon as the report is opened, but then the query that fills that report also asks for the same data range so you end up entering it twice.
What do I need to do to enter the data range only once and have it show up on the report and also be used on the query?
I have a report which will be printed on preprinted paper. On this paper a footer is printed with e.g. address info.
The report has a detail section with a height of 3,5 inch and canGrow=true.
The reportFooter contains totals. The size of this footer, and placements of the fields prevents printing data on the pre-printed footer of the paper.
But when the report has multiple pages, the report footer will be printed on the laste page, and the detail section is expanding to the bottom of the paper, overwriting the pre-printed footer. I need a max height of the detail section, or another solution.
I know that multivalue fields are not the best to use, but I have a simple database that they work fine in. My question is this: Is there a way to show the entire list of choices in the multivalue field on a report? Not just the ones selected, but all of them, whether checked or not? The multivalue field has a list of names and the user selects each name if they repond to a incident (fire, car accident, etc.). My report would show the entire list and count number of responses by each name during a date range. I want to show all of them on the report, with those not selected showing "0".
I have two collums, currentowed and currentpaid. i want to add another field to my report showing the percent of currentpaid to currentowed but I can't seem to be able to make it work. I tried:
=sum([currentpaid]/[currentowed]) and it doesn't work.
I have a main report with several subreports. Some subreports have other nested subreports. all of the reports and subreports are based on queries. when a query returns no values, i would still like for the reports and subreports to display in print preview. (currently, they display in report view but not in print preview.)
I tried a few things:
1) I set all report section can shrink options to "No" - (this did not work)
2) I set the can shrink options for all textbox controls, within each report section , to "No" - (this did not work)
3) I moved all controls from the details section of the subreport to the report header section - (when I did this, I got the subreport to show in print preview when the query for a single subreport returns no values but when i have a subreport with nested subreports that have no value, none of them show up in print preview)
I've searched...moving the controls from the details to the report header was the best thing i could find, but again, this only works with a single subreport and not with multiple nested subreports.
I want the report not to show data with zero balances.
Example: if my report has 10 line items and 3 of these line items have 0 balances, then the report should only show the 7 items that do not have 0 balances. (the report should use up 7 lines / rows only.)
See the attached report for a better understanding...
I have a database with a form called "Main" where users input data and then print a report from it. "Main" has fields in it from another form "Members". This data (from "Members") is shown on "Main' by Dlookup coding, and therefore cannot be selected for input by the user. Now, lets say a user inputs data into "Main" and prints the report on 12/30/2012. On the next day, a member's name is changed and I update that data in the "Members" form. On 12/31, I would like to print the report again, but it shows the updated member's name instead of what is was like on 12/30. How can I keep the old data in case I want to print the report in the future like it was initially printed? What do I need to do to any form(s), report or what VBA code needs to be written?
I would like to create a report that would really impress my supervisors, i just started at the company. I'm trying to create a call action plan, so i'm recording clients information on one table, and meetings we have had with each respective client on another table. Some clients will have multiple meetings, some few, and some none. I have a relationship set between them from the client's id number on the client table to the ClientID on the meetings table. one to many.
When I go to create the report, only the clients with meetings show up on the report, I would like client info to always show up on the report and meeting info to only show up under each respective client when it exists. I have worked out how to shrink and hide any text box without any info on it. It just seems like the existence of a meeting dictates where the client will show up at all in the report.
I'm designing a database for a laboratory. There are many tables that will contain test results. They all have in common a field called ID( primary key) linked by a one to one relationship because one patient has reports in different tables. The ID is unique to each patient. For the Reports, i hit the rocks... How can i structure a report that can extract a patient's records from the different tables where they appear in the database?
I have a report which shows the results of two separate queries in a simple table view.
One set of data varies in size depending on the amount of records and the other is a fixed size and never changes.
I'm wanting to make my report always show the fixed size data in the bottom right corner of the page when its printed.
I've tried putting it in the footer section of the report but don't want it to affect the size of the details section and just show next to the other query results.
Is this possible and if so how would I achieve this?
So I have a text box in a report that I want to pull in data from a field in another report, so the 'control' for my text box looks something like this...
=[Reports]![rptSalesReceiptSub]![Text141] (i.e Text141 is the data I want to pull into my report)
...the path is completely correct but when I run my report I get.#Name? If I run the report that has the data I want, it's fine (in other words Text141 has valid data in it)