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. Unmatched queries (2 replies)
  2. Can this table be restated correctly through a query? (1 reply)
  3. Creating Temp Table for look up Values (12 replies)
  4. display '0' when no count in crosstab (6 replies)
  5. leading zeroes (3 replies)
  6. IIF I only had a brain! (3 replies)
  7. Query For Data Export (8 replies)
  8. Query issue (5 replies)
  9. Date query for a report (5 replies)
  10. Need to show records that are older than 6 months (2 replies)
  11. Multiple aggregate query (1 reply)
  12. Union Query (5 replies)
  13. Query an alphabetical range (3 replies)
  14. Trying to add unique text from grouped data into 1 line (5 replies)
  15. Find numeric value within a text field (4 replies)
  16. Insert query problem (3 replies)
  17. queries or module (2 replies)
  18. Deleting entries from a ListBox linked to a Subform (6 replies)
  19. Query that determines new quarter/new fiscal year? (4 replies)
  20. Previous Month within a query (15 replies)
  21. SQL Statement Syntax Error (5 replies)
  22. Delete Query "not like" (4 replies)
  23. "SUM" (concatenate) a string field across rows in a joined table (2 replies)
  24. Run-time error 3265 - Item cannot be found in the collection... (5 replies)
  25. Nested IIF and AND query (7 replies)
  26. How To? Remove Duplicates In My Query? (4 replies)
  27. SQL only returning 1 record? (4 replies)
  28. Descending Order within a Query (3 replies)
  29. Query Sum with zero values? (5 replies)
  30. Summing fields in a query (9 replies)
  31. combining Two Queries (2 replies)
  32. Implementing missing SQL functions in Access (8 replies)
  33. One status type + another within month (1 reply)
  34. Write Value from Text box into Table on Form Exit Event (10 replies)
  35. Criteria on calculated field (11 replies)
  36. update query 2 fields / 5 citeria (6 replies)
  37. Querying for expired training that resets every year (5 replies)
  38. Parameter query with two date fields in table (7 replies)
  39. Metaphor for a join (6 replies)
  40. MSysAccessObjects tables (1 reply)
  41. Calculating a certain amount of time (3 replies)
  42. code adding characters (3 replies)
  43. Update records starting at a certain record number (2 replies)
  44. Remove duplicates from query? (4 replies)
  45. calculate age by June 30 of current year (9 replies)
  46. Defaulting to zero (1 reply)
  47. Cannot edit information returned in a query (4 replies)
  48. Concatenate with date as criteria (0 replies)
  49. Using "not" criteria excludes null records?? (2 replies)
  50. String function problem (13 replies)
  51. Capture Record Count from Action Query (2 replies)
  52. change query to VB (3 replies)
  53. expression builder from subquery count and total query (2 replies)
  54. Calculating Year-to-date difference (5 replies)
  55. Select TOP Question (3 replies)
  56. Supress parameter dialog (11 replies)
  57. don't know how to do this type of "join" in Access (5 replies)
  58. Extra Column in SQL Query (2 replies)
  59. Querying for Changes in Fields (1 reply)
  60. What is the difference with this (7 replies)
  61. regarding queries in ms access, while converting to mysql (4 replies)
  62. Simple select (5 replies)
  63. Update Query (1 reply)
  64. This should be simple... (4 replies)
  65. Append Query doesn't show all tables? (0 replies)
  66. Update query not updating (5 replies)
  67. Query? to copy and then add entries to same table (3 replies)
  68. Add auto number field to make table query (5 replies)
  69. Making an Excell document from access with auto-formatting (12 replies)
  70. Problems with NULL when calculating average (6 replies)
  71. Update query (5 replies)
  72. query code (1 reply)
  73. Query in MultiValue field (1 reply)
  74. Date Expression (3 replies)
  75. problem with a query locking, can't update records (13 replies)
  76. Select Max value fro query results (23 replies)
  77. Available Surgeon for given input date and time (10 replies)
  78. Data Type MisMatch in Query Criteria (8 replies)
  79. Deleting or Adding values from listbox (3 replies)
  80. Exporting from Access 2007 as fixed width text file (8 replies)
  81. Using 'OR' in an 'IIF' statement in a Query criteria (7 replies)
  82. Update Query (3 replies)
  83. parsing data that has a char in the middle (1 reply)
  84. Query with multiple criteria (2 replies)
  85. Change the Visibility of a Sub Form Control in the OnCurrent Eve (2 replies)
  86. Fuzzy Join (7 replies)
  87. "Record is deleted" error (22 replies)
  88. How Round up in a Query (4 replies)
  89. re: using variables in sql statements (6 replies)
  90. Querie Issues (12 replies)
  91. Change column sort in crosstab (11 replies)
  92. query question... (2 replies)
  93. How to look for a value among Fields and Not the reords? (1 reply)
  94. Date Time Problem in Query (10 replies)
  95. 'Days' Increment Heading - DateDiff (35 replies)
  96. identify Date from a text field (1 reply)
  97. Using a calculated field on a form to get data from a query usin (6 replies)
  98. Sequential ID (3 replies)
  99. Update Query (5 replies)
  100. Sequential Numbering at each change in a value? (2 replies)
  101. Update Query Question (2 replies)
  102. Criteria setting in Query (3 replies)
  103. Inventory database SQL question (8 replies)
  104. I want to Thank Eveyone (11 replies)
  105. autofill values in a query (3 replies)
  106. Searching from a date (4 replies)
  107. lookup/Dmin in a query? (5 replies)
  108. calculation query (2 replies)
  109. make table query, then append? or make table every day with no o (6 replies)
  110. No related records query (4 replies)
  111. Query field not updatable (4 replies)
  112. Add two queries (7 replies)
  113. Query to look up data print in report (2 replies)
  114. Matching Test (3 replies)
  115. Pare down list to eliminate duplicates, keeping one, based on cr (3 replies)
  116. VBA Insert variable into a table (9 replies)
  117. Counting Query (7 replies)
  118. Handling null values in field (8 replies)
  119. Appending records to 2 related tables (2 replies)
  120. Date Criteria Within a Query (6 replies)
  121. Query based on date criteria filter (10 replies)
  122. read NEXT? (11 replies)
  123. Transfer Word docs into Access Database (3 replies)
  124. Entering data through a query (1 reply)
  125. Expressions in queries (5 replies)
  126. Building a cross refernce database for work. (1 reply)
  127. Using Form Combo Box as Query Output (3 replies)
  128. Criteria Is Null causes expression typed incorrectly/too complex (1 reply)
  129. delete multi tables (5 replies)
  130. Displaying matches and non-matches in queries (2 replies)
  131. Running Delete Queries with SQL (3 replies)
  132. Two tables one column (7 replies)
  133. Missing join? (14 replies)
  134. Date format in query (3 replies)
  135. data type mismatch (4 replies)
  136. How to add "*" to an combobox that read values from table. (3 replies)
  137. Customization of Query (Configuration of a query) (3 replies)
  138. Queries based on Queries. I'm Confused (6 replies)
  139. Finding duplicate data (7 replies)
  140. Not a valid name (1 reply)
  141. Using combo box with a query (2 replies)
  142. fill a field with update query (3 replies)
  143. Automatically closing query (26 replies)
  144. Stock Warehouse & Sales (1 reply)
  145. Error "...too complex..." with calculated value (4 replies)
  146. Enable split DB to locate query criteria (4 replies)
  147. Default value in a text box from query (8 replies)
  148. Combo Box in a Parameter Query (1 reply)
  149. Refer to a List of Query Results (3 replies)
  150. IIF statement in criteria of query (3 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.