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. Parameter query not behaving (4 replies)
  2. OR criteria in SQL Statement (8 replies)
  3. Searches. (2 replies)
  4. Stored Procedure Syntax (6 replies)
  5. Refresh query by code (5 replies)
  6. Append records from to another database (3 replies)
  7. Query to show if any one of three fields is not null? (5 replies)
  8. Errors in report when using the (All) function (4 replies)
  9. how to search for no entry (4 replies)
  10. Transposing Data? (2 replies)
  11. Percentage issue if then 0 vs low percentage. (3 replies)
  12. Changing Query's SQL string in runtime (8 replies)
  13. Can I show a percent as a ratio?? (5 replies)
  14. Converting Seconds to HH:MM:SS (7 replies)
  15. return max value record only (4 replies)
  16. Trouble with one to many relationship (3 replies)
  17. Operation must use an updatable query (1 reply)
  18. Sort/Group then Count with Date and Time fields (3 replies)
  19. Selecting a record that is not null or spaces (2 replies)
  20. Find difference between numbers in same field in different recor (3 replies)
  21. Pull data out of text field (2 replies)
  22. How to set a criteria for table fields. (1 reply)
  23. Combine Queries (11 replies)
  24. How to compare field with subquery field (3 replies)
  25. updating a query in real time (1 reply)
  26. query from field containing word string (3 replies)
  27. record Matching (1 reply)
  28. Archiving (4 replies)
  29. Append query from form filtered by sql from list boxes (4 replies)
  30. Show duplicates same row (2 replies)
  31. An 'Update Query' Question.... (5 replies)
  32. Switch Case in a criteria (1 reply)
  33. Records within one year (3 replies)
  34. Criteria Between ... And Not including all dates (4 replies)
  35. Double Distinct in an SQL statement (4 replies)
  36. Referring to a Table field in SQL using the fields collection (3 replies)
  37. Return 0 if no data (3 replies)
  38. Order Query by specific value (4 replies)
  39. query that returns a number (8 replies)
  40. last date as criteria (1 reply)
  41. Inserting data from List Box selection (2 replies)
  42. Grab "currentrecord" number. (10 replies)
  43. Formatting in query Field Expression (5 replies)
  44. Query to limit amount of labels on 1 page (1 reply)
  45. Quotation Marks in Query (3 replies)
  46. using a query to count records (3 replies)
  47. filtering the last date (2 replies)
  48. ORDER BY, exclude record (5 replies)
  49. Automatically refreshing values (2 replies)
  50. Newbie Yes/No Queries. Return All Results that partially match. (10 replies)
  51. query sales last week (1 reply)
  52. turn Email addrs in query list into one string (8 replies)
  53. can't update records due to lock violations (1 reply)
  54. one-to-many query (4 replies)
  55. read only query? (4 replies)
  56. query/sql criteria help using forms (3 replies)
  57. Add Criteria for filtering fields (1 reply)
  58. Month Between two Dates (2 replies)
  59. network crashed and locked up database to read only (2 replies)
  60. selecting criteria (4 replies)
  61. Combo Box to select parameter query criteria (4 replies)
  62. Do not Show 0 fields, help! (7 replies)
  63. Update Query (4 replies)
  64. Right Justified (3 replies)
  65. Problem displaying Select Query (3 replies)
  66. Massive Update Query Needed (3 replies)
  67. select criteria when running a query (3 replies)
  68. How to change existing odbc settings (3 replies)
  69. Update Queries. (8 replies)
  70. CrossTab Query with summary row (1 reply)
  71. Dropdown list for query input (5 replies)
  72. Querying Multiple Fields with one Parameter (1 reply)
  73. Break a Fullname field into Separte fields (3 replies)
  74. query criteria (8 replies)
  75. Getting parameter pop dialog on form startup? (19 replies)
  76. popup from query (5 replies)
  77. TOP "NOT IN"" (7 replies)
  78. Query problem (3 replies)
  79. Nested if with a between dates problem (10 replies)
  80. Date Range (4 replies)
  81. Why Doesnt this query work?? (17 replies)
  82. DAvg or DSum Previous Records (1 reply)
  83. Values in a combo box (4 replies)
  84. Find Shared Value Entries (1 reply)
  85. How many records found ? (3 replies)
  86. Formatted SQL String Not Working (5 replies)
  87. Query gives key violation error - sometimes (1 reply)
  88. Querying for Current Record Only (3 replies)
  89. Getting the name of a user-created query (7 replies)
  90. Expressions in Queries (3 replies)
  91. Trouble with SQL and Row Source . . . (1 reply)
  92. updatequery (6 replies)
  93. Calculate Average Rate (4 replies)
  94. Linked Tables (SQL) and strange results (9 replies)
  95. Workspace versus CurrentDb (2 replies)
  96. Criteria for a calculated expression (5 replies)
  97. Pretty basic query logic snag... (1 reply)
  98. Adding total for a year (10 replies)
  99. Need Advice Please! (1 reply)
  100. Renaming (4 replies)
  101. Opening Access database error (5 replies)
  102. Syntax with dbSeeChanges (1 reply)
  103. Union Query Comparison (3 replies)
  104. multiple Update question (1 reply)
  105. open a query by using a combo box (1 reply)
  106. generating a list as a string from qry results (5 replies)
  107. Count function not working (3 replies)
  108. Multiple dinamic "OR" criteria in where clause (7 replies)
  109. Last name First name (3 replies)
  110. Help with working days!! (3 replies)
  111. Running SQL queries in VBA (20 replies)
  112. Breaking Data up into Weekly buckets (6 replies)
  113. Separating data from one field into several (3 replies)
  114. only use the Year out of the Date Field (3 replies)
  115. Qry date based on criteria defined in a VBA module or function (8 replies)
  116. Three table query problem (3 replies)
  117. how to translate the sql (3 replies)
  118. Join Query (UNION) Clips Memo Fields to 255 (1 reply)
  119. Table Comparison Query (3 replies)
  120. < or > symbols inside an IIF() statement in a query (7 replies)
  121. Create Pass-Through Query Programmatically (3 replies)
  122. Cascading delete doesn't work (6 replies)
  123. #Error, Nz(), and A query with no results... (4 replies)
  124. Two Questions (1 reply)
  125. Find Duplicates Query Problem (0 replies)
  126. Nested Query?? (2 replies)
  127. Tough Query for the tough minded (2 replies)
  128. Deleting Records before September 1, 2004 (5 replies)
  129. loop through subtable (4 replies)
  130. Query with blank data (1 reply)
  131. Database Window displays when User employs Query Wizard (13 replies)
  132. Find Criteria (4 replies)
  133. divide two fields with a conditional function in a query (9 replies)
  134. Convert query result to a String (3 replies)
  135. Append Query Question (6 replies)
  136. Delete duplicate query (7 replies)
  137. Differentiating RWOP queries from other queries (0 replies)
  138. Sum Query (1 reply)
  139. Unmatched Query..... (5 replies)
  140. Date function SQL (4 replies)
  141. if ...... then loop in query (2 replies)
  142. how to kill the Ms-Access application if i am giving the partial (0 replies)
  143. Optional query parameters (7 replies)
  144. Multiple Query (3 replies)
  145. Case-sensitive queries (10 replies)
  146. Hiding Queries from Users (1 reply)
  147. Calculating average in a query (4 replies)
  148. total is incorrect and driving me crazy. (1 reply)
  149. Returning multiple date values via a query (1 reply)
  150. Why doesnt this simple query work ? (4 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.