Dates

[Bentleybelle]

I'm sure this is really easy - the database I am writing is for sales enquires with an anticipated completion date (month), but I also need to show which year. I would then want to concatenate these two fields and be able to produce a report that would list by date in ascending order. Can someome tell me the correct way to do this. Should the fields be text or date fields?
Thanks in anticipation.

 

[FoFa]

Easiest way to store the information wiould be a date field then you can use the MONTH and YEAR function to pull required piece of information. You can always set the day to the first in your interface.
But another option would be to have two INTEGER or LONG fields to store each piece. Storeing them as text would only be an issue if you wanted to SORT on this information. Text does not sort in the same way as numerics.