I have a table with two columns. The first column is date and the second is a number (code 1 or 2). For every date i have more than one records with code 1 and more than one records with code 2 (for example for date 10/3/2015 i have 10 records (rows) with code 1 and 7 records (rows) with code 2, that means that i have 17 rows with same date in first column and the second column contains 10 rows with code 1 and 7 rows with code 2).
I want to create a form that search this table and also counts the amount of code 1 and 2 records for specific date or dates (from date - to date) . That means that the result should be displayed in the form on a "table" with 3 columns. The first displays the date or dates for the given period (from date- to date) the second is the amount of code 1 for every specific date and the third column is the amount of code 2 for the same date (for example 10/3/2015, 10, 7). What text boxes or command buttons should the form contains? I'm a beginner in access 2010 could you please help me? Thanks
I want to create a form that search this table and also counts the amount of code 1 and 2 records for specific date or dates (from date - to date) . That means that the result should be displayed in the form on a "table" with 3 columns. The first displays the date or dates for the given period (from date- to date) the second is the amount of code 1 for every specific date and the third column is the amount of code 2 for the same date (for example 10/3/2015, 10, 7). What text boxes or command buttons should the form contains? I'm a beginner in access 2010 could you please help me? Thanks
Search and count in a form
0 commentaires:
Enregistrer un commentaire