This Access tutorial explains how to use Access StrComp Function to compare text, both case sensitive and case insensitive comparison. You may also want to read: Access Case Sensitive Join Table (Inner Join, Left Join) Access StrComp Function to Compare text (case sensitive comparison) In Microsoft Excel, you cannot perform case sensitive comparison directly using equal sign. For example, if you type formula ="A"="a" The formula returns TRUE. Vlookup also shows matching result even tho...

This Access tutorial explains how to find first date of month, last date of month using Access Expression and VBA Function. You may also want to read: Excel first date of month and last date of month Access first date of month To find first date of month in Access, first we have to understand DateSerial, you can use it to combine the year, month and day to a date. Syntax of Date Function DateSerial( year, month, day ) Example Formula Result Explanation DateSerial(2012,1,...

This Access tutorial explains the problem with BETWEEN timestamp, where the end date is not included in the result. Access BETWEEN timestamp problem - end date not included Very often you may receive data source that uses timeStamp (for example, 1/1/2015 15:34:00) instead of a Date (1/1/2015). The purpose of timestamp is to accurately record the time of action for auditing. In Access (even other system), you may want to select data within specific date period, say, between 1/1/2014 and 1/...