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. Query with Time Range (3 replies)
  2. Number checker (4 replies)
  3. multiple count total columns (3 replies)
  4. Expression: full financial year of YYYY (6 replies)
  5. specifying criteria in a crosstab query (3 replies)
  6. Running Total in a Query - DSum doesn't seem to be working (7 replies)
  7. sort by time (4 replies)
  8. Show duplicate items between two tables (3 replies)
  9. Query data from two tables with same types of data (6 replies)
  10. Writing a Query with VBA (1 reply)
  11. Combining fields while omitting connecting words when a field is (2 replies)
  12. display records with blank field (1 reply)
  13. stuck with this (2 replies)
  14. Requery a subform in a loop (23 replies)
  15. Creating a Query For a Command Button (3 replies)
  16. Insert Statement that uses Select (5 replies)
  17. Attempting To Filter By Comparing Data (1 reply)
  18. Printing a receipt from initial querie to finish (6 replies)
  19. Update Query (6 replies)
  20. Pass a "Is Null" as a string from a form to a query ? (5 replies)
  21. crosstab query (9 replies)
  22. Query based on multiple queries (1 reply)
  23. Null results, want them to be "0" (6 replies)
  24. What's wrong with this crosstab? (2 replies)
  25. Same Union Query (5 replies)
  26. Union qry (1 reply)
  27. Query selecting highest value (3 replies)
  28. Ambigous join? (23 replies)
  29. query locking table (2 replies)
  30. Appending data to multiple tables. (9 replies)
  31. Unique records in a select query (17 replies)
  32. Change Table in Access from Excel to tabular format (1 reply)
  33. Aaargh - parameterized queries!!! Using Double? (2 replies)
  34. WildCard Filter (2 replies)
  35. Help needed with access query with relationships (2 replies)
  36. Choose 2 tables to compare (5 replies)
  37. Counting # Of Characters In A Field (7 replies)
  38. Crosstab Query Problem (4 replies)
  39. Append Query Not Working?? (5 replies)
  40. Smal SQL Statement/union queries (4 replies)
  41. Add Primary Key to Make Table Query (2 replies)
  42. How to append data and make a new table (1 reply)
  43. Query every day between two dates (3 replies)
  44. Combine Fields (7 replies)
  45. Extract data from the right or left side of a comma (1 reply)
  46. SQL not working in vba (33 replies)
  47. Deriving data from another query (2 replies)
  48. Date Help (3 replies)
  49. Results (6 replies)
  50. Access 2000 (Multiple queries on ADODB.recordset) (3 replies)
  51. IsNull question (5 replies)
  52. Debug Code (5 replies)
  53. Append/UpdateColumn (15 replies)
  54. update query (6 replies)
  55. Export a query to excel (1 reply)
  56. How can I accomplish this with a query-ID lookup (3 replies)
  57. Use combobox value for query? (5 replies)
  58. Null Value (3 replies)
  59. Assign Relative Value Based on Criteria (4 replies)
  60. Not Like/ Like/And Like/<- Why is this not working? (2 replies)
  61. SQL help needed please =) (9 replies)
  62. Multitple null fields (3 replies)
  63. Last Entry of each group (4 replies)
  64. Add Table Description with a make-table query? (1 reply)
  65. to Complex (11 replies)
  66. Queries (3 replies)
  67. Concatenate multiple results into single field? (3 replies)
  68. Problems getting the currency sign to display using the Nz funct (3 replies)
  69. Update query to the first instance (2 replies)
  70. formula for a profit query needed (9 replies)
  71. Query Two Tables To Find Matches (2 replies)
  72. Simple Totals Query Problem (5 replies)
  73. Query field using date ranges, multiple results (1 reply)
  74. Need Several totals - don't where to start (3 replies)
  75. how to insert apostrophe in a sql sentence (2 replies)
  76. Returning the max issue date and the ID (6 replies)
  77. How to set text in query (4 replies)
  78. Update Query: Can't update memo field due to ' ' in text (5 replies)
  79. NESTED EXPRESSION (4 replies)
  80. Update table with primary key (5 replies)
  81. Action Query on Jet database backed times out/freezes (60K + rec (8 replies)
  82. filtering combo boxes off of multiple tables (1 reply)
  83. ADO invalid connection string attribute (3 replies)
  84. Subtracting weeks (5 replies)
  85. Updating another query (7 replies)
  86. Trimming out Characters (1 reply)
  87. Remove source causes error (2 replies)
  88. Updating a query using VBA (10 replies)
  89. Adding a column on my table (16 replies)
  90. Finding unmatched entries (4 replies)
  91. internet Router Log Problem (2 replies)
  92. Dlookup Question (20 replies)
  93. General Q (4 replies)
  94. Making a table with an autonumber field (2 replies)
  95. Very horrible query needing revised. (5 replies)
  96. Query Design (4 replies)
  97. formula needed for stock (2 replies)
  98. get the unique column (3 replies)
  99. Format$ question (3 replies)
  100. *[Enter Letter]* (12 replies)
  101. parameter query with crosstab (3 replies)
  102. loop through table (4 replies)
  103. Null = All (5 replies)
  104. ambiguous outer join - query within a query (8 replies)
  105. memo field error in update query (1 reply)
  106. Brain Dead w/ this query (13 replies)
  107. Access Limitations!!?? (16 replies)
  108. Query excluding items (9 replies)
  109. How to create a custom filter (4 replies)
  110. show value of a field from the following record. (5 replies)
  111. Parameter Query with one field to populate list box on form (7 replies)
  112. Update query to remove Quotation marks (4 replies)
  113. Storing query information into an excel spreadsheet (5 replies)
  114. using criteria in a table for my query (4 replies)
  115. Main/Sub Report & Query (3 replies)
  116. Where to begin? (1 reply)
  117. Appending... (1 reply)
  118. Help with the The InParam() function (1 reply)
  119. Query Error with user defined function (2 replies)
  120. Rank in SQL (2 replies)
  121. Results from query needed to be appended to a single record in a (29 replies)
  122. Database Errors & Corruption (5 replies)
  123. Excel Code >>> Access Query (11 replies)
  124. Append 50 queries to a table. (19 replies)
  125. Guidance on query for unbound listbox (1 reply)
  126. Syntax to format number to currency in Query (11 replies)
  127. Queries on check boxes (3 replies)
  128. One is the loniess number (7 replies)
  129. Categorize Letter Grade by Numerical Scores (1 reply)
  130. backdoor query (3 replies)
  131. Remove Duplicates from Table (5 replies)
  132. Filtering a date field to return only those values 30 days prior (3 replies)
  133. How can a query prompt accept blank/null from a user so it retur (14 replies)
  134. Problem with IIF Statement (3 replies)
  135. column reference in query criteria.. (6 replies)
  136. Extract parts of a field (11 replies)
  137. Part of an aggregate function (2 replies)
  138. Finding Duplicates (9 replies)
  139. Crazy math! (10 replies)
  140. SQL Error (10 replies)
  141. Find & Replace (4 replies)
  142. Join Text and number field (4 replies)
  143. Date Query Today 30 days (3 replies)
  144. Single query for 2 different forms (9 replies)
  145. Parameter Query Across Columns (5 replies)
  146. Trim off any letters (20 replies)
  147. Must be a simple answer to this (7 replies)
  148. Access Query (7 replies)
  149. Problem Checking WeekDay (7 replies)
  150. Date calculations excluding weekend (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.