Being more selective in an Access query
One of the incredibly powerful features of SQL-based databases is the ability to write queries with very specific criteria to…
productivity through technology
One of the incredibly powerful features of SQL-based databases is the ability to write queries with very specific criteria to…
A dynamic parameter in an Access query allows for criteria to be entered by the user at runtime. Download the…
This post cherry-picks some questions from the Excel section of the CAT Grade 12 P1 Feb-March 2018 NSC exam paper.…
This solution was arrived at whilst doing some advanced analysis for a Matric PAT where data from a Google Form…
OK so now you must tread lightly! DELETE queries are destructive — there is no “undo”! The Golden Rule is:…