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. Today and 6 more days Report (5 replies)
  2. Can I make a query to find all birthdates in September?? (3 replies)
  3. Query with Dates (4 replies)
  4. Trouble with Union Query (3 replies)
  5. Subtraction in a Query (1 reply)
  6. Is it possible to force a Memo field in Make Table (MakeTable) q (1 reply)
  7. Another SQL date question (6 replies)
  8. How to ignore old expiration date if new record has updated expi (2 replies)
  9. Date Value Conversions (6 replies)
  10. Add select records in a query? (11 replies)
  11. delete one of each duplicate (3 replies)
  12. Dlookup not working (2 replies)
  13. Append Query - Need it to append value with all decimal places (9 replies)
  14. Saved queries mysteriously get wiped out.. lock file related? (0 replies)
  15. Simple Subtraction (1 reply)
  16. query: between 8PM and 10PM (1 reply)
  17. Query rules for access (3 replies)
  18. Uncommon ODBC Error with Union Query (10 replies)
  19. can not get crosstab to supply form (1 reply)
  20. Not in (9 replies)
  21. problem using ' in sql statement (5 replies)
  22. Refer to a specific column in a combo box from a form to use as (2 replies)
  23. Fill blanks in table - numbers stored as text (4 replies)
  24. Delete Query (7 replies)
  25. Calculated Field in Query/VBA Code Assessing That (2 replies)
  26. Expression/IIF (1 reply)
  27. Work Week only 4 days (9 replies)
  28. JOIN with string vs numeric criteria (2 replies)
  29. Error Msg (3 replies)
  30. date splitting (5 replies)
  31. Stored Procedures (4 replies)
  32. Between.... (6 replies)
  33. Fixing Postal Addresses (similar to spellchecker) (7 replies)
  34. Add, not concatenate (11 replies)
  35. Error ?: The search key was not found in any record. (1 reply)
  36. help with updating (7 replies)
  37. Can't figure out proper expression syntax (14 replies)
  38. Finding the Relative Calendar Month that a date falls in (1 reply)
  39. Query types - hidden property only visible when using SaveAsText (3 replies)
  40. update query with percentages (2 replies)
  41. Selecting items via query from a table (7 replies)
  42. Sum multiple rows in crosstab (1 reply)
  43. Select Top 75% (5 replies)
  44. Trouble quering multiple phone numbers (17 replies)
  45. Dates (3 replies)
  46. Expression Filters (5 replies)
  47. Filter for Query (2 replies)
  48. Only need the last record stored by date (7 replies)
  49. Calculated Field in Query Doesn't Work Properly (8 replies)
  50. text to number (3 replies)
  51. Complicated IIf Statement (6 replies)
  52. Going from CASE When to Switch (SQL Srvr to Access) (3 replies)
  53. Crosstab Query Error (5 replies)
  54. Query to slice a table into 3 different tables (10 replies)
  55. ALT + ENTER affect (6 replies)
  56. Multiple Due Dates in Reports (3 replies)
  57. Count help (5 replies)
  58. Calendar appears next to date - how to turn off (3 replies)
  59. Need zero to show in query results (2 replies)
  60. Maximum SQL Length (1 reply)
  61. Query with predetermined list (3 replies)
  62. Distinct values from a union query (3 replies)
  63. Exporting query to Web service (1 reply)
  64. Alias in query not updating (9 replies)
  65. Inverse Crosstab (3 replies)
  66. update query help (3 replies)
  67. dynamic query question from a parm (7 replies)
  68. Help with Formula (1 reply)
  69. Question regarding conditions in queries (4 replies)
  70. Crosstab to column data conversion (3 replies)
  71. How to Add an Incremented Counter to a Select Query (1 reply)
  72. query (3 replies)
  73. Select Every nth row (21 replies)
  74. How to save formatted queries in SQL View (8 replies)
  75. how to reference a value in another table as the criteria (15 replies)
  76. Query List (3 replies)
  77. Parameter query include multiple (7 replies)
  78. Converting Text to a Number (4 replies)
  79. Row Counter (3 replies)
  80. Why this query syntax no work (1 reply)
  81. What does this Query mean? (3 replies)
  82. Query Display Issue (2 replies)
  83. Bug (?): Problem with aggregate queries (4 replies)
  84. Update Query (9 replies)
  85. The Microsoft Jet engine doesn't recognize '[12]' as a valid fie (21 replies)
  86. making this query updatable (6 replies)
  87. Append Query (17 replies)
  88. Using parameter from a field in an open form (4 replies)
  89. Design question - trying to not have 2 duplicate tables (4 replies)
  90. join query (11 replies)
  91. Create new field in a query based on an if statement (1 reply)
  92. Adding days to date format yyymmdd (2 replies)
  93. Sum A Column in a Query (8 replies)
  94. Update query to concatenate (10 replies)
  95. Combine Multiple Fields into one (3 replies)
  96. Summarize Row Data in a Crosstab Query (2 replies)
  97. Cannot open query to fix it (3 replies)
  98. Distinct Date Totals (3 replies)
  99. Select Records In Coming Week (5 replies)
  100. cross tap side colum (5 replies)
  101. Date conversion (2 replies)
  102. list value if previous x out of y dates have values (1 reply)
  103. More help with a query (1 reply)
  104. Query Filter Stops at a Certain # (7 replies)
  105. Expression too Complex (3 replies)
  106. Query that will auto-select date, and generate sum? (1 reply)
  107. exclusion query in related tables with one to many relation (7 replies)
  108. Rank by Group (one table) (1 reply)
  109. Calculating % to hours (1 reply)
  110. remote assistance needed with Access 2003 (31 replies)
  111. Getting previous data 20 months back (3 replies)
  112. Query Stops at an Order # (1 reply)
  113. Select Query is Correct but it Does Not Gives Correct Output (1 reply)
  114. update table to include month (8 replies)
  115. Show all records if search box is blank (3 replies)
  116. < or > Criteria In Query (17 replies)
  117. How can I store a value dependent on another calculated field? (11 replies)
  118. Querying Hierarchy (5 replies)
  119. Previously working query now failing at Form line (8 replies)
  120. Produce a simple list without referencing a table (6 replies)
  121. Calculating Workdays (2 replies)
  122. calculated work-days between dates (2 replies)
  123. Crosstab Query by Year, then Month (7 replies)
  124. Query to go back last 12 hours (5 replies)
  125. Beginner Seeking Help - Convertine English Database to French (1 reply)
  126. Use of Index when 'using' the HAVING clause (3 replies)
  127. Will DLookup Help? Or Crosstab? (5 replies)
  128. month identification (24 replies)
  129. .Execute comand (3 replies)
  130. trouble converting a sql query into access sql - please advise (2 replies)
  131. query not summing when pulling from multiple queries (3 replies)
  132. Not returning all data from a query (1 reply)
  133. use and syntax of row_number in a msaccess sql query (3 replies)
  134. Removing character via update query.... (1 reply)
  135. Count query headaches (13 replies)
  136. Phone num/types query (4 replies)
  137. Help with Query (14 replies)
  138. IIF in Query (3 replies)
  139. Union Query (10 replies)
  140. A challenge - in case you need a break? (21 replies)
  141. Data Type mismatch error in Iif statement (4 replies)
  142. marking top n records (6 replies)
  143. New to Access..... (1 reply)
  144. Filter problems (3 replies)
  145. Compare values from field against excel sheet (5 replies)
  146. Basic "Lending Library" database (1 reply)
  147. Function queries with criteria fail to run for some users (9 replies)
  148. Programmatically setting format of fields in a query (5 replies)
  149. Left function (2 replies)
  150. Displaying zero counts in a Count query (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.