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. Combine records (8 replies)
  2. Rounding to two decimals (5 replies)
  3. Matching two values in the same query (3 replies)
  4. +/- variable (5 replies)
  5. Joining two numbers (2 replies)
  6. Combine Multiple Records from into One Field (9 replies)
  7. InStr (3 replies)
  8. Date Format (1 reply)
  9. ranking multiple sets of data within a table (0 replies)
  10. Nested Top N query - is there a better approach?? (14 replies)
  11. Distinct Criteria in Query (1 reply)
  12. Finding similar records between two tables (5 replies)
  13. Using 2 queries from within VBA (9 replies)
  14. Preview Append Query (5 replies)
  15. Make a Query Updatable (11 replies)
  16. Select Query (1 reply)
  17. INSERT INTO truncates variable field value (5 replies)
  18. Query Locked up (6 replies)
  19. Pull Information based on ID number (4 replies)
  20. TOP 50 Records and Grouping (3 replies)
  21. Referencing Cross-tabulated Field Names (2 replies)
  22. SQL query to fix error 'You cannot add or change a record becaus (9 replies)
  23. Can I choose Tables that I want to compare (12 replies)
  24. Get more out of crosstab? (2 replies)
  25. Update query help (1 reply)
  26. Crosstab query with IIF ? (0 replies)
  27. Query Design Help (5 replies)
  28. Duplicate entries, NO Primary Key. (4 replies)
  29. Lookup Box (2 replies)
  30. Query to perform csubtraction calculation on consecutive records (1 reply)
  31. Using Array Data (1 reply)
  32. remove empty space from postal code (4 replies)
  33. Update Table (1 reply)
  34. Form built from Query (1 reply)
  35. Parse Field Via Query (2 replies)
  36. Keeps jumping to top of page (39 replies)
  37. Query to return found or not found result (4 replies)
  38. How to do a query/consecutive sort of numbers in a text field? (4 replies)
  39. Last 4 recent dates (10 replies)
  40. CREATE TABLE syntax question (3 replies)
  41. Usint the trim function in a query? (2 replies)
  42. Need to remove apostrophe's in data (6 replies)
  43. Help with semi-complex query (1 reply)
  44. Beginning of next month (14 replies)
  45. Searching for parital fields (4 replies)
  46. Upper case/lower case conversion (1 reply)
  47. results from cbo box (3 replies)
  48. Parse a string which has years, months and days in it. (7 replies)
  49. Counting multiple records as one (4 replies)
  50. Append duplicates to temp table based on lastname, firstname, an (14 replies)
  51. Grouping/appending based on time ranges (3 replies)
  52. Append/Delete Query (20 replies)
  53. Removing criteria expression (1 reply)
  54. Export Months Between Two Dates Into A Table (1 reply)
  55. update a field using a index command (6 replies)
  56. Is my access unable to cope or something wrong (15 replies)
  57. Append query, Store excel sheet names? (2 replies)
  58. many to many relationship and query problem (1 reply)
  59. Query On Date (3 replies)
  60. Simple Append Query (8 replies)
  61. Subquery (6 replies)
  62. simple filter? (3 replies)
  63. Preventing a null (6 replies)
  64. Marking records for further action (14 replies)
  65. Delete records using a join for WHERE... Error about which tabl (28 replies)
  66. Referring to subform in Query (3 replies)
  67. How to remove blank records in database using a query (9 replies)
  68. QBE Query FOR SELECT DISTINCT (1 reply)
  69. Return Null Values as zero (1 reply)
  70. functions in queries (3 replies)
  71. Append query problem (2 replies)
  72. Summing a Record (5 replies)
  73. Conceptual problem: cannot create proper query design (4 replies)
  74. Send Individual Emails based on Query (3 replies)
  75. Add autonumber to query results. (4 replies)
  76. If Criteria contained in 1 of three fields, return "YES"? (6 replies)
  77. Return a Value for Null Text Field (14 replies)
  78. Numbering results in a query (3 replies)
  79. lookup query problem (3 replies)
  80. Count in Total Queries... too many records (12 replies)
  81. Join using MID function is REALLY slow (10 replies)
  82. Select query (0 replies)
  83. Creating a lookup wizard in a query (1 reply)
  84. Keep Getting either Runtime Error 3061 (4 replies)
  85. days of the week Sort By Query (10 replies)
  86. Make Table Query Question (4 replies)
  87. Simple Query Question - Drawing a Blank (20 replies)
  88. Assign "ID" numbers in query to select groups (8 replies)
  89. ORDER BY SQL (11 replies)
  90. Want to add a field to my select query Name='Bob' (3 replies)
  91. custom error message for queries with no results (1 reply)
  92. don't show commas when concatenating null fields (5 replies)
  93. Find Unique Products to Specific Build ID's (5 replies)
  94. DLOOKUP in a control on a form (3 replies)
  95. Query Help (5 replies)
  96. Creating a query using date & time data imported from Excel (4 replies)
  97. Customer Query (7 replies)
  98. update query giving lock violation error (4 replies)
  99. Join on a numeric field but FieldA = FieldB+1 (3 replies)
  100. Append query demands the smart and wise from the forum – attache (33 replies)
  101. Combine running total queires (13 replies)
  102. Criteria In A Query From a Form Combo Box (4 replies)
  103. Need to add a number field to the month in a date (1 reply)
  104. Help With IIF Statement (5 replies)
  105. APPEND QUERY using a intermediary table for mapping (9 replies)
  106. Need to Read from Excel While it's Open (for edit) by Another Us (0 replies)
  107. show categories with no data (3 replies)
  108. Query for further levels (6 replies)
  109. Adding a Record, but the Information Comes From All Over... (4 replies)
  110. Query to pull records with the latest date (3 replies)
  111. Converting multiple text fields in a query (41 replies)
  112. Time taken to do something...? (4 replies)
  113. Invoice Warning (4 replies)
  114. Re: Pulling out records with the latest date for each person (1 reply)
  115. Using queries to create a cumulative sum (2 replies)
  116. Help in link table (11 replies)
  117. Time problem (10 replies)
  118. Append Query with mixture of table fields and constants (5 replies)
  119. Delete Query Issues (5 replies)
  120. Query to add multiple records (16 replies)
  121. UPDATE SQL query (3 replies)
  122. Access Query not working with SQL Code (31 replies)
  123. INSTR Function (9 replies)
  124. Query Help (6 replies)
  125. DoCmd.OutputTo- export UDF with parameters in ADP (1 reply)
  126. Update Query Problem (5 replies)
  127. Timecard (9 replies)
  128. Can't change data in query results--workaround? (3 replies)
  129. Insert Into Syntax : can I use SET or =? (23 replies)
  130. Revenue calculation Query (4 replies)
  131. IIf statement in Access query- flip YES to NO and NO to YES (17 replies)
  132. Design vs. SQL vs. VBA Query (5 replies)
  133. quering 2 tables. (15 replies)
  134. Time stamping (6 replies)
  135. Revise Query to return list of items not selected. (8 replies)
  136. Multiple Criteria (Use certain criteria and ignore others based (5 replies)
  137. Query to check if data is uppercase (5 replies)
  138. Eliminate nags from SQL Statement (10 replies)
  139. Populating List Boxes (5 replies)
  140. Group by week, showing the first date of the week? (5 replies)
  141. Combining single column for many tables (3 replies)
  142. Access query: Can I extract/view the SQL in a stored query via (5 replies)
  143. What to do when a field is both NULL and ZLS (16 replies)
  144. Query Function (5 replies)
  145. Nested Query (3 replies)
  146. Getting the right data from a query and displaying it (3 replies)
  147. Removing special characters, i.e. %@*/ (7 replies)
  148. max as criterium (3 replies)
  149. Append Query (11 replies)
  150. Group by week Query (17 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.