SQL: SELECT statement
In a relational database, data is stored in tables. The Select statement allows you to retrieve records from one or…
Author: admin
SQL Join
So far, we’ve been looking at queries that retrieve data from single table at a time. Single table queries are…
PHP: Conditional Statements
Sometimes when you write code, you want to perform different actions for different decisions. You can use conditional statements in your…
Creating Word, Excel and CSV files with PHP
Browsing the World Wide Web you can find out various methods of creating files with PHP. In this article we…
Access IIf Function
Last updated: August 26, 2026. The IIf function evaluates a condition and returns one value when it is true and…
Access UCase Function
Last updated: August 26, 2026. The UCase function converts letters in a string to uppercase. Syntax Argument Description string Text…
Access Switch Function
Last updated: August 26, 2026. The Switch function evaluates condition/value pairs and returns the value belonging to the first true…
Access Sum Function
Last updated: August 26, 2026. The Sum aggregate adds the non-Null numeric values in a query group. Syntax Argument Description…
Access StrConv Function
Last updated: August 26, 2026. The StrConv function converts a string using a specified case, width, or character-set option. Syntax…
Access Right Function
Last updated: August 26, 2026. The Right function returns a requested number of characters from the end of a string.…