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, 279
  1. Formatting query results for calculated fields (8 replies)
  2. Query not updateable (3 replies)
  3. Returning All Dates Even When The Count Is 0 (1 reply)
  4. Help! Complicated Criteria question (3 replies)
  5. Query Not Showing All Records? (3 replies)
  6. best way to compare (2 replies)
  7. Populating text field from underlying tablewhen user selects fro (5 replies)
  8. How do I set up criteria for both null and not null? (1 reply)
  9. External Criteria in a crosstab? (1 reply)
  10. Check box (4 replies)
  11. Add calculated field value to table. (15 replies)
  12. Queries-Switchboard (15 replies)
  13. Question on Pivot Tables or column row calculations... (1 reply)
  14. Two If statements (6 replies)
  15. Exclude SUM from Query (1 reply)
  16. OpenRecordset with WHERE clause (3 replies)
  17. controlling combo box options with a query (1 reply)
  18. query assistance needed PLEASE!!!!!!! (1 reply)
  19. Duplicate Fields Update Query (1 reply)
  20. OutputTo xls Question...HELP (8 replies)
  21. Query Question (1 reply)
  22. Filling in a table record from another table based on similariti (1 reply)
  23. Wild Card Based on User Input ? (8 replies)
  24. Help Needed! (1 reply)
  25. IIf Statement Error ...HELP !!! (9 replies)
  26. Report to show Missing Records (2 replies)
  27. Numbering records in a query (3 replies)
  28. Append query (11 replies)
  29. Populate one field w/ data from another (2 replies)
  30. pull data where pk tbl1 NOTEXIST in tbl2 (5 replies)
  31. Return one distinct item assigned to multiple categories (4 replies)
  32. initials in a full name field (7 replies)
  33. Query of Form Data (3 replies)
  34. Adding hours to a date/time field (3 replies)
  35. Filter for all dates in current month? - obviously not DatePart( (4 replies)
  36. Duplicating sub data. (1 reply)
  37. Displaying record number in my query (1 reply)
  38. Recordset Not updateable (4 replies)
  39. Help with access query situation? (3 replies)
  40. How can I copy information down a particular field? (2 replies)
  41. Determining Relationships Between Sixteen Tables (6 replies)
  42. Multiple criteria (2 replies)
  43. Multiple Criteria from a Form - Problem! (17 replies)
  44. Queries with a Crosstab Query (4 replies)
  45. HELP (4 replies)
  46. Training Database (3 replies)
  47. IF/THEN Query (1 reply)
  48. Crosstab bafflement (0 replies)
  49. Crosstab query with Days and Total (1 reply)
  50. Joing duplicate records into one record? (21 replies)
  51. ADP - Insert Records Using Cmd Button (3 replies)
  52. Make new table (3 replies)
  53. Record Set Not Updatable (1 reply)
  54. Make multiple IIF's a Module? (2 replies)
  55. Date calculations (4 replies)
  56. DateDiff Query (1 reply)
  57. Query Based on Number Scheduled (4 replies)
  58. Updating and msgbox problem (4 replies)
  59. find and replace macro (14 replies)
  60. Random selection query (1 reply)
  61. Finding Duplicate Records (6 replies)
  62. date() function (3 replies)
  63. Probably easy to solve! - IsNull and wildcards in a query (4 replies)
  64. Importing From Excel and Deleting Duplicates (1 reply)
  65. If Then Else or Select Case? (4 replies)
  66. Converting many fields into one field (17 replies)
  67. Calculating Weekly Average (1 reply)
  68. Dates query help (3 replies)
  69. Crosstable Query (1 reply)
  70. not sure!!! (2 replies)
  71. findfirst and error 3251 (4 replies)
  72. Union Query - Format number (5 replies)
  73. Calculate and report yes/no totals (8 replies)
  74. Can this be done with queries alone (4 replies)
  75. problem with data type of calculated field of query (1 reply)
  76. Passing date range from a form to a query (8 replies)
  77. how to append different data types to same column (13 replies)
  78. Query criterium not met error handling (2 replies)
  79. Msgbox to let user choose criteria.How? (5 replies)
  80. Find Duplicate query to VBA Code. (3 replies)
  81. Time for running the query toooooo loooong!!! (15 replies)
  82. Data type mismatch in criteria expression (6 replies)
  83. getting rid of certain characters in a field (7 replies)
  84. Splitting a single field (5 replies)
  85. Make table query (1 reply)
  86. Query to Show Status (and return null if no status exists) (3 replies)
  87. query paramter + no dialog box (6 replies)
  88. Query using multiple combobox selections (2 replies)
  89. Criteria through text box (3 replies)
  90. Query from query (1 reply)
  91. Joining a Query and Table while Excluding some results (3 replies)
  92. Query driving me mad! (8 replies)
  93. Query creating too many records (9 replies)
  94. Average numbers in a row (9 replies)
  95. Calculate Business Days (1 reply)
  96. make table query creates binary fields (5 replies)
  97. Where Question (1 reply)
  98. Combine two tables (3 replies)
  99. Age Calculation problem in Access 2000 vs XP/2003 (4 replies)
  100. Crosstab like query with multiple column headers (4 replies)
  101. Trouble with LIKE ref. a txtbox on Form (3 replies)
  102. Coping to Excel using CTRL + c (1 reply)
  103. Make "All" Selection in a combo box work correctly (3 replies)
  104. what is causing an "Overflow" error? (9 replies)
  105. Return ID ONLY if, ALL linked IDs the same (6 replies)
  106. Query (1 reply)
  107. Only showing the newest record for duplicate values (3 replies)
  108. Referencing another record in the same table (1 reply)
  109. Specifying conditions in a crosstab query (4 replies)
  110. Changing a field setting automatically (1 reply)
  111. Pass Through Query Input (3 replies)
  112. Putting Spaces after text (30 replies)
  113. append/sort (1 reply)
  114. Clinical List box selection dilemma (3 replies)
  115. Returning specific records from query (5 replies)
  116. Cross Tab Date Query (7 replies)
  117. Latest Record (7 replies)
  118. Criteria for a date choice (2 replies)
  119. Multiple Listbox values to a SELECT ... IN () query (3 replies)
  120. Why wont this query work all the time? (1 reply)
  121. Passing parameters from forms to queries (1 reply)
  122. Matching Fields (11 replies)
  123. Problem with SUM calc for each record in a form (6 replies)
  124. query very picky on giving information :-( (1 reply)
  125. Getting an Id into a table from another table (6 replies)
  126. Hide duplicates via code (3 replies)
  127. Minor problem with insert sql (1 reply)
  128. Random Number Generator (4 replies)
  129. What does type mismatch mean? (5 replies)
  130. SQL problem (9 replies)
  131. altering design of a query without going into design view (4 replies)
  132. help with a query for counting up grouped records (3 replies)
  133. Query + filter on project (3 replies)
  134. Compare two tables (2 replies)
  135. Creating table entries based on field data (3 replies)
  136. Max Number of Recordes (1 reply)
  137. IIf Null retrieve from average? (5 replies)
  138. Problems with adding tables to queries with relationships (7 replies)
  139. Querie expression problem (4 replies)
  140. query calculating weekly profits (1 reply)
  141. Convert to a forumla (8 replies)
  142. Query help (5 replies)
  143. Selecting unused resources (4 replies)
  144. SQL Dates and Functions (11 replies)
  145. compile errors..what are they? (1 reply)
  146. Alternating records (1 reply)
  147. Finding SIMILAR fields in a table (2 replies)
  148. Update Query (1 reply)
  149. Help With BUilding a Query from multiple tables to show standing (1 reply)
  150. Error Message (2 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.