View Full Version : Queries



  1. Date range based on a record date
  2. Date filter
  3. Delete Query Problem
  4. Parameter Query
  5. Full Outer Join for Dummies
  6. Join Queries
  7. Delete Query
  8. Yearly Payments
  9. Need a wee bit of help with a min query
  10. Trimming an address
  11. Concatenating a date not working
  12. Populating a date in a field
  13. Wrong Number of Rows returned by Subquery with Top Clause
  14. Delete old orders query
  15. Need help with Query
  16. Min and Max Help please...
  17. Query Criteria Question
  18. Counting rows in a datasheet
  19. using expressions in an update query
  20. Totalling Columns & Rows into Columns
  21. Create start date
  22. Importing records from Oracle to Access
  23. Query by checkbox value
  24. Number of days in a month between 2 dates
  25. Format Date Function
  26. update/amend querie woes!
  27. SQL- select record from Access
  28. Update query for OLE objects
  29. Update Query for new records not working 2007
  30. Ad Hoc Query
  31. Elapsed Time Query in Text Fields
  32. Newbie Duplicates question
  33. Query Criteria Dropdown
  34. Re-sort
  35. Can we do that?or something like that?
  36. how to create a delete query?
  37. Gathering statistics on Access queries
  38. Stop/SKIP Appending Query if Duplicate Found
  39. How to export SQL queries to MS-Access.
  40. Getting a date from Query to Text box
  41. urgent: show last date
  42. Related consultants and assignments based on dates
  43. Formulating stats using a query
  44. Divison with an update query
  45. Dcount
  46. Trying to get a query to change text
  47. Using a query to produce another query?
  48. Updating one combo box from another using select query
  49. Merging 2 Tables
  50. Import Excel 2007 spreadhshet into Access 97
  51. Adding new data to existing Table
  52. Cannot apply filter?
  53. Query Filter
  54. Not all results showing
  55. Create Pop-Up Search Dialog
  56. Help needed on a query operation
  57. Some More Help Needed <_<
  58. Query advice required
  59. Expression Builder IIF Issue
  60. Merge Tables based on Date
  61. Return Zero Value
  62. A different Like IIf Issue
  63. Exporting A Query To A File
  64. Working With Wildcard Char
  65. Query Doubles Quantity
  66. Querie involving related tables
  67. ROWNUM, How to get it?
  68. Crosstab query assistance
  69. Progress Bar?
  70. Problem with DateDiff
  71. Spliting one line into separate boxes
  72. Query With No results
  73. Count Query
  74. Link between query and form object value's
  75. Help needed with Query and form
  76. Need help how to construct query with conditional statement
  77. Week starting with the date ######
  78. Criteria Multiple Search Fields IN Query
  79. Count no of bookings in Jan and Feb query help
  80. Query help
  81. Numbers In Averages
  82. Yet another inexplicable problem
  83. Get data from another query in INSERT query
  84. Says query is too complex.
  85. Separate/Parse Month from Date
  86. Query V SQL Statement
  87. Split Database Make-Table query problem
  88. Time Query
  89. Duplicates records in table
  90. Remove . and BE in a number
  91. This should be simple ...
  92. Look up a range from within a query
  93. Make Query - Defining fields
  94. Nested IIF question
  95. Can't edit due to calculated column. Workaround?
  96. Date Query Issue
  97. Join Query
  98. Summarising data
  99. Between Dates query not working
  100. Self refreshing query
  101. Can't input data in select query
  102. JOIN problem..
  103. Query lets me delete but doesn't actually delete...
  104. HELP - Chart with zero value
  105. Query/Report Issue
  106. Query help
  107. number format in sql queries
  108. Ranking Query
  109. Date query based on month
  110. Adding sequence number to a query
  111. Hi There StupidStudent Again here
  112. Sorting Query by Date & Employee Name
  113. Domain Aggregate Functions in Query Expressions
  114. Yearly Planned Maintenance Report
  115. Query to show non-duplicates
  116. Debits and Credits (was posted wrongly in VBA section)
  117. Splitting Columns
  118. Cant get 'Like' to work
  119. select unique record
  120. Exclusions
  121. parameter query w/null responses w/date range
  122. Query when Queries were last ran?
  123. Complicated Select Query
  124. Format a number as a text in a query
  125. Inserting Into A Table With 2 Pks
  126. Sum multiple columns and IIf
  127. Dynamic multiple criteria in a single field
  128. Queries: Concatenating Column Results into a Single Field
  129. Select Record Based On The Time Of Another Record
  130. Convert formula into formula result
  131. Concat using
  132. Default date in a parameter
  133. Where Condition Help
  134. Delete Records
  135. Convert Num to Date
  136. Unmatch Query with Dates - Bad Results
  137. Help with a query
  138. parameter conversion
  139. Concatenate Names
  140. Selective/if fields
  141. Query based on latest time
  142. difficulty creating code
  143. How To Define This Query?
  144. Passing a date field to a Query
  145. Maiximum number of records
  146. Query returns unwanted results: please help
  147. Merging Two Fields In SQL
  148. Duplicate Records
  149. iif statement with or operator ??
  150. Comparing two databases
  151. Trying to create a count query
  152. Insert records from one table to another
  153. Different Quarter then default
  154. Jumping to Form View Record from a Query
  155. is there a Way to Combine Different Values for a field?
  156. Parameters in a CrossTab Query
  157. hide 1 record
  158. comparing two datbases
  159. Help needed on Up-date Query!
  160. Query issues
  161. Append Queries - Sorting Issue
  162. records existing in Main table not found in Temp Table
  163. SELECT and MULTIPLE dBases
  164. Help with Outer Join Query in Acess 2003
  165. Running sum for time and group?
  166. Deleting 5 year old records!
  167. no warning messge when runing the delete, append or update query!
  168. Checkboxes
  169. Not Exist Join
  170. Count Function in Access Query.
  171. How to run a report based on user's options
  172. Nz function parameter on a text field
  173. check for eof in a query
  174. What is the best way to remove duplicates
  175. Change a number to text?
  176. Urgent Help Needed
  177. Query help
  178. Access Join Output
  179. Another Question.
  180. Query Criteria
  181. Parameter Make Table Query - how to pass the table name to the query
  182. Reverse Crosstab Query
  183. SQL or not SQL?
  184. comparing two tables in msaccess
  185. Comparing current time
  186. Multiply Parameter Queries!
  187. problem adding up...
  188. If Statement???
  189. Can I place a a command button in a query?
  190. Why is my query pulling one record only?
  191. Previous Record
  192. Updating Back-end Databases
  193. Is this query even possible with Access???
  194. No records shown
  195. Connecting Data Basess
  196. Increment date: previous date +1 ?
  197. Blank spaces in data fields after copying data with SQL
  198. Can I access a query from a switchboard?
  199. population current record with information from next sequential record
  200. conditional join
  201. sql problems
  202. It just doesnt add up !!
  203. Paramater query
  204. Date issues in a parameter qry
  205. Comparing values - do they match?
  206. Is there a way to change this search to a like search instead of an exact one?
  207. Counting results of multiple queries and displaying the the reults on a single form
  208. Query Problems..
  209. How to open results of a query in a form?
  210. Parameter query on calculated field
  211. Running Totals
  212. Help a beginner with an Access query/form
  213. Help a beginner with an Access query/form
  214. Help
  215. Record Filtering
  216. Bizaare Field joinging issue
  217. Input masks and append querries
  218. Is there a way to apply a different filter to each column in a table?
  219. Problems with Data
  220. Log function
  221. Query Criteria - Date range
  222. Query Question- Number size
  223. can i access a query in ms access from vb?
  224. Help with Subquery
  225. Text String
  226. Dynamic sort order
  227. Need helps on Query retrieve range of dates
  228. Query Counting
  229. Delete Query - Strange Result
  230. Select 10 or fewer records based on ID field within table.
  231. Simple code?
  232. Querying A List Of Dates
  233. Make-table Query property?
  234. Is it possible to use the same query on different the same but different tables
  235. Update query to change date
  236. AVG Function
  237. Calculate Median
  238. Need Equalent MS Access query for an Oracle Query
  239. Design Problem - Filtering Combo box items based on related table field
  240. Subtract 7 hours from the query
  241. Update query using 3 tables: source, joining, destination tables
  242. pls need queries to
  243. Select records with date inside the current month
  244. Help me Please...this query!
  245. ON/OFF Query Prompts
  246. Filtering Letters
  247. In statement + forms
  248. Date calculation in Query
  249. Month Query Help?
  250. Query returning blank results after installing Office 07