View Full Version : Queries



  1. Help ...show list Movement_inventory
  2. Total Working Hours
  3. AnyOne help with this?? Join Query
  4. Odd query problem giving me grey hairs.
  5. Using an APPEND query to move records from one table to another...
  6. Query Help: Grouping like rows
  7. Global Name Query
  8. Query with a Running Total
  9. query with 2 criteria
  10. Use combobox from form in query
  11. Total Hours by Week!?!
  12. Execute Two Statments In Query
  13. Multiple Parameterized Queries Run Together
  14. Running queries using a macro
  15. Referencing Fields from non-current records
  16. IN with LIKE
  17. Help setting criteria within query
  18. Query calculation problem
  19. DateDiff question
  20. Returning a sequential number
  21. Convert Numeric value to text
  22. MMMM:SS conversion to Seconds
  23. Can't Write Data To Local Table
  24. Altering Data Display
  25. IIF syntax
  26. Date Conversion to Weekday and Weekends
  27. Select 20 Random Records In Query
  28. Design suggestions
  29. Need help on Join creation query
  30. Nearly there just one line of code needed...
  31. Add text on the form when the query is "shown"
  32. SQL delete syntax
  33. Finding records 3 months old
  34. Record entered multiple times
  35. Creating A Master Query or Report From Multiple Queries
  36. really simple one
  37. Week No. chronological order problem
  38. rounding duration to an increment of 15
  39. Error 3071 - Expression too complex?
  40. Invalid bracketing in query in split database
  41. Filtering for Lowest Date out of Duplicate records
  42. Edit fields in an outer join query
  43. Querry by primary key? is it possible?
  44. Time Calculations
  45. Avoiding 20 levels of Iif-Then-Else
  46. Is Select Case the correct way to do this
  47. User inputs Table when query runs.
  48. Display Combo Box before running query
  49. Shortcut to SQL Query (View)?
  50. Really need help with this!!!!!!
  51. ------->>> Please help on filtering out duplicate records.
  52. How make query criteria come from selected records on a listbox
  53. query function with #error
  54. update query
  55. moving range
  56. Criteria for displaying records for a given week
  57. integrating sql query into vb macro
  58. Sort on Calculated Date field
  59. using like
  60. Multiply Fields, Using The Sum Function.
  61. Filter Fields
  62. Parameters/expressions in queries
  63. Query wont allow data update
  64. Unable to search for critera
  65. Can you query a range of dates with a range of dates
  66. vba query
  67. Search by Drop Down List
  68. saving Query data into table
  69. Keyword search query (example attached)
  70. Show Updated Fields
  71. Show results After Date/Time
  72. Qry: Crosstab Query with a few value's
  73. An Anti-Query?
  74. IIF Statement
  75. Speeding up searches
  76. Very simple yet cant get it working...toggle box switch
  77. Updating one table from another
  78. Dates and bookings
  79. Delete Query not working
  80. Two Option Groups, one won't work
  81. Working with text and dates
  82. Does anyone have any suggestion?
  83. Query Filter with multiple checkboxes
  84. Duplicate tag #
  85. Update query to change number of decimal places
  86. Problem running a query based on date criteria over previous 7 day
  87. Query Subtraction
  88. IIf and Isnull in expression builder
  89. display double digit number
  90. Union Query Datasheet Not Updateable
  91. greater than question
  92. SQL problem within Access
  93. Not In and Append Query
  94. Criteria and IIf in Search Page
  95. Ggrouping and do calculation on number of records
  96. deactivate notification
  97. Count not returning 0
  98. check box - query
  99. LATEST date older than 45 days....
  100. Join Syntax Errors Translating Oracle SQL to Access SQL
  101. Simple Query Question
  102. Help with select query
  103. Retrieve Records for the Past Year
  104. query not delivering unique records
  105. New to Queries - Need Help
  106. Query Criteria a List Box Record
  107. Calculating total prices only for specific records
  108. Calculate percentage
  109. Top N Per Group
  110. Union Query ... Help me
  111. Stipulate Combo Column in SQL
  112. Append query to add data from form to table
  113. dropdown selection
  114. zipcode query
  115. inventory
  116. Using COMBO Box to Query a second combo box.
  117. Expression help
  118. make table query with primary key
  119. Calculate No. weekdays between dates
  120. Calculations Query
  121. Duplicates In Query
  122. Says primarykey is NULL when infact isnt
  123. Select record in split form query result
  124. Would I use a query or what
  125. Avoiding to see Today's data
  126. Time in Access: Keeping "medium time" format
  127. Validating email addresses
  128. Validating phone numbers
  129. Time data in query condition
  130. Searching Between two dates via user inut
  131. difference in field
  132. How To Make Query Run Faster
  133. Change query criteria via Excel macro
  134. Query Question / Caluulation
  135. Help please
  136. reformatting Excel numeric dates or parsing
  137. Duplicates in Query
  138. Counting names
  139. Calculated fields
  140. Finding Unique Data using date field
  141. Pass List box Value to SQL Stored Proc
  142. query difference between tables
  143. Parse Text
  144. query OR syntax
  145. Using date and a value to make a text box true
  146. A Basic Question
  147. how to convert decimal values to octal
  148. Disabled Append Queries - Due Patch Update to Windows
  149. Query Problem
  150. Lookup query - help please
  151. Find First Date Approval
  152. how to call/combine 2 queries in pivot chart
  153. calculation within query using combo
  154. Transferring Query data to Excel
  155. Please have a look at my report. It shows numbers (for lookup fiels) instead of names
  156. ListBox Removing Filter
  157. Help with a query... hard to explain
  158. SQL Query, on-the-fly
  159. Yet another append key violation error....
  160. Query w/selection
  161. Need help splitting string in query
  162. Problem with Query Criteria
  163. Working with large data sets.
  164. Union All
  165. Problem finding duplicate records
  166. Importing alphanumeric data into text field
  167. database query using Dynamic Date period
  168. query oh query
  169. Sum(IIf(????Problems
  170. Functions Error
  171. Calculating Totals
  172. Get String function
  173. repeating a query on query returned data?
  174. Find records with a line break using a query
  175. query results minus query results = new query?
  176. Sort by a calculated date in a query
  177. Use Max() ?
  178. Finding dulicate entries
  179. Finding dulicate entries
  180. Checkbox in query
  181. CDate function in query
  182. On Report Print, Run Query
  183. Summing mutiple items in a query
  184. Record numbers, not data, being shown in Query
  185. Combine Multiple properties lists
  186. Query input question
  187. help in query with timestamp
  188. max/last query problem
  189. Use query generated field as criteria for another query?
  190. convert timestamp to time
  191. Data Type mismatch in criteria expression
  192. Query via Excel
  193. Combo Box to Return Records In 2nd Combo Box!
  194. Sum by month query
  195. Not even sure how to title this one! :)
  196. Combo Criteria if not null or is null
  197. Aggregate Function Error
  198. Query with sub form calculation
  199. Flexi Time Query, Can't get the last Calc to work
  200. update query complications
  201. Faulty Query Logic?
  202. Between Dates Parameter Query - Extra Records Generated??
  203. Number of days
  204. Query 1:n problem with Access and attached field
  205. How To Find Pre-Existing Queries
  206. Combo Box Query Problems
  207. numerical sort
  208. No Greater Than
  209. Copying Data without the header row
  210. Access newbie needs help! with charts and data order
  211. Data not transferring
  212. show message box
  213. Commenting SQL Code In-Line
  214. Help counting records
  215. Date range using IIf help
  216. Error (-1524) in Access 2007
  217. little bit complicated
  218. Comparing start and end dates
  219. Working Out Total Time Spent (In A Query)
  220. average number of sausages over time period
  221. Merging 70 individual dbs into one - without creating 70 queries!!!!
  222. Query based on String value in list
  223. Update and append new data
  224. JOIN DB2 table with Access (or other) table
  225. need to add several different fields.
  226. Critiering for two fields
  227. iif is null
  228. Multi-criteria queries?
  229. Row Numbers In Join Query
  230. Query problems
  231. Multi-table query question
  232. New Table creation using SQL
  233. Convert Month Name to Number
  234. help with search form
  235. Datediff() help
  236. DELETE from table
  237. Division by 0
  238. Ranking
  239. Creating reports using combobox user input
  240. Display text from one memo field and multiple records in a report
  241. Date Query - Subtracting Months
  242. Combine Queries
  243. Mix up few tables data ?
  244. Multi-table, multi-criteria: avoid repeating records
  245. Can Count return a zero?
  246. Update query-multiple fields,1 with data, 1 without
  247. Dealing with #error in query
  248. Error 3163: The field is too small to accept the amount of data you're tryng to add
  249. development plan db
  250. Attendance-Query