I have a database in which I need to count the number of times something is selected from a dropdown list (including not used). I need to be able to do this count between two dates (using the between in a query). I also need to make sure that if the user inputs something and then changes his/her mind that only what is currently chosen is counted (Hope that makes since).
The main table where all the data is stored is called tblmain.
The field I need to count in (located in tblmain) is called pit.
The lookup table for this field is called lookpit.
The form in which the input is made on it called PIT.
I am very very new at the writing code of any kind. Using the names listed, can you tell me what I should put and where? I need some pretty basic instructions.
I would appreciate any answers/links/thoughts that could point me in the right direction.
Ellie
**Using Access 97**
lena.wood@wgint.com (work)
ellefant@bossig.com (home)
The main table where all the data is stored is called tblmain.
The field I need to count in (located in tblmain) is called pit.
The lookup table for this field is called lookpit.
The form in which the input is made on it called PIT.
I am very very new at the writing code of any kind. Using the names listed, can you tell me what I should put and where? I need some pretty basic instructions.
I would appreciate any answers/links/thoughts that could point me in the right direction.
Ellie
**Using Access 97**
lena.wood@wgint.com (work)
ellefant@bossig.com (home)
