View Full Version : Queries



  1. Please help with a union query!!!!
  2. Need to do individual count
  3. Is the criteria (in query designer) mutually independent
  4. IIF and wildcards for criteria
  5. Union Query - Data Type Mismatch?
  6. Please help me with this query
  7. Help Needed please
  8. Query returns multiple records
  9. Making lookup tables Dynamic for Queries
  10. Simple MS Access Count Query?
  11. Nz returns incorrect total where one value is null
  12. [Urgent Help] select statement with Date Field
  13. Data entry field help
  14. Spot the difference in these queries...
  15. Limiting repeats of customers name in data.
  16. Conceptual Problem I need Help With
  17. Combining non-similar records
  18. Access 2007: Historical Comments???
  19. Max Query, Why doesn't this work?
  20. Multiple field into limited number of columns
  21. how to use if statement in Access 2007
  22. Quick question - replacing references in a query
  23. Help on query
  24. Update or Append query to different DB
  25. Update Query...
  26. Another Email Question...
  27. #Error should show zero
  28. Update Query Multile FIELDS FROM EXCEL_ pls HELP
  29. Northwind - Products - Component List
  30. Totals and subtotals
  31. Transpose Columns to Rows Query
  32. Table merging via query?
  33. Operation must use an updateable query
  34. Query with Date
  35. Can you help me whit this sub query
  36. Reserve Word Hell
  37. Data mismatch error when running a query with a DISTINCT statement
  38. Calculation with query or report
  39. Collapsing multiple fields by date
  40. IIF Statement to distinguish VAT Rates
  41. In your opinion
  42. compound query to average on groups then sum the averages possible?
  43. Including text from a form in a query
  44. Am I doing this right???
  45. Simple task
  46. 2 questions on multi select list parameters
  47. Help With an expression
  48. Syntax error in select from another DB
  49. Calculate average
  50. Lookup Query? Help
  51. Convert columns/fields to rows for pie chart
  52. Unmatch query
  53. My first subquery......Help???
  54. Another double booking issue
  55. MsgBox
  56. Supplying SQL parameter in VBA
  57. Access2007 query - is it me?
  58. query help stock
  59. [criteria] will not work with text
  60. Query ID number?
  61. Union Queary with Added Column
  62. Subtract numbers from the same field
  63. vba Queries of Queries?
  64. Run and display a query in a second database
  65. Need help in simple query....!
  66. Calculates The Difference Between 2 Columns
  67. Can't quite phrase a query correctly...
  68. Top Values Query
  69. Top / Group Query
  70. Append query
  71. Can't update a field via a query
  72. Query not Exporting all Results to Excel
  73. Question regarding Conversion from SQL Server
  74. Many to Many Editable Query
  75. New to Access Queries
  76. User Input Date/Time Criteria
  77. Problem with 'LIKE' Param in VB
  78. require help with query
  79. Who can hepl me with this query?
  80. Returning Fields depending on value of other field
  81. Union query
  82. MidString Removal
  83. Tail function
  84. DLookup Date Returning #Error
  85. Multiple Criterias
  86. Query Calc on newly created fields
  87. Updatable & Append Query with Dialog Boxes
  88. Update Duplicate Records
  89. One Big Table
  90. Simple Find Duplicate Query
  91. Find and Replace
  92. Append query zero records - Access Runtime
  93. Query to search 3 seperate 'Date' fields
  94. Runing Query in another user
  95. Joining Queries
  96. Expression not working
  97. Selecting Top 10 Values
  98. Hide with Query
  99. Running Sum problem
  100. IIF query question
  101. Criteria not working?Please help!
  102. Query Array?
  103. Calculation Question
  104. Unmatched query based on two criteria
  105. yes/no options in form and query
  106. Dsumlookup
  107. Find field with highest and lowest value in a table
  108. PUtting an AND in a RIGHT OUTER JOIN
  109. Group By: Date Comparison Vs. Current Date?
  110. Memo field looks like chinese
  111. Help with access 2007 query
  112. Interesting Duplicates Issue
  113. ADO Select Into Query
  114. iif statement in query criteria
  115. Query for Same value in multiple fields
  116. Newbie with sql
  117. Query Problem
  118. MS Query window OK or Cancel
  119. query over my head (order vs in stock inventory)
  120. Using Combo Box to Query
  121. Match & Unmatch Query
  122. Find null input
  123. Reporting Field Properties from and Append Query
  124. Union Query & balance brought forward
  125. Sum of column in query
  126. Calculations with many-to-many relationship
  127. Running total issue
  128. Extracting lowest price from 31 downloaded Excel vendor price lists
  129. Catagory, Sub-Catagory, Sub-Sub-Catagory help
  130. date search
  131. DAvg(....)
  132. Query by Non-blank field
  133. Date/Time Parameter query
  134. Summary Data
  135. Link two fields of different format
  136. Need help with a query
  137. Counting
  138. QRY not reading textbox
  139. Split rows to 2 columns
  140. Histogram query
  141. Top values query
  142. Duplicate Records
  143. Subtracting two time values
  144. Newby: Data Doesn't Display When I Run a Query on Two Tables
  145. Multiple Query Criteria for same text box problem.
  146. Return value if data is between certain ranges
  147. Duplicate record warning
  148. Previous time peroid query
  149. Finding songs in a music libary that are not in any playlist
  150. counting query
  151. Updat query percenatges
  152. Find fields containing Negative Numbers
  153. ODBC Query So Slow - Why So?
  154. Add Multiple Criteria to Same field in a Query
  155. Explain SQL
  156. within the last month
  157. Concatenation Please help fast
  158. Help me in Growth rate query.. Urgent!!!
  159. How can I Link / Relate two tables using partial word match?
  160. Problem with Appending attachments to a new Table
  161. multiple starts and stops by date?? HELP!
  162. Using "" and <> in IFF() for html references
  163. Problem with query syntax
  164. how to make a query do this?
  165. Problem with date query
  166. query top 3 ID with exclusion of the last 4
  167. Searching by month
  168. Merging table with no IDs into table with IDs
  169. hi, please help!
  170. Create view
  171. How do i send query output to specific excel sheet?
  172. Filter Dates
  173. Using Same User Input Parameter Twice
  174. Hey all, Need some help!
  175. Sql
  176. SQL part 2
  177. Top values in an update query
  178. SQL Delete Query - RecordCount?
  179. Summarize TIME
  180. Query anomoly in Access-HOW TO FIX!!!
  181. Convert AutoNumber to Number
  182. Text Function
  183. Find out changed data
  184. IIF: any suggestion?
  185. Email addresses as links in Query?
  186. Not In query
  187. Find average of three fields in query
  188. Really quick question
  189. Run query to export to sequential text file
  190. Find duplicate keys in SSH data
  191. Help with Iif statement in a query
  192. appending query
  193. Query Query
  194. MAX records help
  195. Daily Volume by Queue
  196. Divide by three, no remainder
  197. Formula inputs from multiple records
  198. Date Query
  199. Assistance with writing query for MS Access DB
  200. passing DATE to Where Clause
  201. Dates
  202. Counting unique values SQL
  203. Transferring IF Statements
  204. Append Query
  205. Check box results into a query
  206. Hi there, Basic query question (I hope)
  207. Need help with Select Distinct
  208. Display 0 if no data is available
  209. Date Criteria
  210. Chart from multiple selection
  211. Mail merge and query issue
  212. Query to read checkbox
  213. Getting % and $ signs in the query
  214. Format as currency
  215. Suming data with time issues
  216. if statement
  217. Find Name of Open Query
  218. Mulitiple combox to filter subquery
  219. Top 1 for multiple records
  220. nested if
  221. IIF Statement with DLOOKUP criteria
  222. Help with displaying empty records
  223. Textbox to filter records
  224. wildcard decimals
  225. Combo Box & Query??
  226. IIf function within a IIf function
  227. An append query based on data in an excel list?
  228. Update Query from another database
  229. Iif elseiif statement for a query
  230. Use Drop Down menu in a Query?
  231. Just added a field and now query is over calculating!
  232. Send individual emails from a Query result
  233. Substraction of two queries
  234. Select random records from multiple tables
  235. Select TOP 0.1 Percent
  236. Database Conversion failed from Access 2003 to Access 2007
  237. Exclude 'this' entry from the list
  238. Access query randomly starts asking for parmeter twice
  239. Filtering records on highest number
  240. how to compare two queries returned rows?
  241. Desperate for help- Age restrictions and checkboxes
  242. Updating a field in one table based on querying a field in another table
  243. Need help with queries
  244. Including every record in table b for each record table a.
  245. Changing Headers to Row
  246. Query to append multiple tables
  247. Run query twice on wildcard
  248. Difference between rows
  249. Graph help
  250. how to replicate the look of a subdatasheet