troubleshoot calculation conflicts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a query based on a table with multiple fields.
one field consists of dates with the following format: 05/06/2004; and another field consists of card numbers.
i want to calculate how many cards correspond to each month.
which is the best way to perform this calculation?

moreover, i have another field containing promoters. i would like to create another query that will calculate how many cards each promoter has sold per month.
 
1. Create a query into this table.

2. Depress the Totals icon on the toolbar (upper Sigma icon).
Access adds a Total row to the grid.

3. In the Field row, enter:
TheYear: Year([d])
where "d" represents the name of your date field.
Accept "Group By" in the Total row under this field.

4. In another column of the Field row, enter:
TheMonth: Month([d])
and accpet "Group By".

5. Drag the card numbers field into the grid.
In the Total row beneath this field, choose:
Count

The query gives the count of the number number of cards, for each year/month
combination.

For your 2nd query, drag the PromoterID into the grid, and accept Group By
under this field also. This query groups by year, month, and promoter, and
gives a count for each.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

angie said:
i have a query based on a table with multiple fields.
one field consists of dates with the following format: 05/06/2004; and
Click to expand...
another field consists of card numbers.
i want to calculate how many cards correspond to each month.
which is the best way to perform this calculation?

moreover, i have another field containing promoters. i would like to
Click to expand...
create another query that will calculate how many cards each promoter has
sold per month.
 
Back
Top