P PWG Registered User. Local time Yesterday, 16:57 Joined Jun 13, 2019 Messages 56 Aug 25, 2019 #1 I have a sale Query that shows me the the date that the sale was made. I want to be able to filter this by year. I would like to add a EXP:field that will show the year of the sale based on the value in sale date field.
I have a sale Query that shows me the the date that the sale was made. I want to be able to filter this by year. I would like to add a EXP:field that will show the year of the sale based on the value in sale date field.
isladogs Access MVP / VIP Local time Today, 00:57 Joined Jan 14, 2017 Messages 19,326 Aug 25, 2019 #2 EXP: Year(SaleDate)