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. Nested Select (6 replies)
  2. layout difficulties (10 replies)
  3. Make table to different database (4 replies)
  4. Using an "update query" to add additional columns to a table (6 replies)
  5. Rept function in Excel available in Access? (6 replies)
  6. Utility that shows the underlying queries (1 reply)
  7. Question about Append Queries (4 replies)
  8. Expression problem? (5 replies)
  9. Multiple Table Query Problems (2 replies)
  10. Sending input parameters to pass through query (1 reply)
  11. Iif and OR? Doing my head in!! (3 replies)
  12. Parameters in queries (3 replies)
  13. Crosstab Query Append to Table (1 reply)
  14. Cross-Tab Problem (3 replies)
  15. Trying to calculate Age - help needed (3 replies)
  16. Pass-thru query (3 replies)
  17. update/append two tables from excel spreadsheet (5 replies)
  18. Text vs. Memo (4 replies)
  19. recordset sum (4 replies)
  20. Changing date format (5 replies)
  21. Q about SELECT DISTINCT (3 replies)
  22. Update Query (3 replies)
  23. Sorting a Query (Categorically if possible) (7 replies)
  24. Syntax Problem-- Between (4 replies)
  25. Excluding data (4 replies)
  26. Store results of db.Execute strSQL (5 replies)
  27. Query based on fiscal year with IIF statement (9 replies)
  28. searching for a record... a faster way (9 replies)
  29. Query - change it from updateable to non-updateable? (3 replies)
  30. Dlookup Problem (6 replies)
  31. Sorting Data (16 replies)
  32. Crosstab with month year sorted incorrectly (3 replies)
  33. GUIDfromString (7 replies)
  34. Create query to break on account number and give subtotal (2 replies)
  35. Dates missing from sequence (10 replies)
  36. SQL query date (1 reply)
  37. small query big results (14 replies)
  38. Getting SUM in Control Through SQL (3 replies)
  39. Creating a Table with a Primary Key (10 replies)
  40. combining fields and keeping currency. (9 replies)
  41. Update query problems (2 replies)
  42. Problem with a SELECT query... (6 replies)
  43. Query Madness (6 replies)
  44. Dealing with *s in data (5 replies)
  45. select max function (3 replies)
  46. Loop Problem (7 replies)
  47. Textbox Value in Criteria (15 replies)
  48. Query gives ODBC Call Failed (3 replies)
  49. OBDC –call failed (1 reply)
  50. Bof and Eof (3 replies)
  51. NZ function (6 replies)
  52. syntax is wrong (12 replies)
  53. Validating user selections from a list box using VBA (6 replies)
  54. Don't want * used as wildcard! (6 replies)
  55. Help with a query that has a new year problem (1 reply)
  56. criteria (4 replies)
  57. Formatting numbers to Currency format (3 replies)
  58. Create new columns through append query or sql (7 replies)
  59. Query check box (5 replies)
  60. field value problem (1 reply)
  61. selecting month and year from a date field (5 replies)
  62. Retaining number format in a concatenated text field (3 replies)
  63. Select from Form and use wildcard (3 replies)
  64. Minimum Value from multiple fields (16 replies)
  65. Business Days Function that account for holidays (2 replies)
  66. "Analyze with MS Excel" (6 replies)
  67. Error Trap Not Working - RecordCount (6 replies)
  68. Combining records (3 replies)
  69. How do I form this query? (13 replies)
  70. Combo Box question (1 reply)
  71. populating a ComboBox (6 replies)
  72. Query to get the max date from multiple fields on one table (3 replies)
  73. UNION query to place string in "0" index of combo box not workin (5 replies)
  74. Trying to create an auto-restarting number sequence (10 replies)
  75. Case sensitivity in queries (3 replies)
  76. regarding a program that displays important dates from access db (7 replies)
  77. Is it possible to link a query and not a table? (12 replies)
  78. Date Query (3 replies)
  79. using a string to search a range of dates in a query (4 replies)
  80. Using multiple combos with --ALL-- to generate report (12 replies)
  81. Printing a query in landscape? (2 replies)
  82. Overflow problem (2 replies)
  83. HELP...Querying Database with dates set as text (1 reply)
  84. Inporting data from word form (3 replies)
  85. Month Count (3 replies)
  86. Mutliple Queries (2 replies)
  87. Rename Columns In a Query (14 replies)
  88. Combine tables with a query, then export to Excel (16 replies)
  89. Help With Lookup (1 reply)
  90. Record Number Column in Queries (3 replies)
  91. Duplicate Bookings Query (1 reply)
  92. double function query (11 replies)
  93. Using Substring function (13 replies)
  94. Criteria Question (3 replies)
  95. Multiple IIF Statements (3 replies)
  96. Division calculated by Access is WRONG! (4 replies)
  97. Using Instr function (4 replies)
  98. Query criteria to show a form (63 replies)
  99. Remove the characters but leaving the numbers (3 replies)
  100. Setting Format Properties In A Group By (Totals) Query (3 replies)
  101. Query for entire table (6 replies)
  102. Show months in order on a Pivot Chart? (3 replies)
  103. Cross Tab Woes (8 replies)
  104. Change appearance of SQL Code Results (18 replies)
  105. Exporting loads of queries - can it be automated? (6 replies)
  106. Normalizing Data (3 replies)
  107. Dateadd and Criteria... (10 replies)
  108. get elapsed time between two caluclated dates? (9 replies)
  109. Incorrectly Written strSQL - Syntax Error Missing Operator In Qu (9 replies)
  110. Text To Date Concatenation (7 replies)
  111. Query Calculation Overflow Error (5 replies)
  112. Add Criteria to existing SQL Code (3 replies)
  113. Need week of the month..not week of the year... (7 replies)
  114. Delete Query - Bypass security prompts (4 replies)
  115. Percentages (15 replies)
  116. Summary Query Question (2 replies)
  117. Find min date from different date columns (4 replies)
  118. Pull Data from two fields into one (3 replies)
  119. Calculated time value has various results (4 replies)
  120. Problem concatenating two fileds in SQL (4 replies)
  121. Generating A Memo Field From A Make-Table Query (1 reply)
  122. calculation in Query (5 replies)
  123. Display Column Heading of Minimum Value in CrossTab Query (2 replies)
  124. Query by form trouble (3 replies)
  125. query by date (1 reply)
  126. Year over year dates (6 replies)
  127. DSUM syntax (4 replies)
  128. reference issue (15 replies)
  129. Trouble with between date and date syntax (3 replies)
  130. SQL for an update query needed (1 reply)
  131. Which Query to use? (2 replies)
  132. Duplicate Records Problem (6 replies)
  133. NORMDIST: Follow up to Tomturkey5's question about LOGINV (1 reply)
  134. Update query but.. (1 reply)
  135. Distinct Work Units in Totals (0 replies)
  136. Adding/Deleting Series to/from a Chart? (0 replies)
  137. Problem with SQL (4 replies)
  138. The expression is typed incorectly or is too complex to be evalu (2 replies)
  139. Debug help needed. (6 replies)
  140. Trapped by an apostrophe (3 replies)
  141. Dlookup? (2 replies)
  142. Minimum Date (5 replies)
  143. append query, dbfailonerror (11 replies)
  144. Formula for scoring a field (4 replies)
  145. like function, using numerics in text field (8 replies)
  146. SQL Query (13 replies)
  147. Multi Query Export 2 XLS (4 replies)
  148. Splitting cell into fields using commas (12 replies)
  149. Trouble with Query by Form (3 replies)
  150. Delete Query - Only delete 1st instance (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.