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. Action Query, Convert Field to Title Case (2 replies)
  2. Creating an error message in a query (2 replies)
  3. Select query? (2 replies)
  4. How can i export a query to excel in access 2007 (4 replies)
  5. Updating 3 tables from one form (17 replies)
  6. Query to number records found (5 replies)
  7. Filtering Data in Listboxes (3 replies)
  8. SQL Query as datasource of MSChart (1 reply)
  9. Count first record in table only (5 replies)
  10. Multivalue Field passed to Word through mail merge (1 reply)
  11. Sorting Problems When Formating For Week Number (5 replies)
  12. UPDATE/SET and Field Names/Column Names (7 replies)
  13. combining and trimming (5 replies)
  14. Having problems with GROUP BY in a query across 9 tables. (13 replies)
  15. Excluding values of an entire table from query results (13 replies)
  16. Concatenation (11 replies)
  17. How to retrieve the dates meet criteria using Query? Need expression builder (7 replies)
  18. Age query bringing back odd results (4 replies)
  19. Join query not updating underlying table properly (10 replies)
  20. Union Query? (2 replies)
  21. "Read Only" Query (3 replies)
  22. Exclude records to archive (8 replies)
  23. Queries b/w Multiple Tables Not Producing Results (3 replies)
  24. Round Up Function (7 replies)
  25. Test text field for numeric content in an Append Table query (13 replies)
  26. Dynamically changing the criteria in a query ....can I ... (4 replies)
  27. where query help (5 replies)
  28. Query result opened in Excel (4 replies)
  29. Last odometer date per card # query (5 replies)
  30. Count Within A Query (3 replies)
  31. Can't get query to pull in updated value (8 replies)
  32. Matching conditional on no matching (1 reply)
  33. Parameter Query - Show all if no value entered (9 replies)
  34. Query to upadte the differect between 2 tables (5 replies)
  35. Many Side Totals, Running of these Totals, etc (6 replies)
  36. Union query made easy... (2 replies)
  37. Query to Extract Text Portion of a String (4 replies)
  38. Top N Query Question (4 replies)
  39. sql mid (). Is it possible?! (9 replies)
  40. count query question (urgent!) (1 reply)
  41. Substraction Query (2 replies)
  42. Hi everyone I need help please. (3 replies)
  43. Select Top 20 by ProviderNumber (3 replies)
  44. Need query that will return the Name of the Fields (1 reply)
  45. Wildcard in Query that represents "ALL" in a list... (4 replies)
  46. Query Based on a List inside Table (4 replies)
  47. Using adp with sql backend. Need to filter stored procedure (9 replies)
  48. WHERE Clause Conditional Statements (6 replies)
  49. Syntax for querying multiple tables with implied inner join (6 replies)
  50. Docmd.RunSQL Syntax problem - I'm Stumped! (8 replies)
  51. Query Criteria with And/Or Results (1 reply)
  52. Slow performance with multiple users (2 replies)
  53. Dates dependent query (9 replies)
  54. how to handle leading zeros (7 replies)
  55. Filter By Query (3 replies)
  56. Types of Table (1 reply)
  57. Pull all records that contain an alpha character based on a field that is primarily numeric (3 replies)
  58. Find where applied amount not equal payment (11 replies)
  59. Total in A Query (3 replies)
  60. Subtracting in an iif statement (10 replies)
  61. combining text from multiple rows (1 reply)
  62. Query Wildcards Question (5 replies)
  63. trying to get records to show totals on one line (3 replies)
  64. Attaching PDF Report to Email (11 replies)
  65. Calculating using IF and IsNull or True/False (3 replies)
  66. Linking Combo Boxes Problem (15 replies)
  67. Number of headers in a crosstab query - 2007 ? (1 reply)
  68. Do I need a VBA created query? (3 replies)
  69. Conditional Trim (9 replies)
  70. How do i include data? (2 replies)
  71. If Statement (5 replies)
  72. Returning a static 'N/A' value for query records with null in a field (3 replies)
  73. UA Challenge Q6 - Prevent Errors Simply (12 replies)
  74. Column Limit in Access Crosstab query for 2007 (1 reply)
  75. compare dates in different formats (2 replies)
  76. Mailing list from names in different records (5 replies)
  77. Query Caption (7 replies)
  78. Sum of field based on IIf statement (3 replies)
  79. Joins not working properly for exact matches (1 reply)
  80. trying to multiply a time by a number ? (5 replies)
  81. Query to count unique date values (1 reply)
  82. Error on Multiple Table Join & IIF (5 replies)
  83. Force Row Headings in cross tab? (8 replies)
  84. Query Help (15 replies)
  85. my SQL has no syntax errors but shows no results (5 replies)
  86. Type Conversion Failure Fix? (5 replies)
  87. Missing Fields in Cross Tab (3 replies)
  88. IIF Statement Help Needed (5 replies)
  89. Limit number of records to update? (1 reply)
  90. CountIf in Access and Syntax Error (10 replies)
  91. Query help (2 replies)
  92. Dlookup with Environ (6 replies)
  93. one to many query with totals (4 replies)
  94. Making counts of multiple fields (7 replies)
  95. multiple critera for the same field select results (12 replies)
  96. convert text to Int, then specify Between range...? (14 replies)
  97. Left Function (2 replies)
  98. Finding Matches (1 reply)
  99. Overlapping Postcode ranges/show each distinct range (5 replies)
  100. nested queries (3 replies)
  101. date range query (5 replies)
  102. Delete Query (12 replies)
  103. subtract consecutive values from same field in a query (26 replies)
  104. Pivot tables in Access Queries (1 reply)
  105. Access Student: Adding Row to Table by Button/SQL (4 replies)
  106. Loop Through Table and replace text (4 replies)
  107. Query critera using the result of another query? (5 replies)
  108. Previous monthly hour reading (5 replies)
  109. Run Make Table query automatically (2 replies)
  110. Query by combo box on form (1 reply)
  111. No Data from Form (11 replies)
  112. basic outer joins in Access 2007 (4 replies)
  113. How to add to query using VBA? (1 reply)
  114. Exclude certain records that match the numbers I tell it (5 replies)
  115. leading zeros (4 replies)
  116. Price Quote showing the right funding source (9 replies)
  117. Removing non-numeric characters from a string (5 replies)
  118. Date Sorting (8 replies)
  119. Showing Null data against populated data (4 replies)
  120. Extract list of queries that use certain criteria (4 replies)
  121. Microsoft OLE DB Provider for ODBC Drivers error '80040e14' Syntax error (missing operator) in query expression '<expression>' (3 replies)
  122. How to extract the latest entry in a LEFT JOIN table? (4 replies)
  123. Very Slow Crosstab Query (9 replies)
  124. Create Comparison query (2 replies)
  125. Use of COUNT in query with multiple criteria (6 replies)
  126. Cannot Delete from Specified Tables (5 replies)
  127. Multiple Field Search and Filter Query (6 replies)
  128. Updateable query (7 replies)
  129. Update records in one table based on changes in another table (4 replies)
  130. New to Access - Query help needed please (13 replies)
  131. Convert List Of E-Mail Addresses to a Single Line Seperated by ";" (3 replies)
  132. Overthinking an update query? (2 replies)
  133. Help a noob: Query sales totals (5 replies)
  134. make-table result will not display (1 reply)
  135. Append Query error if no records (4 replies)
  136. Lock query result records (7 replies)
  137. Concatenate date variables into SQL query (15 replies)
  138. Why is the third query involving top does not work (4 replies)
  139. Query question (3 replies)
  140. Extract First Character (2 replies)
  141. Query to compare a value against the lack of the same value (3 replies)
  142. Max of a date Type (2 replies)
  143. Between date range (7 replies)
  144. DCount and DSum in a query between two dates (5 replies)
  145. "Not Like" Problem (9 replies)
  146. INNER JOIN query delivered NULL even with records existing in all 3 tables. (7 replies)
  147. IIF question (3 replies)
  148. Look for number in a range or multiple ranges (3 replies)
  149. Reserved error (-3087) with make-table query (5 replies)
  150. Rank Day By Order (1 reply)
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.