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. Open form from Query (1 reply)
  2. Select Records not found on another table (3 replies)
  3. Best way to do this? (13 replies)
  4. Please could you tell me how best to set up form and table/s (2 replies)
  5. Delete query (Deleting InStr?) (3 replies)
  6. Query to append data to tables (1 reply)
  7. Multiple Unbound listboxes on a form (2 replies)
  8. Combine 2 lines of data to 1 (7 replies)
  9. Can an index ignore words in an expression (3 replies)
  10. Numeric Field Overflow (2 replies)
  11. Pass Text Not As Parameter (3 replies)
  12. Query with variable problem. (3 replies)
  13. Date "Between" Query ... (7 replies)
  14. help with an expression (4 replies)
  15. Add cumulative total to query (2 replies)
  16. Display Trailing Zeroes Currency Data Type (8 replies)
  17. Access Query (3 replies)
  18. Combine 2 lines of data into 1 (2 replies)
  19. Query to list permits expiring (1 reply)
  20. Dir() in 2007 (8 replies)
  21. Date criteria problem (6 replies)
  22. Date Parameter in query (1 reply)
  23. All caps to lowercase (3 replies)
  24. Query to find empty fields (7 replies)
  25. Calcullating from previous Record (5 replies)
  26. How to Open query in design view, edit it, run it and close it w (2 replies)
  27. Proper Query Language for Access (7 replies)
  28. DLookup or a SQL statement? HELP! (4 replies)
  29. delete query (2 replies)
  30. Include All Records from One Table (5 replies)
  31. Query Wizard looks different (3 replies)
  32. Query using a variable criteria (6 replies)
  33. Price Fluctuations Query? (2 replies)
  34. Help: Distinct Query or an Expression or Both? (3 replies)
  35. Max Date (2 replies)
  36. ComboBox populate question (4 replies)
  37. Update one Table from two other tables (5 replies)
  38. Queries using prompts (4 replies)
  39. conditional query? (3 replies)
  40. Dates from table in a query (2 replies)
  41. Show Last 10 Records, by date (5 replies)
  42. Yes/No fields display improperly in query (9 replies)
  43. Can I allocate a ranking number to all records in a query? (1 reply)
  44. finding the difference in time (2 replies)
  45. Identify Duplicates with debit/credit factor (3 replies)
  46. Update query: "Operation must use an updatable query" error (4 replies)
  47. Update Query for PK (4 replies)
  48. Is there a Numeric FieldSize limit for queries? (5 replies)
  49. Updating queries (4 replies)
  50. APPEND QUERY with variables (12 replies)
  51. Data type mismatch with date using DateSerial (6 replies)
  52. Sub Query Criteria (1 reply)
  53. Change Date Format? (1 reply)
  54. wildcards search in query dialog box (6 replies)
  55. how to OBDC TO SQL 2005 SERVER FROM access 2003 (2 replies)
  56. Leaving Parameters Blank to Display all Records (5 replies)
  57. Datatype conversion error (3 replies)
  58. Wats wrong with this SQL? (14 replies)
  59. The Ole StartDate, EndDate, Date() Quandary (2 replies)
  60. Search field and move certain parts to another field. (17 replies)
  61. Query not working right (2 replies)
  62. Criteria escape code syntax (4 replies)
  63. How to convert a text to a number (3 replies)
  64. Relationship problem when inserting records (1 reply)
  65. Update and append records in one query (2 replies)
  66. Write a query for records NOT in a table? (5 replies)
  67. Crosstab needed?? (1 reply)
  68. Query Retrieval Question - two tables - text and number (8 replies)
  69. type conversion failure to update (10 replies)
  70. Date field in union query Sorts as text (3 replies)
  71. aggregate function in expression (6 replies)
  72. excluding rows when blank (1 reply)
  73. remove date from a date time field (1 reply)
  74. character return (2 replies)
  75. changing to Minus figures (9 replies)
  76. Query Criteria (5 replies)
  77. Query By Form Unmatched Records (1 reply)
  78. Simplify query results into one row per location (4 replies)
  79. Help with Query Criteria (8 replies)
  80. Query date confusion (8 replies)
  81. Run a query based on a form's combo box selection or return all (16 replies)
  82. year to year days behind / variances with 0 Div (1 reply)
  83. formatting in a query (1 reply)
  84. selecting a record (1 reply)
  85. Multiple expressions in same field (4 replies)
  86. Can't get past error message (3 replies)
  87. Using Pass-Through Query (SPT) for Pivotchart (OWC) (11 replies)
  88. CASE Statement inside a UNION query (1 reply)
  89. Licenses set to expire (8 replies)
  90. Hierarchical Parameter Query (4 replies)
  91. What's wrong with this? (15 replies)
  92. Eliminate Duplicate Records in Query (0 replies)
  93. Detemine Sunday's Date (3 replies)
  94. updating a field in a table using a query (1 reply)
  95. WAV File Duration Query (1 reply)
  96. Removing Commas to format a Date (7 replies)
  97. X-foot a row in a table (13 replies)
  98. IIF statement (1 reply)
  99. Update Query (3 replies)
  100. Group Each Page In Query With 20 Items (3 replies)
  101. Criteria not working in Crosstab query (3 replies)
  102. Union Queries in Excel (2 replies)
  103. MAX date confusion (4 replies)
  104. Create a list of configurations that can be added to (13 replies)
  105. query used to count (7 replies)
  106. An expression that will enable me to make a schedule (1 reply)
  107. Replace null with zero (16 replies)
  108. How to convert a number through Query? (7 replies)
  109. Convert to Text (4 replies)
  110. UPDATE query VBA w/variables (6 replies)
  111. Complicated Query Field Calculation (3 replies)
  112. Code that opens WORD nor working correctly. (12 replies)
  113. Printing a memo field greater than 255 characters long (2 replies)
  114. help with an if statement (5 replies)
  115. Crosstab query: long load / save times? (13 replies)
  116. Help with removing text from an Access Table. (8 replies)
  117. IIf function using AND operator (4 replies)
  118. a month to date query (8 replies)
  119. Combo box (1 reply)
  120. query with check box (1 reply)
  121. Distinct Counts (9 replies)
  122. aggregating functions for text? (1 reply)
  123. Two questions in one? (3 replies)
  124. selecting most current records (22 replies)
  125. Make Table Query not Populating Field (2 replies)
  126. Query worked last night...not now (12 replies)
  127. Ordering Numeric Data In A Query (13 replies)
  128. Invalid use of null (4 replies)
  129. minimising a clunky Lookup (5 replies)
  130. Saving query as a web page (2 replies)
  131. Data type mismatch (2 replies)
  132. Group and match by unique ID (2 replies)
  133. Age Count Query (1 reply)
  134. Lookup Field Query (10 replies)
  135. Today and 6 more days Report (5 replies)
  136. Can I make a query to find all birthdates in September?? (3 replies)
  137. Query with Dates (4 replies)
  138. Trouble with Union Query (3 replies)
  139. Subtraction in a Query (1 reply)
  140. Is it possible to force a Memo field in Make Table (MakeTable) q (1 reply)
  141. Another SQL date question (6 replies)
  142. How to ignore old expiration date if new record has updated expi (2 replies)
  143. Date Value Conversions (6 replies)
  144. Add select records in a query? (11 replies)
  145. delete one of each duplicate (3 replies)
  146. Dlookup not working (2 replies)
  147. Append Query - Need it to append value with all decimal places (9 replies)
  148. Saved queries mysteriously get wiped out.. lock file related? (0 replies)
  149. Simple Subtraction (1 reply)
  150. query: between 8PM and 10PM (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.