The previous video showed you how to create a calculated field in a query. Here we go through some more examples as well as extra functions you can use in your calculations like Round and Int, text functions (Left, Right, Mid, UCase, LCase) and date functions (Date, Year, Month, Day, MonthName).
Microsoft Access Queries Video Series
Part 1 Basic queries - [ Ссылка ]
Part 2 BETWEEN and IN in queries - [ Ссылка ]
Part 3 LIKE and NULL in queries - [ Ссылка ]
Part 4 Separate queries - [ Ссылка ]
Part 5 Grouping in queries - [ Ссылка ]
Part 6 Calculated Fields in queries - [ Ссылка ]
Part 7 More Examples of Calculated Fields - [ Ссылка ]
#MrLongEducation #Access #Query
