I want to generate a number. I know what I wanna do, but just can't find the correct way to jot it down. Please assist if you can.
I want to generate a number by counting the records in my database for the current year. Yes, that's right. I want to count the number of records in a field called Tdate (01/06/01 - shortdate format) current year only - from a table called Travel only. I am using ADO.
Can you help me?
Your assistance is really appreciated.