View Full Version : Queries



  1. Error running queries
  2. Look for entry that does not contain another field entry
  3. Help with Group By query
  4. Consecutive Query
  5. Query, Addition, Multiple Line Items, Group By Sum
  6. Comparing 2 fields - Not equal to
  7. how do i make a query format only if certain criteria are met?
  8. If statement to change the value of my data within 1 column?
  9. Filtering Based on Count.
  10. Canceled Previous Operation
  11. Show records between 30-60 days, 61-120 days, etc
  12. Criteria Problem
  13. Simple Query on condition
  14. IIF calculation
  15. Validate Postcode
  16. How to display value in query
  17. Where on a Make Table Query can I see what file will be created
  18. Iif
  19. Displaying results from a comparison in query
  20. I want a union - or something like that?
  21. Date within range
  22. Delete NON duplicate records
  23. Conversion Type Error
  24. Subtracting date and time
  25. Subtraction of two field values in query
  26. Pass value from query to table
  27. What triggers the parameter input box on a query
  28. Display null query results
  29. Concatenating a UniqueID
  30. Question about Insert Into
  31. Querying for two values in same field
  32. Help with my IFF AND statement. Error is provided.
  33. Posting Date Criteria on Report from Query
  34. Expression in Query
  35. Can I use NOT BETWEEN non-equi joins?
  36. searching for 2 items in one query?
  37. Recordset not updateable
  38. Overflow message in Query
  39. Select records only on the same dates
  40. Search on Multiple Parameters
  41. problem with date in the query
  42. “Operation must use an updateable query" error.
  43. Formula for difference from previous value
  44. Cannot query if a record doesn't appear in all tables...
  45. Querying for next weekday
  46. How to get records that dont match???
  47. Count total names in a table
  48. COUNT And IFF Statement
  49. Print query
  50. Help with Update Query using Case Statement
  51. OrderBy Property for a Query?
  52. Percentages of Pass/Fail fields in records
  53. how to replace records with null
  54. Delete query for one field only
  55. Error in adding the null value in query
  56. Tricky! Event log - show eventID and the next 5 minutes
  57. Appending only the records that do not exist
  58. Query from Different tables
  59. Only show if certain checkboxes are true
  60. Append query: from start to end week
  61. Query Criteria Not Working
  62. Display data for all months in a year
  63. Making new records in table using queries.
  64. Filling in blakStartDate fileds with the FinishDate value
  65. Can I count multiple items in one field?
  66. query tracking
  67. Re-prompt search criteria if no result
  68. Find Unmatched Records
  69. Another Running Total In Query Issue
  70. Defining "Yesterday"
  71. send value to report without formula
  72. how do you write a case statment in Microsoft Access SQL view
  73. fill in a value when a append query runs
  74. How can I get this query to work with SQL tables?
  75. ambiguous join error
  76. Error in adding null values in query
  77. Count Problem
  78. Remove 'First' clause
  79. need sql query to show 1 of each different item
  80. Change field data type in make table query
  81. Filtering Time range in Time field for records
  82. Count Specific Values From Multiple Tables
  83. Problem in query...
  84. append new records to table where record does not exist on table.
  85. Counting data from multiple tables
  86. Access changes value to 00:00:00
  87. How to link all information
  88. Which dates occured on a Sunday?
  89. LEFT JOINs with running total
  90. Transfer data from a calculated field
  91. Transfer data from a calculated field
  92. Multiple select query
  93. Data type mismatch in criteria expression. (Error 3464)
  94. Previous Record Query
  95. Formula for Returning End of Year date
  96. Eliminate redundant values in query
  97. Eliminate redundant values in query
  98. Querying by start and end time
  99. Extract Text (dollar amount) in Query
  100. Formattign dates to dd/mm/yyyy with no remainder
  101. Adding Records to bottom of Database incrementing Id by 1
  102. Date Criteria from Combobox
  103. Subquery Dilemma
  104. Extract period of a range of dates
  105. Trimming in MS Access ?
  106. Overflow !
  107. Please help for right join with more than 3 table
  108. Get Date from DateTime field
  109. Query display Employee name not number
  110. Run Report with Query and Comboboxes from Multiple Forms
  111. Query two tables with many-to-many relationship
  112. Use a Query to Generate a Monthly Report
  113. Delete or Unmatched query?
  114. 3075 error in query expression with LEFT and RIGHT function
  115. Filter table by name with the latest price
  116. Select n random records per group
  117. Using DMax for Finding Highest Date of Order
  118. Parameter Query
  119. How do i stop range duplications?
  120. Last Record Query
  121. Query to show all years even when there are no data for a particular year
  122. Sending Parameters SQL
  123. PivotChart too slow on my query...
  124. Critiria not working?
  125. Linking Excel Table
  126. Adding a field to a table through a query
  127. Query returns nothing
  128. Running multiple update queries on one column
  129. opening form from a query
  130. Reverse names in access?
  131. insert records into table
  132. Searching for Blank Text fields
  133. check if record exists
  134. Delete Query
  135. update query
  136. How to combine queries
  137. To build a queries
  138. error is due to too manyIIf's i think.pls help
  139. Time difference in Query
  140. Query results...
  141. Identify records that are on 1 table but not another
  142. Query to find the n highest records
  143. How to use Switch function in Query
  144. Exceptions Queries
  145. Export Query as Text Document
  146. Week begining and ending of a month
  147. Compute a field depending on an effective date
  148. Help Masters Of This Forum!!!
  149. Function in a Query
  150. IIf vs Custom VBA function If Then...Else....
  151. Query show infront of Switchboard
  152. SQL Query
  153. Changing data type with sql
  154. Querying Dates... help!
  155. filter to show all
  156. Selecting only certain fields in query based on dates
  157. Query Help Needed
  158. Export for email
  159. create records x amount of times
  160. Who can help me
  161. Queries
  162. Criteria Help
  163. Get rid of Exact Search
  164. Trim how to?
  165. Deleting Multiple Records from different tables
  166. General ODBC Error Runtime Error 1004
  167. Replace multiple lines in a table
  168. filtering
  169. Double Clicking doesn't work
  170. Creating Separate Tables for Duplicate Records
  171. Query search in various fields!
  172. Changing default message
  173. Join Queries
  174. How to convert AS400 date to Access date/time
  175. Can someone help me with this pls?
  176. Sum and Group By Query
  177. How to convert text format date to date format mm/dd/yyyy
  178. Dateadd
  179. Run multiple Append Queries
  180. Combo - Query help
  181. Trimming Again!!
  182. combine three tables in a query/form
  183. Combining Data??? Help!
  184. Get previous months data when running in current month
  185. Date Issue
  186. Drop record based on date
  187. Deleting Duplicates
  188. Sum on an invoice
  189. Subtotals
  190. Query is doing my head in
  191. sorting by day of the week
  192. How do I allow a specific user permission to process only certain records
  193. How to get average out of these tables
  194. Add a return value inside alias query
  195. How do I look at a week instead of a day
  196. a query within a form and i will like to export to excel
  197. recordset query endless loop
  198. DELETE query with values from different table
  199. Query Criteria using specific Month
  200. Basic Question
  201. Unique Keys??
  202. 3 Table JOIN. Please help me with this query
  203. Filter on Subform problem
  204. Query for mail merge
  205. Query for a comparison in same table
  206. Show query status
  207. Most efficient of querying a multiple condition table with wildcards
  208. Data from Same Column in table
  209. Mulitple Queries into 1
  210. Can someone help me with this pls?
  211. How to call a query from within another query
  212. Date Calculations
  213. Referencing control properties in Where clause
  214. DSum
  215. Query Error Message
  216. Query on a variable number of comboboxes
  217. Nested IIF Statement
  218. Query works in SQL Server, not in mdb back end
  219. update query
  220. Writing a query to find the most popular tutor and get this as a value
  221. Enter Parameter Value problem in query
  222. DateDiff help
  223. How to requery subform code?
  224. Error In Query
  225. Convert Excel to Access MIN() function help
  226. Weekday funtion, group dates, not showing correct amount...
  227. Join two tables
  228. Iif to define where clause
  229. Two Tables in Query Results in Wrong Count of Records
  230. Update Query
  231. Drive mapping problems
  232. Display 0 before a number
  233. delete query - "could not delete from specified tables"
  234. Problem with query
  235. Question: Multiple Date Criteria Search
  236. Extract column names into a string
  237. Requery doesn't work
  238. Multiple Date Ranges in One Query?
  239. Display Query Name on Status Line
  240. Running 3 Month Average
  241. Calculate value by using data from another table
  242. multiple table query problem
  243. Query on Date and Null
  244. Using a Combobox to run a query
  245. Combining multiple rows
  246. Dates
  247. Account Statement Query
  248. parse based on first number
  249. Criteria
  250. Append Query problems