How to count a field and sum

[rehanemis]

Hi Professionals,

I working on simple MS Access program which have 2 tables. As you can see in snap shot. What I am trying to achieve is. I would like to run a query which shows data between certain dates(It is done) and also to show me which Technician has done how many jobs(i have 5 technicians) and how much money a technician received by a payment method like Technician ID 1 did Cash Transactions 4 worth $300 similarly Credit Card transactions 2 worth 120$ and so on for other technicians.

The main theme is to get weekly summary report of technicians how many jobs they done and how many transactions each technician made by cash, by credit card along with their amount.

Thanks and waiting of your answer.

 

[namliam]

Are you looking to do a group by query and count(*) sum(amount) ??

 

[rehanemis]

Yes, Only willing to get weekly report which shows each technician did how many jobs and what payment method he has used with its total.

 

[namliam]

assuming you have a date on day basis, you can use format or Datepart functions to "change' it to a weeknumber....