PDA

View Full Version : Queries

  1. Query to select the duplicated records.
  2. query design. current month. ytd, last ytd/month same query
  3. Parse a filed
  4. Adding amounts per record
  5. V. Simple Query, not working
  6. Symtax Error missing operator ?
  7. Using IIF With an aggregate function
  8. help with rank query- everything gets ranked the same!
  9. Query not responding: empty fields?
  10. Date criteria in a query
  11. changing query to show null values
  12. Query with no results (Zero Count)
  13. Like / Not Like
  14. Multiple Source Query
  15. update query with subselect for percent total
  16. Count Multiple Fields
  17. Count Multiple Fields
  18. Pesky Parameter Dialog Box
  19. quite good gold ,look
  20. Day of week totals
  21. Day of week totals
  22. Hours Time Problem
  23. Question about format of a query
  24. Update query to add +1 to date?
  25. The Data has been changed : lock violations
  26. Querying for Records From Today till One Week Ago
  27. Plz help! Query for Summing individual records on their own
  28. Replace words in record that are described in different table
  29. Append Query problem
  30. Search
  31. Importing of data from Excel/Access to two tables linked by a querry
  32. Delete Spaces in text field
  33. Execute expression in query if not null
  34. YTD Values and A year from to day values
  35. Select Group By Having In (SELECT), HELP !
  36. SQL expert help needed- getting complex joins to work in Access
  37. SQL expert help needed- getting complex joins to work in Access
  38. Summing other fields per record
  39. Getting Checkbox to update visually
  40. Create multiple records based on date range
  41. Run query without prompt
  42. Selecting dates
  43. Total Count Of Sources Query
  44. query to calculate busiest day
  45. Query Address Help
  46. Counting unique ID's without duplicates
  47. Decode from SQLPLUS
  48. Using the Left function inside a "NOT LIKE" comparison
  49. Calculating Totals per Item
  50. Complicated table join with subquery
  51. Multiple Search criteria for 1 query
  52. Clean the records
  53. Query Job id selection vis text box input
  54. Very Beginner Question
  55. need to calculate weekend date
  56. Extra lines appearing in Query builder!
  57. Position, Automatic
  58. Parameter Query based on a ListBox
  59. Query not returning correct results
  60. Chart
  61. Counting words in a collumn on a access table
  62. Search Query Criteria
  63. How to find out all the tables contain a particular field
  64. Query Headings
  65. Simple Query
  66. ranking
  67. importing SQL instructions
  68. Filtering problemo!!!
  69. build expression for query
  70. Expression - want 0 results only
  71. Creation of two fields from parts of another
  72. Counting jobs completed by a vendor.
  73. Updating Email address in Customer List
  74. Simple Query, for you - not me
  75. Duplicate values
  76. expression using start/end dates
  77. Join on Fractional Numbers/String?
  78. cascades and datasheets, oh joy!!!
  79. New DB for me
  80. Struggling with TimeValue
  81. Count Function
  82. Recommendations for data retrieval
  83. Update query / Sql problem
  84. Grouping of data
  85. Update Query
  86. every record since #date#
  87. Crosstab query
  88. Query to do a Keyword Search
  89. Help! Query-report asks for "format" (?)
  90. Do Not Call Database
  91. Displaying relevent data only!!!
  92. multifield keyword search
  93. conditional formating of query
  94. updating Table
  95. Calculate days when there are 4 variables
  96. Date Query
  97. Calculating Daily Values For a Month
  98. Counting Zeros with A Criteria
  99. Empty field
  100. is it the queries or tables?
  101. Query help!!!!
  102. Pivot Table Query
  103. Query run the linked tables
  104. Running queries
  105. Retrieving values from 2 subforms
  106. SQL Wildcard and Is Null statements
  107. Criteria problem
  108. Help with Dates & values
  109. Query Conditional Criteria
  110. Trying to Combine Multiple Queries into 1 main Query
  111. Query help, transpose?
  112. Is this a Querie or Sorting problem?
  113. Query Question
  114. Find Missing Classes
  115. Minus <-> Union
  116. combine two sql queries - see example
  117. minus two values
  118. Filter parent data by child data?
  119. Query- Assuming wildcard if control is null
  120. Updatable query error
  121. Error
  122. Updating query flag if child records exists
  123. Simple qry using unbound textbox.
  124. 1 prob
  125. Simple qry using unbound textbox.
  126. 1 prob
  127. Return all records where an id field occurs more than 3 times
  128. SQl query for dividing a field
  129. Conditional Query using Between
  130. Setting query table to Number format
  131. Count Stages in a contract
  132. Converting text to date
  133. Converting -1 and 0 into Y or N on select
  134. Adding column values
  135. Barcode font with Mail Merge
  136. Need to display value from another table if current value is null
  137. Yes/No Field
  138. summing different multiple amounts with grouping
  139. Selecting Records through a form for a Query
  140. Make Table Queries and Concatenated Memo fields
  141. Date / Time calculation help
  142. Query selected fields from a multi-select list box
  143. Query updating a table?
  144. Union All
  145. help please
  146. Export and save into excel
  147. Couple of Newbie Access Questions
  148. Query over Query
  149. Number of Records Based On Table Value
  150. Appending Query
  151. Is this possible
  152. Update Data
  153. Delete Query based on another table
  154. previous record value
  155. Recordset update from combo
  156. Problem Changing Query Criteria
  157. Query - Search Engine
  158. Unknown Query
  159. Counting 2 columns/fields
  160. Fake Autonumber in Query
  161. adding "1" to the quantity from a barcode
  162. Query Criteria Is Not Allowed
  163. union queries
  164. Substitue a Null value with a Space in Query
  165. How to do percents ?
  166. Update query question
  167. Create a new table Ignoring dupes
  168. Set Criteria to Show 'W' if exists otherwise..
  169. Changing data source (table) for a query
  170. Finding missing classes, pt II
  171. update query error message
  172. how search within a field
  173. using if/else in an SQL query
  174. Criteria returning wrong results/WHERE clause length
  175. Where clause in a pass thorugh query
  176. How to make a reference to another column in the same query?
  177. SQL -> VBA Translation
  178. Pop up a calculator
  179. Help me please
  180. filtering duplicate records query problem
  181. Text Expressions
  182. delete query - simple but i dnt get it?
  183. Something Complicated?
  184. NZ Function Problem
  185. Union Query - create additional field / clear records
  186. Using IIf in Query Criteria & multiple table expression
  187. count query problem
  188. fix the expression
  189. Printing Querie
  190. Getting Count To Return Zero
  191. First day of week expression
  192. Help! Query Syntax
  193. --Is Not Null-- vs -- <>"" --
  194. finding max date
  195. Multiple field values need to be returned in ONE line
  196. How to sort by a calculated field in a query?
  197. Totals from Instances (not of instances)
  198. Application not giving desired results
  199. Append Records from an Access Table to SQL Server Linked Table
  200. Problem setting a Date range on my query criteria
  201. Using the Calendar once to update all records
  202. Number to Date conversion
  203. selecting data from 2 fields input into 1 field
  204. Criteria Query
  205. Qry to accumulate values doesn't work?!?
  206. SQL to search multiple fields
  207. Create a "this month" data query
  208. Last 50 records
  209. SQL question
  210. Hour of day calculation
  211. Parameter Query or other option
  212. Help
  213. Query with LEN function
  214. VBA Login to pass Criteria to a query and the Dlookup
  215. Subtracting a column from a column
  216. Trying to update field based on other table
  217. How do i count date fields?
  218. Using IsNull
  219. Query Terminology
  220. In need of advice
  221. Calculation/Date rang problems
  222. Update all records with random value ?
  223. I need Recursive Query Structure
  224. Days lost per month
  225. Advanced Sql Query
  226. Delete records automatically frm table
  227. inexact match
  228. Delete records automatically frm table
  229. where clause
  230. condensing records
  231. DateDiff in a query
  232. a query (i think it's simple, but impossible for me)
  233. DoCmd.RunSQL
  234. Querying via php
  235. Sql Intersect
  236. Sql Intersect
  237. DELETE statement
  238. Devious Query
  239. Access 2k3 Compile error. in query expression Date()
  240. Speed up a VERY slow append query
  241. adding prefix to autonumber?
  242. query needs to return match and unmatched results
  243. Retuen Zero Value in a query
  244. Newbie Query Problems
  245. no duplication in Append query
  246. Extremely Newbish Question
  247. How To Reconsile Items Logged IN and OUT
  248. need access help from the experts
  249. I need a SUM of Quantity depending also by date!
  250. ORDER BY dropdown output