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 Problem (3 replies)
  2. Parameter Query (3 replies)
  3. Display information based on a Projects desired format. (5 replies)
  4. ACCESS 97 bug or my code is wrong ? (1 reply)
  5. Copy record to multiple (2) linked tables (13 replies)
  6. Increased Values Query (1 reply)
  7. Easy (I hope) question (3 replies)
  8. Asign a status name to a status Id (6 replies)
  9. Query using a check box parameter (1 reply)
  10. Losing preceding zero using Trim function (4 replies)
  11. Calculating in a Query (28 replies)
  12. Query File locations (4 replies)
  13. formatting my numbers to be ##.## (5 replies)
  14. Delete Query with 2 tables not working (2 replies)
  15. Date Query (3 replies)
  16. Queries cannot work properly with similiar field details (4 replies)
  17. Time Field In Update Query (4 replies)
  18. Sequential Number (11 replies)
  19. Crosstab in form? (2 replies)
  20. Do i need a Case selection? (11 replies)
  21. Queries disappear! (1 reply)
  22. Query by groups (counting totals of each group) (1 reply)
  23. CrossTab query troubles (1 reply)
  24. Query for multipule workshops (1 reply)
  25. Listing numbers in same field (7 replies)
  26. help with query/Rapport (15 replies)
  27. Query Problem leading to Pivot table problems (1 reply)
  28. Combining Fields (1 reply)
  29. setting textbox value as criteria for a query (13 replies)
  30. Counter in a Query (3 replies)
  31. Access and XL integration (1 reply)
  32. SQL CrossTab Impass (1 reply)
  33. UnEqual Records (3 replies)
  34. joining query that has text field with number field (1 reply)
  35. SELECT Statement in the FROM Clause of a SQL Statement (6 replies)
  36. DateDiff Dilemma (8 replies)
  37. Make Table Replaces Oracle ODBC Connection (0 replies)
  38. Simple Query built for search - issues with spaces (2 replies)
  39. Problem with SQL Query in Access (2 replies)
  40. How to Run query for filled values but "" for nulls (4 replies)
  41. Unwanted Field Truncation (1 reply)
  42. Criteria of 'null' in update query? (4 replies)
  43. Using IFF statement for 2 fields (5 replies)
  44. Crosstab query error (3 replies)
  45. Count of Instances of Dates as 1 or 2 Depending on Whether the (2 replies)
  46. SQL query which is not case sensitive (3 replies)
  47. Update data by matching the phone numbers (1 reply)
  48. Duplicate Output Destination (3 replies)
  49. Round function in query (1 reply)
  50. Self-join? (1 reply)
  51. Crosstab Query (10 replies)
  52. SQL kick my butt (2 replies)
  53. General Query Coding (2 replies)
  54. wildcard passed to sql query (14 replies)
  55. Union Query Woes (3 replies)
  56. HELP! Pulling up correct records in query (2 replies)
  57. variables in a query (8 replies)
  58. MTBF (1 reply)
  59. Displaying no records (2 replies)
  60. average of several fields (10 replies)
  61. capturing id of record returned by aggregate function (1 reply)
  62. Selecting from a table in vba (9 replies)
  63. Address Fields Matching (1 reply)
  64. Delete query (4 replies)
  65. ACCESS QUERY FAILS WITH ODBC CALL FAILD ERROR (2 replies)
  66. Query: Group By 2 Fields and Average by 3 Seperate Fields (1 reply)
  67. One at a time (1 reply)
  68. Add more field criteria (3 replies)
  69. Need total from a text field. (3 replies)
  70. Trouble with an UPDATE Query (16 replies)
  71. Problem with creating SQL statement strings and single quotes (4 replies)
  72. counting days but excluding weekends? (5 replies)
  73. Query not showing null ranges (3 replies)
  74. Campare 2 dates (1 reply)
  75. Math Query Help (34 replies)
  76. Date Query with a Twist... (8 replies)
  77. Calculation in an Update Query (1 reply)
  78. Parameter Query/Combo List (6 replies)
  79. Numeric equivalence, compare numbers, "same number not equal" (6 replies)
  80. How to "rollback" an update after a failure has occured? (1 reply)
  81. Syntax in query - date range (15 replies)
  82. Scheduling questions (3 replies)
  83. Counting ZERO records in ACCESS QUERY (4 replies)
  84. Project List trouble (1 reply)
  85. 4 Append queries? Better solution? (8 replies)
  86. Need to get a specific record count Most recent 5 with detail (1 reply)
  87. Problem with Append Query (23 replies)
  88. Clarification on a calculated txtbox (5 replies)
  89. Criteria in Query: Ignore IIF condition if criteria is met (1 reply)
  90. criteria problem (6 replies)
  91. Union-Select gone bad (46 replies)
  92. Find/Replace character: Data Type Mismatch Error (7 replies)
  93. Replacing the records in primary key (1 reply)
  94. Multiple If Statements, Best way ? (2 replies)
  95. Nesting SQL (to avoid having to link to saved query) (3 replies)
  96. matching problem (2 replies)
  97. Finding duplicates by query (3 replies)
  98. Within a Query, listing multiple values in a single field, separ (6 replies)
  99. query too complex (9 replies)
  100. Query / SQL Conflict (5 replies)
  101. Query "Criteria"-How to word it? (2 replies)
  102. Help with query (2 replies)
  103. Data Input form - record adds automatically (1 reply)
  104. Populate an images field based on the content of another field? (1 reply)
  105. Trouble with Query (Two Tables) (1 reply)
  106. SQL question (3 replies)
  107. Creating a Hierarchy in a Report/Query (4 replies)
  108. Access Query - Basic Query a Query - Videos (1 reply)
  109. Access VBA Code (3 replies)
  110. Parameter queries as control data sources (9 replies)
  111. Deleting records that were selected by a query (5 replies)
  112. Concantenate Fields (6 replies)
  113. Queries for number of entries in db of various groups (1 reply)
  114. Problem with Query (7 replies)
  115. Data changed when exporting to Excel (1 reply)
  116. Replacing existing data based on a look up table... (4 replies)
  117. References and date queries (3 replies)
  118. I can't enter data (11 replies)
  119. querying 2 union queries (16 replies)
  120. Calculated field in a query not adding up (5 replies)
  121. Union query? (4 replies)
  122. Unique ID number for group of records (6 replies)
  123. #Error (9 replies)
  124. End of Month (3 replies)
  125. Append 3 or more tables at once in access (3 replies)
  126. exporting query results (1 reply)
  127. Query for most recent test and test one year ago (3 replies)
  128. append and compare query not updating / Should it update also? (20 replies)
  129. Formula Help (15 replies)
  130. Queries related to tables (5 replies)
  131. Formatting query results for calculated fields (8 replies)
  132. Query not updateable (3 replies)
  133. Returning All Dates Even When The Count Is 0 (1 reply)
  134. Help! Complicated Criteria question (3 replies)
  135. Query Not Showing All Records? (3 replies)
  136. best way to compare (2 replies)
  137. Populating text field from underlying tablewhen user selects fro (5 replies)
  138. How do I set up criteria for both null and not null? (1 reply)
  139. External Criteria in a crosstab? (1 reply)
  140. Check box (4 replies)
  141. Add calculated field value to table. (15 replies)
  142. Queries-Switchboard (15 replies)
  143. Question on Pivot Tables or column row calculations... (1 reply)
  144. Two If statements (6 replies)
  145. Exclude SUM from Query (1 reply)
  146. OpenRecordset with WHERE clause (3 replies)
  147. controlling combo box options with a query (1 reply)
  148. query assistance needed PLEASE!!!!!!! (1 reply)
  149. Duplicate Fields Update Query (1 reply)
  150. OutputTo xls Question...HELP (8 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.