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. Adding The Description Text From Issuenew Form To Issuesextended Query - Issues Web Database Template. (1 reply)
  2. Find Exact Duplicates Of Import (7 replies)
  3. Update Multiple Fields At Once (5 replies)
  4. Delete Duplicates Records - Fix Related Records (10 replies)
  5. Multiply A Negative Number In An Expression On A Query (7 replies)
  6. SQL Error (24 replies)
  7. Expression Error? Dont Know Why? (8 replies)
  8. Querying With Complex Aggregate Issues (9 replies)
  9. Dsum Running Sum Results In "type Conversion Failures." (9 replies)
  10. Query Max Value And Convert To Group (3 replies)
  11. Automated Emails After Updates On Certain User Selection? Plus A Few Other Problems (5 replies)
  12. Extracting Dates From Issue Comments - Issues Web Database Template (2 replies)
  13. Too Few Parameters. Expected One. SQL Issue (6 replies)
  14. Dupe Record Base Off Field With Number (8 replies)
  15. Export Crosstab Query To Excel With Code (2 replies)
  16. Problems After Update Query (7 replies)
  17. Duplicate Patient Names (6 replies)
  18. Use Formula In Access Query (2 replies)
  19. Calculate Date Ranges From Single Date Field (10 replies)
  20. Query Stays Open Even With Code? (4 replies)
  21. Date Criteria In Access With SQL Backend (1 reply)
  22. How To Get Information From A Query By Using VBA Code. (8 replies)
  23. Query To Return Data That Falls Within User-inputted Dates (8 replies)
  24. How To Auto-populate Related Issues In The Issuedetail Form To Include Issues With Similar Data - Issues Web Database Template (4 replies)
  25. How To Add A Cost/time Tracking Part To An Issues Database - Issues Web Database Template (1 reply)
  26. Trust Certificate Problems On Database. (8 replies)
  27. Extracting Date/month/year/time From Text Field (3 replies)
  28. Query The Results Of A Query? (4 replies)
  29. Multiple Items Search (14 replies)
  30. Query To Display The Fieldname That Is True. (5 replies)
  31. Exclude A Field When Export Query To Excel (9 replies)
  32. Copy Data From Table1 (sub1) To Table2 (sub2 (5 replies)
  33. Best Way To Filter Results From 2 Pivot Columns (1 reply)
  34. Query For Unique Records Based On A Field (2 replies)
  35. Export Info In Table To Excel As Multiple Worksheets Based On Criteria (2 replies)
  36. Display Most Recent Audit Record Equal To Current Pk (4 replies)
  37. Query Problem With Called Public Function - Data Type Mismatch In Criteria (8 replies)
  38. How To Create Query For Subform (3 replies)
  39. Access To SQL Server Queries (4 replies)
  40. Ccur No Value Returned Else Value Returned (13 replies)
  41. Insertinto (6 replies)
  42. Query To Find Null With Date & Time Criteria (2 replies)
  43. Pull Most Recent Date (3 replies)
  44. Need Help With Query Paramter For Having Clause (14 replies)
  45. Top Three (3 replies)
  46. Password The Way We Not Allowed Others To Use It (5 replies)
  47. Iif Function Does Not Work (or Work Other Way Round) (12 replies)
  48. Filter Query (1 reply)
  49. Instr Function To Exact Match 2 Or 3 Initials From Employee Table (8 replies)
  50. Ranking Values From Multiple Fields (4 replies)
  51. Min And Max Fuction In Access Like Excel (3 replies)
  52. Union Query (34 replies)
  53. Strange Accdb Behavior - Running Query Twice (2 replies)
  54. Queries Not Updatable After Migration To mySQL From Access Tables? (4 replies)
  55. Need Help With Database Query (3 replies)
  56. Update Query Not Updateable (8 replies)
  57. Query Returning Multiple Instances (18 replies)
  58. Retrun All Months In A Totals Query (10 replies)
  59. User Input Not Working With Crosstab Query (1 reply)
  60. Need A Code To Export Crosstab To Excel File Like Gantt Ch. (8 replies)
  61. Dcount To Get An Average! (3 replies)
  62. Convert .125 To A Number From Text (5 replies)
  63. Combine Two Crosstab Query (6 replies)
  64. Help On Constructing String (3 replies)
  65. Combine Queries (24 replies)
  66. Loop Through A Table And Return The One Or More Values (3 replies)
  67. Need Help With Query Expression (7 replies)
  68. Set Query Criteria With VBA (1 reply)
  69. Compensating For Nonexistent Data (9 replies)
  70. Oracle Linked Table Query 'not Like' Not Working (1 reply)
  71. Cannot Calculate An Expression In Query (5 replies)
  72. Reverse A Crosstab Type Table (2 replies)
  73. Reality Check Please (8 replies)
  74. Can Too Many Optional Parameters Choke Access? (11 replies)
  75. Date Min And Max For Each Change In Another Variable (3 replies)
  76. Criteria In Query Based On Combo Box Field..not Working :( (8 replies)
  77. Did It Occur Last Month (6 replies)
  78. Leading Zeros (8 replies)
  79. Crazy Join Query (4 replies)
  80. Display The Total Hours Billed By Fiscal Year (7 replies)
  81. Query Lookup From Dlookup (12 replies)
  82. Concatenate If/else Statement In A Query (12 replies)
  83. Giving Value To A Number And Show It On A Report (20 replies)
  84. Autogenerate Query And Export Based On Field Value (2 replies)
  85. Querying Table For Most Recent Date And By Another (5 replies)
  86. Would A Union Query Solve This? (4 replies)
  87. Assign A Value Dynamically To A Number Field (1 To Max) (5 replies)
  88. Improving Old Queries (4 replies)
  89. Sub Queries! I'm Trying To Learn How To Create/use These. Could .. (3 replies)
  90. Multiple Query Results Displayed In 1 Form (7 replies)
  91. Make Table Data Type (17 replies)
  92. Cant Get "frustrated Outer Join " Work (4 replies)
  93. Query With A Date Filter And Most Recent Record (5 replies)
  94. Combining Two Queries Into One ? (4 replies)
  95. See Horizontal Line In Crosstab Query (9 replies)
  96. One Query Or More? (4 replies)
  97. Using Like In VBA SQL Statement (9 replies)
  98. Getting A Count In A Subquery (6 replies)
  99. Creating SQL From Form Control Values For Append Query: How To Allow A Null Value? (17 replies)
  100. Inner Join Dysfunction (5 replies)
  101. Only First Required Of Multiple Instances (3 replies)
  102. Sorting A Union Query (6 replies)
  103. How And Where To Insert Code To Compare Values (4 replies)
  104. Need To Make The Query Omit Certain Records (3 replies)
  105. Need Code Check, Passing String To Query (3 replies)
  106. Importing Excel Tables Into Access (5 replies)
  107. Word/access Mail Merge Issue (4 replies)
  108. Insert Or Append In One Query (14 replies)
  109. Random 10 Records By Employee (8 replies)
  110. Is There An SQL Solution ? (5 replies)
  111. Combo Box Limitations On A Memo (9 replies)
  112. Union Query Does Not Return All Records (4 replies)
  113. Num2ord (3 replies)
  114. Join Expression Not Supported For Valid Join (3 replies)
  115. Merge Tables And Overide Data (10 replies)
  116. Search More Than 1 Field (3 replies)
  117. Autonumber Format In Query (3 replies)
  118. Limiting Listbox To 50 Rows (10 replies)
  119. Two Query Columns See In Crosstab Like One (2 replies)
  120. Using A Function In A Query (17 replies)
  121. Calculate A Value (4 replies)
  122. Change Formulas In Crosstab Query (0 replies)
  123. Filling In Zeros In Table (3 replies)
  124. Displaying Data Horizontally - Crosstab? (4 replies)
  125. Can A Where Clause Reference Bit Positions Within A Column? (14 replies)
  126. Like "*" Sorting Out Blanks (4 replies)
  127. Average Multiple Fields In Query (4 replies)
  128. Creating A Log For Each Item In Db (3 replies)
  129. Converting Data From Excel To Access (16 replies)
  130. Building A Person's Name From Several Fields... (6 replies)
  131. Not Like Or <> Not Working With Date Fields (6 replies)
  132. Can You Have More Than One Where In SQL View? (5 replies)
  133. Write Sequential Numbers To Table Without Autonumber (9 replies)
  134. Union Query Asking For Information When I Run It (9 replies)
  135. Unmatched Query For Multiple Fields And A Date Criteria (5 replies)
  136. Distance Calculation Formula (7 replies)
  137. Update 1 Table With Data From Another Table (6 replies)
  138. Previous Quarter (4 replies)
  139. Divide By Criteria In Query (7 replies)
  140. Query Criteria...trying Again (10 replies)
  141. Query Criteria Help (5 replies)
  142. Rolling Year Violation (27 replies)
  143. Undefined Function (10 replies)
  144. Simple Query But Need Help (12 replies)
  145. Access Code Help (9 replies)
  146. Filtering Records In A Many-to-many Situation (7 replies)
  147. Concatenate Unique Values (5 replies)
  148. Unique Record Query (1 reply)
  149. Simplify SQL Help! (12 replies)
  150. Query Used To Open A Form, Broken References (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.