View Full Version : Queries



  1. A small question ?
  2. Query of Struggling With...
  3. complex table query.. help needed
  4. Graph based in query return's Microsoft Jet error
  5. Select record based on row numbers...
  6. Delete Query - 'Specify the table containing the records you want to delete'
  7. Problem in Under exist in Field_Name
  8. Query taking long time onbly for certain data
  9. RE: Summarize on text column
  10. (NOOB) sorting and prioritizing by dates
  11. Dynamic Reference to Tables in Queries
  12. Getting Query is Too Complex ERROR Messages
  13. NOOB-Import CSV & Reformat For Efficiency
  14. Simple Query
  15. Sending query to Excel.
  16. IIF statement in WHERE clause does not working
  17. Displaying Records Entered in Prior 10 minutes
  18. Rounding Down As Apposed to Rounding Up
  19. Multiple values in a WHERE ... LIKE statement
  20. easy question new to access
  21. list most frequent occurences in a table
  22. IIF Statement
  23. Query Fields
  24. using expression in another field of query give wrong answer
  25. IIf vs Switch
  26. Nz and IsNumeric not working
  27. Query to use on Pivot Chart / Report
  28. Help with Query Expression
  29. Query with "like" in access
  30. Nz queries
  31. Show last Month Record
  32. Query filtering criteria by code help
  33. Can this be done and how?
  34. DateDiff between 2 records
  35. Problem Query Wizard Build a select query by using tables with a many-to-many relatio
  36. Beginner:Need help with joining tables/forms
  37. Why don't the query properties update?
  38. How can I set a paramter on my query based on the value held in a field ?
  39. Need help with a date querie
  40. Can someone help me with this?
  41. Dynamic Column Headings Crosstab Report
  42. Problem with an InStr Query
  43. Creating user login with access
  44. Need help with query to Access db
  45. Delete query using combo as selection
  46. Compare Items Within a Query
  47. Date help: extracting mm/yy out of dd/mm/yy format
  48. Embed Parameters In Sql Script
  49. query results
  50. Problems with Update Query: Avoid changing data in source table
  51. Count How Many Students had more than one tutorial?
  52. DlookUp Help Please
  53. Parameter not working in Update Query
  54. Using Combo Box as Parameter
  55. Access 2007 - DateDiff Problem
  56. Running Totals / Remaining
  57. IIf statement with multiple conditions
  58. Is there an "If Exists" option in SQL?
  59. Update query based on Min Values problems
  60. Find/Replace on all queries
  61. Query over past six CALENDAR months
  62. Group characters in string
  63. Error in Dsum
  64. Query casusing MS Access to crash and backup
  65. Issue with subquery using LIKE statement
  66. Query Baffled
  67. Adding calculated field to query
  68. querying SQL server - a problem
  69. Need help on Query
  70. why show "Record is deleted"
  71. Append query not appending
  72. Append query, duplicate key problem
  73. query to Import few fields from excel file to access table
  74. Adding Fields
  75. Querying IsNull in multiple fields
  76. Query Criteria Parameters: Running Out of Characters
  77. Clever SQl req'd
  78. Need help with query with 2 different dates
  79. Optional Paramater
  80. Pls help me with this! UPDATE QUERY
  81. Working Week
  82. Query How To Find Previous Record
  83. Queries to Count Data
  84. Query based on Combo box result
  85. Saving the Long Date Format for Mail Merge
  86. Set Field Length in Make Table Query
  87. how to join two query in one
  88. Query/Import question
  89. run query on close
  90. Averaging Totals of several adjacent fields
  91. Query multiple records
  92. Query on updating a field with current date?
  93. New to Access looking for some help.
  94. help for union query
  95. Cummulative total query for chart
  96. Delete QueryDef?
  97. Query not updating
  98. Update query with 'null' value for numeric field
  99. IsNull Function! Pls help me!
  100. Help Designing an Update Query to Convert Currencies Please
  101. Working Days Again!!
  102. Qbf
  103. Crosstab query not recognising textbox input ref
  104. Insert query not inserting all fields
  105. Difference between 2 tables
  106. Eliminating Duplicate Records
  107. Update Query
  108. Analyze with Excel deletes Query
  109. Query Help
  110. Creating a count
  111. Conceptual Design Quandry
  112. Add a OR for using Multiple Fields
  113. Query hangs technical problem
  114. Counting Yes/No Fields
  115. Tricky Query
  116. ALike
  117. Don't need a heading telling me it's a sum
  118. UNION ALL headache
  119. reminders for anniversaries
  120. lookup syntax question
  121. How can I count money, not records?
  122. not having fun today with SQLServer2005, ODBC and MS Access2003
  123. Error 3075
  124. Records on Join Table
  125. specific day!!
  126. one year anniversary
  127. query iff criteria
  128. Distinct Date Totals
  129. Query Returns Too Many Records
  130. zero number not a zero
  131. Nested If Statement trouble.
  132. Need to return only characters (not numbers) in a string
  133. Cannot format and expression
  134. How do I Split My [Name] field into [FirstName] and [LastName] ?
  135. Related table query
  136. Query to delete records that no data not working
  137. Building a table in Access
  138. find Not matched username
  139. Too Few Parameters Expected 1 Error 3061
  140. Attachment in 1:n query
  141. Use operators in textbox for query
  142. Update or Append Query
  143. Insert query please help
  144. Exporting queries - cell formats
  145. SQL: group after group
  146. Order by date created in VBA?
  147. Grouping problem
  148. Problem with query containing date criteria
  149. Need zero to show in query results
  150. From and To locations
  151. How to create a delete query using VBA for event procedure?
  152. multi-word search
  153. Finding "missing" records
  154. ACCESS 2007 update query: blank fields
  155. to create a table automatically
  156. Query takes long time in execute
  157. accents
  158. Display a message when the wrong Contract is input
  159. create table with same structure from other table
  160. DateAdd Add full month to a date
  161. switching two cells in a row
  162. Query Criteria Based on a Cell in Excel
  163. Iif statement where false has no condition
  164. Query with InStr Function.
  165. Concatenate data within the same query
  166. Find duplicates based in a few characters
  167. Summing contents in columns
  168. Help with multiple Iff statements
  169. Update/Insert query
  170. nested IIf (nor Switch) function not working....
  171. Serial Sequence Gap Checking
  172. how to read the database from excel and save it in database
  173. Work week only 4 days
  174. Duplication in queries - how to eliminate
  175. Concatenation: Insert New Line
  176. Delete duplicate rows
  177. Problem with setting criteria on datetime value
  178. Queries & Combos
  179. Delete Duplicates on a make table query
  180. Query Too Complex, is there a better way?
  181. auto increment button
  182. Syntax Error in FROM Clause
  183. simple code required
  184. INSERT INTO using a value from another table
  185. Daily Account balance
  186. aggregating functions for text?
  187. Calculated Fields
  188. Query Counts records not Companies
  189. QueryHelp on Date
  190. Query to list sales by product in 2 periods
  191. Replace empty entries in LEFT JOIN query with '0'
  192. Return Primary Key Value after insert into
  193. SQL into a labels caption ?
  194. Calculating Percentage
  195. SQL error but not when run in query
  196. filtering a query
  197. subquery problem
  198. Query
  199. Problem when importing data into excel pivottable: zero values
  200. Grouping
  201. count if
  202. high qty column table data rotation
  203. Query by selecting from drop down menu
  204. Summarizing hourly into weekly
  205. Creating a "Count Query"?
  206. I think my problem is in the Query
  207. Qry to copy data and edit data from one field to another
  208. Query table and return all EMail address
  209. Conversion of 4 columns of binary data into one column with text
  210. Top Value
  211. Automate a field
  212. Query From 2 diferent tables
  213. 2 fields issue
  214. Query Relationship Problem: Need Help
  215. Can't get rid of duplicate rows
  216. Query Designer
  217. Date filtering
  218. Query Criteria
  219. Another brick wall
  220. Query returning wrong results
  221. "You tried to execute a query that does not include..." Error 3122
  222. Updating queries
  223. Conditioned MIN Function
  224. Get as much information from a query as possible
  225. Join Query from one Table?
  226. Query Reference
  227. insert records into a table within SQL
  228. Trying to select a single row from many side table
  229. How to Reference Data from a different Table?
  230. conditional query?
  231. Calculating Time - Start - Finish - (Lunch)
  232. Crosstab query
  233. Make Table Query Mis Sorts Numbers
  234. INNER JOINS: how to create??
  235. datepart help
  236. Newbie - help with syntax (comma) error
  237. Query with a variable
  238. HOWTO: indicate if a value exists in another table
  239. Query help need please
  240. Unique based on Field
  241. Max Date Problems
  242. Query criteria from another table
  243. Query sequence help
  244. Recieving Syntax Error using "OR" command
  245. Iif.......
  246. Time Calculation in Query
  247. Running Total in a Query with a criteria
  248. Find duplicates, and remove BOTH records?
  249. Another Time Calc Question
  250. Relationship - How did I do?