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. List Records that Contain a Phrase (3 replies)
  2. Update Query to normalize table (2 replies)
  3. WildCard criteria (3 replies)
  4. Compile Error when working with a dynamic query (8 replies)
  5. Using "All" in SQL Statement (7 replies)
  6. Daily birthdays (1 reply)
  7. having trouble with a query (26 replies)
  8. Monthly Birthday listing (1 reply)
  9. Problem display all data in query (2 replies)
  10. Sequentially number records within a group (5 replies)
  11. Query (1 reply)
  12. Update a table with the sum of values from another table (2 replies)
  13. Double ordering (4 replies)
  14. Help with multiple appends (1 reply)
  15. IF statement (9 replies)
  16. Group By-append blank record when no results? Or get # effected (1 reply)
  17. DLookUp (3 replies)
  18. Setting Criteria using parameters from a form (1 reply)
  19. Query using DCount Questions?? (1 reply)
  20. Identify patterns in columns for each row (5 replies)
  21. Month and Day without the Year (2 replies)
  22. Grouping and Ascending Order (1 reply)
  23. Filtering a form based on a combo-box (or buttons) (1 reply)
  24. Non Updatable Query (7 replies)
  25. Show a message when no information is found. (4 replies)
  26. Data Type Mismatch in Criteria Expression (5 replies)
  27. Max Query (1 reply)
  28. New field in query from multiple sources (4 replies)
  29. Database Bloat (18 replies)
  30. Help request on a query I'm having a problem with (3 replies)
  31. Creating a query in VBA (6 replies)
  32. Null won't Zero (8 replies)
  33. Summing amounts per currency (2 replies)
  34. Selecting decimal places in calculated field (2 replies)
  35. SQL Query - Quantity (1 reply)
  36. Finding events in a range of dates (4 replies)
  37. count function anyone? (3 replies)
  38. Efficient Searching (12 replies)
  39. no clue as to how the sums work (3 replies)
  40. crosstab query help (0 replies)
  41. SQL Query - Quantity Limit Problem (10 replies)
  42. Problems with SQL Statement in Access (9 replies)
  43. Need to have query accept value or if value = “All” return all r (8 replies)
  44. Question about dlookup in a query (2 replies)
  45. Basic query question (18 replies)
  46. selecting fields from a record based on date (1 reply)
  47. Range Criteria and Nulls (3 replies)
  48. Rolling Sum ,How to use IIf for 3 variables (0 replies)
  49. New Line (7 replies)
  50. Insert different fields into table if a textbox is null or not?? (1 reply)
  51. selecting UK postcodes Both 1 or 2 Letter Prefixes (15 replies)
  52. Query Date Field on the Fly (4 replies)
  53. Referring to a dynamic field / Assemble a field name (0 replies)
  54. Using a variable as a table name in INSERT INTO STATEMENT (5 replies)
  55. Access Benchmarking (3 replies)
  56. last date (5 replies)
  57. Avoid duplicate records on INSERT (5 replies)
  58. Problem with Query (10 replies)
  59. Qury Active Directory (2 replies)
  60. Selecting corresponding fields in aggregate clauses (5 replies)
  61. Run a query at a certain time everyday (2 replies)
  62. Query, Query iif is null (7 replies)
  63. Bubble up (2 replies)
  64. can't get VBA code right for SQL query (5 replies)
  65. Trouble with Date Criteria (5 replies)
  66. Query (4 replies)
  67. Query problem with date and time (10 replies)
  68. Rounding Up (3 replies)
  69. Part of a string (15 replies)
  70. Make-Table through VBA (11 replies)
  71. union query problem (7 replies)
  72. Multiple calculations query (4 replies)
  73. Count Queries Excluding a number (9 replies)
  74. Query Nightmares (5 replies)
  75. Programatically change the ODBC Timeout setting on ALL queries (3 replies)
  76. Loop through dates in a query (0 replies)
  77. do i deserve to be killed? (0 replies)
  78. Query order (10 replies)
  79. Query returning duplicate values (6 replies)
  80. Using "Like" in a query (6 replies)
  81. I think I need a query for this... (2 replies)
  82. query to yield record closest to a date entered by user (1 reply)
  83. Access Newbie with Query query (1 reply)
  84. Many-to-many r/ship (5 replies)
  85. bad queries (1 reply)
  86. qry not returning correct results (5 replies)
  87. Query/Relationship Question (1 reply)
  88. Setting a NULL Value (3 replies)
  89. Query of Memo Field For Carriage Returns (1 reply)
  90. not pulling date (1 reply)
  91. Export Query with NO carriage returns (3 replies)
  92. SQL: Creating a new table and want to add a default value to co (6 replies)
  93. back track through subqueries? (4 replies)
  94. Using the Count() and Sum() functions in the same query (8 replies)
  95. Signing out Equipment and Updating Database (10 replies)
  96. Dollar amount total grouped by week (1 reply)
  97. Select Statement Error (3 replies)
  98. Crosstab Query (5 replies)
  99. Export Query to a clean .CSV File? (9 replies)
  100. Query not working (3 replies)
  101. Grouping in queries (2 replies)
  102. DateDIFF using current date? (7 replies)
  103. between time criteria (4 replies)
  104. Query (2 replies)
  105. Current Fiscal year criteria issue (5 replies)
  106. Counting 'yes' (3 replies)
  107. SQL Query Problem (1 reply)
  108. Executing a query is not working (4 replies)
  109. Multiple Query Output to Single Excel File (1 reply)
  110. Return records from the last month query (6 replies)
  111. Using SUM function in query (1 reply)
  112. Month Ahead Query (3 replies)
  113. Passing variable from forms to queries (3 replies)
  114. Query Giving Errors (3 replies)
  115. query on a date range not working (1 reply)
  116. Query built from Mutliple Form Control (2 replies)
  117. Query in Datasheet (1 reply)
  118. Criteria: Last full 12 months, doesnt include current month unt (4 replies)
  119. Form Entries used as parameters in Query (18 replies)
  120. build SQL on the fly (10 replies)
  121. Unto Combo Change (3 replies)
  122. Weekending query (11 replies)
  123. "Simple" SQL problem (22 replies)
  124. Weekname/Monthname function (4 replies)
  125. Update query not working like I want (3 replies)
  126. Query w/Parameter (5 replies)
  127. Recipe Subform (4 replies)
  128. DSUM: Setting up criteria portion to use current record data (3 replies)
  129. Access incorrectly joining on a time field? (10 replies)
  130. query to use the current record (11 replies)
  131. Calculated field ( Year over Year Growth) (1 reply)
  132. Sorting and Grouping, First by City, then by Street Name (1 reply)
  133. query help (2 replies)
  134. Autonumber records returned in a query result (1 reply)
  135. SQL Server large field via ODBC returns blank (0 replies)
  136. How do I highlight Listbox items, based on a field in the Listbo (2 replies)
  137. Update Query won't work (3 replies)
  138. Query Function to extract First word(s) before a comma (5 replies)
  139. Ranges (Between clause without And) (9 replies)
  140. increment the next record (4 replies)
  141. not having to match all fields (4 replies)
  142. Search using IF Then but I also need And (4 replies)
  143. Spot the error? (6 replies)
  144. DSUM using AND and OR criteria (1 reply)
  145. combining records within tables (3 replies)
  146. Filtering multiple entries (5 replies)
  147. Summary and details in a query (4 replies)
  148. Search Facility (1 reply)
  149. Multiple queries in one table (10 replies)
  150. Query using a form to enter criteria (5 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.