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. LEFT() Error in Query (4 replies)
  2. SHELL command not working (8 replies)
  3. Filter Field Data (3 replies)
  4. Counting records in multiple queries (5 replies)
  5. Attaching a check box to a max date function (3 replies)
  6. showing a query in a subform using the day as a filter (1 reply)
  7. Query Syntax help (8 replies)
  8. How do I do something similar to a "MINUS" union in Oracle? (3 replies)
  9. Integrating the code for a max.date function with a check box co (4 replies)
  10. IIf statement in SIMPLE query not working! (13 replies)
  11. Building queiry, form & report (2 replies)
  12. Top Ten (3 replies)
  13. percentage calculation in total query (1 reply)
  14. Finding Records in one table that have related records in anothe (4 replies)
  15. Text in Memo fields getting cut off in queries (9 replies)
  16. Combining Queries (3 replies)
  17. Delete duplicate fields within record (1 reply)
  18. Replacing a value (1 or 2) with "yes" or "no" in the query. (10 replies)
  19. Obtain Computer Name (6 replies)
  20. Sum Query not working (1 reply)
  21. Auto number field in query (4 replies)
  22. Parent query with conditional children included? (3 replies)
  23. Multiple criteria for query (4 replies)
  24. Appending To A Table (5 replies)
  25. Year Query (3 replies)
  26. How can I find only the first date for each set of records? (10 replies)
  27. Time Schedule Query (1 reply)
  28. Expressions and Update Query (1 reply)
  29. Limit records returned in a query (1 reply)
  30. Message if query returns no results... (1 reply)
  31. Convert to Proper Case (13 replies)
  32. Totals depending on a range of dates (numbers) (5 replies)
  33. Text box flash (10 replies)
  34. IIf statement based on whether a combo is enabled (14 replies)
  35. Help to flip VBA to SQL (10 replies)
  36. Selecting Query Parameters from a Form (1 reply)
  37. Query on a Query? (4 replies)
  38. Return occurences within a date range and null returns within th (2 replies)
  39. simple date question (6 replies)
  40. Select multiple items from a list box (7 replies)
  41. how do you use SELECT DISTINCT on two fields? (32 replies)
  42. Dlookup Question (3 replies)
  43. Define dates for query results (2 replies)
  44. Comparing two fields(string) from different tables using LIKE (11 replies)
  45. Birthdate query (3 replies)
  46. Picking Random Records (2 replies)
  47. Sequence of SQL interpreted/executed (3 replies)
  48. using dbfailonerror gives variable not defined error (6 replies)
  49. help needed transforming data (5 replies)
  50. Query Setup (4 replies)
  51. Birthday Date Query (38 replies)
  52. find matches (1 reply)
  53. Date within Date (24 replies)
  54. search for null string (8 replies)
  55. Need to select a certain X records after a query in access (1 reply)
  56. Newbie Inventory Help (10 replies)
  57. How do I evaluate a field as t/f false in query. (6 replies)
  58. Count of same entries in a query (4 replies)
  59. Access query to PostgeSQL database error (1 reply)
  60. Criteria Mismatch (4 replies)
  61. Top Values Question (1 reply)
  62. Query - Pulling latest dated record for a common ID (5 replies)
  63. Divide by 0 output (4 replies)
  64. Easy way to copy a record? (4 replies)
  65. Test for duplicates before posting (4 replies)
  66. Multiple Table Query based on updated criteria (1 reply)
  67. update qry (6 replies)
  68. Return a group in a totals query when no one is in that group (10 replies)
  69. query / database speed (3 replies)
  70. Multiple date criteria from correlated records? (3 replies)
  71. Access newbie (1 reply)
  72. Using NZ and still bringing up #Error (5 replies)
  73. How do i work with crosstab queries (3 replies)
  74. Breaking Data up into Daily Buckets? (1 reply)
  75. User specified search via query (1 reply)
  76. Duplicate records in query - how to stop them (5 replies)
  77. Using field as condition to open correct record (7 replies)
  78. Calculation Age (11 replies)
  79. Label query (12 replies)
  80. Access 97 Issue (4 replies)
  81. Decimal values to strings (1 reply)
  82. How Can I Identify, Use and Secure the next AutoNumber from a ta (6 replies)
  83. Dynamically select which column of the query to output (23 replies)
  84. Run Time Error 3131 (7 replies)
  85. Query two tables (7 replies)
  86. Automation leaves hidden Excel session (16 replies)
  87. is it possible to not run a data qry after its first run (2 replies)
  88. Calculate days between Billing Dates (1 reply)
  89. Need a query that counts items from a table on a per group basis (19 replies)
  90. Query to filter duplicates and count records? (28 replies)
  91. Append Query Key Violation (7 replies)
  92. crosstab with specified date range not working (3 replies)
  93. ADO error: the text, ntext, and image data types are invalid in (0 replies)
  94. Query Does Not Work Anymore (5 replies)
  95. inputting the same date for each criteria (1 reply)
  96. Passing Form Variables to an Access Project "Row Source" SQL Que (1 reply)
  97. Multi-table query , how to handle null fields. (2 replies)
  98. Remove quotes (4 replies)
  99. Query Type Mismatch (3 replies)
  100. Split one field into two whenever a space is encountered (6 replies)
  101. missing parameter- form variable not recognized in query (3 replies)
  102. Filtering Unique rows for addresses on demand (2 replies)
  103. Replace specific value in field with another value (3 replies)
  104. All Records Except Between Dates (2 replies)
  105. Query column data from row data (3 replies)
  106. Select Case Query (4 replies)
  107. Need to update master table cost & price fields from new tab (1 reply)
  108. Getting a value using SQL and VBA (3 replies)
  109. Newbie Q? RE: two table query (relationship trouble??)THANKS! (3 replies)
  110. TRANSFORM (3 replies)
  111. MS Access-Show Occurence Count (2 replies)
  112. Truncating of Memo Data Type (8 replies)
  113. Overflow Error 6 (1 reply)
  114. Opening a file from a record (3 replies)
  115. Use Multi-select Listbox as criteria for Append Query (7 replies)
  116. Running Total in query (9 replies)
  117. ERROR 3131 (1 reply)
  118. Adding new Record with a query (3 replies)
  119. A Query which will search a for surnames and return partial text (3 replies)
  120. Selecting the correct pay rate (19 replies)
  121. change field value in table after certain value in subform chose (5 replies)
  122. Truncating a linked table (3 replies)
  123. Query for a dummy (2 replies)
  124. Removing "-" from the phone number (1 reply)
  125. Automating to word - different approach.. (18 replies)
  126. Select Top of "" Sort Descending (4 replies)
  127. how do I change multiple join types at one time (5 replies)
  128. How do I remove 2 characters of text from the left of a field? (6 replies)
  129. Minus Date / Cdate() (3 replies)
  130. Output to a report (2 replies)
  131. true Appending of a value (1 reply)
  132. Combine 3 queries into 1 SQL statement (10 replies)
  133. Update query setup help (1 reply)
  134. LIKE query help (3 replies)
  135. Correlated subquery-type-query... (6 replies)
  136. Adding 3 field together into one total (2 replies)
  137. Date range query (4 replies)
  138. Counting WORKDAYS (M-F) without Holidays (3 replies)
  139. Records can't be read error - WITH OWNERACCESS OPTION; (1 reply)
  140. search for blank strings (7 replies)
  141. Group/count by fiscal year not calendar year (3 replies)
  142. Can you query from two different databases in Access (2 replies)
  143. Getting highest number in a table (3 replies)
  144. Group by: "Max" not giving needed results (1 reply)
  145. Query that finds missing value....more complicated than that ! (4 replies)
  146. Very simple or Very difficult? (3 replies)
  147. Multiple IIf Statements (6 replies)
  148. Query that shows only differences (1 reply)
  149. Updatable Query (1 reply)
  150. "keywords" feature in Access?? (1 reply)
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.