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. Execute stored procedure from VBA (4 replies)
  2. Conditional Join (7 replies)
  3. Update Query -- Problem with date criteria (32 replies)
  4. Query Count if "x" or "y" (1 reply)
  5. problem returning a date (4 replies)
  6. Can Access Open a Database (.mdb) Automatically? (10 replies)
  7. DateDiff Help (2 replies)
  8. Query not bringing a value (1 reply)
  9. Query on last name problem (3 replies)
  10. Combining results from various fields into single query result f (3 replies)
  11. Sort by month and year in same query (4 replies)
  12. Going Chinese (4 replies)
  13. Query to add results from 2 tables (9 replies)
  14. Query PivotChart View - Edit Programmatically? (0 replies)
  15. Create field in query to show part of another field (3 replies)
  16. How can I query this properly, so that the result will not shown (4 replies)
  17. Relational queries and parameter values (12 replies)
  18. Dlookup question for date range (6 replies)
  19. Simple query question - same value from multiple fields (3 replies)
  20. query condition in csv list (5 replies)
  21. Calculate payment based on loan amount and int rate (1 reply)
  22. Combining field contents (21 replies)
  23. Need to place a 0 in front of a 5 digit code I have (5 replies)
  24. simple vba and query (3 replies)
  25. Update query to increment field (2 replies)
  26. Logical expression help needed (4 replies)
  27. 2 tables 1 query (20 replies)
  28. restrict lenght of field returned (2 replies)
  29. iif statement (3 replies)
  30. query to return values from multiple fields from same table. (16 replies)
  31. Query multiple fields for specific numbers (1 reply)
  32. query with if ... then ... else show all (2 replies)
  33. TOOOOO LOOOONG (5 replies)
  34. Listing Table Structure via SQL/ODBC (3 replies)
  35. LIKE Operator won't see form txt box (3 replies)
  36. select only part of field (4 replies)
  37. group by Fiscal Year pivot table display (1 reply)
  38. Total (sum) with subtraction (4 replies)
  39. Query is swapping the format of the entered date (4 replies)
  40. Query take long time to run (6 replies)
  41. unexplainable (16 replies)
  42. special running sum in query (4 replies)
  43. Searching on mutliple optional fields (4 replies)
  44. Text to Number Conversion (9 replies)
  45. Count in query help (6 replies)
  46. Comparing 2 pairs of columns, Each 1 to many (1 reply)
  47. What is the Access version of Count(Distinct(fieldname))? (2 replies)
  48. IIF Statement (5 replies)
  49. Dynamic Query error (14 replies)
  50. How to remove characters from a field/string (5 replies)
  51. Access query retreiving SQL view data (2 replies)
  52. Crosstab, unknown column headings (3 replies)
  53. reporting new consumers based on date entered into DB (1 reply)
  54. VB syntax for value of a column from a query (3 replies)
  55. Distinct Count Query (1 reply)
  56. Average using only values BETWEEN others (3 replies)
  57. Query in Subform (9 replies)
  58. subform syntax in query (11 replies)
  59. Exclude three different values from one field (6 replies)
  60. Max value query (5 replies)
  61. Count Characters (3 replies)
  62. Unpivot query... (0 replies)
  63. selecting data from a table (4 replies)
  64. Ambiguous joins error (3 replies)
  65. Standard Deviation (4 replies)
  66. Query running under Access 2003 under Vista (5 replies)
  67. Report returns only 1 record (4 replies)
  68. Query about a Query :) (1 reply)
  69. Query Finding Last Date and Time (8 replies)
  70. Summation - Doubling?? (3 replies)
  71. text/memo (4 replies)
  72. How can I compare two tables? (5 replies)
  73. Combine 2 tables into 1 query (3 replies)
  74. Assign value from DoCmd.RunSQL to a variable (3 replies)
  75. Add two records in same field (4 replies)
  76. Mapping Values (1 reply)
  77. Working with Dates in a Query (3 replies)
  78. Ranking System (3 replies)
  79. Dynamic query (1 reply)
  80. Using the IIf Function in a Query to show ALL results (3 replies)
  81. How do I format a sql field as “$xxx,xxx.00” (1 reply)
  82. Access allergic to certain subqueries? (3 replies)
  83. Using the Iif function with a wildcard (3 replies)
  84. Deleting a space (2 replies)
  85. Can't get query to run faster (1 reply)
  86. Queries and memo fields (4 replies)
  87. Add queries - prevent from running accidentally (2 replies)
  88. Array formula for MS Access (2 replies)
  89. Record is not deleted from table (4 replies)
  90. addition field on query (3 replies)
  91. Replacing spaces in a table? (2 replies)
  92. Build a query to extract data (1 reply)
  93. Re: Query - with 2 colums (11 replies)
  94. Concatenated Fields (1 reply)
  95. Inventory Checking (1 reply)
  96. Limiting Records by Date (2 replies)
  97. Dmax and Dmin (12 replies)
  98. Finding longest distance in a group of data (4 replies)
  99. Criteria needed in a Select Query to return only the latest reco (4 replies)
  100. Error '2001' and Dlookup (8 replies)
  101. UK date calulation (2 replies)
  102. Comments in SQL? (1 reply)
  103. Is a Select query Open in Access 97 (12 replies)
  104. Populate Form with Parameter Query (15 replies)
  105. create table and specify pk (1 reply)
  106. min greater than zero (6 replies)
  107. Average (1 reply)
  108. counting query (3 replies)
  109. How to keep a Mouse Scroll Wheel from paging through records? (2 replies)
  110. Eliminate results that don't have X matches (3 replies)
  111. Criteria returning nothing if not answered (2 replies)
  112. DLookup with date (7 replies)
  113. query being deleted by random (3 replies)
  114. Update Query (Random Reference Number) (2 replies)
  115. can a query really do this? (8 replies)
  116. Between date function in a query (5 replies)
  117. Parametric Query with Like (2 replies)
  118. Random queries with sum of seconds (1 reply)
  119. querydef (12 replies)
  120. A query to split tables (7 replies)
  121. Current month criteria (5 replies)
  122. Fuzzy Join Query (1 reply)
  123. how do i format a column on a query to a specific # of character (3 replies)
  124. VBA SQL Query Needed (4 replies)
  125. Number of query values and destination are not the same (3 replies)
  126. Query based on three conditions? (6 replies)
  127. date format to dd-mon-yy (4 replies)
  128. Simple select query doesn't work in form (3 replies)
  129. Injury Log query help (2 replies)
  130. Loop Through Recordset Error (3 replies)
  131. Use criteria to show just 2 records of query based on Record ID (2 replies)
  132. Query selecting X number of records. (11 replies)
  133. Code Problem (1 reply)
  134. Subquery not working. What am I doing wrong? (11 replies)
  135. DLookup issue (11 replies)
  136. Query for duplicates (1 reply)
  137. How can I “fix” my query so that I can edit mt data? (1 reply)
  138. Joining 2 tables by 2 columns but encountering problems with ':' (3 replies)
  139. Creating a query using a tick box field (10 replies)
  140. Control box error (22 replies)
  141. Top Five Query (6 replies)
  142. Query conversion problem (6 replies)
  143. Inner Join yield one row only (8 replies)
  144. How to export text before query? (3 replies)
  145. Calculation error with nz (1 reply)
  146. Is a Select query Open in Access 97 (0 replies)
  147. Select Top 10 or select all (1 reply)
  148. Between 2 dates... (7 replies)
  149. Simple query output (17 replies)
  150. Determine autonumber being assigned (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.