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!
JethroUK© - 31 May 2006 19:46 GMT
how about Year([service])+1
> I have a select query linking 3 databases. Customer, Fillers and Service
>
[quoted text clipped - 6 lines]
>
> Can anyone help? Thanks!
Marshall Barton - 31 May 2006 20:51 GMT
>I have a select query linking 3 databases. Customer, Fillers and Service
>
[quoted text clipped - 4 lines]
>each time someone has serviced the customer in the crosstab query.
>I need to show anothe column for 2006.
Change the criteria to:
IN(2005,2006)

Signature
Marsh
MVP [MS Access]