This function allows you to retrive a section of a string. MID( text, position, num_of_characters ) Where: Text : is the string of characters Position : the... Read more
Are there any functions under Access to concatenate a pair of strings You can make use of the & operator string1 & string2 & string3... Read more
This function will convert a string (text) to uppercase UCase(text) UCase(kioskea), shall return "KIOSKEA" Read more
This funtion returns the name of the day (string) of the week related to a particular date. WeekdayName(weekday,abbrv, first_day_of_week) weekday: a... Read more
This function converts a string expression as a time value TimeValue(time) Where time is a string representing a time value (0:00:00 to 23:59:59) Read more
The DateSerial function returns a date value from a set of numerical values. DateSerial ( year, month, day ) Read more
This function can convert a string (representing a date) to a date value DateValue ( string_date ) Read more
This function returns a time value based on a set of values. TimeSerial (hour,minute,second ) Example of use: TimeSerial (18,13,00) shall return 6:13:00 PM Read more
