Search results

Thanks, that worked. Now, how do I also add a Total Count to the same query? Is that even possible?

OK, it works but it is not showing those with a count of zero. How do I get it to show those? My end product is a report that shows metrics and those categories with a count of zero is required by the end user.

OK...so I have the table with the categories listed above. The categories are chosen via Combobox that is linked to another table. How would I fix the join? tblAV_Fail_Cases - table that I want to perform the count on tbl_Test_Case_Status - table that the combobox displays in the above table

I have a table that shows the the status of the record as "Not Started", "In Work" or "Complete" I want to count the number of records that fall into each category. I am currently doing the following SQL: SELECT tblTest_Case_Status.Test_Case_Status, Count(*) AS NumberofRecords FROM...

I have tried each of the examples you have given and still get the Runtime Error 13 - Data Mismatch. Each filter works independently, but when I try to filter based on both conditions, it doesn't work. Each of the combo boxes are text fields, and carefully looked at the syntax. I'm stuck. I...

OK...I understand the logic and have tried several variants, but keep getting a syntax error or run time error. Here is exactly what I have... Private Sub Combo11_AfterUpdate() Me.Filter = "[1st_Fail_Domain] = '" & Me.Combo9 & "' And " "[2nd_Fail_Domain] = '" & Me.Combo11 & "'" End Sub

I am trying to filter data on a form based on user selection of criteria from two independent combo-boxes. Here is the code I have so far: Private Sub Combo9_AfterUpdate() Forms![frmDF_AV_Fail_Cases_Summary].Form.Filter = "[1st_Fail_Domain] = '" & Me![Combo9] & "'"...

I have a field on the form that is suppose to indicate when the last edit to the record occured. I was trying to get it to fill in the date on the users machine when the save record command button was depressed. How would I do this?

Anyone have any suggestions...

First table is as follows... Domain - text, combo box Failure_ID - text Failure_description - text Other-supportign data that makes each record unique... Failure_rate - Number In the Dual Failure table, the failure rates are calculated.... If you have any ideas on if I shoudl change the...

pbaldy... I tried your code and generated no errors, however, no data is returned. The second table has the following structure... DF_ID - text field 1st_Fail_ID - text field based on Failure_ID of the original table 2nd_Fail_ID - text field based on Failure_ID of the orginal table and...

The second table contains data specific to the dual failure condition.

I have a table that lists single failures, I then run an append query to create a table of dual failures of every combo of the single failures. I am trying to create a form that lists only the dual failures associated with a particular failure and here is the criteria I have below...