PDA

View Full Version : Queries

  1. Fed up and Frustrated!
  2. Accessing previous row
  3. Query in Access
  4. Problem in getting count of distinct values!!!!!
  5. Query Question
  6. Need Help w/ PAC Database
  7. Comments In Queries
  8. Sum(IIf(IsNull(query1dates.fdate),0,[fhours])) AS Sumfhours
  9. Append Query from MS Excel File
  10. Query shows more digits after comma than there is in a table
  11. Need some help with query
  12. How to create a list Box which debends on a value in the next field?
  13. SQL - join three fields - same table into one column
  14. Comparing A date to a date
  15. Update query then record changed fields in new table
  16. Run query same time every day
  17. Select consecutive dates in a query
  18. Pull random records
  19. Lookup Table Value
  20. Data type mismatch in criteria expression
  21. Query muliti-criteria to be entered from 5 Form combo boxes???
  22. Newbie Question: How do I attach a form to each record in a query's recordset???
  23. checking Query content
  24. How Do I Automate My Queries?
  25. query using 2 columns
  26. Passing values to query
  27. How do I make this Query?
  28. Compare Query
  29. Open Querry
  30. Combo box Default Value?
  31. SWITCH query help
  32. Searching Two Colums
  33. Restrict calculated field
  34. Comparing entries based on Form, Date Range, and Type
  35. date sort problem from a newbie
  36. Calulate days between dates in a recordset !
  37. Query
  38. Relative Date Query......help
  39. Using DLOOKUP with totals (aggregate) queries?
  40. Sorting by Day
  41. Reminder date
  42. Query between two fields
  43. Automatically generate new record(s) based on event
  44. Add Text Space
  45. Attach Database
  46. Return amounts divisible by 12
  47. Julian Date and Military Time
  48. query help statement
  49. How to call Function from Query?
  50. Calculate average
  51. Multiple Reference Query?
  52. Crosstab: show line for Month with no activity?
  53. Copy records without duplicates
  54. Running a query with related tables and a null value
  55. How to get query's parameter value
  56. Make Table Query to Find Partial Matches
  57. INSERT INTO with multiple rows
  58. SWITCH expression using values from 2 fields
  59. counting the YES responses
  60. Query Parameter question
  61. Internal OLE automation error
  62. Calculating %
  63. Form Query using Sub/Embeded Form Data
  64. Setting Query Criteria
  65. Accept User Input for a Query
  66. ADODB Order Question
  67. Why am I getting a Data Type mismatch in this query?
  68. Query Help!!
  69. Help Needed - Parameter Query from Multiple fields
  70. Database queries run on different machines give different answers
  71. query help
  72. Eliminating Duplicates with different field values
  73. Can anyone conform this query /?Will +Rep
  74. Hide Duplicates from Find Duplicate Query
  75. Combining Multiple update queries into one SQL Statement
  76. Querrie from Multiple Tables
  77. Finding similar terms in fields from two seperate tables
  78. End-User Specific Query
  79. Union Query to only select numbers
  80. Date Criteria messing up my query
  81. Calculated Date Fields
  82. Access 2007: XML Error on exporting query?
  83. ANOTHER date range issue
  84. Sorting a profit margin by date
  85. error with Update Query
  86. Append Query
  87. how to display table colums.
  88. add hours
  89. Entering additional line
  90. select identical rows in table
  91. select identical rows in table
  92. Top Ten count iif report
  93. iif question
  94. Look for data across 4 fields
  95. Help with Criteria Field
  96. Query Challange
  97. IIf(year="2007",PuraseDate > #1-1-2007#,"*")
  98. Missing data after sorting query results
  99. Search criteria
  100. Subquery, Date, and Time
  101. Update query for Boolean flag?
  102. Group By first 3 digits of 6
  103. How to Strip out Data in An update Query
  104. Help with an IFF Statement
  105. Question about Totals in Crosstabs
  106. math inside the query
  107. Joining Logical Tables
  108. Simple Query based on another simple query not working
  109. combining values from 3 fields in one new field - removing spaces
  110. One Query Two Date Ranges
  111. Query - System Date
  112. Trouble with Date Fields (sum)
  113. DateDiff in query
  114. Populate a Table with IF function
  115. Query Criteria Quandry
  116. how to display value on query
  117. Error with Crosstab query
  118. Update with Last Records
  119. Group daily dates into weekly dates...?
  120. Error message on update query
  121. Logging a Total
  122. Criteria: Too Strict (way too strict!!!)
  123. Autonumber in Query
  124. Copying Expressions in a Query to a Table
  125. Inserting Dashes in Phone Number field
  126. Cascading Sum
  127. Improve crosstab queries performance
  128. Counting most recent 12 weeks......
  129. Calculate Price Change
  130. Using calculated fields in other calculated fields
  131. Query Not Showing Desired Results - HELP
  132. Reference a field value specific to a record in a query?
  133. date difference
  134. Parameter order
  135. Sort of a reverse crosstab concept
  136. Help with using function in Query
  137. Showing the last 2 records per person
  138. ‘No value given for one or more required parameter.’
  139. Replace query value "0.0.0.0" with alternate txt "HP Procurve"
  140. merging column name and value in one record
  141. This query is killing me - IsNull problem in IIf argument
  142. Simple query help please!
  143. Test Query Results
  144. Append records if date not listed in table
  145. Most efficient way to populate query
  146. Sorry to keep posting
  147. problem with deleting
  148. First Records or Certain Data
  149. Ranking problems
  150. help please
  151. Function from a Combo Box
  152. Question with Criteria
  153. Formatting Issue with Query
  154. Check if field is Numeric
  155. date calculated field
  156. Conditional Criteria for a Date Field in a Query
  157. Unrelated table as criteria
  158. Query doesn't return record with null field
  159. INSERT INTO Syntax
  160. Date difference... (I think)
  161. Date Ranges
  162. Query to show total count
  163. Problem running Query
  164. Auto Fill data in textbox from Combobox selection
  165. Forced to save query
  166. Sum(IIf(DateDiff("d",[Date Entered],[MaxOfDate Entered])>15,1,0))
  167. Date range of [datefield] minus 1 year
  168. changing UPPER CASE letters to lower case doable?
  169. Update Query Requires Source With Pk
  170. Top Values in sub groups
  171. SELECT specific via filter or select all if no filter
  172. Query field If Like and Not Like?
  173. Count Text Values on a report
  174. query Order By help
  175. Umatched Query Help
  176. Query has week number and year from a date field.
  177. call a existing query in vba
  178. How to select top three values from a crosstab
  179. Mailmerge update field once complete.
  180. Using combobox values in query
  181. How to stop the attached Pop Up Box
  182. Select using LIKE
  183. Problem with differing values creating multiple lines
  184. Help with my Date Query
  185. expression to complex message
  186. Dropping a recordset into Excel
  187. Editable Queries
  188. Convert length of time to years, months, and days
  189. Datediff Problem
  190. Help with Date function in query...
  191. Am I doing something wrong?
  192. Help with a query
  193. Record Count
  194. Display Maximum Value of a Field
  195. Nested Joins
  196. Query to call Date Range parms for a report
  197. getting query criteria from one source
  198. Rank Query
  199. Using a forms filter string to filter query
  200. ambiguous outter joins
  201. Criterior in Select Query
  202. Using parameter queries instead of binding to control source for criteria?
  203. Pulling out non payments in a date range
  204. Update or Append? and how to accomplish this?
  205. IIf not working
  206. Query criteria help
  207. how to write these queries
  208. Can 1 query delete data from 2 tables ?
  209. runtime error '-2147217904 (80040e10)' --should be easy thing Version: 2003 (11.0)
  210. Splitting one field into two based on contents.
  211. Delete query
  212. Formatting select query from text to date
  213. Query question, subquery error.
  214. Displaying the Date the record was generated in a query
  215. Help with Union/Join
  216. Get Rowscource in Select Query
  217. error in a query filtering records in a form
  218. Help joining data from two queries
  219. Query to get previous Day and week based on today's date
  220. Using replace to update/change two values
  221. count YES repsonses across a row and group
  222. calculate average time
  223. Query Critera -> Text Box
  224. copying contents of one field to another [duplicating]
  225. Query based only on tables as defined in date/customer criteria
  226. Totally Stumped
  227. returning records for one-to-many tables for missing "many" record
  228. Searcing on three digits only
  229. running a Query from a Menu
  230. Re: Form Paramanters in Query
  231. Setting specific criteria
  232. Sum of Entries
  233. SQL Syntax
  234. Update a table using Query
  235. Append Query Question
  236. Sum of values of a field
  237. Concatenate Leading Zeros, and Storing 11 Digits in Numeric Field
  238. matching strings except last character
  239. Multiple IIf statements
  240. SQL Statement Help Pls
  241. Query from two fields
  242. Mail Merge with Sub Records
  243. Using Like in Query Field name
  244. Meaning
  245. Create new field
  246. Primary key from two fields
  247. combining names in a query
  248. Created Table using a field from another table
  249. Puzzled?? Comparing dates
  250. Current Month results