change date format

[Mike Hughes]

When writing a query is there some way to change a date format of mm/dd/yyyy to just mm/yyyy?
Thanks

 

[RuralGuy]

Assuming it is a dateTime field then Format([YourDateTimeField],"mm/yyyy") should do it.

 

[Mike Hughes]

Thanks for the help