I have the following data in the field MA-84
I created a query and added the following
Year: "20" & Right([TYPEFY],2)
when I run the query I get a new field named Year and the format looks like
2084
Now I just need a IIF statement that looks at 2084 and compares to to current year is the current year is less than 2084 leave alone else make it 1984
One last question if the Field TYPEFY IS BLANK how do I make the query do nothing to Newly created query field Year?
I created a query and added the following
Year: "20" & Right([TYPEFY],2)
when I run the query I get a new field named Year and the format looks like
2084
Now I just need a IIF statement that looks at 2084 and compares to to current year is the current year is less than 2084 leave alone else make it 1984
One last question if the Field TYPEFY IS BLANK how do I make the query do nothing to Newly created query field Year?