PDA

View Full Version : Queries

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