SQL: SELECT statement
In a relational database, data is stored in tables. The Select statement allows you to retrieve records from one or…
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
In Access, the IIF function returns one of two arguments depending on the evaluation of an expression. The syntax for…
Access: UCase Function
In Access, the UCase function returns a string in which all letters of an argument have been converted to uppercase.…
Access: Switch Function
In Access, the Switch function evaluates a list of expressions and returns a Variant value or an expression associated with…
Access: Sum Function
In Access, the Sum function returns the sum of a set of values in a set of values in a…
Access: StrConv Function
In Access, the StrConv function convert a string to upper case, lower case, proper case, or several other formats. The…
Access: Right Function
In Access, the Right function returns the rightmost n characters of a string. The syntax for the Right function is:…