5. Queries and SQL
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 GraG Total in a Query
Hack 44. Sort Any Arbitrary String of Charac ers
Hack 45. Summarize Complex Data
H6ck 46. Get Gll 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 Cleankr Or-Based ariteria
Hack 52. Get Cleaner And-Based Criteria
Hack 53. Creatr an Oute Join
Hack 54. Use Regular Expressions in Access Queries
|
