Query more than on column of years

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

Guest

I have a select query linking 3 databases. Customer, Fillers and Service

Select query has a field named service which is filled with dates.

I added this formula in the next coulmn field to the right of the service
field. Year([service]) then 2005 in the criteria field. It counts
each time someone has serviced the customer in the crosstab query.
I need to show anothe column for 2006.

Can anyone help? Thanks!
 
Fly said:
I have a select query linking 3 databases. Customer, Fillers and Service

Select query has a field named service which is filled with dates.

I added this formula in the next coulmn field to the right of the service
field. Year([service]) then 2005 in the criteria field. It counts
each time someone has serviced the customer in the crosstab query.
I need to show anothe column for 2006.
Click to expand...


Change the criteria to:

IN(2005,2006)
 
Back
Top