Re: Buttons To Record # of Contacts
You should be able to do this with a single table and two update queries and a Form.
Have fields in the table:- ID, Department, fCount...
ID would be an auto increment field,
fCount I reckon an integer would do
Place in the first department field an "A" to represent department "A" and in the next field "B" to represent department "B" ... Have the default value for the count field to be 0..
Now open the query builder grid and select your table "tblDeptCount" create a select query which returns the row containing "A" Now change the select query to an update query and under the fCount field is an area for calculations. I think it's called "Update To" ... You need something like:- fCount = fCount + 1
Now create a form:- frmCountDept
On the form create a command button have the "wizard" selected and you should have the option to select a query. Select the query for updating "A"
Create another button just the same to run the query for updating "B"
| Uncle Gizmo |
| Get $20 worth of "Nifty Code" |
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| Ooo |
( ) ) /
\ ( (_/