Display date as MM/DD in reports

[papabill]

I have a simple database with a membership list that has birth dates and anniversary dates entered as MM/DD/YYYY, but in the report I want them to display as MM/DD. (Some of our members don't want their ages told <g>)

I have searched for the last couple of days, and can find nothing.

(Actually, I'm not quite sure what phrase I'm supposed to be searching for.)


Thanks

 

[papabill]

Sorry, I did mean "SQL View in Access".

Thanks

 

[Joe4]

OK. The code I posted in my previous post should do what you want. If you want to give it an alias, just add it to the end like this:

Format([Birthday],"m/d") as [I]AliasName[/I]