I have a basic table with 2 columns.
I have to create a query that shows the number of site each customer has. Can anyone help? I really have no idea what to put in the criteria.
eg.
Site No. Customer No.
1 1
2 1
3 1
4 2
5 3
6...
Ive created a form, i enter data, it saves to the table i want it to after i add the new record but i want to be able to have the data cleared for the next record to be put in. How do i do that?