Full Version: Access Queries
UtterAccess Discussion Forums > Microsoft® Access > Access Queries
Pages: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258, 259, 260, 261, 262, 263, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278
  1. Getting Data From A Specified Field Of The Row I'm Hovering Over. (2 replies)
  2. Query Criteria Iff Statement Failure (4 replies)
  3. SQL Subquery (24 replies)
  4. Return All Values Including Null, Unless Record Is Selected With Combobox (3 replies)
  5. Calculating a Grade based on the totals in a query (14 replies)
  6. SQL Parameter Query To Select Field And Data From Table (1 reply)
  7. Assign A Sequence Number Via Query (18 replies)
  8. Query Criteria Row Ineffective.. (10 replies)
  9. Date & Time Query (18 replies)
  10. Dataset Analysis (9 replies)
  11. Transform Query With Top (1 reply)
  12. Combobox Issue After Adp Upsizing (1 reply)
  13. Automatic Updated In The Report And Form (4 replies)
  14. VBA For Backup (2 replies)
  15. How To Add A Field To A Table In Access By Useing Query (1 reply)
  16. Extracting Specific Information From A Tilde Delimited Field In A Table (17 replies)
  17. Specific Criteria (2 replies)
  18. Convert Dlookup To SQL (3 replies)
  19. Access SQL Query Help On Dates - Saturday And Sunday (6 replies)
  20. Listing Table Name In A Query (14 replies)
  21. Lookup A Value In A Query Problem (5 replies)
  22. Problems With Select Query (2 replies)
  23. VBA-built SQL String Contains Unintended Line Break (11 replies)
  24. Query Help (8 replies)
  25. Can't Open Record Set Error 3061 (10 replies)
  26. Use Query Or Join To Import Correct Data? (2 replies)
  27. Query Calculate Percen (9 replies)
  28. Query To Enter Data Not Less Than Certain Data In Another Table(field) (6 replies)
  29. Sifting Through The Garbage: Excel Or Access? (4 replies)
  30. Union Query - How To Filter Out Records With No Data. (2 replies)
  31. I Am Query Query Confused. Using Criteria On A Calculated Field (2 replies)
  32. Pass Through Query ODBC Fail - Reasons For This And How To Fix? (2 replies)
  33. Remote Query For Cross-tab Not Working (1 reply)
  34. Query Help Needed (3 replies)
  35. Excluding Records, Based On Two Tables (6 replies)
  36. One Pk In Main Table To Left Join Two Secondary Tables. (3 replies)
  37. Update Query Same Field Multiple Criteria (1 reply)
  38. This Query: Is There A Better Way? (6 replies)
  39. SQL Help (2 replies)
  40. Multi-value Combobox In Queries (10 replies)
  41. Join Or Merge Multiple Occurrence Of A Record And Separate With A Comma (4 replies)
  42. Query Source Connection String For Passworded Access Database (10 replies)
  43. Problem With Query Designer Field Name Aliases (6 replies)
  44. Finding Customers Who Have Not Scheduled Followup Appt (4 replies)
  45. Query Time Range Based On Table Source (25 replies)
  46. Search A Table For A Value If You Don't Know What Field It Might Be In (7 replies)
  47. How Do You Restate 12.56 As 12 In A New Field? (2 replies)
  48. Query Based On Date In Unrelated Table (5 replies)
  49. Add Carriage Return To The Data In A Table. (4 replies)
  50. Ado Query Returns No Records When Using Group By Memo Field But Dao Works Ok (4 replies)
  51. Copy Data From One Table To Another (2 replies)
  52. Insert Query: No Data Inserted? (3 replies)
  53. Calculate The Percentage Of The Number Of Passengers In The Total Number Of Passengers (4 replies)
  54. Users Who Attended Classes (8 replies)
  55. How To Get Result Based On Condition (5 replies)
  56. Receive Key Violation Error In Append Query (2 replies)
  57. Remove Duplicate Query (7 replies)
  58. Proposing To Backup Before Exit The Database (12 replies)
  59. SQL Problem (2 replies)
  60. Assign Autonumber To New Records (10 replies)
  61. What Is Wrong With This Function ? (9 replies)
  62. Why Is This Not Updating ? (6 replies)
  63. How To Calculate Of Costs Per Order To Drive (4 replies)
  64. Complex Formula? (4 replies)
  65. Left Join Query Insted Of Not Exists Query (9 replies)
  66. Sorting Problem (7 replies)
  67. Update The Text In A Field (16 replies)
  68. Syntax Error With Insert Into With Values Clause (14 replies)
  69. Function Question (8 replies)
  70. Format Result Of Calculation (1 reply)
  71. Return Record That Matches Multiple Criteria From Second Table (3 replies)
  72. Update Query Based On What Is The Filed (9 replies)
  73. How To Get Rid Of This Error (3 replies)
  74. Linking Photos Via Id Number. (1 reply)
  75. Dynamic Rtrim And Recordset Updates (5 replies)
  76. Update Values In Table (3 replies)
  77. Different Filter Criteria (4 replies)
  78. How Do I Set Criteria In An Access Query By String Length? (5 replies)
  79. Subquery Syntax: Compare With Value From Same Table (3 replies)
  80. Crosstab / SQL Query - Percentage Of Row Total (7 replies)
  81. Too Many Fields Or Criteria - Transaction Locking On SQL Server (1 reply)
  82. Update Date Field Based On Another Table (5 replies)
  83. 4 Related Queries 1 Works 3 Dont (12 replies)
  84. Force Refresh Of Saved Query Or Discarding Execution Plan (11 replies)
  85. And/or Statements (6 replies)
  86. Crosstab Subquery With Parameter And Left-join (21 replies)
  87. Query For Last Name On Same Day (8 replies)
  88. Query For Yes/no Percentages On Dashboard (21 replies)
  89. Deleting Multiple Records From Datasheet View Subform (9 replies)
  90. Search Wildcards (9 replies)
  91. Need Month And Year In A Querry (14 replies)
  92. Linking Query To Excel (2 replies)
  93. Modifying This Query (3 replies)
  94. What Is The Meaning Of This Code (13 replies)
  95. Isolating Records In A Mapping That Contain A Mix Of Mapped + Unmapped Values (0 replies)
  96. Aggregate Count Function Error Count(iif(count(iif...))) (8 replies)
  97. Query Two Tables (2 replies)
  98. Sum Of 2 Previous Record = Next Record Value (3 replies)
  99. Take 2: "insert Into" - Must I Name Every Field? (2 replies)
  100. Change Select Query SQL To Delete Duplicate Records? (4 replies)
  101. Qry Dropdown To Auto Populate Another Form And Allow Additional Data Entry (9 replies)
  102. Dsum #ERROR (6 replies)
  103. Return Date Even If Record Count Is 0 (15 replies)
  104. .recordcount Gives Unexpected Value (4 replies)
  105. Invalid Data Type (3 replies)
  106. Evaluating A Text Field For 8 Numeric Characters (3 replies)
  107. Average Data Within The Year And Month (1 reply)
  108. Need Query To Show All (2 replies)
  109. Replace Error Msg With Custom Msgbox (8 replies)
  110. Criteria Search (1 reply)
  111. Change From Maketable To Delete And Append Queries Resulting In Error (5 replies)
  112. Data Type Mismatch In Criteria Expression (15 replies)
  113. Query Criteria (7 replies)
  114. Expression Builder Question (17 replies)
  115. Stop Auto Converting Text To Date (9 replies)
  116. Help! Running Sum Combined With D/elookup (1 reply)
  117. Delete Report Prefix In Query SQL? (11 replies)
  118. Immediate Window And The . Operator (7 replies)
  119. Cast Function (14 replies)
  120. Why Is The Report Not Showing Some Records? (9 replies)
  121. Misbehaving Update Statement (9 replies)
  122. Queries To Pull Specific Results Based On The Selection (2 replies)
  123. Define Date Format Of VBA Strsql Update (3 replies)
  124. Select Second, Third,...n From A List (5 replies)
  125. One Employee On Call Per Week (13 replies)
  126. Lookup A Specific Value In A Related Table (3 replies)
  127. Memofield Tot Table (6 replies)
  128. What's The Eval Alternative? Or What Do I Fix? (7 replies)
  129. Writing/editing SQL Without Query Designer, Access Vs. SQL Server (4 replies)
  130. Invalid Use Of Null (5 replies)
  131. Filter On Multiple Criteria (4 replies)
  132. Pass A Formula Form A Query To Excel (3 replies)
  133. Can Not Update My Table (9 replies)
  134. Very Strange When 2 Criterias Are Used (5 replies)
  135. Joining Text From 2 Fields (2 replies)
  136. Append Query (7 replies)
  137. How To Round Up The Values In Access (7 replies)
  138. Make A Query To Find Same Date In Table (4 replies)
  139. Circular Referance Error With Calculated Field In Query (8 replies)
  140. Calculating Shifts That Spans Overnight (12 replies)
  141. Count Workdays (3 replies)
  142. Insert/update Query, Target Field Has A Lookup Table (4 replies)
  143. Can You Over Normalize? (22 replies)
  144. Query To Chart Percentages By Month (5 replies)
  145. Quick Insert Into Question: Must I Name Every Field? (13 replies)
  146. Query And Form Based On Crosstab Query (5 replies)
  147. To Delete Query Or Form (2 replies)
  148. Query With A One To Many Join (1 reply)
  149. Select Criteria (12 replies)
  150. Add Multiple Rows With Same Criteria (8 replies)
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.