Access World Forums - View Single Post

theDBguy · 10-14-2019, 01:22 PM

Hi Clara. Welcome to AWF! A better way is to normalize your table structure, if it isn't already normalized. Otherwise, you could try something like:

Code:

IIf(Format([DateField],"mmdd")="0101",Year([DateField]),[DateField])

However, I'm not sure what kind (data type) of column you will get.

10-14-2019, 01:22 PM	#2
theDBguy I’m here to help Join Date: Oct 2018 Location: SunnySandyEggo Posts: 6,538 Thanks: 58 Thanked 1,429 Times in 1,410 Posts	Re: Looping through fields by type Hi Clara. Welcome to AWF! A better way is to normalize your table structure, if it isn't already normalized. Otherwise, you could try something like: Code: IIf(Format([DateField],"mmdd")="0101",Year([DateField]),[DateField]) However, I'm not sure what kind (data type) of column you will get. __________________ Just my 2 cents... To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. \| To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. \| To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.