Need help getting started

[ITGL72]

I hope someone will be able to lend a helping hand to at least get me started and pointed in the right direction. This seems simple, but I'm having the most darned time trying to get it started. My CF experience is limited and I usually only have to do simple queries on a web page. This one seems like a simple one but I'm held up on it!




I am trying to list a number on a web page for these categories:

TODAYS ACTIVATIONS:, WEEKLY ACTIVATIONS:, MONTH TO DATE ACTIVATIONS:, YEAR TO DATE ACTIVATIONS:

TODAYS TERMINATIONS:, WEEKLY TERMINATIONS:, MONTH TO DATE TERMINATIONS:, YEAR TO DATE TERMINATIONS:



For example, next to "TODAYS ACTIVATIONS:" on the webpage, the table would be queried and list whatever was listed in the "TODAY" field of the database for todays date. Somehow I have to add it all together too, to display Weekly, Monthly, and Year to Date as well.


The table I am accessing has 6 fields.
WEEK, DAY, MONTH, YEAR, NEW, TERMINATED

The way the database has data listed is like so:

WEEK, DAY, MONTH, YEAR, NEW, TERMINATED
40 1 10 2001 1 2
40 2 10 2001 21 0
41 10 10 2001 5 9






Anyone will to help out?

 

[Silvano]

I don't know how big your database is and if you know how to manipulate with databases, but I really think that you might want to consider putting date field as a date should be: in the one field of the database (Date/Time Type); after that, the SQL to query the database for a weekly or yearly display is quite simple Sylvano
dsylvano@hotmail.com