Section 5.1. Hacks 4054
Hack 40. Return a Sample of Records
Hack 41. Create Bulletproof Insert Operations
Hack 42. Find Unmatched Records on Multiple Field Keys
Hack 43. Place a Grand Total in a Query
Hack 44. Sort Any Arbitrary String of Characters
Hack 45. Summarize Complex Data
Hack 46. Get All Combinations of Data
Hack 47. Don't Let Nulls Ruin Data Summaries
Hack 48. Use a Custom Function in a Query
Hack 49. Create Access Tables with SQL Server Scripts
Hack 50. Use Wildcards in Queries
Hack 51. Get Cleaner Or-Based Criteria
Hack 52. Get Cleaner And-Based Criteria
Hack 53. Create an Outer Join
Hack 54. Use Regular Expressions in Access Queries