View Full Version : Queries



  1. Re help me about date formating
  2. How to combine 2 queries?
  3. Simple Expression, Need Help
  4. Count query
  5. Simple Delete query
  6. Search result based on the first letter of a field
  7. Crosstab query & calculating percentages
  8. Left Trim / Right Trim
  9. Search String using spaces as "Or"
  10. Viewing only those data with value
  11. Grouping/Calculating Months
  12. List Box Problem
  13. Dsum
  14. Query Criteria based on an input date
  15. indexing
  16. LEFT JOIN problem
  17. query performance
  18. querying with text/dates
  19. Display all with DOB within a week
  20. Trying to match forecasts with actuals
  21. Tricky query
  22. Maybe it's a anti-query
  23. problem filtering yes/no data data type
  24. Archiving Records
  25. counting text selections
  26. How to check and set values
  27. Function Sequence Error
  28. update table query
  29. Extracting a portion of data
  30. display stock left and allow input new data
  31. Update Query - Trying to Avoid Parsing
  32. Update Table Query Anoter Question
  33. Emailing
  34. User defined dates into a report
  35. Merge one or more fields
  36. Very simple SQL question
  37. Calculating time Help Needed!!
  38. counting Days between Services
  39. Subquery works alone, but not with query.
  40. Top 5 Most Often
  41. Distinct command not working
  42. Simple Query/Form Not Working...
  43. User Input multiple criteria
  44. Get value from sql where its select statement is a variable
  45. Access SQL Subqueries
  46. Query Code in VBA - Newbie
  47. Access slow to sum or join on null values?
  48. Counting occurrances of a string
  49. Date Criteria
  50. How to find duplicated records?
  51. Select Equal type - Based On Random Query
  52. Date Value
  53. Text to Time Conversion
  54. The Union of 2 Queries
  55. Format Text field data as Date
  56. matching names
  57. RecordCount please help! im stuck
  58. Access multiple tables query
  59. Matching Part Of A word in series of words
  60. Year Help!!!!
  61. Macro/Script for looping through a list of parameters
  62. Query question
  63. Query Details on a form
  64. sorting issue
  65. combining text when it has space
  66. Query similar to vlookup (true)
  67. query taking forever to execute!
  68. Counting occurances of months
  69. Counting occurances of months
  70. Combo box to also select all options
  71. customise query form input
  72. calculation workdays between 3 dates
  73. is this possible in access
  74. converting iif to Case
  75. Grouping COUNT() help
  76. Parameter query - allow user to select all
  77. sorting records after the last space
  78. Confused update query
  79. Help
  80. date range SQL
  81. Date Format in Crosstab Query
  82. limiting results to the most recent date
  83. iNPUT BOX IN QUERY
  84. How to search from all tables in a database
  85. please help on query problem
  86. simple Query not working
  87. changing recordsource then go back to original - query is faster
  88. Update Query
  89. Separating Data
  90. Identify oldest inventory
  91. Update query for one table
  92. Selecting Time Range in Parameter Query
  93. Finding Duplicate Entries
  94. IIF Statement
  95. Lock down data in queries
  96. Minof Criteria
  97. I need to update data in a table with information from a calculated field in a form
  98. treating Text like numbers
  99. Append Query Where clause issue
  100. UK postcodes in the query design grid.
  101. Rounding Up
  102. month string to numerical month
  103. Counting column data
  104. OrderBy with Wildcards
  105. Only first result gets a value
  106. Field Value via List
  107. Update Table data from Import
  108. The new IE7 will not open all images on the page
  109. list displaying wrong value
  110. Joins?
  111. Totaling the values in multiple rows in a table
  112. Querying and 'Tagging' Records
  113. Query/Update Sales Values for Individual Staff
  114. Status Bar
  115. Help with Searching Records
  116. Help with Search query statement
  117. populating field with query result
  118. I am trying to 'concatenate' the two id fields together
  119. Search Query Using A Form
  120. SQL stuck point
  121. Passing parameters thru combo selection: ERROR:Data type mismatch criteria expression
  122. Explain Query
  123. Running Sum resetting each year
  124. Real Estate Business
  125. Group data into arbitrary time periods
  126. Query data will not export to mail merge
  127. please help with query logic
  128. probably something simple
  129. Update Error
  130. top 10
  131. Oracle criteria
  132. search and fit to a certain layout
  133. Union Queries and selecting Fieldnames with criteria
  134. Querying Details
  135. Action query to make a field = another field
  136. Calculate a % of total.
  137. Show Record If Our Group Is Not Listed
  138. Keep Newlines From Disappearing
  139. Query resumes running
  140. Query by Date Issues
  141. How to delete duplicated rows from table
  142. How add lines to table?
  143. Make table Query .... a Plan
  144. Save Numeric Results as Text
  145. Group Data into Half Hour Intervals
  146. Nested IIf nightmare
  147. Seperate one column into two
  148. Help with Like & "*" parameter...
  149. Query for Exporting to Excel
  150. Create Table from truncated info from other table
  151. Event Procedure
  152. Greter Than ... Less Than ...
  153. SQL to get a job start time and end time??
  154. Setting query criteria to be 'blank' depending on the criteria of a combo box
  155. Append Without Duplicate Rows?
  156. ISAM error
  157. Unmatched Query
  158. Expression Help
  159. Default format
  160. more expression help
  161. Append,Incrementing number problem
  162. Help to return results in a certain order
  163. 2 simple questions - sorry if long
  164. Indexing with literals
  165. Speed issue, Query takes 7-8 min
  166. Update Matched Query
  167. crosstab query
  168. Expression Problem
  169. Expression referencing same query
  170. Using TOP with SUM
  171. How to Query list of criteria
  172. Finding the lowest average
  173. Help with wildcards
  174. Duplicate's Query
  175. Head fudge over Combo Box
  176. Can you use one query for two or more parameter query searches?
  177. What is the value of a Yes/No box?
  178. MIN in Row
  179. Where is the query used?
  180. Formatting numbers
  181. insert fields into a text box from a lookup
  182. Filter A Report USING a Forms Filter Results
  183. Grouping & Filtering Issues
  184. Max of Count
  185. Please help me with query!
  186. Simple Querry Help
  187. Joining tables problem
  188. Create ID
  189. Delete from one table with key linked to another
  190. Help needed to build my query!!!
  191. lookup value
  192. Multipe nots
  193. Simple But I Forgot
  194. Remove leading "the" from a title/name
  195. Union Query not linking
  196. Need to add a column that would calculate percentage
  197. Nested IIF
  198. Problem with max function
  199. SUM Discrepancy
  200. another query help request
  201. create a new row for each table column in query
  202. Growing Records..
  203. Another weekdays question
  204. Listing all records for same field in multiple tables
  205. Linking Queries
  206. Multiple Nots from a table field...
  207. Delete Query Message.
  208. search for a string within a string
  209. how to calculate business hours!
  210. SQL query question
  211. UCase does not work in a Query
  212. Timestamp for the date only
  213. If function to remove error
  214. Using a form to enter criteria for a query
  215. SQL Count function..
  216. Queries - PivotChart View
  217. Nearest Date
  218. can someone help me with my query?
  219. Null Values
  220. Hidden Queries
  221. Adding/Subtracting across adjacent table rows
  222. setting query search criteria from a form
  223. Sending field data in queries to tables problem
  224. Lookup query
  225. Posting data to tables problem
  226. Problem with IIF statement on a Query by Form
  227. Trim within makeup query
  228. Totalling the data from a query
  229. Sum not working! (URGENT HELP NEEDED)
  230. Return Greatest Value
  231. looping query
  232. How to get working days in the query?
  233. Removing Prompts
  234. Eliminate the number of rows returned per each...
  235. Creating a financial year query
  236. LEN command in Access / sql
  237. finding first records only
  238. iif Query
  239. Count entries over a specified number of days
  240. Joins to the same table
  241. Querynot working when opening into a recordset
  242. Query Set-up with special column headings
  243. Active Forms And Queries
  244. Would like to try
  245. Order by numbered list "1.2.3"
  246. adding fields in tables
  247. Minimum Difference btwn. Dates
  248. How can I make this a IIF Statement
  249. A query on queries
  250. iif statement