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. Is there anything Access could do in this situation? (6 replies)
  2. checkbox to change data in select statement (6 replies)
  3. Query Returning same info on two lines (5 replies)
  4. Select Query is fast but make-table is slow (20 replies)
  5. Columns in Query output (14 replies)
  6. Records in query dont show when using Totals function (4 replies)
  7. How to query multiple fields based on conditions (3 replies)
  8. Append Query: do NOT want duplicates (5 replies)
  9. alias in listbox (5 replies)
  10. Append from four tables to one table..... (14 replies)
  11. Crosstab Date Selection v. Select Query (2 replies)
  12. Current Year Savings using Month and Day (6 replies)
  13. Convert Crosstab output into two fields (4 replies)
  14. Hyperlink from query results to input form for update/change (8 replies)
  15. Getting duplicate sets of data from related table (5 replies)
  16. Problem with SQL (6 replies)
  17. Totals and comparing rows within table (0 replies)
  18. Query to create an unknown number of culumns (5 replies)
  19. Query Wildcard Help - Look for '/ /' ? (6 replies)
  20. Non-Filtered Query Results (3 replies)
  21. Index violations (10 replies)
  22. Error log with append query (2 replies)
  23. Is possible to use Collection item in a query as parameter? (3 replies)
  24. Date issue: Pulling data based on dates parameters of other table (14 replies)
  25. Use of NZ (3 replies)
  26. Select query that combines crosstab and query as v (0 replies)
  27. SORTing a RowSource for Combo-Box including UNION (8 replies)
  28. Excluding a column when using Select* (3 replies)
  29. Query Criteria Expression? Help (3 replies)
  30. Searching of data within a specific range. (2 replies)
  31. How do i show the second to last unique LedgerDate ? (1 reply)
  32. Why is access treating this as a parameter query? (3 replies)
  33. What does 'Expression' mean in the query grid in the totals row? (1 reply)
  34. Update Query and 'You have tried to assign a null value to a variable that is not a Va (4 replies)
  35. Date Conversion Issue (4 replies)
  36. 'Part of an Aggregate Function' error (1 reply)
  37. I want to create a query that will show all the records after my Customer’s second to (2 replies)
  38. Linking Tables (3 replies)
  39. Multiply two values (6 replies)
  40. sql pass through problem (6 replies)
  41. Format h:nn to dd/mm/yyyy hh:nn (7 replies)
  42. Group data, then rank WITHIN group (8 replies)
  43. List of Query Fields (1 reply)
  44. Pop up report (3 replies)
  45. Combine 2 date fields (8 replies)
  46. Calculating between two times nearly works! (3 replies)
  47. Possible to change Sql Statement with Code before it runs? (4 replies)
  48. Question for Crystal - Select Query Syntax (3 replies)
  49. Filtering Percentages in Criteria (6 replies)
  50. Locate Orphan Records with Multiple Joins (2 replies)
  51. Query criteria defined in a form through checkboxes (4 replies)
  52. If statement with or (10 replies)
  53. DLookup in Query (4 replies)
  54. Query help (3 replies)
  55. query (5 replies)
  56. Date Calculation (5 replies)
  57. Query to include all records from one table when linking another (1 reply)
  58. Creating a Report in a Datasheet Format (4 replies)
  59. Make Table query freezing up (4 replies)
  60. IIf brainfog! (23 replies)
  61. Auto Append date records to table (7 replies)
  62. Using Queries to Fill Fields in Tables (4 replies)
  63. Selection through table (5 replies)
  64. Opening a Folder in Adobe from Access (3 replies)
  65. Access 2003 VBA Else Without If ERROR (5 replies)
  66. I want to create a query that will show the records for each Customer’s last payment. (4 replies)
  67. Counting Records based on multiple columns (2 replies)
  68. Call a parameter query from a query (5 replies)
  69. How do I join two tables with problematic rows (13 replies)
  70. Update/Delete Queries - import excel SS data and combine with table (8 replies)
  71. Alternative of Double Quote (6 replies)
  72. Access 2007 Parameter Query Problem (1 reply)
  73. Mass Data Input (6 replies)
  74. How to convert an Int to a Date (5 replies)
  75. Problems with InStrRev (4 replies)
  76. Getting Left 8 Characters in String (3 replies)
  77. clear query from list box and maintain table (3 replies)
  78. Matching part of a field (9 replies)
  79. Retrive Text Box entry into a Query... (3 replies)
  80. How to make query that parses information ? (help) (4 replies)
  81. Queries and variables (5 replies)
  82. Creating a history from surveys (5 replies)
  83. querydef passing parameters through PTQ to MySQL 5.0.24... (19 replies)
  84. Question on combining 2 very similar queries (4 replies)
  85. Scalar Query Question (using subquery as a table) (0 replies)
  86. Making a query to transfer information from one table to another (3 replies)
  87. SQL to delete in date range (1 reply)
  88. show all child records based on 1 child record criteria (4 replies)
  89. IIF in query (2 replies)
  90. Totaling columns in a query (9 replies)
  91. Inventory query & pulling selected records (2 replies)
  92. Saving Page Format for a Query (2 replies)
  93. Listbox to select one or all records (2 replies)
  94. Relationship and Multi Record Issue (6 replies)
  95. If Vs Case Statements (4 replies)
  96. Disappearing results! (3 replies)
  97. If statement can be true on both ends? Need Assistance (2 replies)
  98. Help with query removing duplicates based on conditions of each row (3 replies)
  99. Date Math in Queryies (3 replies)
  100. Matching Query Dates (2 replies)
  101. Create an Undo Button for Queries (1 reply)
  102. Determine if a table contains entries that contain a date interval (1 reply)
  103. Query to create mail lables for specific 3 digit zipcode only (6 replies)
  104. Combining duplicates and adding Sums (6 replies)
  105. CharIndex() not defined (2 replies)
  106. Update Query with a delete query (1 reply)
  107. Help combining data from multiple queries (3 replies)
  108. Coding with Parameters (6 replies)
  109. Table name and value from field in that table (1 reply)
  110. Date Searching (1 reply)
  111. How do you count blank spaces? (8 replies)
  112. Need to identify 'non-hits' from a query (3 replies)
  113. select query (12 replies)
  114. Query Expression - Display (8 replies)
  115. Union query creates too many decimal places (3 replies)
  116. Using a query to temporary store data and later add to a table? (2 replies)
  117. A General Purpose String Splitter (7 replies)
  118. Query problem with combo box (3 replies)
  119. How to populate a field with condition (4 replies)
  120. Percentage of past 3 months (1 reply)
  121. Need To Understand SQL Statement Not Using LAST (11 replies)
  122. Same IDs with Multiple Names (3 replies)
  123. Flagging Missing Items between Tables (3 replies)
  124. Key violation error in update query (5 replies)
  125. Need Trek 46 - Inventory Qry (96 replies)
  126. crosstab by week commencing (4 replies)
  127. Using a field reference in a query critereon (4 replies)
  128. Using function in a query (6 replies)
  129. Make Table Query doesn't put data into Ascending Order (3 replies)
  130. Cartesian join in Access (2 replies)
  131. Several parameter queries with same question (1 reply)
  132. ID based on date (2 replies)
  133. Multiple Records with Same Name But Different Address (1 reply)
  134. Queries to find duplicate names with name ID. (20 replies)
  135. Add data from previous record if blank (4 replies)
  136. Limiting Query by Age (10 replies)
  137. Calculate Age in Query (23 replies)
  138. Multi-faceted Query (2 replies)
  139. Convert a negative number to a positive number (11 replies)
  140. Change yes/no based on date in query (1 reply)
  141. Using another field in the record for a Query filter (5 replies)
  142. Access Pass through with parameters - multiple querydef as subqueries? (18 replies)
  143. Convert Number to Hours & Minutes (2 replies)
  144. data from multiple tables that aren't joined (14 replies)
  145. Can't Get Union Query To Use "ORDER BY" Clause (2 replies)
  146. Query to get unique values of two columns in the same table (24 replies)
  147. IIF issue (3 replies)
  148. MTD Query not showing anything when no MTD Data (21 replies)
  149. Pull values from tables and store them in temp tables (1 reply)
  150. Date Calculation (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.