View Full Version : Queries



  1. Need Query to Return same record twice
  2. help with a query
  3. changing column names
  4. Grouping with particular records at the top
  5. Weekday
  6. Count days in query
  7. Can you fill a text box using a query
  8. Month to Date
  9. Email query results by date
  10. Counting including 0
  11. Current Date +1
  12. Age SQL from birthdate in a query
  13. Update Query Problem
  14. please help with this
  15. query results for specific date
  16. change quantity to rows
  17. OR and LIKE when searching with a keyword
  18. staff holidays
  19. Help with Query
  20. Append dates - US/UK confusion!
  21. Using IsError and IIf
  22. Append query based on variable data
  23. Supress output of a column
  24. Don't know how to approach
  25. Query to get summary results for multiple queries
  26. Query problem w/look-up data...
  27. If function in access
  28. Send Query In Email Body
  29. query hangs in design view
  30. Parameter query with possible choices?
  31. Delete matching records
  32. Help needed with date query!
  33. Export and format
  34. Most Current Date Query
  35. Field name and query syntax
  36. Help writing queries
  37. Northwind, Need to Restrict Customers To One Category Only
  38. need help!! queries and commands
  39. need help!! queries and commands
  40. need help!!! queries and commands
  41. Excluding records from a qry
  42. QBF form and search
  43. Selecting Records Greater Than Seven Days Old
  44. combining multiple queries into one
  45. Need Help with Access2000Newbie
  46. Access version of Transpose?
  47. Update Question
  48. yes/no condition for query
  49. Date/time US <> EU
  50. Single result query
  51. Parsing Name Fields
  52. Sorting by month
  53. Expression HELP!!
  54. I want the name to appear only once in query result
  55. Help pls!
  56. too many brackets query sql statement
  57. yes/no condition not working
  58. Non-Values & Matrix Linking
  59. A quick memory jog as i'm stuck ??
  60. Deleteing lowercase letters only
  61. Dsum Problem
  62. Problem with using expressions with strings
  63. Appending column text
  64. easy one...
  65. Query with IIF
  66. Need Query Help
  67. Query to compare field
  68. dynamic queries
  69. Calculating "Max" in a query
  70. Locating multiple entries in query
  71. query database to tally replies from a questionnaire
  72. Query stopped working
  73. Expression Sum IIf
  74. Returing multiple rows with single nested SELECT?
  75. SQL Statement?
  76. Challenge: Real Time Queries and Lookup
  77. Saving SQL created on the fly as a query
  78. Really Need Help!
  79. If (checkbox) = true, add a unstored value to a field?
  80. Need Query Arithmetic help
  81. Criteria in Queries
  82. "Reserved Error -1517"
  83. Using MSysObjects in Queries
  84. Access query problem
  85. Help a newbie
  86. membership renewal letter.
  87. Query help
  88. Query with no table
  89. hellllllllllllpp please :D
  90. Export adding time stamp to date field
  91. Count/Total recurring numbers
  92. Message Error
  93. Select one record for each repeated entry
  94. Compare 2 values from fields on a table
  95. simple query problem - calculating percentages
  96. OVerflow on INSERT Statement
  97. Making a Calc Based On A Table
  98. Export query results to text
  99. multiple queries in access
  100. Date Range By Month Number
  101. Operation must use an updateable query?
  102. Search Query return nothing if creterias were not all entered - HELP!
  103. need help with checking room availability query
  104. using a form to run a query
  105. Merge two records into one
  106. Date Format Between Query And Table
  107. Using a form to set a query field
  108. Stock Control Query
  109. Query field string too long
  110. Sum No of Members Wrong
  111. Please Help With Concatenation Query
  112. remove comma from string in query
  113. hyperlink field in union query
  114. Date Problem
  115. Date format problem
  116. Need a way to total duplicates
  117. Query Assistance needed please.
  118. Append table into a table
  119. operation must be updateable query error?
  120. Sum Thread
  121. Why can't I connect to the DB in this manor?
  122. Running a query with a lot of records
  123. Inventory totals (sum query)
  124. Unwanted extra results from Select Query
  125. Min/max from secondary table without returning extra rows from primary
  126. No data Returned with criteria from Calendar Control
  127. Decode data in Ms. Access
  128. Query Help
  129. in case of missing record
  130. excluding a field which exists in another table
  131. Newbie Needs help
  132. Crosstab query dates
  133. Updating a table
  134. Uppercase
  135. Referencing form field for query between
  136. Exclude Errors
  137. select query problem
  138. select query problem
  139. Report to indicate projected losses of job assignments
  140. query a query
  141. Store Data from Query in Memory
  142. Help With An Update Query
  143. Probelm with Left Function
  144. Summary Query for Single Data Type
  145. Help needed in this query - Plzz someone help me
  146. update query
  147. Easy question - compare 2 fields
  148. Help needed inserting formula
  149. Date between
  150. Multiple Selection from List box
  151. Help on query - customers and *last order only*?
  152. Storing a number in another table
  153. Time Query
  154. query re-writes itself and throws error
  155. Duplicated records in Query
  156. how do I compare the results of a store procedure
  157. Need help with a delete query
  158. Query - Divide
  159. Query Sums Too Large
  160. So simple, It's ridiculous
  161. Exception report from query
  162. Parameter Query Question
  163. Running Balance in a query
  164. Need query to calculate on time deliveries as a percent
  165. Counting Query
  166. Flagging Newest Date within a Month
  167. Fairly simple calculation (that i cannot do!)
  168. Add 1 Year to year part of date
  169. Find Unmatched/Unique records
  170. "DMax" Attendance Query Problems
  171. Date format
  172. Newbie Post - Query question
  173. Counting occurrences of same fields after a query
  174. Select statement for multiple states
  175. or criteria
  176. Query on joining table's field, FROM different table
  177. Crosstab 12 months doubling up on a month
  178. Automatically Return Parameter Query as a Report
  179. Rolling a Date Back 12 Months Question
  180. How to send Count(*) --> Declared Integer
  181. show/not show control
  182. Looking up valuse
  183. Updating table in second Db from current Db
  184. Refering to Global Variable in Query
  185. Calculating number of days using dates
  186. Restrict action queries
  187. Query returning 3 repeated records per ID?
  188. extracting numbers from a memo field
  189. Union problem on two queries
  190. Help designing a query
  191. Update Query based on reference table
  192. ac97 replacement for DateAdd()
  193. Adding iif to query or table
  194. Adding iif or maybe a lookup table to db
  195. Formatting a parameter?
  196. Count problem
  197. Help with SQL Query
  198. Adding Tax to query
  199. DSum with Date
  200. Specify data type in "make table" query
  201. Query - Access - Match Names
  202. query - Parameter
  203. Union All Query Help
  204. Output Time Problem
  205. Date Query bringing on insanity HELP!!
  206. Convert String to Date
  207. Search queri social security number
  208. This will stump you
  209. Weather station programme.
  210. Modifying Data In A CrossTab Query
  211. Disabling Parameter Dialog Box
  212. Sales transaction query
  213. Multiuser access same query
  214. UDFs that accept arguments to process UPDATE/INSERT INTO SQL stmts?
  215. When the last week of the year and the first week of the next, are the same!
  216. weekly Query
  217. Simple Question
  218. Parameter on an formula
  219. Totally stupid question...
  220. Conditional Formatting Query
  221. 8 Querry inside 1 - Can i Simplify?
  222. Retrieve previuos record
  223. String Searching
  224. Creating a query across 2 tables
  225. Query thinks that IS NULL = " "?
  226. Troubles with a parameter query
  227. 2 Validation queries
  228. more than 1 queries on a button cmd
  229. How to develope query using other queries?
  230. Attached db for help with query
  231. Plus or minus
  232. Clearing up data
  233. Specific Criteria
  234. Calculate Days Open Based On Status
  235. Parameter Query
  236. Ignoring Null values from Form in Query
  237. pls hlp,how to cut stock?
  238. Appending Queries to an empty records
  239. DateDiff error
  240. Too many records in my golf query !!
  241. Expression problem
  242. Multiple Variables in Query
  243. An easy one i think ?
  244. Group By and Expressions
  245. Keyword search Query
  246. Another duplicate delete question...
  247. Another duplicate delete question...
  248. Appending Query
  249. Matching string count
  250. Update question