Do Not Report If All Fields Showing An N
Jul 28, 2005
:p Hello,
I am wondering if anyone can help me create a query (which is used as a basis for a report) using a criteria which is clever enough to know that if all fields are have an N (no) that a report should not be generated - but with anything else e.g. all Y's or a mixture of Y's and N's that a report will be printed. There are 6 columns where there could be a Y (yes) or an N (no) and I would really like to know if this is possible in access??
Thanks.
View Replies
ADVERTISEMENT
Jun 12, 2006
Please help
I have created a database to track student grades. I have made a report that shows the different grades for each criteria of each unit but, because the students get to do the unit many times it shows the same criteria many times on the report. What I want to do is have the report show only the best grade for each criteria.
i also want to be able to work out the average grade for each unit from the best grade for each criteria and store this for use in another table.
If you require more info i would be happy to supply this. Thanks
View 4 Replies
View Related
Aug 15, 2006
I have created a form off a query. I made the form for adding new records only. When i bring up the form it is blank, the labels and fields don't even show. Anyone know why this is?
Thanks in advance for your help.
View 2 Replies
View Related
Jan 2, 2014
I have a report that is returning percentages based upon other calculated fields. Some of the percentage fields are showing #Num on the report. I've found this is due to one of the calculated values being zero.
3 Fields used:
Field: Qty
Total: Sum
Field: InitQty
Total: Sum
Field: OrderQty: Sum([Qty]-[InitQty])
Total: Expression
I need two more fields to return percentages based off of those 3 fields. This is what I started out with:
Field: InStock: [SumOfInitQty]/[SumOfQty]
Total: Expression
Field: Ordered: [OrderQty]/[SumOfQty]
Total: Expression
This works great until the query returns one that has sum of qty equal to zero. So this is what I've tried:
Field: InStock: IIf(Nz([SumOfInitQty],0),0,[SumOfInitQty]/[SumOfQty])
Total: Expression
Seems like it should work but its still showing #Num when I run the query.
View 2 Replies
View Related
May 3, 2005
Hi,
Each client has either an entry with a correspondence number or a notes number. So, the table would look somewhat like this:
Client: 333, Correspondence: 1, Notes: Blank
Client: 333, Correspondence: 2, Notes: Blank
Client: 333, Correspondence: Blank, Notes: 3
Client: 333, Correspondence: Blank, Notes: 4
How would I make a report that will make it look like this
Client: 333, Correspondence: 1, Notes: 3
Client: 333, Correspondence: 2, Notes: 4
Thanks! Hope that was clear.
G
View 4 Replies
View Related
Jun 24, 2005
Dear All:
I am totally clueless on this one. Here is the statement I am using in a textbox in a report:
=DCount("[Transcript_type]","[Diplomas_requested_per_month]","[Transcript_type]='Official copy'")
This report is based on a query. The query is called "Diplomas_requested_per_month". The fields in the query are: "Transcript_type" and "Request_date". In this query there is Between [Start Date] And [End Date].
I am attempted to count the number of "Official Copy" for a specified month.
I am propted to input the start date and ending date, it works great when I run the query. But in the report, I get a "#error".
I am thankful for who have responded to the previous posting of this issue, but I am completely lost.
Any help is greatly appreciated.
Regards,
Dion
View 3 Replies
View Related
Apr 21, 2013
I have a query that runs - off the back of this, a report. The query will show a name eg dave however the report will show Daves unique key (eg 3) and not just say dave how do I sort this?
View 2 Replies
View Related
Mar 14, 2008
In Expression Builder and other areas of Access where the fields of a query show, my fields are not showing anymore for any of my queries. Does anyone have a solution for this?
Thanks.
View 3 Replies
View Related
Apr 30, 2008
Firstly, thanks to everyone for help so far. My first access project in a proffessional environment has been successful and mostly down to the people who have helped me here. I know i didnt really do it all myself but i have learned things that will hopefully serve me well going forward!
Secondly, i apologise for the ambiguously titled thread, i'll explain what i mean.
Basically i have my form that looks like the below
What i'm trying to do, is make the questions below ("Risk in Authority" and "If Not, Risk Referred?") hidden, unless the answer to "Are All Policies Acceptable?" is No.
I have managed to make it happen, but it's far from perfect. As below:
I'd set the value for Visible to No in the properties for every object in the Questions (the pretty boxes are all named things like Box123 and Label 53, all set to hidden). Then i set the "On Click" event of the No in "Are All Policies Acceptable" (called Option168) to
Me.Box60.Visible = True
Me.Box121.Visible = True
Me.Box122.Visible = True
and so on.
This works ok, but if you click on the same option twice it reverses the action.
Is there a more effective way of doing this? maybe through Validation?
Thanks for any help once again. (I've also recommended this board to a couple of guys in the office who are already proficient with Access and SQL who can hopefully contribute to the community )
Edit: As an Addendum - this formattign should only apply to one record at a time. So if the question are visible on record 1, they could still be hidden on record 2. If that's even possible.
View 7 Replies
View Related
Aug 8, 2013
I Created a form and linked it to a ODBC table with no data. Set the Allow Additions property to Yes. It shows fine if there is data in the table but not when there is no data.
View 1 Replies
View Related
Sep 27, 2004
Colm and Baxter, you've been great helps to me so far, and I will include you in the special thanks in my programming credits. I ask your help once more-
My program tracks how many calls are received per day at the office. I have a report showing a chart (thank goodness for wizards ) that lists the calls per day. This all works fine, and I was extremely proud of myself for doing so. However, after thinking about it, I realized that after a while, my client might not care to see ALL of the calls per day ALL of the time, and might wish to see maybe a week's worth or a month's worth at a time. I was thinking I could solve this by using a form to enter "from" and "to" information, but I'm not quite sure how to apply this so it would work with my report.
Also, if I can get this to work, on this same form I would like to have an option field that the user can select so that the usual options (today, this week, this month, this year, all) require only a click, rather than having to figure out what days are in this week (a tedious task, I know, but we're going for efficiency here ) but they also have the option of seeing specific dates they want.
The fields that I'm using for this are very simple- tblCustomer.CallDate and tblCustomer.LeadType, where CallDate is just a date and LeadType is a string from a lookup table that is either "Call-in" (the one I'm tracking) or "In-field".
I know this sounds like a lot of coding, but I'm sure if you could get me started, I could figure out the rest myself. It's just that the way Access does dates is so confusing to me, and I have midterms coming up and not a lot of time to figure this out by myself from scratch. Anyways, thanks for your help in advance!
Jason
View 2 Replies
View Related
Jan 12, 2015
I have a main report with one subreport. The main report contains details of a payment being made to a supplier. There is the total amount being paid, and the cheque number being transferred. There is also a field called payref which is made invisible. This is used to link up with the subreport. The amount is the total of several invoices for which payment is being made.
The subreport contains details of each of a number of the invoices being settled. The subreport is linked to the main report via a common field called pay-ref, and the subreport is 'visible'. The subreport prints when placed in the page header section of the main report. However when there is a large number of invoices being shown in the subreport only a certain number appear. It appears that the subreport can only hold a certain number.
When the subreport is put, as it should, in the detail section of the main report, it does not appear at all in the main report. I have no clue why and I have made several reports like this one before.
View 2 Replies
View Related
Jun 16, 2015
I am trying to show the Current Repair Estimate total in currency form on my report. The attachment shows my criteria, which works on the query, but does not show in the report. The second attachment shows what pops up when I try to view the report. What can I do to get this current rep estimate to show correctly in currency form on the report?
View 8 Replies
View Related
Feb 9, 2015
I have a REPORT containing 7 ('columnar') subreports. Each subreport is to show showing a days worth of medical doses.... to visually represent a wall planner.
When the report loads - user enters a week value # via Inputbox(). This value is written to a TEMP table. Each subreport accesses this same TEMP table to retrieve the week # value. In the Recordsource for each subreport I have the following code :
SELECT * FROM GETPATIENTREADINGS_WEEK WHERE (((Format([DateR],'ww'))=DLookup("WeekVal","[TEMPTABLE]")) AND ((GETPATIENTREADINGS_WEEK.DayVal)=1));
... where the DayVal goes from 1...7 corresponding to the columnar position of each subreport on the display ie. for each day of the week.
The problem I am having is that when the report runs - I see the display showing the data from when the report was previously run. ie. I have to run the report twice to see the data for the correct week value entered. All the SQL works as expected when I run from Query view but when I run through VBA..
View 3 Replies
View Related
Apr 22, 2015
On design, layout and report view, everything looks exactly how I want it. However, when I display it in Print Preview mode, checkboxes appear about the Project Name.There's nothing in my report to show that I have these checkboxes on the report. Where these could be coming from and why they only show in the Print Preview layout?
View 2 Replies
View Related
Mar 6, 2014
I created a Report from a query. The query shows the correct data that should be on the Report. I created the report to sort by Field A and then sum Fields D, E, & F. None of the query data shows up on the Report. I;m stymied as to why I can see data on a query, but the ONLY data that shows up on the Report is Field A. None of the summations show. All are blank with the box outline.
I've created the report 3x thinking I did something incorrect. Whatever it is, I did it 3x!
View 4 Replies
View Related
May 2, 2013
I have a subreport with bitmap files attached, the sub works great until I link it to the main report then the sub shows nothing.
View 2 Replies
View Related
May 28, 2015
On report, date shows as: 5/23/2015
I want it to show as: 05/23/2015
The input date in main table has the same format as the fields without the '0'.
Property for all date fields appear the same...
View 5 Replies
View Related
Jan 3, 2013
I have an Access 2010 report that is pulled from a dedicated query. When i run the report, one of the fields pull the information in both the numerical ID number and the Field information. For example, the field in question is a field for "business type"......the report comes back in some lines as Manufacturer, Supplier, distributor, or contract. In other lines it comes back as either 1, 2, 3, 4...which is the ID number form the table. I have gone through all the properties and data source and can not figure out my the information is being returned so differently.
View 1 Replies
View Related
May 6, 2013
In one of my databases, I have a form and a report where the images stored in my tables are not showing properly for all entries. They show as an icon with the file name rather than the image itself. This is not true for every entry, so I don't think it would be a problem with how the form and report are set-up.
View 6 Replies
View Related
Jan 28, 2014
My company wants to store both a digital copy and a hard paper copy of the files in the access database. Because of this I need to figure out a way to show in the reports the paths to the attached files so that people reading the paper versions can locate the corresponding files on the computer in the future. I have been searching the internet for several hours and have come up with nothing. Is there a way to do this?
View 1 Replies
View Related
Jun 4, 2013
How to query Select Distinct field + showing other fields? E.g.:
Code:
SELECT DISTINCTROW assetMovementTable.assetNo, assetMovementTable.moveCode, assetMovementTable.compCode, assetMovementTable.compCodeDesc, assetMovementTable.assetDesc, assetMovementTable.equipType, assetMovementTable.equipManufacturer, assetMovementTable.equipModel, assetMovementTable.constYear, assetMovementTable.plateNo
FROM assetMovementTable
[Code] ......
View 7 Replies
View Related
Jan 21, 2015
I have a report that runs from a query with fields but for some reason its not showing all the text in the field it only shows around 250 characters, I have the field to auto grow in size but still not working?
View 1 Replies
View Related
Jan 27, 2014
I have a query which selects a material ID and material name from one table and the associated manufacturer, supplier, and packaging type from three other tables. Some of the manufacturer, supplier, and packaging data were imported from an Excel spreadsheet and did not have data for those fields, so those fields are blank. When I run the query, I only get the records which have all fields filled out. How can I get the records where the material ID and material name are filled in, but the manufacturer, supplier, or packaging type are blank? Here is the query I'm using currently:
Code:
SELECT tblMaterialSpecifications.ID, tblMaterialSpecifications.Critical, tblMaterialSpecifications.MaterialSupply, tblManufacturer.Manufacturer, tblSupplier.Supplier, tblPackaging.PackageType
FROM tblPackaging INNER JOIN (tblSupplier INNER JOIN (tblManufacturer INNER JOIN tblMaterialSpecifications ON tblManufacturer.ID = tblMaterialSpecifications.ManufacturerID) ON tblSupplier.ID = tblMaterialSpecifications.SupplierID) ON tblPackaging.ID = tblMaterialSpecifications.PackagingID
WHERE (((tblMaterialSpecifications.ActiveInactive)=-1))
ORDER BY tblMaterialSpecifications.Critical, tblMaterialSpecifications.MaterialSupply;
View 1 Replies
View Related
Feb 12, 2014
I've recently moved up to Access 2013 (from Access 2010) and everything went well, until one day my splash screen was blank and the program had empty fields...after seeing that all the links to the BE were OK, I re-booted and everything worked fine....until the next day the same thing happened...... The program randomly falls over about once or twice a week and I have to re-boot to cure it.....
My splash screen has a standard dlookup ( [=DLookUp("Banner","tblCompanyInfo")] ) to display the active company name...and sometimes its populated and other times its not..... if its not populated then loads of other fields on the forms are also blank - even if they point to valid data in the database!!!!!!
Win7 (both 32 and 64bit) with Access 2013 32bit on three PC's - same problem on all!!!!
View 14 Replies
View Related
Mar 26, 2014
I have a very simple report that is generated from a table. There are no queries associated with this report. When new information is entered into my table I run the report and the new information appears. It has been working correctly for months. Now all of a sudden after the new information has been entered it doesn't show in the report.
View 4 Replies
View Related
