View Full Version : Queries



  1. Edit a query in SQL view to perform multiple actions
  2. Confusing query-type help
  3. querying from tables without same fields
  4. Most Recent Entry
  5. Adding wildcard character to query criteria
  6. IIF - help in query & labels
  7. Join Question
  8. Search for a number not a text, SQL
  9. noob need help, comparing 2 records from same field
  10. DLookup Previous Date
  11. Append query - appending multiple tables quickly
  12. Collect information a year back
  13. WHY am I getting this error? (Date function)
  14. Mail Merge Current Record Only
  15. Update/Append Query
  16. Construci '....LIKE.....' Error !!!!
  17. A REALLY hard Query Question
  18. Creating a query to write a value
  19. Is this possible?
  20. IIF statement is acting up in a query
  21. Change Top N based on table
  22. Weighted Averages In a query
  23. CrossTab help
  24. Possible? Query column and order by frequency
  25. merge fields into one field
  26. Show item with last updated price by date
  27. Show only one occurance of data in a field
  28. Passing Multi parameter values to a query
  29. Help With SQL
  30. number of people within age renge?
  31. How to delete multiple records
  32. INSERT INTO problem
  33. how to get year and month value from date field
  34. Delete Records Based On Date Criteria
  35. Problem with Top Value
  36. Update Query will not Update!
  37. too many results from one table and other problems
  38. Question on parameter query?
  39. Query help
  40. Wierd Date Between Query
  41. calculated expression
  42. Drop down menu queries
  43. Rejoining queries in one query
  44. Wildcard Entry
  45. plz help me
  46. plz help me
  47. Relationships with multiple tables
  48. How to use Query to remove info
  49. Using a query to extract email addresses
  50. Date & Time difference & calculations
  51. Wildcard Queries
  52. Combo-box Query Problems
  53. Query Weeks Over Multiple Years
  54. Question about counting records with query
  55. Minimum values in a query
  56. Help Please
  57. ListBox parameters problem
  58. ListBox parameters problem
  59. ListBox parameters problem
  60. ListBox parameters problem
  61. Query Based on 2 out of 4 criteria?
  62. Return New Record Id
  63. Append records where non exist
  64. Update Query Help Please
  65. Recordset not updateable
  66. Problems with duplicate matches in my queries
  67. Date query not working
  68. summing query.
  69. query many database
  70. query many database
  71. Let the user enter the field they wish to see
  72. Compare Query
  73. Running sum query syntax problem
  74. Time Issue
  75. Parameter Query with Mail Merge
  76. Enter a parmeter value intermittent
  77. Top 10 Query
  78. Trying to populate a listbox from a query
  79. Expression? Return 1 of many
  80. Parsing the left and right characters of a string
  81. SQL Query Help
  82. SQL Query Help
  83. update query and autonumber
  84. Get previous field value in a query without a form
  85. Only include fields with value 'YES'
  86. Create query with checkbox in result
  87. Query two fields based on one criteria
  88. Proble with Joining Tables
  89. Date range criteria...
  90. Data Validation Query
  91. Display rows with no data
  92. Inquiry of a Query
  93. Delete query
  94. Need Query Assistance
  95. How to ?
  96. Show record
  97. I want to see null values......
  98. Current
  99. Multiple Querries In One
  100. query problem
  101. last order date of 2004
  102. Date Ranges in Reports or Queries???
  103. Division by Zero?
  104. could someone tell me where i went wrong
  105. To Add Yes/No Field using SQL
  106. Need another Query
  107. How to create a totalling query ?
  108. Due Date Query
  109. Multi combo box query
  110. Joining strings
  111. Parameter query - Using Choose function
  112. Swop fields and records in a totals query
  113. Odd Queries
  114. Not getting entire data from memo field on query
  115. Quering based on distinct values
  116. Help with Query Criteria
  117. scenerio anlysis - basd on user dates
  118. trimming query return value
  119. Totals by person
  120. Changing the criteria on a query via a Form
  121. Compare data in two tables, with multiple conditions…..
  122. (query) move old members to another table
  123. code problem
  124. Query Criteria Help
  125. Merging Queries
  126. date recode
  127. Overall totals in a crosstab query
  128. Query is missing out memo fields with more than 255 characters (Variation on a known
  129. Real Simple: add together 2 numbers in query?
  130. Sum Queries and Storing Calculated Fields
  131. Running more than one sql update query
  132. Insert is binge called updateable nature?
  133. Another date Querie
  134. Help again with custom query
  135. Help With DB
  136. Need Querry to show records that are 3 months old
  137. help with (IIF) in criteria
  138. Query help needed
  139. Decile values query
  140. Syntax confusion
  141. How to identify the repeat data?
  142. Dynamic Query Based on anthoer crosstab
  143. Convert results to percentage
  144. Aggregate Functions in Where Clause
  145. can commenting be done in access queries
  146. UPDATEing null dates
  147. *User Notification Message*
  148. Need field to add up how many times another field is changed
  149. Where to put the brackets?
  150. Help with query: FROM Table1 WHERE Table2.Column1
  151. greater than 1 record, less than another
  152. How to create a field showing numerical position within a table
  153. query results in form, but what if query is null?
  154. Query output to Excel not working
  155. crazy thing
  156. Query Returns No Records
  157. query/filter records
  158. What am I doing wrong??-Datediff
  159. count issues
  160. Assets database query
  161. Count or Sum function in query
  162. query
  163. Parameter Query
  164. display a list of the most recent records
  165. Query to look at the 3rd letter in a field
  166. How to delete duplicate record in query?
  167. How to remove the primary key?
  168. limit records
  169. Data type conversion failure
  170. select range of records
  171. Limit query by part of a field
  172. Help!
  173. Between
  174. Query dislpay only certain conditions
  175. IIF Statement
  176. How to format a field in the select statement?
  177. How to put the value into different column?
  178. Can add the left join in Cross tab query?
  179. whats wrong with this sql statement?
  180. Order 2 different fields in query by number
  181. Query to act like a pivot table???
  182. A way to delete a field in a table safely
  183. Parameter Query Help
  184. Filter date field
  185. Query the occurrence of a particular absent reason in past 12 months?
  186. Having a hard time with LIKE operator
  187. Query Search for an exact value in an exact location
  188. output format of date/time
  189. DLOOKUP Type Conversion Failure
  190. Function is not available
  191. A Little Help Please
  192. Unmatched Query
  193. Complex Queries (Append/Update/Delete?)
  194. Adding single record
  195. Finding specific fields in a record (sorry, newbie!)
  196. Common Data
  197. Multiply Queries
  198. Drop down menu query problem
  199. Using Field ID to access the data in the field.
  200. How to select a single row multiple or certain time
  201. Book catalogue queiry problem
  202. Conversion / Format help
  203. This shouldnt be hard.
  204. how to create conditional statement
  205. Max Date in two fields
  206. Eliminating Duplicate on a Query
  207. odd- year() stuck in 2000 and 1900
  208. Using a Checkbox In A Query
  209. Query for Bar Chart report
  210. How to select part of a field
  211. SQL query, count and group
  212. Query Criteria
  213. Matching Data Help!!!!
  214. Multiple selects in an Access Passthru query
  215. 90 Days, but not current month
  216. Query help needed,will pay for services.
  217. Calculations in a query
  218. Operators in IIF Statements
  219. Expression Problem
  220. query returns zero rows and count errors
  221. Query only latest info
  222. QUERY IIf statements in criteria
  223. Trying to create a status Query
  224. Unmatching Query
  225. Query record set greater than null???
  226. Query - weird decimals return
  227. calculation in a query
  228. query result into a TextBox object
  229. how to insert a value in a foreignkey?
  230. Return Earliest Date
  231. left three characters from string using query
  232. Conditional formatting
  233. Query difference in Time from Multiple Records
  234. Incorrect Information
  235. combining values
  236. strange JOIN and strange realtion of tables
  237. Query not picking up current record
  238. Nested If (I think)
  239. Query Date and Hours Fields
  240. Problem converting date stored as text to data/time format
  241. Syntax Problem and a Question on SQL
  242. Can't Save Printer Settings
  243. multiple keywords
  244. sale + commission query + subform
  245. Criteria help needed
  246. Help needed with this simple query
  247. How to make a row with totals in a query
  248. help with a querie
  249. Syntax Error
  250. Track missing records