This is just a little script I'm using to organize my client database for a tax company so I can separate the clients I've done recently from other clients. Is there any way I could number these?
Select * FROM AllReturnsIndividual
WHERE
(
Month(AllReturnsIndividual.[Last Touched]) = 12
AND
Year(AllReturnsIndividual.[Last Touched]) = 2002
)
OR
(
Month(AllReturnsIndividual.[Last Touched]) >= 1
AND
Year(AllReturnsIndividual. [Last Touched]) = 2003
Please email me or respond here with any suggestions. Thanks!
Solaron
Select * FROM AllReturnsIndividual
WHERE
(
Month(AllReturnsIndividual.[Last Touched]) = 12
AND
Year(AllReturnsIndividual.[Last Touched]) = 2002
)
OR
(
Month(AllReturnsIndividual.[Last Touched]) >= 1
AND
Year(AllReturnsIndividual. [Last Touched]) = 2003
Please email me or respond here with any suggestions. Thanks!
Solaron