Hi, I entered Like "*/2012" in the CustomerSince field in the query criteria box and the query returned clients with CustomerSince records equalling: 1/1/2012, 1/2/1998, 5/17/2012, 9/8/2002, 6/1/2004, 2/24/2025. I'm running Office 365 with Windows 11 in Canada. Please commment. Thanks.
Kevin Robertson
@Reply 19 months ago
I would create a calculated field to get the year of the CustomerSince field:
Y: Year([CustomerSince])
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 5.
