如何计算组合框中的数据 [英] How to count the data from a combo box

问题描述

我创建了一个包含两个组合框和其他信息的表单。第一个组合框包含以下项目：（5000美元以下的索赔，PIR / CPRA，潜在索赔，CA Vic Comp，Summons& Complaint，生成文档的请求）。第二个组合框包含以下项目（车辆损坏，挡风玻璃索赔，而不是州公路，ORIM，合同，区域）。两个组合框都是相关的。我需要创建一个查询，计算并显示总共处理5000美元以下的索赔数量以及5000美元以下的索赔数量中有多少是用于车辆损坏，挡风玻璃索赔，非州高速公路，ORIM，合同或区域。我需要对第一个组合框的每个项目执行相同的操作。请帮助。我不知道我是否必须在组合框中的AfterEvent选项中执行某些操作。像我这样的新手最简单的方法是做什么。

I created a form that contains two combo boxes plus other information. The first combo box contains the following items: (Claim Under $5000, PIR/CPRA, Potential Claim, CA Vic Comp, Summons&Complaint, Request to produce docs). The second combo box contains the following items ( Vehicle Damage, windshield claim, not state Highway, ORIM, Contracts, Districts). Both combo boxes are related. I need to create a query that counts and displays how many Claims under $5000 were processed in total and how many of those claims under $5000 are for Vehicle Damage, Windshield Claim, Not state Highway, ORIM, Contracts, or Districts. I need to do the same for each item of the first combo box. PLEASE PLEASE Help. I have no idea if I have to do something in the AfterEvent option in the combo box. What will be the easiest way for a newbie like me to do this.

推荐答案

5000，PIR / CPRA，潜在索赔，CA Vic Comp，Summons& Complaint，Request制作文档）。第二个组合框包含以下项目（车辆损坏，挡风玻璃索赔，而不是州公路，ORIM，合同，区域）。两个组合框都是相关的。我需要创建一个查询，计算并显示总共处理

5000, PIR/CPRA, Potential Claim, CA Vic Comp, Summons&Complaint, Request to produce docs). The second combo box contains the following items ( Vehicle Damage, windshield claim, not state Highway, ORIM, Contracts, Districts). Both combo boxes are related. I need to create a query that counts and displays how many Claims under

5000下的索赔数量以及

5000 were processed in total and how many of those claims under

5000下的索赔数量是多少车辆损坏，挡风玻璃索赔，非州公路，ORIM，合同或地区。我需要对第一个组合框的每个项目执行相同的操作。请帮助。我不知道我是否必须在组合框中的AfterEvent选项中执行某些操作。像我这样的新手最简单的方法是做什么。

5000 are for Vehicle Damage, Windshield Claim, Not state Highway, ORIM, Contracts, or Districts. I need to do the same for each item of the first combo box. PLEASE PLEASE Help. I have no idea if I have to do something in the AfterEvent option in the combo box. What will be the easiest way for a newbie like me to do this.

这篇关于如何计算组合框中的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！