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 results in double results (5 replies)
  2. Need syntax for Update Statement (3 replies)
  3. Some basic questions.... (3 replies)
  4. Hi, I am new here. (12 replies)
  5. Bottom 50% (3 replies)
  6. Select Query with Join has trouble with "equal text" (3 replies)
  7. update query (1 reply)
  8. 25, 50 or 75% in a query (2 replies)
  9. Percentage Help (7 replies)
  10. Appending Numbers (0 replies)
  11. SQL Query Explanation (3 replies)
  12. How to know if a query exists before deleting it (3 replies)
  13. Query to display last record for each property (4 replies)
  14. Modifying a stored query - is it possible> (4 replies)
  15. query prompts for parameter, parameter doesnt exist (3 replies)
  16. Sample generation (7 replies)
  17. How can I subtract two times to find total hours worked? (25 replies)
  18. New Records (13 replies)
  19. From with a Cascading Combo boxes (7 replies)
  20. Truncating characters in a text field (1 reply)
  21. Calculation on a letter? (4 replies)
  22. top 10 values in a total query (2 replies)
  23. refresh (9 replies)
  24. Ordering result in a query (4 replies)
  25. Date Function Question (5 replies)
  26. Field in table null until it changes (8 replies)
  27. Help with Averages (1 reply)
  28. Query the number of weeks in a month (5 replies)
  29. Delete Query Help (3 replies)
  30. Delete Query - "Cannot Delete from Specified Tables" (3 replies)
  31. Finding difference between two dates AND time (9 replies)
  32. Update Query (1 reply)
  33. optimize SQL (4 replies)
  34. Help with counting records in a query (6 replies)
  35. Inventory Costing By Weighted Average Cost (4 replies)
  36. Pass Parameters to Query using a Multi-Select List Box (16 replies)
  37. Delete record from one table and place it in another table (4 replies)
  38. Update with subquery (11 replies)
  39. showing fields based on a checkbox (7 replies)
  40. Query Puzzler - Help! (9 replies)
  41. Evaluate Text Fields (5 replies)
  42. how to build a search query (11 replies)
  43. Query using Last function disappears overnight? (7 replies)
  44. Dateadd Based On FrequencyID (18 replies)
  45. Append Query is creating duplicate records!!! (6 replies)
  46. Finding all newest records for several items - INTERESTING PROBL (2 replies)
  47. convert list in query, like IIF but not.. (10 replies)
  48. populate tables with a query (12 replies)
  49. Count the # of items in a group then display in query results... (7 replies)
  50. problem with invalid argument (5 replies)
  51. Import Query as Table (4 replies)
  52. insert data (2 replies)
  53. Update Query reports two more records than in the file. (1 reply)
  54. expression in the criteria of query design (5 replies)
  55. compare results and show only one item. (2 replies)
  56. Query Criteria from Filter by Form (1 reply)
  57. Query to compare sales over periods (1 reply)
  58. Transaction table with date query (1 reply)
  59. Comparing records in 2 tables (10 replies)
  60. Limiting the number of rows by a certain field (4 replies)
  61. Query Returns Values but Recordset Object says EOF (11 replies)
  62. criteria no repeats (2 replies)
  63. Two Excel worksheets ---> Need duplicate columns (2 replies)
  64. Group by Query Overflow? (3 replies)
  65. How to Match Everything with a query pop-up box? (2 replies)
  66. Compact on Exit (5 replies)
  67. insert records into table (2 replies)
  68. Split contents of one field into many (5 replies)
  69. Query Search (2 replies)
  70. I need an IIf Statement - quick! (4 replies)
  71. pass parameter's from on query to another (1 reply)
  72. Count to compare with a 'check' table (21 replies)
  73. data access forms (1 reply)
  74. Auto increment Project Number (8 replies)
  75. use a query to find SUM of a field (4 replies)
  76. Query to append controls into Memo field (4 replies)
  77. Selecting most recent record for a foriegn key (7 replies)
  78. % usage for each week (1 reply)
  79. Insert a string with single quote and double quote (2 replies)
  80. Parameter Query (1 reply)
  81. Calcuated Average Start Time (3 replies)
  82. Public function as criteria for a query (1 reply)
  83. Crosstab Query Question (5 replies)
  84. Sum by group - HELP? (10 replies)
  85. Cross Tab Query Date Column Headers (2 replies)
  86. Updating Field (5 replies)
  87. Dividing the Sum by the Max Value (3 replies)
  88. Danged Key Violations! (3 replies)
  89. MS ACCESS -Query Dependencies problem (1 reply)
  90. Combo Boxes (1 reply)
  91. Outer Join increases loading time dramatically (3 replies)
  92. Input mask question (4 replies)
  93. Display oldest date (3 replies)
  94. Export Filtered Subform Records (5 replies)
  95. Criteria to place in a query for an Option Button (2 replies)
  96. column count query (1 reply)
  97. Sorting Numerically (4 replies)
  98. Criteria input before query execution (3 replies)
  99. Removing duplicates (2 replies)
  100. select sql.. (1 reply)
  101. condensing rows into one (8 replies)
  102. Room Availibilty Query (15 replies)
  103. Filter "Yes/No" Fields (10 replies)
  104. Data entry in a query (3 replies)
  105. Strip off end of string (8 replies)
  106. Tracking Status (3 replies)
  107. Loop Query (10 replies)
  108. Problems with SQL Query (4 replies)
  109. Query by form using currentuser (1 reply)
  110. combining contents of fields in a query (0 replies)
  111. Getting guids to work from Excel Import to Table (0 replies)
  112. questions on group by query (3 replies)
  113. Query Expression Help Using Conditional If (IIf) Function (7 replies)
  114. Weighted Averages... (0 replies)
  115. Nz() type handler for errors (2 replies)
  116. Find The Latest Date in a Report (2 replies)
  117. Query between dates in month format (4 replies)
  118. multiple if statement (2 replies)
  119. Selecting unique records (6 replies)
  120. Sort a string? (9 replies)
  121. query returns nulls and empty sets (6 replies)
  122. Problem with aggregate query (4 replies)
  123. Confusing Query Issue (7 replies)
  124. Insert Query not doing anything (8 replies)
  125. convert text (7 replies)
  126. Finding a period between two dates (5 replies)
  127. Count nulls (5 replies)
  128. Query Multiple Databases (1 reply)
  129. Unwanted parameter box appears (6 replies)
  130. OLE object query and export to excel (2 replies)
  131. Using a query or macro to run multiple queries (1 reply)
  132. One Query from two queries is giving Duplicate Record in Reports (3 replies)
  133. Right Justify and zero fill a field (8 replies)
  134. Speeding up massive (2mill records +) queries (25 replies)
  135. List Box With Multiple Table Values (5 replies)
  136. Using an Update Query to fill a table (4 replies)
  137. Query finds subform but remains empty (9 replies)
  138. Query Multi results (2 replies)
  139. Pass field name through IIf statement (3 replies)
  140. Union query distinct rows (3 replies)
  141. Query to Show Account Assignments (6 replies)
  142. Query with wildcard (5 replies)
  143. comparison of 2 calculated numbers (2 replies)
  144. Selecting unique records (7 replies)
  145. Identifying Successive Records and then writing results to a new (6 replies)
  146. Getting a sum from a query (5 replies)
  147. Query of Two Tables (2 replies)
  148. Multiple queries condensed to one (1 reply)
  149. Convert "Date/Time" to "Date" (5 replies)
  150. SQL CASE Statement (2 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.