View Full Version : Queries



  1. query truncate memo
  2. Query Field Calculation
  3. Fortnightly count
  4. Crosstab problems with Nulls and column headings
  5. getting a flatter result
  6. Conditional criteria
  7. not showing duplicate entry's
  8. Query Confused.
  9. Tricky Query
  10. Save me from myself
  11. Query Problem
  12. This is a weird one!!
  13. Access Query Help: Data Analysis
  14. Find dates
  15. Cross Tab
  16. Encorporating a Left Join query into a Criteria query
  17. Remove spaces
  18. Week-Quarter date format
  19. Count by Day and Month but not by Year
  20. Amend query to make list box work correctly
  21. -1 Values
  22. Searching for Symbol Chars
  23. Exporting To Excel(New day, New Sheet??)
  24. Query Eliminating too much
  25. Problem with multiple relationships
  26. Multiple Update queries
  27. Show highest Value
  28. Moved to XP
  29. [Microsoft][ODBC Visual FoxPro Driver]Syntax error (#200)
  30. Date Wildcards
  31. summarizing data
  32. Select all records from a subform
  33. Can someone help?
  34. Merge Columns
  35. Graph Sales By Quarter
  36. Add criteria with VBA
  37. Converting Date from string to date format problem!!!! URGENT HELP NEEDED THANKS
  38. Sum column in query
  39. Query multiple fields
  40. Pattern Matching Query needed
  41. please i need help
  42. Calculate ratio between two numbers
  43. Display the current Day
  44. Item linking error
  45. Date Problem
  46. Update Query to matched Values
  47. Work time calculation
  48. Select top [variable]
  49. Crosstab Query Problem
  50. Displaying results for the current week so far.
  51. Please Help Me With This Problem
  52. querying across different fields linked 1-to-1
  53. Update query problem
  54. Query Help Needed
  55. Searching for Part of a Date
  56. Crosstab results Displaying order
  57. Error when Importing
  58. Dropdownlist based on query
  59. parameter queries
  60. If query returns no records...
  61. Query to merge two tables based on common entries?
  62. Problem merging two tables
  63. count records using month and year
  64. Changing Query Criteria
  65. Combo box for mesage prompt
  66. Date Difference
  67. Several date formulas
  68. Check Box
  69. split a field
  70. Counting Across
  71. how to make fields fill in automatically?
  72. Query problem?
  73. Access Date Query
  74. Strip out everything after a string
  75. Public Variables and Queries (or 2 forms, 1 query)
  76. Date Range Query
  77. SQL parsing problem
  78. Cross Tab Query and Date Range
  79. Changing to Date Format
  80. ListBox Query
  81. Crosstab...
  82. Help with query !
  83. Query Records
  84. Listbox
  85. 85th Percentile of a set of records
  86. Multiple Querys
  87. Help with select query criteria needed
  88. Group by Two Year Interval in Query
  89. Access Mail merge and SMS Text
  90. Pull data from one table if it exists, another if it doesn't?
  91. Group by Quarter in Query
  92. Append query help
  93. Problem with zero in my query
  94. Crosstab nightmare
  95. Calculation troubles
  96. Compare tables and delete
  97. Sub Totals
  98. how do i select criteria based on a value in a check box?
  99. Format for Phone Number in query?
  100. Need to return value based on two values in each record.
  101. is this query possible???????
  102. relationship
  103. Updateable query problem (AutoLookup City/State)
  104. Delete Query Help
  105. Multiple Record Query For Statement
  106. quering Views
  107. Help with query please...checking for data in another table
  108. Query by name AND last record
  109. breaking a date range into weeks
  110. Help with syntax in vbasic like Query
  111. syntax help
  112. Simple Query Idiot User!!!
  113. Delete query comparing multiple columns
  114. Help on Totals
  115. ***///Complex Query Help....!
  116. Return Both Yes/No Records In Query
  117. Query name and latest date
  118. Update query problem
  119. SQL form relationship again!
  120. Query Long Format Date
  121. #Deleted In Query Results
  122. Crosstab question
  123. query help please
  124. Sum query help - not sure what to make of it.
  125. Trying to do a mail/delivery route
  126. Minus Operator
  127. Query returns WRONG FIELD!!!!????
  128. Returning Times for Jobs based only on working days
  129. and or statement
  130. More Query Fun!!!
  131. How do i select a top5 and then a(other) column to graph
  132. query with no results
  133. Querying and Range or a single value
  134. I forgot what my query does. Can someone explain it?
  135. Delete Query
  136. Excel formula conversion to Access problem - gives me #ERROR
  137. Problem with the Count Function (another one...), please Help !!
  138. a query that will skip nulls
  139. Multiple Fields into One
  140. Crosstab Dependency
  141. Append/Delete Query
  142. Yes/No to No/Yes !!
  143. Date Range Report qry
  144. Use criteria or return all records
  145. Finding alike entries in 2 tables???
  146. function not available
  147. summing up the values in a column
  148. Possible Multiple Criteria Combinations
  149. quarterly reports
  150. Criteria Help
  151. Weird unmatched query
  152. Counting Query Results?
  153. IIF question
  154. sorting a union query
  155. Append from subform selection
  156. Can this be done with a query?
  157. Subtype Supertype
  158. List item not expired
  159. How can I sort 4 date fields into 1 column/row
  160. Query problem
  161. Where is TOTAL?
  162. Makeing a query to exclude event types
  163. Joining queries that return different no. of records.
  164. Union query sql...any ideas whats wrong?
  165. Query Based of Form Drop Down Criteria
  166. data type mismatch error
  167. Simple query syntax error - what's missing?
  168. query not showing up as data source from Word
  169. simple insert statement
  170. Parameter dialog prompt repeating.
  171. Convert "1/1/1944" date to CCYYMMDD
  172. Query Date Problem
  173. Make-Table Query
  174. Query to Extract data from 1 Field into 4
  175. parsing for null values
  176. A little exercise for you you guys...:)
  177. Date Calculations
  178. Unmatched Query Error using Linked SQL Server Tables
  179. convert time to seconds
  180. select 2 fields from 2 table and combining into 1 table
  181. Bracket Error
  182. Overwrite Record When Importing
  183. Calculating average
  184. Message Box
  185. Grouping times
  186. Query from a Form Group buttons! Help!
  187. New Guy Needs Simple Help Regarding IIf Criteria
  188. Average
  189. UK date format problem
  190. Query/form problem
  191. Getting a Query to return data where form txtbox gives partial Info
  192. Number Sorting Problem in Query
  193. Can you export the same query to excel in diff file names?(date?)
  194. Mail Merge Query
  195. Sort order problem
  196. Please Help With Append Query
  197. How do I get rid of that blank row?
  198. Dlookup - Vlookup
  199. Insert into sql statement with union query
  200. Query can pull value from form's textboxes; I want to pull from combobox
  201. Query of items in one table and NOT in another
  202. Updating a Calculated Field to a Table
  203. What is wrong with this if statement
  204. Need help in VB with a Public Function--what am i doing wrong??
  205. Easy question - Expressions in Queries
  206. Help with a select statement
  207. Whats up with aggregate-functions
  208. query for calculating difference and display
  209. dynamic querydef
  210. Query specifics conundrum
  211. Datediff query question
  212. query over two databases
  213. How do I create a query to show records with nulls?
  214. Conditional Formatting through queries
  215. Help with Sql statement
  216. Modifying an Update Query
  217. Query database for the names of all tables
  218. Ordering words in a string alphabetically
  219. Selecting Households (Avoiding duplicates)
  220. Updating a Query
  221. Query question
  222. The Joy of Access
  223. Between dates or is null
  224. queries and if statements
  225. Counts?
  226. Difference between records
  227. limiting query results even more
  228. returning strange values?
  229. Filter Results based on input?
  230. organization chart
  231. Combining summary queries
  232. Counting number of records found in queries.
  233. Using NOT to exclude records in query design
  234. SQL Queries and Reports
  235. Please Help
  236. parameter query and recordset
  237. I need to be able to count occurrences of certain fields
  238. Joins??
  239. Need to Calculate an Anniversary Date - Please help!
  240. Same Problem: A Different Approach
  241. parameter queries drop down list
  242. Query returning wrong data
  243. Where is todays data?
  244. Making a dynamic query form
  245. If then statements in queries?
  246. new to access - needt lookup a member # in memdb and populate it ln the frm
  247. If function help
  248. Linked Comboboxes
  249. Exporting Query to RTF
  250. Custom dialog for parameter query