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 to find a customer order pattern (4 replies)
  2. Inventory Bar code Lookup (7 replies)
  3. concatonate (12 replies)
  4. Parallel processing of SQL queries? (2 replies)
  5. sum a column in subform (1 reply)
  6. I posted the following re: Cross Tab queries in the wrong forum. (1 reply)
  7. Query to eliminate duplicate registries that aren't "duplicates" (5 replies)
  8. Striving for Efficiency on a Pass-through query (4 replies)
  9. Append Query (3 replies)
  10. Display Unique records (3 replies)
  11. Conditional summary in query result (14 replies)
  12. Data missmatch issue (6 replies)
  13. adding into my query some formatting req.'s for the recordset? (7 replies)
  14. Is there an easy way to convert an Access query to Oracle SQL Pa (0 replies)
  15. Query to show certain invoices but not others (10 replies)
  16. Extract part of a field (11 replies)
  17. Number of records (5 replies)
  18. Query to change text to number returning some strange numbers (3 replies)
  19. Running a Query and putting the answer in a text box on a form (1 reply)
  20. dumb one (1 reply)
  21. vbCrLf ?? (5 replies)
  22. Compare two fields within a query to find what doesn't match (1 reply)
  23. Access 2007 Fill Handle (5 replies)
  24. point me to info on query logic? (5 replies)
  25. Access 2003 Date & Time Query Question (1 reply)
  26. Help understanding query logic (5 replies)
  27. Chart Labels (2 replies)
  28. Automatically filter the last month of data (8 replies)
  29. If else query criteria (13 replies)
  30. Wildcards in my tables (10 replies)
  31. Query Confusion. (2 replies)
  32. How to perform a Query with LIKE (3 replies)
  33. DISTICT on 1-filed (4 replies)
  34. Filter records based on date (2 replies)
  35. Basing the Criteria of one field on another field (3 replies)
  36. Combining Values From Several Records (4 replies)
  37. Query Parameter Drop Down choice? (7 replies)
  38. How to show query on form (1 reply)
  39. Order problem with UNION and CROSSTAB query (2 replies)
  40. Secondary Sort in a Query (2 replies)
  41. Crosstab query into table (5 replies)
  42. Updating multiple Rows/Fields in one table with one Update query (6 replies)
  43. I'm Lost Help (10 replies)
  44. Concatenate field from table linked by intermediate (1 reply)
  45. Employee Time Storage (1 reply)
  46. expressions in query (1 reply)
  47. Date Format - Export From Query To Excel (1 reply)
  48. What's wrong with this query? (3 replies)
  49. Query to find a specific record (1 reply)
  50. Relationship problem (6 replies)
  51. Placing queries into groups (6 replies)
  52. mail merg with a query (6 replies)
  53. Union query row sort; parameter box popping up (1 reply)
  54. Counting Related data in single table (2 replies)
  55. A query feeding off a cascading lists on a form (10 replies)
  56. Add results from query to table if contidtion is true (3 replies)
  57. Sorting issue using query (1 reply)
  58. Query for search (2 replies)
  59. Append Query into MySQL (1 reply)
  60. set criteria in query to use all records from a continuous form (2 replies)
  61. SQL help (1 reply)
  62. Creating a query of highest sums (7 replies)
  63. Access 2007 Complex Query Question (2 replies)
  64. Query Date (1 reply)
  65. Need to sum partial data in a query (4 replies)
  66. compare 2 fields and have lesser value entered unless they are e (1 reply)
  67. displaying a message if query is empty (10 replies)
  68. Exclude dates from String (5 replies)
  69. retrieve last entry (2 replies)
  70. Two Query Sequence Number Merge! (4 replies)
  71. error: filter string to long (1 reply)
  72. Complex query - need to get subtotals? (1 reply)
  73. Returning only data which does not exist (3 replies)
  74. Looking up old records (2 replies)
  75. Execute an action query without a warning (19 replies)
  76. Listbox doesn't seem to be allowing a selection (3 replies)
  77. error when running update query (6 replies)
  78. deciphering a query (3 replies)
  79. DateDiff function not returning a result (5 replies)
  80. Autonumber in Query (3 replies)
  81. BAD SQL statement? (2 replies)
  82. Looking Up A Field Based Upon A Form Entry (6 replies)
  83. LABELS - Print One or Multiple – HOW? (7 replies)
  84. creating an update query (12 replies)
  85. using date as query parameter (6 replies)
  86. Object Required Error 424 (7 replies)
  87. Show records from one table that do not match a join... (9 replies)
  88. Dealing with minutes (3 replies)
  89. re: Query Problem (1 reply)
  90. whats wrong with my date range (2 replies)
  91. Parse Help.. (12 replies)
  92. Passing lookup table entries to Queries for reports (4 replies)
  93. In query how to call IIF function located in a module (21 replies)
  94. extract data from table if match in 3 fields with another table (7 replies)
  95. ODBC Call failed on MSSQL based query (5 replies)
  96. Saving Query Parameter (1 reply)
  97. Group By Min doesn't include null values? (3 replies)
  98. Assigning a single number to multiple records (4 replies)
  99. Null problem (5 replies)
  100. Query Grouping to add sums (1 reply)
  101. Adding data to data already in a memo field via coding (4 replies)
  102. If field is zero show 0 (5 replies)
  103. Pass through queries with access programatically (1 reply)
  104. Pass-through question (4 replies)
  105. Pass-through producing different results (2 replies)
  106. Criteria Question (9 replies)
  107. query to count individual data in single field (6 replies)
  108. compile error on query (9 replies)
  109. Query with 2 different critieria on same field (4 replies)
  110. Query String with another string inside (3 replies)
  111. finding unmatched records (7 replies)
  112. Add sequence of numbers in order to only a small list (4 replies)
  113. How do I sort based on two criteria? (2 replies)
  114. can u use a pass through query without a DSN? (6 replies)
  115. Using range of dates as crosstab query headings (10 replies)
  116. Allow data entry in a query (21 replies)
  117. Need Totals Count based on multiple fields (3 replies)
  118. Only return records with "x" characters (3 replies)
  119. Sorting a crosstab query (3 replies)
  120. Using Totals "Max" in Query versus VBA Code (4 replies)
  121. Trying to compare data just to 2 decimals (4 replies)
  122. leading zeros (5 replies)
  123. How can I use the value of a calculated field in the same query? (4 replies)
  124. Append Query Not Producing Desired Results (3 replies)
  125. Separte Report based on User input in Select Query (8 replies)
  126. Query to return value of last invoice (3 replies)
  127. Select Numeric Range (3 replies)
  128. Unable to do UPDATEs for the next run. (0 replies)
  129. Sort Dates by Day of the Week (4 replies)
  130. Query criteria for "ONLY" (6 replies)
  131. Drilling down from cell in datasheet view (3 replies)
  132. Unioning Crosstab queries (7 replies)
  133. Query to Show Null OR a value (5 replies)
  134. SELECTing from a parameterized query (3 replies)
  135. Need to get the first record and last (2 replies)
  136. Calculating difference from current and previous date (5 replies)
  137. Calling an Oracle stored procedure from Access 2003 Passthrough (5 replies)
  138. initiate a query outside of access? (1 reply)
  139. Cannot Delete "One" Record in One-to-Many Query (7 replies)
  140. Select * EXCEPT for ceratin fields (6 replies)
  141. newbie (1 reply)
  142. Requery on lost focus? (2 replies)
  143. Union or Append Query? (1 reply)
  144. Converting data but not an easy transpose (3 replies)
  145. Needleman-Wunsch algorithm (2 replies)
  146. Problem with queries (4 replies)
  147. NZ on Numeric Value (22 replies)
  148. Yes/No field autofill based on date field in same table? (5 replies)
  149. sql error (3 replies)
  150. Example of why normilization would not work...? (6 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.