View Full Version : Queries



  1. very very simple query just not working
  2. Retriving Specific records that contains time
  3. Run query from form?
  4. Dialog boxes
  5. Filtering resilts by Date() on fields that recorded time()
  6. Business Intelligence Program
  7. Could not delete from specified tables. (Error 3086)
  8. refering to Query data in VBA
  9. Proper a Field in a Query
  10. Reports from an update query
  11. if Statement in a Dlookup and a Query
  12. Append Query
  13. Update statement cannot use group by?
  14. Combining 3 Queries to Form One Query With Columns from each query by month
  15. Help with Identifying a character within a field
  16. Concatonated query fields truncated
  17. Union Query
  18. Beginner need some pointer on Queries.
  19. Append Query Help
  20. Update table with data from another table
  21. Query between 2 dates
  22. Copy a Value from a text box to a query?
  23. Using sql query to filter by year then a dynamic search field?
  24. Query help!!
  25. Trouble with a Delete Query
  26. Specify the table containing the records you want to delete in access 2007
  27. get most recent date for each test?
  28. Query with optional multiple parameters
  29. 2 similar queries started giving duplicate results, but I didn't change either query
  30. Combining multiple fields in a table into one for searching
  31. Query to list data from one tabel that not exist in a another tabel
  32. Help with ranking in Access
  33. "Query is too complex" error in Access 2007
  34. Merge tables into one Big table
  35. Working Day - Idiots Guide?
  36. Query not filtering correctly/using parameters on calculated fields
  37. string to sort as numeric
  38. Change value of field dependent on what original field value is
  39. Using a left function in a query
  40. Can a Query take a list box as a parameter?
  41. Filtering Query to get final given period
  42. TOP 1 Subquery Problem
  43. Prompt for variable in Query...
  44. Sum Query
  45. Query unable to use not in -
  46. Get Multi-Select List Box as a single output
  47. Query to concatenate records in a table with no key
  48. Use autonumber field from form in query
  49. Please Help
  50. Query and Emailing
  51. Or Feature
  52. Access rookie...need help separating a field...
  53. Make sure a person has at least one of each type
  54. Change order of Crosstab Columns
  55. Numbering in a recordset or Query
  56. Want a bar chart in your query? Check this out...
  57. Update text in a NTEXT field
  58. show fields horizontally(different way of showing data)
  59. show fields horizontally(different way of showing data)
  60. Another DATE question...
  61. crosstab query question
  62. stuck
  63. Problems with a query parameter
  64. Sum records with no value
  65. "Array" type query structure
  66. Query smiliar results
  67. Multiple IIF statements in one column?
  68. Query filtering
  69. Birthday and last contact date reminder
  70. SQL Server to Access SQL
  71. Invalid Use of Null Error
  72. IIf Statment and Left, Synax Error
  73. Problems with DSum
  74. between time
  75. Using if statement to fill a field depending on other records in the table...
  76. Only Accepting Full Lines from an Excel Spreadsheet
  77. How to find "ENTER's¸- NEW LINE" in the Field
  78. Recordset is fetching 1599 record immediate after 1532 record. Why?
  79. Query wont give me a partial result
  80. Complex Splitting of cell
  81. Requry a Query
  82. DCOUNT issue
  83. User Define Criteria
  84. IIF and LEFT JOIN
  85. Conditional (specific records) query
  86. Adding dates
  87. IIF statement
  88. Copying Data
  89. complex query help
  90. Need help and suggestions
  91. between dates filter for day and month only
  92. Help on Make Table Query
  93. Group Query Results
  94. Basic Search
  95. Very puzzled with results of SQL query
  96. Problem in Query
  97. Material Unit Conversion Problem
  98. How to add data from one table to another table via query
  99. Brain fart? What on earth...
  100. IFF and Null Criteria Help
  101. Weird Characters return on query
  102. Days remaining?
  103. query works, and doesn't work...
  104. Creating query from 2 tables using date criteria
  105. Selecting most frequent value
  106. Joining on Calculated Field - Is This a Problem?
  107. Error in Dateadd 'h'
  108. Access Query not displaying everything I wanted
  109. -1 value to pass or fail!
  110. Query asks value when closing form.
  111. Find Values With Letter Then Number
  112. Parameter query
  113. Making a Field Negative in a Query
  114. Automating the process of making a query.
  115. Query 'Total' that takes no action?
  116. Identifying Empty Records
  117. combine multiple rows into one
  118. Getting Data To Link Between Tables
  119. Thinking Outside of the Box
  120. format this 32.2100ffffff to a number w 2 places after decimal
  121. Change date format
  122. help to construct a query
  123. Insert into for more than 1 record
  124. Query: Retrieve Invoices between certain dates
  125. Query to list all blank fields for one record
  126. Message Box to appear when the number 14 shows in a query
  127. need help with getting digits to not appear in formula
  128. GROUP BY query with a grouped calculation
  129. Criteria and Return
  130. Date query
  131. Query to report on *days* after logged date
  132. BETWEEN query
  133. Count # of Fridays between start & end date
  134. No automatic "" or * in Query
  135. string in a query
  136. Access Count Distinct with Grouping
  137. Count Query based on Criteria
  138. Queries using column headers
  139. Invalid use of Null...
  140. how to write this criteria....? Please Help
  141. Trouble using dates query! HELP!!
  142. Adding a percent column to a query
  143. Assign Records to differnt users
  144. Field name changed automatically!!!
  145. Need help with Query
  146. Need Top 3 within 2 categories?
  147. How to display all data in a range with non-numerical criteria
  148. How to display all data in a range with non-numerical criteria (2)
  149. Unique Values in Crosstab.....Please
  150. How can i update so many diff results?
  151. Returning Overdue Records
  152. Creating a Weekly Payroll Report
  153. Converting Julian Date
  154. Days Between Submittal Date and Today
  155. Create a iif type query
  156. The power of Access Design View?
  157. Get the Last Date from a table
  158. Distinct subquery
  159. Need help with an access assignment..
  160. Dynamic number in a TOP clause
  161. Creating a SUM total Query
  162. Update Query Help
  163. Simple Query Wizard - Getting Error
  164. query with single occurrences from many fields
  165. Query not recognising cboBox
  166. How to calculate age from a date format mm/dd/yy
  167. Add 3 departments into one in query
  168. Crosstab query w/ multiple values....
  169. delete record
  170. Query Returning All Dates Between - please help!
  171. Comparing Records using SQL?
  172. Help with Self-Referencing DSUM
  173. Need to change Datatype Upon Retrieval
  174. Need help advanced query
  175. New workdays
  176. Tools menu and date question
  177. Filter records on double click
  178. Skips in a Control Number
  179. Linking criteria to query from combox box.
  180. Simple select query not retrieving correct results
  181. Grouping Dates
  182. Formatted dates query
  183. How to navigate to a url in invisible mode on 92 desktops
  184. Is Null Criteria (Access 2007)
  185. Duplicate records
  186. Dates
  187. Calcluating Queries
  188. ?!?! query
  189. Group by Sum
  190. Formatting data imported into a query
  191. Sub query replaces parenthesis with brackets
  192. Help with query
  193. Query Criteria
  194. Very Stumped! Multiple Criteria Query (One Table)
  195. how to validate data in ms-access using vb.net
  196. Comparing two dates from different tables
  197. Build a query that pass parameters to another query
  198. Change Query so in alphabetical order
  199. First-Last(or something like that) With a twist...
  200. Problem with 'running totals' in queries
  201. Parameter Query that selects many values in a field
  202. Parameter Query between two date fields
  203. Search>check box
  204. Data consolidation help...
  205. Help Needed with Multiple Combo Box filters.
  206. query operation
  207. How to make a blank row in a query
  208. Query not recgonising form
  209. deleting a spacebar
  210. SQL - Conversion of char to datetime data type error
  211. What in the World is wrong with my DSUM
  212. How do I query based on a variable?
  213. SQL append
  214. VBA Code for Update Query
  215. Access 2007 - Create Table Query
  216. Help needed building sum by month query.
  217. delete a digit in a field
  218. Update query does not work
  219. Parameter query based on a combo box
  220. Weird Output from Calculated If Statement
  221. Querying Week
  222. Is appen query best? Not sure where to start...
  223. Between two dates
  224. syntax error. in query expression ".
  225. crosstab query calculation
  226. Sorting Query by Multiselect Listbox
  227. Turn crosstab into a table...
  228. Mail Merge with secured db
  229. Checkbox IIF statement URGENT HELP PLEASE!!!
  230. Declare and use a varible in a Select satement???
  231. Help with a JOIN Query
  232. Count giving wrong total
  233. "Type conversion failure" error when running update query
  234. Delete/Update Query question? Is there a way to do this?
  235. Addine new records to multiple tables
  236. Case sensitive query for MS Access
  237. [Help] How to generate working dates of a year?
  238. Not part of aggregate function?
  239. Conditional Formatting within Query
  240. DateAdd(W) Query
  241. Seemingly Nonsensical Query Problem
  242. Working with Dates
  243. SWITCH Command Between function???
  244. Multiple IF statements in query
  245. Query to sum by [Item] help needed.
  246. is access case-sensitive?
  247. Delete Query
  248. Query doubt on access?
  249. Find and Replace
  250. Date Range Problem in Query