View Full Version : Queries



  1. Greater Than ... Less Than .... 2 Fields
  2. Noob needs help
  3. Select query showing too many records
  4. Query Count between two dates
  5. help me design this query!!
  6. problem in my query
  7. Update Query Problems
  8. Parameter + Update question
  9. More efficient query design..
  10. Problem with Query Report
  11. Query Circular Error?
  12. join properties cause type mismatch
  13. Append query with check boxes
  14. Between Dates Joins
  15. How do I start thinking about this multiple criteria query?
  16. query problem (missing operator)
  17. Null acceptance issues
  18. turnaround time for different records and different fields
  19. Joining only for 1 record...
  20. Crosstab query
  21. Begginer needs help
  22. Addition within a query
  23. Date Query (last week, last 2 weeks, last month, last year, all)
  24. Grouping query results
  25. Adding 0 infront of a Number
  26. Find records that are present in one table, but are not present in other tables.
  27. Compare 2 tables
  28. If statement
  29. sum per day between 2 dates
  30. ODBC Call Failed
  31. Date Diff [DATE] & Now
  32. Help overcoming NULL in a query
  33. #Error - How do I turn into a zero?
  34. Query on multiple tables
  35. Converting Data Type in a Query
  36. parameter query
  37. Enter Parameter Value
  38. how to choose field based on criteria
  39. Problem with Updateable Query
  40. ORACLE PROBLEM - Linked Tabled-Update Query
  41. Comparing Similar columns in multiple tables.
  42. query problem
  43. Filter Query with more than 1 variable problem
  44. Queries and multiple criteria
  45. Count the Distinct items
  46. Counting Distinct Valve in a row
  47. advice - query?
  48. General question - uneditable query results
  49. Type mismatch in query
  50. Current number
  51. Passing Parameters From Excel To An Access Query
  52. Multiple calculations in a single query
  53. how to make separate lines for checkboxes
  54. transform table from horizontal to vertical
  55. like [date]?
  56. Find Duplicates that don't match single field
  57. Help please with multiple outer joins to return all records from main table
  58. Not Exists Query Not Working
  59. Query problem with COUNT
  60. Merge Similar Tables
  61. From report control stmts to query
  62. query criteria question
  63. Help!!
  64. Error from simple statement
  65. query for various spelling possibilities
  66. Eliminate Duplicate Records in a Query
  67. Combining fields from multiple rows into one row & field
  68. Error when running append query.
  69. How to calculate field in query
  70. how do i run a query to find duplicates??
  71. Between? <=? >=? Dates? I'm Confused!!!
  72. Joining query question
  73. append query help
  74. Sum
  75. Excluding deleted records from an imported table
  76. Annoying popup messages
  77. Can i dynamically choose which fields are being selected in a query?
  78. Multiple IF statement
  79. Problem Query
  80. Strings within strings using expression builder
  81. Running a Query on the check boxes
  82. Update UnitsInStock
  83. Sort a query based on a table
  84. query on summation
  85. Parameter keeps popping up in design view
  86. Totals Query Help
  87. Query Averaging Help Needed
  88. Crosstab and Calc Time Difference
  89. How do I show convert vertical entries to show horizontally
  90. Combo box tomfoolery
  91. Query by Date behaving strangely!!
  92. IIf statement problems, problems
  93. Problem with ComboBox selection to drive query criteria.
  94. blanks spots
  95. Query Question
  96. Key violations in query
  97. multiple criteria off a listbox
  98. Duplicates - PLEASE HELP
  99. Split Data in to different cells
  100. nested IIF
  101. Too few parameters. Expected 1.
  102. How to show only the Current forms details!!
  103. Splitting data HELP
  104. Displaying QBF in a form
  105. date problem
  106. how to set query on the current record
  107. Making data in a field a certain lenght
  108. Doing 2 counts in one query
  109. Need Help Please
  110. Concatenate detail value in one column
  111. Query help needed please
  112. modifying an action query
  113. How to use eval() with dlookup() ?
  114. Group by - help needed
  115. count
  116. Parameter in a subquery?
  117. 30 days from current date
  118. How to use expressions with missing values
  119. multiplying fields in a Query??
  120. Update Query
  121. wats the different between . & !
  122. Need help for date related query
  123. How I can print the results of a filter into a search form?
  124. How I can take text and no number in result that arises from a combo-box into a searc
  125. stupid question
  126. Grouped Counts using Criteria
  127. Work Week Calculations
  128. Really Confused!
  129. Trouble with code in query
  130. Removing duplicates from a query on a query?
  131. Combining Data
  132. query help using a iff statement and relationships
  133. Refering to the current record in a query
  134. Help!!
  135. Updating a field with the + as part of the value
  136. Query??
  137. Select Top 2 Records
  138. Sum() in empty table doesn't return zero
  139. missing records in query
  140. Count Function
  141. Error 3258 ambiguos outer joins
  142. User entering Date Range for a query with Sum function present
  143. IIF & ISNOTNULL Problem
  144. Removing redundant rows?
  145. Allowing Duplicate Data in a Query
  146. Duplicate Query Returns
  147. IIf statement problems in query - please help!
  148. Nz or IIf(is null) to force a certain value?
  149. DLookup in a query expression
  150. Is there a way to simplify this?
  151. combo box query
  152. date sort
  153. simple question
  154. Count Occurances of a Record?
  155. Remove Duplicates
  156. Calculate future dates based on inputs
  157. Counting data from csv
  158. Counting Problem
  159. Query causes crash
  160. Append table with a varable option for out put????
  161. Help Needed Urgently ... Pls Pls Pls
  162. Erratic query behaviour?
  163. Alphabetical Order Query
  164. Query from Teradata table
  165. count/sum function
  166. Parameter Query from LookUp
  167. Problem with Filter Query
  168. Numbers Only
  169. Syntax Error From Clause
  170. Access substring or trim
  171. Using a query as a Table
  172. Query to Find Duplicates
  173. Query + Report
  174. qry to excel automation
  175. Stuck on validation problem
  176. combo box in Query
  177. Comparing two fields in a query?
  178. ID starts with ...
  179. Distinct count
  180. Query Criteria
  181. Query in subform - You cancelled the previous operation
  182. category - sum
  183. update select query
  184. Need Zeros, Too
  185. WorkUnit totals by month via Date range
  186. Date Range Query
  187. Nz
  188. Cross-tab Query
  189. Matching Fields
  190. Alternative SQL Query
  191. Stock update
  192. Export PivotTable Access to Excel
  193. Query how to show a temp address over a perm address
  194. Access 2k query problem (print last record ?)
  195. Removing Duplicate Entries from Joined Tables in CrossTab Query?
  196. Rookie questions
  197. Distinct and DistinctRow
  198. little problem
  199. pulling a Like* criteria from a table.
  200. Calculating totals
  201. Syntax Error
  202. Can you silently pass a parameter without VBA?
  203. Passing value from Form to Report
  204. How do I arrange my data column?
  205. How to calculate average time/duration
  206. How to hide a character in a field?
  207. How to obtain a table summary using QUERY function?
  208. getting grade with a query
  209. lookup
  210. Quick questions
  211. Setting a format in a field in a union query
  212. Possible to combine two queries?
  213. Group by time error
  214. Exclusion
  215. how to make a query to determine the difference in two numbers
  216. Anniversary
  217. Automated Query
  218. Replacing many iif by something better
  219. Adding 'Autonumber' to query on the fly.
  220. UnitPrice = Price1 or Price2 or Price3
  221. CAST in SQL Statement
  222. output qry
  223. division by zero error but it works when I dont have any criteria
  224. Requerying data ina subform
  225. union query problem
  226. retreive a word
  227. Missing Pane
  228. Table cannot be modified
  229. Query Criteria
  230. Group Columns under one title
  231. Append Events by Date
  232. Invalid SQL UPDATE Syntax
  233. Query to return table name as a value?
  234. Conditional Data Type
  235. add a field to count
  236. Limiting a dropdown list in a subform from within the subform
  237. Query works but with errors?
  238. Query from queries
  239. Does Anyone Know How To Do This?
  240. Date Query Help
  241. duplicate results in query
  242. Calculate # of occurrences of string in a field
  243. Copy table post and secondary table
  244. Export Pivot Table query view in Excel
  245. which is better?
  246. Forcing Null
  247. How Can I Do This
  248. Appending one record using a button
  249. SWITCH problem in time field
  250. Query with parameter?