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. weekday query (3 replies)
  2. IIF(IsNUll....Still getting errors (7 replies)
  3. Can someone please explain this odd Access SQL syntax? (14 replies)
  4. Poplulate multiselecttextbox with listbox column values (4 replies)
  5. Running queries (4 replies)
  6. Data type mismatch (14 replies)
  7. Nested IIf Statements (7 replies)
  8. How to select from a list or show all (14 replies)
  9. Left Join + count (4 replies)
  10. One query different form controls as criteria (8 replies)
  11. Lookup field based of query (13 replies)
  12. parameter symbols (1 reply)
  13. Between Month question (4 replies)
  14. Combining records, looking for a method (3 replies)
  15. Delete and Update Queries (9 replies)
  16. Multiple parameters within stLinkCriteria (3 replies)
  17. Calculate 4 sickness occaisions in under one year (11 replies)
  18. Find MAX of Column and include additional record information (5 replies)
  19. Beginner Question: Building a Query (6 replies)
  20. Total Query (2 replies)
  21. Update one table with values from another in design view (1 reply)
  22. Getting a count of unique records between two dates (2 replies)
  23. Query criteria conditional on form opened (9 replies)
  24. Pass variable to a query (8 replies)
  25. Using AND / OR properly (3 replies)
  26. Access Query (4 replies)
  27. Create a new table with contents of duplicate records from anoth (5 replies)
  28. creating a sequence (7 replies)
  29. Calcuate Moving Total and Store Max Value (2 replies)
  30. displaying combo box output in a query expression (7 replies)
  31. Data from 5 tables (5 replies)
  32. Need a Specific Char Length with Spaces (7 replies)
  33. Delete Query (3 replies)
  34. Moving Multiple Columns Data into One Column? (8 replies)
  35. "Multiple Fields" Sorting Criteria Problem in My Query (5 replies)
  36. Query won't run a parameter form (15 replies)
  37. Closed to Closed date (9 replies)
  38. Sub-query for report (7 replies)
  39. Not picking up Nulls in a query (5 replies)
  40. Using VBA to extract and store Access query properties (12 replies)
  41. append query duplicate records (3 replies)
  42. Round to next whole number (9 replies)
  43. Parsing table rows and making tables (2 replies)
  44. Need to rewrite a query for Access 2007 (3 replies)
  45. Percentage on each line (3 replies)
  46. Manipulating a date (4 replies)
  47. Unhiding a query (2 replies)
  48. Simple Cross tab question (3 replies)
  49. query totals (1 reply)
  50. date- greater than 24 hours query (13 replies)
  51. Is this efficient/optimized query? (3 replies)
  52. INSERT INTO... WHERE - Form List Box Problem (7 replies)
  53. Lookup / join to specific point in field (4 replies)
  54. Sorting Roman Numerals/Query (2 replies)
  55. Help with sorting a query (3 replies)
  56. SQL problem from [censored] (1 reply)
  57. Maybe IIf, I don't know!!!! (8 replies)
  58. Count records in query (7 replies)
  59. Pass-through Query - Adding/Editing Data (3 replies)
  60. Help w/ date range in query. (1 reply)
  61. sequential grouping (12 replies)
  62. Set a filter for a query based on another query's results. (5 replies)
  63. What is wrong with this union query (3 replies)
  64. Update Query (1 reply)
  65. Relating a Union Query ID field to source tables (17 replies)
  66. saving data from a form query to another table (1 reply)
  67. People query (1 reply)
  68. Dates (11 replies)
  69. returning values that are similar but not equal (3 replies)
  70. Addin a record count on every line to get a percentage. (3 replies)
  71. Grouping Totals (2 replies)
  72. Inherited DB Issues (6 replies)
  73. IIF clause (1 reply)
  74. Calculate how long a Query will take Access2003 (4 replies)
  75. Picking the lowest number in a list of dupes (3 replies)
  76. Calculating fees returns an error (1 reply)
  77. Editing table data with a query (2 replies)
  78. Confusing Parameter Passing (from query to query)... (8 replies)
  79. Date formatting (3 replies)
  80. Pass-thru query and Excel: exporting to (3 replies)
  81. Parameter query with combo box not working (3 replies)
  82. Adding Blank Records (3 replies)
  83. Query to highlight items with more than 2 decimal places (14 replies)
  84. how to use SQL in Dlookup (6 replies)
  85. nasty crosstab query (10 replies)
  86. Getting the Previous Records Value (12 replies)
  87. how to order by text, which has number(want to put L11 behind L2 (5 replies)
  88. MSA 2007 - Top X Records per ID? (5 replies)
  89. Problems with Left And Mid functions (1 reply)
  90. Set a Value List from code (3 replies)
  91. Update query with very specific criteria (2 replies)
  92. have a problem with subform (10 replies)
  93. Help with IIF function (5 replies)
  94. Trying to pull data from form control into query as criteria (4 replies)
  95. Group by Month (4 replies)
  96. quantity for identicalitems (5 replies)
  97. Update query with subquery giving me trouble (8 replies)
  98. Action query warnings (3 replies)
  99. Find second to last order (2 replies)
  100. Totals Query: Trouble with Duplicate/Many-to-One Data (3 replies)
  101. I'd like to create one crosstab query with the query result ,but (2 replies)
  102. multiple keyword search (10 replies)
  103. Listing number of duplicate records (1 reply)
  104. Update query (9 replies)
  105. Strip formatting characters from a memo field (3 replies)
  106. Union Query Producing Garbage Characters in Numeric Field (4 replies)
  107. Query with popup calendar (5 replies)
  108. need to execute criteria condition in a query (3 replies)
  109. Variant variable in SQL Where clause (3 replies)
  110. Output (14 replies)
  111. Getting Max Date from a query (5 replies)
  112. Export Query (3 replies)
  113. Another append question (1 reply)
  114. Sum Query to display totals (12 replies)
  115. Need some help (10 replies)
  116. Query Expression Issue (5 replies)
  117. Rank by velocity and percentage function (1 reply)
  118. How do i make a query to work out the number of days in a year a (4 replies)
  119. Dropdown list in a query? (23 replies)
  120. FirstName] & " " & [LastName] & ", " & [Title] (4 replies)
  121. Can an integer variable be used as query criteria? (7 replies)
  122. Count unique results (12 replies)
  123. matching set of roes within a table within a given set of date (27 replies)
  124. Conditional Formating (4 replies)
  125. Problems with iif statement (11 replies)
  126. Minus Signs instead of Yes/No in a List Box display (2 replies)
  127. Passing value from a query to a vb variable (3 replies)
  128. Query ; where orderdate=determineday() (10 replies)
  129. Trying to filter a query using a global variable (15 replies)
  130. Remove Decimal but leave number (4 replies)
  131. May I change data in MSysObjects? (4 replies)
  132. Append Query that Prompts for Table to Append to? (1 reply)
  133. How to create an SQL function to return a field (10 replies)
  134. Query with criteria summing results but outputting detail (4 replies)
  135. Query Locks Up (3 replies)
  136. Query by date range (1 reply)
  137. Building an Expression using Sums in same query (8 replies)
  138. Rounding question (13 replies)
  139. query not working (3 replies)
  140. dcount query (4 replies)
  141. Calculating a date from generic criteria (6 replies)
  142. How to exclude records w/ a specific field filled? (21 replies)
  143. How do I pass field names to the Select side of a Query? (11 replies)
  144. Assign Field Name from a Form to a Query (1 reply)
  145. Strip ending "00" a number (10 replies)
  146. INSERT INTO queries in sequence (2 replies)
  147. Query based on date parameter (1 reply)
  148. Create a parameter query (3 replies)
  149. aaaa ; bbbbbbbb ; cccccccc ~ Can I break it up? (3 replies)
  150. Filter only upper case words (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.