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. Can I show first 40 characters in query column (4 replies)
  2. Break down Excel data into Access-friendly data (4 replies)
  3. omit currency symbol (4 replies)
  4. Access Union?? (1 reply)
  5. Counting records based upon criteria of another field (6 replies)
  6. not duplicates (2 replies)
  7. Parameter Query with specific or null criteria (Between & Like) (5 replies)
  8. Delete Top 60,000 (11 replies)
  9. Return records of multiple fields that are not null (2 replies)
  10. Import data from csv file (12 replies)
  11. Wild Card Characters (5 replies)
  12. Pivot query access to sql (1 reply)
  13. Search for a single charecter in a field. (4 replies)
  14. Updating a table Field from a Query (1 reply)
  15. Updating multiple records on table (3 replies)
  16. does this look right? (5 replies)
  17. Creating a form-based query (4 replies)
  18. subselect query not returning selected records (4 replies)
  19. Query sum not calculating from function call in design mode (7 replies)
  20. Find every 1000th record (6 replies)
  21. reporting off 2 databases that are the same. (5 replies)
  22. Help with Nulls in a query (10 replies)
  23. Running Sum ? (3 replies)
  24. Alternate Records with 0 or 1 (7 replies)
  25. Input parameter on calculated field in select query (3 replies)
  26. Average of 5 Largest Field Values (2 replies)
  27. Appointment Calendar (4 replies)
  28. make tabel query (4 replies)
  29. query to remove ' apostrophies (9 replies)
  30. Open SQL Server Table as Recordset for VBA Loop? (2 replies)
  31. SQL to list Requests and its Staging when they are late or non-exist (3 replies)
  32. Calc pace - divide hh:mm:ss by number (11 replies)
  33. Need assistance with DLookup or something similar (7 replies)
  34. use query to "break down" table (4 replies)
  35. Refresh a Query through an "On Click" command of a Form (5 replies)
  36. Match documents between two tables by numbers, then match by name for any docs that we (0 replies)
  37. Creating a simple Query (1 reply)
  38. Tricky expression building (2 replies)
  39. Record is deleted Error After executinr SQL queries (2 replies)
  40. Help with IIF statement in query Null field (2 replies)
  41. Extracting Dates (3 replies)
  42. INSERT INTO SELECT FROM vs. Multi-valued Field (2 replies)
  43. append to table iif variable is not in table (5 replies)
  44. Matching entries in two tables with a lot of typos (1 reply)
  45. Access runtime & Vista query (3 replies)
  46. Parameter Value (5 replies)
  47. Update query won't update current record (6 replies)
  48. Export Access into Excel (6 replies)
  49. Stripping Different Amounts of Characters (3 replies)
  50. multiple if's (3 replies)
  51. Query by Month (4 replies)
  52. Union Query Problems (2 replies)
  53. How to easily print a Query result? (1 reply)
  54. Query not pulling data (2 replies)
  55. Query export in excel (5 replies)
  56. Age Query not working properly (2 replies)
  57. DSum function (5 replies)
  58. Access 2007 SQL to three Tables (3 replies)
  59. count date field by month (1 reply)
  60. how to create a dynamic file name from a query on transfertext (2 replies)
  61. querying a select group of products (1 reply)
  62. Creating a schedule Matrix from an access table/s (3 replies)
  63. Nested IIF in a QRY (1 reply)
  64. filtering records with sequential numbers (6 replies)
  65. Count of Numbers in a String? (6 replies)
  66. Delete records from a table (2 replies)
  67. Displaying time over 24 hours (3 replies)
  68. Using two queries (2 replies)
  69. Running Total for Inventory Database Stock in and Stock Out (22 replies)
  70. Pass through query problem (9 replies)
  71. Adding Criteria Parameter not providing results (3 replies)
  72. Query Criteria by VBA (4 replies)
  73. How do I get the AGE from a DOB (10 replies)
  74. Is there a more efficient way of doing Table1 INNER JOIN (Table2 INNER JOIN table3)? (0 replies)
  75. DateDiff cirteria referencing two records (4 replies)
  76. criteria being another field in a table (1 reply)
  77. Access Front end using stored procedures (4 replies)
  78. Joins (3 replies)
  79. Prevent Close of Startup form when closing Query Datasheets *DELETED* *DELETED* (4 replies)
  80. IIf expression as criteria (7 replies)
  81. Top 3 in each group - multiple tables (5 replies)
  82. Multiple filtering criteria (3 replies)
  83. Which Event to use to refresh a form when returning to it? (3 replies)
  84. invalid argument value (#0) (1 reply)
  85. How to take off the Close Button in Parameter Box (2 replies)
  86. Table Comparison Query (3 replies)
  87. two fields in one result? (4 replies)
  88. Query (3 replies)
  89. Identify active volunteer based on Start and End dates (5 replies)
  90. FK in Queries (1 reply)
  91. Birthdays in 7 days Query (6 replies)
  92. Need Access query to read Excel cells (1 reply)
  93. Global variable not being passed to query (6 replies)
  94. Query Help (5 replies)
  95. Update a table using a cross tab query (3 replies)
  96. Time of day causing problems with date based query (9 replies)
  97. Using Sql Server SP through Microsoft Access adp (1 reply)
  98. Access Application has different results using same data (2 replies)
  99. Update fields in different tables (6 replies)
  100. Pass-Through queries with autonumbers (5 replies)
  101. Returning Text In a Lookup Query (6 replies)
  102. User Defined Field in an Update Query (9 replies)
  103. Append Queries (13 replies)
  104. import query as a table (9 replies)
  105. Count quieries (4 replies)
  106. Is Not Null clause (5 replies)
  107. Date field, last two years (from Now()) (3 replies)
  108. Default ODBC timeout. (6 replies)
  109. Maximum Query (1 reply)
  110. Multiple Table Entries by Query? (2 replies)
  111. Query to lookup Variable and pass in VBA (13 replies)
  112. Division by Zero- Error Handling (7 replies)
  113. View today's data and yesterdays (5 replies)
  114. Date Reference With A Twist (3 replies)
  115. Query Qualification (2 replies)
  116. Dlook-up (8 replies)
  117. Running total in group by (2 replies)
  118. Cbo/Lst for query msg? (1 reply)
  119. Counting Multiple Similar Fields (3 replies)
  120. Trimming strings with criteria (5 replies)
  121. Use of the Max function (7 replies)
  122. Using criteria, except when not needed... (2 replies)
  123. Converting field from text to number (6 replies)
  124. Update query on several fields (2 replies)
  125. Find primary key of newly created record (6 replies)
  126. Export of Memo Fields (1 reply)
  127. Counting a calculated value (6 replies)
  128. Troubles with Update Query (3 replies)
  129. Issues grabbing auto-filled values in a form (1 reply)
  130. Count Distinct Problem (2 replies)
  131. Remove Primary Key in SQL (16 replies)
  132. Function similar to the find formula in excel? (3 replies)
  133. Select where null (3 replies)
  134. Filtering a query not directly used in report (2 replies)
  135. Changing data in a table to different format - Sort? (8 replies)
  136. Insert a slash into a text field (3 replies)
  137. List box selections (4 replies)
  138. Currency Calculation Issues (14 replies)
  139. Hide values that are empty (8 replies)
  140. Query Using Grouping is Cutting off Text (3 replies)
  141. Startdate + 4 days (4 replies)
  142. Calculations in a querry (1 reply)
  143. Counting Query will not return a 0 (3 replies)
  144. Grouping by Age (6 replies)
  145. break a name into it's part (5 replies)
  146. Query Multiple Tables for Unmatched (2 replies)
  147. Delete Query that doesn't delete :( (3 replies)
  148. Making a Query move with the (fiscal) times (15 replies)
  149. Nesting DLookup as criteria to DSum (4 replies)
  150. Help Generating Dates (5 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.