I am a beginner and trying to get the following results:
All records from page0 where records on page4 do not have a Role of 'DCA Specialist'. Page0 is the one record table and Page4 is the table with the many records.
The issue is:
I getting records that have 'DCA Specialist' on page4. The Serial Number in Page0 joins to the CaseSerial in Page4.
Here is the query I attempted to do: ...
rhonda6373
Last Activity: Jun 15 '21, 03:34 AM
Joined: Mar 10 '10
Location:
-
Finding duplicate values in 2 different tables
Hello,
I am a very new beginner. I have the following problem I would like to solve. I have a column named matterno in a table named page0. I have another column named court in a table named page2. I would like to find all matterno that have the court duplicated in page2. I would like to include both matterno and court in the results. Can someone assist?
Thanks! -
Thank you. I will try that. -
Thanks Rabbit. I got it before I saw your reply by combining some other functions I had. I will try it your way as well so that I can understand.
Here is what works:
...Code:=Sum(IIf([Final]="TST-TST OK RTN" Or [Final]="NFF-TST & NFF" Or [Final]="RTN-RETURN" Or [Final]="SCL-SCR LOCALLY" Or [Final]="SCR-SCR RETURN" Or [Final]="BER-BER RTN CST",Nz([Cost of New],0),0))/Sum([Final]="TST-TST
Leave a comment:
-
Average function not calculating correctly
Hello,
I am trying to compute the average of Cost of New based on the criteria below. However, for example if there are 18 records and there are only 2 that meet the criteria it is dividing by 18 instead of 2. How can I get this to work correctly? Thanks in advance for the help.
...Code:=Avg(IIf([Final]="TST-TST OK RTN" Or [Final]="NFF-TST & NFF" Or [Final]="RTN-RETURN" Or [Final]="SCL-SCR
-
That is what I am looking for, thank you!Leave a comment:
-
Access Sum Function Criteria
Hello,
I am trying to sum a column on a subform named Cost of New if another column named Final = any of the values listed in my code. However, it is summing the Cost of New column regardless of the values of Final. It is summing for all values.
What do I need to modify to make this correct or should I do it another way?
...Code:=IIf([Final]="RPR-RPR & RTN" Or [Final]="NFF-TST & NFF"
-
DCount function returning zero records
Hello,
I am trying to count a field ID from Completed (the table name) where the values in a text box (txtFinal) on a form = RPR*. It is coming up with zero records when there are several. Do I have something wrong with the syntax?
The count I want to return is the amount of records on the subform where txtFinal = "RPR*".Code:=DCount("[ID]","Completed","[txtFinal] = 'RPR*'")
... -
Please disregard my first message -- I found a mistake and corrected it.Leave a comment:
-
Compile Error Method or Data Member not found
Good morning,
I am not an experienced user and have a basic question. I have a main form named Test Cases which has a subform called TestSteps. The subform TestSteps has a field named StepDescription . I want the user to be able to click on the field StepDescription and open another form UnitTestCase. I want Unit Test Case to open where StepDescription on TestSteps matches TestCaseID on UnitTestCase. Both fields are text fields.... -
Good tips, thanks! I will make those changes. Yes, st is numeric.Leave a comment:
-
Thanks, NeoPa. Understood. I will post the code as is in the future unless it is SQL.
Here is what I did in the event someone else is having issues with reordering columns in a subform based on a certain condition:
...Code:Select Case [st] Case "3" Forms!Default!NavigationSubform![Account Number].ColumnOrder = 1 Forms!Default!NavigationSubform!Company.ColumnOrder = 2 Forms!Default!NavigationSubform![CBSLeave a comment:
-
No problem. I did not realize putting the and on a separate line would be such a problem -- I was just trying to make it easier to read. It is not coded on a separate line and the code does compile. I am not delusional (well maybe but not in this instance). As you can see, I am new to the site and don't fully understand how I am supposed to write these questions up.
Sorry for the confusion and the waste of any time. I do appreciate...Leave a comment:
-
I am posting the code because it does run. Thanks for the harsh answer, but forgive me I have not had VB in 10 years. Also, this is someone else's database with existing code in it. I would not be so condescending. I will figure this out on my own somehow.Leave a comment:
-
ColumnOrder in Subform not performing as expected
Hello,
I have an option group on the main form that filters what records are displayed on the subform. The option group is named st.
I need to also reorder the columns on the subform if option 3 is chosen. I have to reorder several columns.
I have tried just one to see if it worked. The issue is that it reorders correctly if option 3 is chosen, but it does not reorder back to the original order if... -
Thanks everyone for the input! I did figure this out.Leave a comment:
-
Reset Option Group
I have an option group that filters a subform. It is filtering correctly except that when I select a value and close the database, it filters on that same value instead of the default when I open the database again.
So for example -- the default is All. I select Pre Installed and the subform is filtered correctly. I close the database and re-open. The subform is still filtered for Pre Installed records although the All button... -
Hello,
I figured this out. Rather than trying to understand this query, I just replaced the values "All";"Pre-Installed";"Q Accounts";"Acti ve Accounts" in the query with 1,2,3,4 and renamed the radio button frame to st. It appears to work.
Thanks!Leave a comment:
-
Filter Subform with Radio Buttons
Hello,
I am trying to change a filter for a subform (Default) that has a filter based on a drop down box with a Search button to a filter based on radio buttons.
However, I don't understand the current query enough to begin to change it. Here is the command that opens the query which has a subquery as well.
Here is the part of the query I am having...Code:DoCmd.OpenQuery ("QryAccounts")Last edited by zmbd; Aug 27 '14, 09:12 PM. Reason: [z{stepped code and SQL for easier reading. Underlined the control and ctrl.name}] -
Thank you all very much. This was helpful.
The database has a drop down box (st) where the records from a subform can be filtered after making a selection and clicking Search. I was trying to change (st) from a drop down to radio buttons and was not sure how to make that change.Leave a comment:
No activity results to display
Leave a comment: