PDA

View Full Version : Queries

  1. Strange thing filtering weeknumbers
  2. Retrieve New Autonumber CurrentDb.Execute
  3. Run Time Error 3061
  4. Formatting Date/Time
  5. Help Me Understand This Please
  6. need help with a query
  7. Find the maximum time vs the target time
  8. Append query nightmare!
  9. Using Combo Box in a Query to run report
  10. Custom dialog box+query link with a 'where' in total
  11. pass parameter from table, yes-no does not work
  12. How do I get around this one?
  13. Elapsed time
  14. Help needed with update query
  15. Append Qry - destroys d/b
  16. Fill listbox if a form date falls between 2 dates in a query
  17. Find unmatched records
  18. Show a record for each side of a join
  19. Date of Max Value
  20. MS Acces Query Help needed
  21. Count doesn't work
  22. How to create a teble from a query
  23. Queries - Dates
  24. Days since last entry
  25. Serious help needed!
  26. Creating a Calculation in a Query
  27. Query / Function Problem.
  28. append multiple tables
  29. something similar to sumproduct...
  30. Multiple Table query
  31. VBA Query with LIKE won't return data
  32. Recommend a DELETE method?
  33. Query for Adding Duplicate Fields
  34. SQL Question - OleDB from C# Application
  35. Strange query problem using dates...
  36. Queries - Strange Date
  37. Search Exact number on Query
  38. appending data to a queries....
  39. SQL help
  40. Query within a Query - is this possible?
  41. Dealing with dates and null values in parameter query
  42. Removing Left and Right characters and getting only the middle characters
  43. Time Values
  44. Queries
  45. Parameters, convolution and multiple query calls
  46. Basic stock control problem
  47. IIF Statement with an Or
  48. Append to a passworded database?
  49. Booking Query
  50. Report running off page
  51. SQL Group by problem
  52. Allow only 8 characters in Query Search/Parameter box
  53. Query criteria return no records
  54. Insert into table
  55. Statement ageing date totals
  56. Query 3 tables - Sum quantities and return range of prices
  57. Variable column Crosstab query
  58. Merging records with same address
  59. Query multiplication of null fields
  60. Can someone help me with this update query?
  61. Please help me decipher this code
  62. Append query to parent and child tables
  63. Converting #error to 0
  64. If I can't aggregate....
  65. Crosstab Query Buckets
  66. Missing Time periods
  67. Multiple SUM(Column) on different table at the same time
  68. OutPut of quries1 = Input into Quries2
  69. ODBC Call Failed (3146) - but only on some PC's!
  70. Automatic update of field names
  71. Query problem
  72. Thoughts or guidance on the structure of a query?
  73. Counting consecutive months in Access
  74. How can you search for a specific character from a string.
  75. Update logic field with Update query
  76. Data parameter value issue
  77. Multiple Table Query - Duplicates Messing Up Count
  78. Excel help (SUM IF formula)
  79. IIF/IsError sql Combo still returning #Error
  80. totals query does not show zero and currency format
  81. Counting Distinct Values In A Query
  82. Search Criteria Month Function
  83. Acc2003 - SQL updateable Passthrough
  84. replacing null values with a number using query in desing view
  85. Lookup in a Query?
  86. Help with criteria for subform
  87. query with calculation
  88. Help Me Pls Here! Thank You!
  89. Help with query
  90. Converting dates to week number
  91. Simple query and yet won't work?
  92. Combo box not passing Parameter to query
  93. Getting First/Last Values from a query
  94. Query to create a new column for each week interval
  95. How to display date into required format
  96. Counting Consecutive Months in Access
  97. Append Query - 2 Issues
  98. Forms,Queries,Macros..
  99. Selecting all from combo box to use as a parameter
  100. How to calculate average time/duration?
  101. Pass parameter to query from a table
  102. DB in Read-Only
  103. adding travel times without regards for timestamp
  104. Help with using not like in parameters
  105. How to convert Number to Time in Table
  106. Please help me organise my DVDs !
  107. Querying a date and time stamped field
  108. HELP NEEDED: Running Balance with Data Containing NULL
  109. Deleting all the data in a table
  110. Criteria the day (Today)
  111. Sending Query output as password protected XLS
  112. Simple task for you pros I am sure
  113. key violation error
  114. Help creating a running sum based on a calculated field in a query
  115. Select Query referencing multi select list box
  116. Hi, Pls help me about this Update Query
  117. To Do List Query
  118. Query to change table columns
  119. Trouble with IIF and time
  120. Show only record with latest date on subform
  121. Query - pull entire prior month
  122. Updating a field, when records match
  123. SQL - problems editing
  124. Count Days Between Two Dates and Exclude Weekends
  125. Creating a user friendly Query/Form on multiple fields
  126. comparing dates
  127. prepared statements
  128. Getting values from a column A that has same values in column B and C
  129. Date today to end of week
  130. How to find privious month,day,week,qtr data
  131. Hello! Pls help me in this update query I have.
  132. creating a form into a query format
  133. Convert yeardays to year-month-day
  134. Force empty columns in a crosstab query
  135. Query to Create Record with next Autonumber
  136. Measure Query Run-time
  137. Joining two large linked files in Access
  138. Query - Tally date
  139. Removing All Spaces Between Data In Text Field ?
  140. Multiple Queries and Null Drop Downs
  141. Multiple queries returning all fields
  142. Access TRANSFORM (Crosstab) Queries and Missing Rows
  143. joining information in two tables
  144. comparing data in two tables
  145. invalid argument. anyone know how to solve it ?
  146. Pass Through take long time while save in MsAccess
  147. Calculate the time difference where a number of users are involved
  148. Reference to main form in append query
  149. Consolidating data?
  150. Between Dates Query on Multiple Fields
  151. if condition
  152. If the string contains a text Value
  153. about queries
  154. Select top statement
  155. updating text field with numeric value?
  156. Edit data in Query's
  157. Displaying a calendar in a query
  158. help with query
  159. Searching query based on searched query.
  160. function in query
  161. extract records using list of "keywords"...
  162. Selection list of Mondays
  163. While statement
  164. Query Help! (two tables)
  165. Max Date & Time
  166. how to substract total of groups
  167. IIF & IsError in combination always give me "#Error"
  168. help with update query please
  169. Working days/hours in a query
  170. use concatenated expression in Instr function
  171. Display last 12 weekdays data
  172. Updated Table with External Data
  173. Previous months in months order
  174. how to get data that crosses two dates
  175. Extra criteria
  176. Using another date as a criteria?
  177. SUM between two dates
  178. last 12 Business days starting from today
  179. Updage Query Problem...
  180. Displaying a Query Result in Form field?
  181. Count Number of distinct students seen by each tutor?
  182. Date Filtering from my form
  183. Update using WHERE EXISTS
  184. problems with splitting date and time fields
  185. Calculate money spent =<200 for customers during 2008
  186. Unable to Delete a Table
  187. Query to find different between 2 tables.
  188. Sort a calculated query into descending order
  189. IIF Or
  190. Combine several fields into 1 Field
  191. Joining Fields shows duplicates
  192. Criteria Current Month
  193. User-Input queries?
  194. SQL Union group by problem
  195. Append Query through Macros
  196. Question
  197. ADO and Where ((table1.colum1x <> table2.column2x) is Null)
  198. Automatically creating and updating a form record
  199. data type mismatch
  200. update query data type mismatch issue
  201. Different results in query
  202. order query please help
  203. Counting Days Problem
  204. Brackets and Exclamation Points
  205. Calculating average time help
  206. Passing value from text box to query
  207. NEW & DELETED Records Query
  208. Query Returns when data mis-matched
  209. Dynamic Pivot Header in SQL Query
  210. Simple Query I am sure - but I just can't see how!
  211. Wildcard in Query
  212. Query with variables as dates
  213. Simple Query Question?
  214. "In any calendar year" as criteria
  215. Query displaying Dates withing one year
  216. Update SQL in VB problem
  217. Syntax to refer to combo box in query
  218. Query returns no results when expPilot is added
  219. Newbie question - How to show all records in a query
  220. retrieve unique entries
  221. How to do dynamic counting in the query?
  222. appears easy (to me), appeared difficult (to me) : Query
  223. Currency Field in Query
  224. Counting 0s
  225. form based parameter query with multiple values
  226. Update Query question -
  227. Loop and Append Text to a Memo Field
  228. problem with using <>
  229. Strange!
  230. Query on field name and primary key
  231. Querie using check box
  232. limiting a look-up column based on current row data
  233. =( why is this Data Mismatch?????
  234. How to search every field of every record
  235. Queries select rows with chronologically updated value in one text field
  236. Displaying weeks with two digits
  237. SQL Statement correct - But not returning results
  238. cbo RowSource Query
  239. Sorting records with a query
  240. Staff count month on month.
  241. Quering and re-Quering aint working !
  242. Date Query
  243. Help with expiry flags
  244. Update queries and record locking
  245. vat % calculation from a record
  246. Top X Query
  247. Update a Record From a Record in Another Table
  248. Getting a query result by comp'ing a date in a child table to a # in the parent
  249. Combo Box Select All Help
  250. Confused trying to produce results in a query