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. Display a record only if a certain field is filled (3 replies)
  2. Help with Nulls (4 replies)
  3. Help with 'If' in a query (11 replies)
  4. VBA Query + get values (5 replies)
  5. crosstab query question (20 replies)
  6. Count the number of new accounts per month (1 reply)
  7. Syntax for criteria? (5 replies)
  8. Query latest dates (2 replies)
  9. Widcards in Queries (3 replies)
  10. Testing queries (1 reply)
  11. Make Table Query Prompts (4 replies)
  12. Converting SQL Server Stored Procedure to Access (2 replies)
  13. Expression problem. (2 replies)
  14. SQL to insert records not already in table? (9 replies)
  15. Hard return in memo field/query (3 replies)
  16. How to obtain 1 specific child record based on date? (4 replies)
  17. Validation on query (2 replies)
  18. calender query (5 replies)
  19. One Query 2 Forms (5 replies)
  20. COUNT on 2 Coloumns (1 reply)
  21. IsNumber? (5 replies)
  22. Trouble with Select Statement (2 replies)
  23. How can i allow my user to search for any information? (7 replies)
  24. Query only the first 3 numbers of an account number (3 replies)
  25. Question on trying to create a merge query (2 replies)
  26. Help! Fieldname w/ double quotes! (7 replies)
  27. Query Filter by Date Range through IIf statement (1 reply)
  28. Date criteria query - simple umm? (3 replies)
  29. Queries with Null Value (1 reply)
  30. Querying another DB (1 reply)
  31. transfer text (2 replies)
  32. Criteria in select query (4 replies)
  33. Combining two update queries (1 reply)
  34. UNION query not returning correctly (5 replies)
  35. Having trouble with calculations... (13 replies)
  36. Find duplicates criteria problem! (5 replies)
  37. Using a multiplier in a query from my form (4 replies)
  38. Problem with form/subform and SQL (1 reply)
  39. Access 2000 Query Problem (3 replies)
  40. Minor Calculations (3 replies)
  41. Totals in crosstab query (2 replies)
  42. Default value (6 replies)
  43. Operation must use an updateable query (2 replies)
  44. Select "<ALL>" code is giving me trouble.. (5 replies)
  45. checking if character exists (5 replies)
  46. Create table with Outlook form container (UserProperties) (0 replies)
  47. Query Data Extract Nightmare by a Novice (4 replies)
  48. Left( ) question (1 reply)
  49. Check one, add one... (3 replies)
  50. Combing an empty query with another (3 replies)
  51. Counting Records and Adding Values (3 replies)
  52. My query disapears (2 replies)
  53. Selecting records from subsets of data (9 replies)
  54. Get only one return per record (4 replies)
  55. Grouping Query (5 replies)
  56. ODBC Call Failed (1 reply)
  57. query with multiple filters (3 replies)
  58. Tricky SQL Problem (4 replies)
  59. can I add more than one iff statement per field? (2 replies)
  60. querydef fields.value property returns error "invalid operation" (1 reply)
  61. Update Table based Query help (1 reply)
  62. Query for - no empty fields (3 replies)
  63. Update query to fill in table holes (7 replies)
  64. Number of records in a query (1 reply)
  65. Help with update query... (1 reply)
  66. Query for Spreadsheet (0 replies)
  67. Changing row data to column data with queries (3 replies)
  68. Complex criteria (1 reply)
  69. Querying on date range (7 replies)
  70. Query Problem? (2 replies)
  71. simpleton here (3 replies)
  72. Count criteria (1 reply)
  73. stoping system halting on errors (5 replies)
  74. Remove prompt on delete (5 replies)
  75. Newby Query question (8 replies)
  76. Convert function in SQL Server used in VBA (7 replies)
  77. Query Help (3 replies)
  78. Query by Form help - need simple solution (20 replies)
  79. Select query is not returning correct results (1 reply)
  80. Date on Query (18 replies)
  81. query on a many-to-one relationship (3 replies)
  82. Delete query (3 replies)
  83. qry too slow (5 replies)
  84. problems with distinct (1 reply)
  85. Filecode generation / manipulation, too much for me! (2 replies)
  86. OLE Error when using FlexGrid control (0 replies)
  87. Problem with retrieving value from form to query (1 reply)
  88. Problems with Recordset (3 replies)
  89. Count Query (1 reply)
  90. Calculate a Field from a Subquery? At most one record error (1 reply)
  91. How can I accomplish a conditional or multiple join? (1 reply)
  92. Adding New Records (0 replies)
  93. finding matching records and updating a field (3 replies)
  94. Character checking (4 replies)
  95. An Auto Lookup Query (1 reply)
  96. Side By Side Query (2 replies)
  97. Filtering by two criteria (1 reply)
  98. return a range of resultes (4 replies)
  99. Resetting primary keys to 1 (6 replies)
  100. Between Date Query (3 replies)
  101. Need to delete record out of one and table and append to another (2 replies)
  102. Select T/F in 2 of 3 fields (1 reply)
  103. Query quandry.... (13 replies)
  104. Find and Replace (4 replies)
  105. Tried "not in" but may need a "on change" (3 replies)
  106. Insert statement (7 replies)
  107. Scanning using Kodak Image Controls - SetScanCapability (10 replies)
  108. Week ending Date (9 replies)
  109. Select Query (35 replies)
  110. Help with query result (excluding data) (3 replies)
  111. A question concerning Make table queries (2 replies)
  112. Grouping Query fields (3 replies)
  113. month name (1 reply)
  114. Totals Query Question (7 replies)
  115. Help with Query (1 reply)
  116. Yes/No checkbox in a query (7 replies)
  117. Wildcards and Parameter Queries (3 replies)
  118. Current Week and Current Month command (1 reply)
  119. Parse Names (17 replies)
  120. Help with IFF statement (5 replies)
  121. Help with union query (3 replies)
  122. Outer Join with 3 tables (12 replies)
  123. Not displaying a field in a Query (3 replies)
  124. Deleting Results of Unmatched Queries (3 replies)
  125. Sorting by time when the day turn over is a factor (1 reply)
  126. Counting how many times a field value appears (5 replies)
  127. Why does a "DoCmd.OpenReport" print?? (5 replies)
  128. Touble with Crosstab Query (3 replies)
  129. Can a report include a button to create word document?? (3 replies)
  130. Handling a table with a field left blank (3 replies)
  131. Creating Searches (3 replies)
  132. Calculating N/A in a field (4 replies)
  133. How do you pass a global variable to query criteria? (1 reply)
  134. Cannot Update Identity Column (6 replies)
  135. Listing Years Between Two Dates (5 replies)
  136. Adding an number (2 replies)
  137. First Letter Upper Case (4 replies)
  138. Query 2 hours old (5 replies)
  139. Limit Recordset to Current Form (3 replies)
  140. Dynamic query sorting (5 replies)
  141. filtering query doing weird things (2 replies)
  142. Three-level optional join? (7 replies)
  143. Parameter query question (1 reply)
  144. Query about Weeks in a year (12 replies)
  145. Complicated IF statement (4 replies)
  146. Select a range (2 replies)
  147. Export an Access Query to a Specfic Excel Templae (1 reply)
  148. Finding Matching Person in a table (2 replies)
  149. Weekly Running Report (6 replies)
  150. Pointing queries to tables in a different .mdb file (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.