View Full Version : Queries



  1. Count of Null records
  2. Expressions
  3. Running Query With Like In Ado
  4. Extracting record(s) with most recent date
  5. Changing Sql In Ado Query
  6. Excluding Data from a Query
  7. Can't Update Record from Select Query
  8. Unmatched Query - Using multiple fields
  9. Selecting top x records
  10. Hide Duplicates within Query
  11. drop table if exists?
  12. Help Please!!!!
  13. sql help
  14. how to archive files/ table queries in Access?
  15. Query not including all data
  16. Keyword query in access for knowledge tree
  17. summing records where field is between
  18. Count on Query and Displaying result on a switchboard
  19. Monthly Expense Query
  20. delete similar records
  21. Getting values for each day from one column
  22. How to reduce minute from date field
  23. Help need for Expressions Builder
  24. How to reference data that does not exist
  25. Grouping many different dates
  26. multiple selection in a query from a form
  27. Query for each record
  28. Multiple entries using append query
  29. Manual Input Query
  30. Numerical values within a string
  31. Using BULK INSERT to Load a Text File to MS Access
  32. Subtotals in Queries
  33. Adding a combo box to query
  34. I'm stumped..
  35. Dashes are causing problems retrieving data
  36. Confused !
  37. First time using 2 tables for a Query....
  38. Use query results from report to make table
  39. How to default to SQL view?
  40. Numbers with in a disordered text field
  41. how to query the first 3 digits of a field
  42. looping query
  43. Run-time error '3035'
  44. If filed hasnt changed in 24hrs...flag it and dcount the results ?
  45. Replace function in Access
  46. Union Query
  47. How to return both matched and unmatched
  48. Append query question - simple
  49. IIF statement not working
  50. Searches
  51. Rounding to nearest hundred
  52. Help with expression, keeps asking for criteria
  53. display all when NULL
  54. unique record
  55. Rolling Sum
  56. Adding a row to the query
  57. Help with count query
  58. Queries and Reports
  59. Return results where there is no relationship
  60. Can you query between two DBs
  61. Get all Unique composite pair of records
  62. Help Creating a View
  63. query help
  64. query help
  65. Totals Query
  66. Help a newbie understand simple math functions
  67. Date Criteria
  68. How do I create multi-field queries??
  69. Select all fields that start with...
  70. ill sound stupid
  71. Query to group like words
  72. IIF and Like "*" problem
  73. Changing total cell to expression
  74. Decimal Places
  75. Passing a Field Name into a SELECT Query?
  76. calculating date difference excluding weekends in access
  77. dcount?
  78. Count problems
  79. Query Runs Slowly
  80. DCount Wierdness
  81. how to split out all words in fields with multiple words
  82. Query Nightmares
  83. Newbie with query
  84. Selecting parts of a field for querie
  85. Query to Filter by 1 criteria, or all.
  86. nested loop query
  87. Please help with my query query!
  88. Query By Form - Listbox criteria
  89. Multiple Criteria Query - Using formula from table
  90. Query date only for month
  91. Do I need a query?
  92. drop table if exists
  93. Get Unique records within a query
  94. Query with options into a form
  95. query with options into a form
  96. Date Criteria
  97. complicated query/reporting stuff
  98. small problem with sums
  99. Query dependency
  100. yes/no parameter
  101. search criteria within same field
  102. query data to update table
  103. Basic query question
  104. Retrieve Specific Contacts
  105. Year To Date???
  106. Another if statement problem
  107. Another if statement problem
  108. Help with insert query please
  109. Help with IIf function in criteria
  110. Query as Report source
  111. Duplicates
  112. Problem with a crosstab query
  113. Make Table Query Help
  114. Can somebody please tell me how to make this work!!!!
  115. Calc'd field won't format?
  116. Expression Builders/Equations in Queries
  117. runtime error err number is -2147467259
  118. Filter by selection not working
  119. Null / Non Existent values and Query woes.
  120. Help with validation rule in a query
  121. Calculated Date ....Help please
  122. Show Query fields in subform using option groups
  123. import 1NF to 2NF db
  124. Possible Sum Requirement
  125. Keep track of stock items by query
  126. Updatable Query Error
  127. Orders held up for one or more reasons
  128. Using value from a form field.
  129. Appending a Table Using Crosstab Query
  130. cascading combobox help
  131. Query - Records within a certain range
  132. Interesting query challenge
  133. converting hyperlinks to text and cleanup
  134. How do I query a recordset object in VBA?
  135. Date statment
  136. Link a query with Excel
  137. Limiting results
  138. Access Dates
  139. Compare same data - delete
  140. Access query will not list certain date
  141. extract certain data
  142. Updating Year....
  143. IF isnull want query to answere 1
  144. Query looking up option group not working; value not remembered?
  145. get the difference between 2 rows of same column
  146. Whats wrong with this query?
  147. Newbie Question
  148. After append update query
  149. Filter Query By Date
  150. Filter Query By Date
  151. Filter Query By Date
  152. Query Help
  153. Query Help!
  154. Query Question
  155. Query Help
  156. Ignore Duplicates
  157. Selecting multiple postcodes from table
  158. setting the record set of a Query
  159. Using Between with Time
  160. Sort Query Ascending
  161. how to use IIf with three variables
  162. Using the count function
  163. Convert text to date
  164. how rewrite queryfilter to refer to a control in a subform?
  165. Comparing Records
  166. Counting Unique UID
  167. Displaying Null Values with Expression Builder
  168. Group By/Sum query help needed!
  169. This expression is typed incorrectly, or is too complex to be evaluated
  170. Return all rows
  171. date criteria as NULL
  172. Search month
  173. "Or is Null" in Design View
  174. Append Query
  175. Finding ABC
  176. Delete
  177. Count In A Query
  178. Extract Data
  179. Hard code TIME to selected Date on form (to make it date&time) for my query criteria
  180. BE Append Query Error
  181. group by and summary?
  182. date/time subtraction using previous row.
  183. Another delete duplicate
  184. ID changed when UNION queried
  185. Multiple field queries
  186. Find Units that are In Work
  187. "average" problem
  188. Parse query
  189. query by future paydays
  190. Query based on future paydays
  191. Query Math With Dates
  192. add counter to query
  193. How to disable Action Query popup messages
  194. Is conditional averaging possible?
  195. Can this qurey be modified ?
  196. Possible to use function: Left(Field,4) in a query?
  197. Simple Q on multiple queries
  198. Assign text to a text field
  199. max day in the month record
  200. Query refrencing form for data
  201. Simple Query Qestion
  202. Format within Query
  203. Totals Query
  204. Date Query
  205. Query ~ Seperate 1 field into 8 fields using Pipes "|"
  206. How to have report use more than one query
  207. Difficult If-statement
  208. Lookup tables and queries
  209. Simple Query Needed
  210. IIF Date
  211. Building A Query Based on a Form
  212. Extract Date
  213. Query Criteria using a table
  214. select where not in doesn't seem to pick up data
  215. surname name
  216. Create a unique identifier
  217. Query Input Must Contain At Least One Table or Query
  218. Edit destination table in visual basic
  219. 12 month's of data
  220. need help in VB Code
  221. Parameter query use value from other query field
  222. Filling blank cells in a crosstab with next value
  223. Add two fields to a query
  224. Baseball Scores
  225. Crosstab queries, column headings and lookup table
  226. Fuzzy links possible?
  227. Finding the sum of the values in a field.
  228. Adding data to one table from multiple csv files
  229. Count City
  230. Show Query Result in Form Fields
  231. Date query issue
  232. Search criteria question
  233. Joining Queries
  234. Query criteria question, quick answer needed
  235. How to Right outer join several tables in a query?
  236. Query to get Sum
  237. Export Specific Columns To Excel
  238. Join where contains ?????
  239. How to use IIF when more than two alternatives exist
  240. Combining calculated values from two queries.
  241. Total does not sum
  242. Merging 2 records into 1 record
  243. How do I find if an Index exists?
  244. runSql
  245. Query with Multiple Criteria
  246. count number of characters in numeric field
  247. Need help with Query (Some names with "*")
  248. 2 Queries and a Form, Please assist
  249. Year only -haw hard can this be!!!
  250. Suppress error on report