View Full Version : Queries



  1. Counting month fields for the current year?
  2. Running Sum in Query Problem
  3. Multiple field query
  4. Update query - getting rid of duplicates.
  5. Qry on 2 tables using ~15 check boxes in each table
  6. Using Table data in Criteria of Query
  7. Duplicating records
  8. Search Records
  9. Magic query needed to isolate non-matches
  10. Make-table resetting table field value?
  11. count working days between 2 dates
  12. Crosstab IIf function - Need query between dates
  13. cross tab query?
  14. Averaging in Queries
  15. Transferring 4 queries to 4 tabs of the same spreadsheet
  16. Can some1 help me?
  17. Linked Tables - Cannot add new record
  18. sql for insert into join tables
  19. Text to Numberic help
  20. Query Criteria
  21. ODBC Error in query (client/server SQLServer)
  22. Query pulling a column not existing in the table
  23. Query to pull most recent account balance
  24. Multiple Insert Into - Some Don't Work
  25. Can I use a query to show only one of each repeated data
  26. Using quey criteria from a combo box?
  27. Criteria Question
  28. Access 2003 Expression Operators
  29. Records not displaying in query
  30. Multiplying Currency times elapsed time
  31. Null Columns
  32. Appending Values From Form To Table
  33. select for update
  34. Another Access query to Excel
  35. Finding position of second space
  36. Column(1) in query
  37. Time/Decimal convert
  38. Adding a date parameter to a query
  39. Round integer division .5 to 1
  40. Bypass the no edit restrictionin "Total queries"
  41. Results of past 7 days
  42. Making A Search Form and sending values to a query
  43. Access Query to Accept multiple check box parameters
  44. Create Un-aggregated Records Table
  45. Consolidating Fields
  46. Editing information from a Query
  47. Query returns WRONG FIELD!!!
  48. Update Query problem/question
  49. Update Query to change Display Value part of Hyperlink Field
  50. Sum/Product in Query
  51. Date Query
  52. Calculated field based on the value of the next record
  53. Please help me, New with access 2007.
  54. Having trouble with OR operator in query
  55. calculating the difference between 2 'Time' values
  56. calculating the difference between 2 'Time' values
  57. running balance / subtotal
  58. Matching "Similar" records
  59. Indentify a page index (tab)
  60. Query By Form
  61. Calculating time difference from the record above
  62. Need Help About Query
  63. Subtracting 12 hours from a date-time field
  64. Two Fields Using OR In Both Not Giving Me Results
  65. Entries with Date This Week
  66. Double return into a Memo field
  67. the query didn't execute ..... why?
  68. Passing Form Value to Append Query
  69. How do you do a sumif in Access, similar to excel?
  70. Len, Char, instr Not sure what to use or how to use it
  71. Append Query Question
  72. Selecting only the best three
  73. Multiple condition IIF
  74. Formating Date field in query grid
  75. Keyword Search Query
  76. Sum Query
  77. mean mode help required
  78. return weekend results on Monday, yesterday's results otherwise
  79. Values in certain columns
  80. Create Query that removes any entries with more then 5 digits?
  81. Is it possible to do Make Table Query from Union Query ?
  82. Query / Relationship Issue
  83. Crosstab Query with TEXT values?
  84. Queries That Extract Repeated Item
  85. Left Join
  86. total excluding duplicate
  87. IIF function as query criteria
  88. Parameter Queries
  89. Query formula
  90. multiple table query
  91. Query Customers that havent purchased in the last six months
  92. Updating values when importing data
  93. Help with a date range query problem
  94. A tale of two tables
  95. SELECT DISTINCT help...Please
  96. Sample Records
  97. Select Open a record from a query
  98. Newbe Question - Single and all selection
  99. identifying words spelt incorrectly with numbers instead of letters
  100. Its me again - SUM Function
  101. Using a Calculated field in another Query
  102. How to compare time values?
  103. new to db, cant figure query critera for between dates
  104. Delete Query
  105. Simple query
  106. Using Last in Query
  107. Query Expression Help
  108. Can't figure out expr needed
  109. Field criteria: Is Null; there are Null values in that field; no records are returned
  110. Duplicate that flags Case Change
  111. DLOOKUP help
  112. Telephone field help
  113. Problem with filtering in query table
  114. Top n Query
  115. subtracting info using data from another table
  116. default access messages on query run
  117. DLookUp Problem in Query
  118. Making some specific records with different font style
  119. Linking Queries (I think)
  120. Time Calculation
  121. First 12 digits from one field into another
  122. How to use a date range
  123. Filemaker Lookup equivalent
  124. Beginner Update Query
  125. Get the number out of a string
  126. Query showing all the dates within a range
  127. Max function
  128. Join Properties to include all Records
  129. Calculated Query with user "margin" input
  130. simple up-date querry
  131. up-date querry?
  132. Using record number and total coount in a calculation
  133. function args in a query
  134. Date Range Expression Needed
  135. Query error
  136. Removing Duplicate
  137. Crosstab Query sometimes loses fields
  138. Adding a string to the end of a field
  139. Values comparison query
  140. Using text boxes in a Between Statment
  141. Query for Chart
  142. Check to see if 72 hours
  143. Crosstab query and between
  144. easy fix for >< issue
  145. Access 2007 Query Help
  146. Very slow update query
  147. Update problem
  148. dlookup
  149. stock control update query
  150. Audit Trail using Queries
  151. Selecting every 4th record
  152. query to merge two databases into one
  153. how do i validate data that is already in the database
  154. Rounding problem
  155. MS Access SQL Query Question?
  156. Amount of time between 2 dates
  157. IIF statement not working
  158. Query calculation incorrect
  159. Queries wont work on the net?
  160. update field automatic !!!!!!
  161. IIf or an alternative function.
  162. Join Question
  163. How do I add an unbound control to a query
  164. Capturing Updates in Tables - Part 2
  165. Queried Reports
  166. Repetitive Records
  167. Nz() function does not work with Excel
  168. Joining results from multiple queries.
  169. Deleting all data from B_E database tables. (AC2003)
  170. Crosstab help
  171. COUNTING Yes Values in Checkbox in a Query
  172. Median in a cross tab query
  173. Problem with query criteria
  174. Enter Parameter Value message - after sorting
  175. "Advanced" querying in a listbox
  176. Beginners question - Auto update fields based on fields in another table
  177. Make Table query
  178. Date calculation
  179. Query Doubling Results
  180. Changing a text value in an expr:
  181. Filter Query by multiple fields, one value
  182. Count and filter.
  183. Check to see if a record exist
  184. Query Multiplication Problem.
  185. A simple query check
  186. Delete two tables
  187. Do I need a query or not?
  188. Query Help
  189. Queries - Where Used Query?
  190. SQL help
  191. Problem in Nested IIF
  192. Please check my Insert Query (avoid inserting duplicates)
  193. Crosstab values
  194. Using Like operator to link tables
  195. Max Columns/Fields in a Query
  196. .ldb file write admission problem for our users
  197. Baffled: Gosh! I hope someone will understand and be able to help me!
  198. Append Query, multiple tables to multiple tables in another database
  199. Counting dates and Null values in Charts
  200. select not returning any value
  201. Crosstab Query Contains <> Column
  202. How to find result "Total" - Expressions?!
  203. How to find Total Results - Expressions or Visual?
  204. I am trying to run a pass-through query in access with a variable that a user enters
  205. Selecting records with a prompt for date
  206. concatenate not giving needed result
  207. adding in query does not work
  208. beginner access 2000 query question
  209. Field Selection in SQL from form.
  210. "If" statement on Qery?
  211. Iif In Query
  212. Join Twice???
  213. dlookup two values
  214. Null/empty field count
  215. Count query as well as select query
  216. New User, Need help with Count Query
  217. Min Max Dates and Values
  218. null/zero calculation
  219. conditional query?
  220. Noobie question about Dates and Between or >= And <=
  221. If Not Null
  222. Convert number to text in query
  223. noob needs help
  224. about period calculating
  225. Ms Access Query troubles.. sum(case...)
  226. Noob Insert/update/delete queries
  227. Query advice
  228. Searching for records between a certain date
  229. Appending Tables - Attachments
  230. Search Form Appearence
  231. Grouping by Year then by Months
  232. Find and Replace Query or Macro
  233. excel if on query
  234. excel if on query
  235. Export Query Help
  236. DLookup function
  237. Adding value in table based on values in two other fields
  238. Running total
  239. Query for Calculating a Rating depending on Multiple Criteria
  240. Query takes dashes out of SSN
  241. Calculating Fiscal Years
  242. export a field with varying space
  243. Total Noobie Question here.
  244. Really basic sql question
  245. Edit Result of IIF Query Calculation
  246. Calculations in Access
  247. How can I update a table each time I run a query?
  248. 10 consecutive years
  249. slowness over network
  250. help with iif statement