View Full Version : Queries



  1. Troubles with aggregate functions in queries and null values
  2. Any error with this syntax?
  3. *** HELP *** Query Generator.
  4. bodged query - better way
  5. Multiple queries on memo field
  6. ODBC Query
  7. This should be simple ...
  8. Is doing this even possible
  9. ODBC connectivity with Linked table
  10. putting all emailaddresses in one string
  11. Top 10 within a few groups
  12. Recommend a good SQL Book.
  13. Find Matched Records
  14. Query duplicate question
  15. Number of days between last pay and today
  16. Delete query lockup
  17. Selecting data and incrementing using DMax
  18. automatic completion
  19. Update the second table based in first table???
  20. Writing out all records from and to date
  21. update table?????
  22. New Autonumber primary with existing data
  23. division by zero
  24. SELECT INTO from Oracle db?
  25. Complex Query
  26. No way to describe!
  27. Help with Max function!
  28. Query by zipcode
  29. Help with query
  30. reduce multiple records to one
  31. Select Query based on another field value
  32. Is this SQL query right?
  33. records appearing in previous queries
  34. Calculation in Query not working
  35. crosstab query help
  36. not found query
  37. Parameter Queries
  38. Macola tables in Access 2000
  39. Multiple Criteria Query Help
  40. Error 3122
  41. Upsizing Access Question
  42. update query problem
  43. query to Update data to foreign key field?
  44. UNION Query - 1st attempt
  45. Listbox of queries
  46. Fitler Problems 2
  47. Record not updated in table
  48. SELECT INTO using ODBC?
  49. Using UPDATE and WHERE to copy data from a table to another
  50. IIF Function
  51. Append Query help
  52. Creating a formula in a query
  53. First Record Function
  54. Criteria syntax problem
  55. execute query
  56. Creating a new field
  57. Refreshing ODBC
  58. Executing Stored Queries from VB.NET
  59. Not working the combo box from query
  60. Index and query relation?
  61. [Ask] SQL to produce this result
  62. Access Database as source for Mail Merge
  63. Using IIF function in query?
  64. IIF/IFelse and Dates?
  65. Expression for data not to show if same
  66. Creating Field names from the data within
  67. Simple query question: setting a field to a set value
  68. Count/SUM Distinct Help
  69. Count dates from two different Tables
  70. Subtracting 2 dates and 2 times from seperate boxes
  71. Query not returning all results
  72. Total query with yes/no and date fields
  73. Search Alphabetically
  74. Adding Based on Value
  75. queries in forms
  76. Sum up the values calculated.
  77. Query with Replication ID Parameter
  78. Query for duplicate records
  79. Ignoring leading zeros in join query
  80. Table Query Help
  81. Duplicate field help please!
  82. Selecting records based on multiple criteria
  83. Opening the current database
  84. Duration Cut off
  85. Pulling Most Recent Records for Each Company
  86. Can I add totals to a query column?
  87. Is it possible to simplify this query?
  88. multiple cases
  89. Query Expression to autofill given other criteria
  90. compare strings in SQL
  91. Query for Characters Not in "IN statement"
  92. Date
  93. need help with sql statement for a range
  94. INSERT Sql problems
  95. This should be simple (marge 2 queries)
  96. basic update query
  97. Qry Nested If's and date formats
  98. Sum duplicate data
  99. Select only last entered records
  100. Undefined function 'replace' in expression
  101. Selecting equal amount of records
  102. Search
  103. using a function in a query for if/then/else
  104. Update Query based on length of value in field
  105. Wildcard query with User Input Parameter Not Working
  106. searching with a like clause
  107. Limiting records retrieved to 10... with a catch.
  108. crosstab issue
  109. Error: DoCmd.RunSQL
  110. CAST and CONVERT
  111. Count by Group
  112. DISTINCT Question
  113. between querie
  114. null values
  115. Query Accross Multiple Tables
  116. Date and Time Format Calculation
  117. Query /Filter Show X months worth of records
  118. Sums and Null Value Help Please
  119. What is wrong with this SQL?
  120. Pass-Through Query Help
  121. combining two query's
  122. Select top X amount criteria.
  123. Pulling specific data for specific date range
  124. Sum Two Columns With Query
  125. Collate Field Content from multiple records
  126. entering data through a query combo
  127. SURVEY database - problem on "survey questions"
  128. DateDiff
  129. Combining multiple tables with multiple records
  130. Multiple Start and Ending Dates
  131. help with query - employee heirarchy
  132. update queries
  133. selecting based on a text field and most recent date
  134. Append query Help!
  135. How to select the maximum value
  136. Using SUM in Access
  137. Create a table from 3 other tables
  138. help with aggregate query
  139. Check if in a table
  140. Returning Value of "score" if field is numeric
  141. Help with DSum
  142. using expressions as criteria
  143. Summing two fields in a query
  144. How do I get out part of a date in a query??
  145. Concat two int columns into one
  146. Date range in crosstab query
  147. Change Check Box Value Query
  148. Combining two cells
  149. Order By Clause not being following
  150. Exp^x
  151. Query Question
  152. Combo Box items in a Lookup Query
  153. Finding records with empty field
  154. Query criteria cannot reference subform
  155. How to run query Q1
  156. Access Critereia Query - with blank fields and search parameters
  157. How to change row in query
  158. Returning 0 values
  159. Recording date that a record has been appended and deleted
  160. Query Help
  161. Losing Records in a Query
  162. Partial Text Compare Across Two Tables
  163. Problem with Criteria in Queries using Combo Boxes
  164. Append Query Pass ID Format and Data
  165. Connecting Queries
  166. This question actually goes in two threads.....
  167. Query results?
  168. List box problem (query rowsource)
  169. Grouping by month & year
  170. Update query help please?
  171. Is Null / Not Null
  172. Query Criteria Crisis--this sucks
  173. Query taken away "-"
  174. nested queries and forms
  175. Running Totals
  176. Really Basic Question
  177. Joining two fields by backslash
  178. Switch function problem
  179. Dcount
  180. update query problem
  181. Crosschecking/Comparing two tables
  182. Cancel Query / error trapping
  183. What is wrong with this query
  184. Query is too complex
  185. Searching for name among table fields
  186. only last 100
  187. Datevalue
  188. Find records with a duplicate field entry
  189. Query Challenge
  190. Query by Multiple Selection List Box
  191. Query PROBLEMS
  192. Multiple joins
  193. Help with Update query
  194. Ordering Dates
  195. Just need year from date
  196. Append Query Field Name Problem
  197. Using same date range on report for multiple queries
  198. Date minus 1 year
  199. Evaluating query results and setting a value
  200. Less time consuming Query (A toughie)
  201. Date check help please.
  202. Empty crosstab colums killing Access 2007
  203. Updating a query
  204. Updating a query, when still in the form
  205. Queries Read Only?
  206. Ransom Selection of Records
  207. Can this be done with a query?
  208. Query Start and End Dates
  209. Multiple query errors
  210. error but cannot view query
  211. Date Full Day Query
  212. How to use an append query to update a table?
  213. Deleting One Table from Another
  214. Sorry newbie question
  215. Need solution for calculations
  216. Append / Delete Query
  217. Show bookings staying today from Checkin & CheckOut dates
  218. Concatenation Frustration!
  219. Help Required Urgently
  220. using wildcards with a combo box
  221. Query by Combobox
  222. How Can a create a monthly query ?
  223. Help with IIF in Query
  224. use search qry result for something else
  225. Getting only the last
  226. Getting only the last date per record in a primary table
  227. Simple Count Question
  228. Count statistics of db
  229. Totals
  230. Query for name total.
  231. Table update
  232. When query returns no records in set
  233. Count up check boxes
  234. Inverse query?
  235. showing 0 if no results
  236. Inner Join Results from nested query.
  237. Help with Query and dates
  238. How to change criteria not in design view
  239. return all records if combo box is null
  240. Help Pls! Calculated Grouped Querry
  241. data type problem
  242. Append Query Problem, wont add entries
  243. Why wont this work
  244. Subtract Query?
  245. Removing text labels
  246. Duplicate Entries and queries?
  247. Criteria input format
  248. Need help designing a query...not sure if this is possible.
  249. Query help, Calculating multiple Fields.
  250. Problems with "or"