Search results

I have an option group (optResponse31) that has 3 buttons. I want a message to pop up when the user clicks on the form by clicking the X on the top right of the form. I want the message to state "Please enter a value." if no value is entered. I tried to set the required property in the...

I am a beginner, so keep that in mind :confused:. I am actually a Business Analyst and not a developer. I have an issue with a database that has two forms: frmBankruptcy and frmClaims. I think frmClaims is a subform. The forms are joined on CaseID. There is one Bankruptcy case to...

Hello all, I am not a developer, but a Business Analyst. The limits of my Access knowledge were from a class taught almost 20 years ago, so I am looking forward to getting help here. I have a few questions. Please forgive me if I am not asking them in the right place and let me know...

First, I am a novice at Access. I have the following question: I have a database of attorneys. The attorneys detail table has a column named section and division. Each attorney is assigned to a section and division. The divisions are a subset based on the section selected. I need to...

Hello, I am using the following function: =Avg(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)) I have a subform with a total of 18 records. 2 records...

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...

Hello, I am trying to count the number of records in a subform where the text box (txtFinal) = RPR-RPR & RTN. The subform is called PartNumbers. The table name the subform is bound to is named Completed. I tried using =DCount("[Part Number]","Completed","[Final] = 'RPR-RPR & RTN'"). That...