Recent content by jphenning

Thanks for the advice I have changed the filed to MonthOf as the information on this table will be entered at the beginning of them month but will be for the month before so what is entered in October 2011 will be for September 2011. This is why I do not want a entered date and just a...

Hi CBrighton thank you for the reply, can I confirm: If I put in Field Name- Date Data Type - Date/Time under the general tab under do I change Format to Format([DateField],"mmm yyyy")? or am I missing something?

Hi This is my first post. I am creating a DB for the first time, and need some advice please. I am creating a DB that will be rolling on a month-month basis. i.e Jan, Feb, Mar etc... and then Year do I need to create two separate tables one for month and one for Year? or can I use the a...