Below is the SQL Code for a Query that I have. It gives me the total of No Faults. My issue is if there are no No Faults I would like to show a zero. Is there anyway to accomplish this?
SELECT WorkUnitsFaultsMainTBL.FaultCategory, Count(*) AS [No Fault Totals]
FROM WorkUnitsFaultsMainTBL
WHERE (((WorkUnitsFaultsMainTBL.BuildID) In ("E010","C809","F001","C810","F187","A910","M173","M174")) And ((WorkUnitsFaultsMainTBL.FaultCategory) In ('No Faults')) And ((WorkUnitsFaultsMainTBL.TodaysDate) Between Forms!Queries_ReportsFRM!StartDateTxt And Forms!Queries_ReportsFRM!EndDateTxt))
GROUP BY WorkUnitsFaultsMainTBL.FaultCategory;
I have a parameter query built and am curious if anyone knows of a good way to allow the user to define which fields are displayed in the query results.
i tried looking for other threads discussing this without any luck.. not sure if it was my search terms or what. thanks so much for any help..
I'm trying to create a report where I can use a section header as a hyperlink to show/hide detail, but only for that section. For example, my customer names are:
Code: ABC Co. ZYX Co. 123 Co.
If I click on ZYX Co., I want it to show the contracts for ONLY that customer:
I have two tables, one for categories and one for records. I have sorted out the active records. But I only want to see each category once. Right now I see the category for each active records.
What I am looking for is a list of categories that have active records in them.
I have Part Numbers and Events. Each Part Number should have 4 different Event Numbers.
10 20 40 80
I would like to have a query that would show me which of these part numbers that do not have Event 10, 20, 40 or 80 with it and for it to show which of these four numbers it does not have.
This hard to explain. Can anyone tell how to do this?
I have a query made up of a number of other querries. the query works fine and I am able to get the results to go into a form, (I have been advised that calculations, which is what the results are should not be put into a table, so I havent). The query is set up to show results even if some of the origonal querries produce no results, again it works fine. My problem is that when I show the results in a form I want anything that produced no results to show "0". At the present time it just leaves the textbox blank. I need it show "0" in order that furthur calculations can be carried out! Make sense, I hope so!
I have a query that displays tow number fields. Feild1 and feild 2.
I only want to show the feilds that dosent match. If feild one has 50 and feild 2 has 60 then it would show. if feild one has 50 and feild two has 50 then it wouldnt show, only the values would show if they dont match
I'm trying to view the last two valuations for each property so that they can be compared. I can pull out the last valuation for each property and can pull out the top two records but not for each property, just shows me the top 2 of all records.
Hi again, my problem is that on a report I have a row of dates i.e. 10/10/2006, 11/10/2006 etc. However, people would prefer to see Monday, Tuesday etc. Is there a way to show the date as the day name. The date fields are all based on the Date() expression then +1, +2 etc so are always changing.
Hi, I have been using Access 2000 for quite a while now. I have been using the Immediate Window to call my code, but for some reason, this window won't display now, no matter what I do - I have repaired the installation and reinstalled it but to no avail
Hi there, i have a field called numbers - i need to throw a messgae box alert if the value within taht field reaches or is 5. I have records so if within any of these records if the number field contains say 5 then it should show john's number has reached 5. So it must read the first field name of that record and teh number field of the record. I've been trying to use the macro tool - but no luck yet. An start would be just to show that the number field has reched 5 without showing the first field record i.e. john not shown. Anyone have any idea how i could do this.
Have developed an Access dB for logging and reporting on support issues. The following query is used to show how many issues are raised in a specified time period.
SELECT ISSUES_BY_SYSTEM_AREA.report_category, Count(*) AS instances FROM ISSUES_BY_SYSTEM_AREA GROUP BY ISSUES_BY_SYSTEM_AREA.report_category;
REPORT_CATEGORY can have a number of values e.g. Technical Support Issues Configuration Changes User Admin Other
I have two questions (1) How do I get it to report for each category even if the number of intances is zero? For example, if there have been no instances of 'User Admin' this month, I want the results to show as follows (2) How to show the sum of these as well
For example what I want to be returned is: Technical Support Issues 5 Configuration Changes 14 User Admin 0 Other 2 Total 21
Currently this is what would be returned: Technical Support Issues 5 Configuration Changes 14 Other 2
I have a table with an autonumber incremental ID field using the format 0000, 0001, 0002 all the way to 1530. I'm trying to create a query that returns the last 5 records in decending order, so...
I am writing a very very simple query to identify postal codes from a list of addresses. The table containing the data has a field called POSTAL_CODE.
I need to exclude the last three digits of this postal code so as to only show the first 2,3,4 digits.
Example would be simple by having a query just showing the first few digits like this Left$([POSTAL_CODE],4) for example, however that will not show correctly for SK6 5LP and M2 4DJ and SK12 8LY.
I have either 2, 3, 4 digits I will need. All that is sure is - I do not want to see the last three digits. Identifying the last three is of course simple, but I cannot exclude them. Tried this
Right$([POSTAL_CODE],3) - and calling the field LAST_THREE and then ([POSTAL_CODE]-[LAST_THREE])
However does not work because these are numbers and letters.
Probably a simple one, can someone please help - perhaps a query that sounds like this : show all but not Right$([POSTAL_CODE],3)
I am writing a very very simple query to identify postal codes from a list of addresses. The table containing the data has a field called POSTAL_CODE.
I need to exclude the last three digits of this postal code so as to only show the first 2,3,4 digits.
Example would be simple by having a query just showing the first few digits like this Left$([POSTAL_CODE],4) for example, however that will not show correctly for SK6 5LP and M2 4DJ and SK12 8LY.
I have either 2, 3, 4 digits I will need. All that is sure is - I do not want to see the last three digits. Identifying the last three is of course simple, but I cannot exclude them. Tried this
Right$([POSTAL_CODE],3) - and calling the field LAST_THREE and then ([POSTAL_CODE]-[LAST_THREE])
However does not work because these are numbers and letters.
Probably a simple one, can someone please help - perhaps a query that sounds like this : show all but not Right$([POSTAL_CODE],3)
I know this might be an easy one, but I need to know how to have a field in my report/query not show data if the field has a value. It is a date field that when I have a date in the field I do not want it to show in my report.
Below is the SQL I have on a query. This query is made up of 4 other queries. If any of the fields = zero how can I make a zero appear? Right now the field just shows blank if it is equal to zero. I really want the zero to appear on a form that I have created from the query. Thanks for all help.
SELECT MonthlyEcnReceived.Received, MonthlyEcnImplemented.Implemented, [MonthlyEcnW/Structure].[W/Structure], [MonthlyEcnW/StructureImplemented].Implemented FROM MonthlyEcnReceived, [MonthlyEcnW/Structure], MonthlyEcnImplemented, [MonthlyEcnW/StructureImplemented];
Below is the SQL for my query. The results will show month year in a column that looks like: 03 2008. Is there anyway for this to show as Mar 2008 instead. This month is achieved by selecting a date range on a calendar on the form. If the first date is 3/1/2008 and the last date is 04/29/2008 then the query will show as:
03 2008 04 2008
I would like for it to show as: Mar 2008 Apr 2008
Can anyone tell me how to do this?
SELECT Format([TruckDate],'mm yyyy') AS [Month Year], Count(*) AS TruckTotals FROM TruckRegisterTbl WHERE (((TruckRegisterTbl.Company) Is Not Null) AND ((TruckRegisterTbl.TruckDate) Between [Forms]![VisualInformationForm]![StartDateTxt] And [Forms]![VisualInformationForm]![EndDateTxt])) GROUP BY Format([TruckDate],'mm yyyy');
On aform I have 3 controls, 2 x check boxes and a combo box. depending on what is selected from the combo box will determine which of the two check boxes are visible.
I want to reflect this on a report. i.e I only want to show the checkbox which has got a true reading. Is it possible to do this without doing it on two seperate reports?
