jcarouth

when storing floating point numbers - especially when arithmetic will be involved (e.g. monetary numbers) - it will be beneficial to use DECIMAL in favor of FLOAT because of the precision. i know this is not what you were asking about, but FLOAT was mentioned and this little caveat is something you will need to be aware of. as for smaller integer numbers, as mentioned above use TINYINT.

where is the form processing code?

how about posting table structure, example data, and desired results.

So this [code]SELECT   Donors.DID   , Donors.DFirstName   , Donors.DLastName   , Donations.DonMonth   , Donations.DonDay   , Donations.DonYear   , Donations.DonAmount FROM   Donations INNER   JOIN     Donors       ON Donations.DonId = Donors.DID ORDER   BY     Donors.DLastName ASC     , Donations.DonYear DESC     , Donations.DonMonth DESC     , Donations.DonDay DESC[/code] won't give you results? In the future, you can consolidate those date fields into one column of type date or datetime and extract the specific part you want when necessary.