P
Peridot
I have a table in Access 2003 that list all my accounts, what day I call
them, and what week I call them. Some accounts are called every week (weeks
1, 2, 3, and 4). If this is so, the table has separate entries for each week:
Account # Name Day Week
3400 Chez Andre M 1
3400 Chez Andre M 2
3400 Chez Andre M 3
3400 Chez Andre M 4
Some are called every other week (weeks 1 and 3, or weeks 2 and 4).
Account # Name Day Week
4400 Chuckles M 1
4400 Chuckles M 3
Lastly, some accounts are called once every 4 weeks (only week 1, ...).
Account # Name Day Week
5400 Charly's M 1
I am trying to write a query that will tell me which accounts are called
weeks 1 and 3, but not weeks 2 and 4, or which accounts are called only in
week 1. There has to be a way to tell Access to exclude the account if it is
in week 1 and weeks 2, 3, and/or 4 also, but I don't know it. I'd be very
grateful for any help.
them, and what week I call them. Some accounts are called every week (weeks
1, 2, 3, and 4). If this is so, the table has separate entries for each week:
Account # Name Day Week
3400 Chez Andre M 1
3400 Chez Andre M 2
3400 Chez Andre M 3
3400 Chez Andre M 4
Some are called every other week (weeks 1 and 3, or weeks 2 and 4).
Account # Name Day Week
4400 Chuckles M 1
4400 Chuckles M 3
Lastly, some accounts are called once every 4 weeks (only week 1, ...).
Account # Name Day Week
5400 Charly's M 1
I am trying to write a query that will tell me which accounts are called
weeks 1 and 3, but not weeks 2 and 4, or which accounts are called only in
week 1. There has to be a way to tell Access to exclude the account if it is
in week 1 and weeks 2, 3, and/or 4 also, but I don't know it. I'd be very
grateful for any help.