I have a database that I use to store data and the column is called date, and the format of the date is 01/06/2006.
I has a form with a list as shown below:
Item Label Value
Jun 06
Jul 06
Aug 06
Sept 06
due to the complex site the results page has 31 recordsets and I need to have one page for all the results but I am struggling as I don't know how to
to set up the value or what the value would be to carry accross from the form to the results page. could anyone help me please???

I have no idea what you're trying to ask.

Can you show us a sample web page and what you're ultimately trying accomplish?

http://www.glasgow-airport-movements.../mylogglas.asp



I would like when you have selected the relevant month that it will bring the information for that month only in the recordset.

I am new to coding and webdesign so I would like some help if you can spare the time please.

I understand that you all are professionals and I am a beginer so any help would be greatfully welcomed.


Stuart

SELECT *
FROM personal_log
where logdate= '('m' events.[logdate]) = '4'
ORDER BY airline AS


This is what is in the recordset, I know that it is wrong help ????

31 recordsets ??? are they all open at once ??

I think you need some normalising of your tables and queries

but

SELECT fieldlist FROM table WHERE MONTH(datefield) = number_of_month

Since you want the year, there's one mod you'd need to make.

Select fieldlist from table where Month(datefield) = number_of_month and Year(datefield) = number_of_year