View Full Version : Queries



  1. Prevent and signal empty queries
  2. Report/Query needed- PLEASE HELP a begginer!
  3. Search that gives empty fields
  4. Problem with Query
  5. Create an entry in a table based on records matching
  6. ODBC query question
  7. How to present informtaion from two or more differnt tables??
  8. Find records with missing data
  9. Query Help - Can This Be Done?
  10. Query Help - Can This Be Done?
  11. Query Help - Can This Be Done?
  12. Query Help - Can This Be Done?
  13. Query Help - Is this possible?
  14. Consolidating Records
  15. numeric overflow error
  16. Null values
  17. Query for Lowest 2nd lowest and 3rd lowest value
  18. Query to return values that are not equal
  19. reformatting data type
  20. Question about extra text in query
  21. STDEV arcoss multiple fields/tables
  22. Yes/No Problem in Query
  23. Format date yymm based on number of months.
  24. Help with date and location query
  25. Apend query problem text size
  26. Count vs. Function for Attendance Report
  27. Format Double Question
  28. show records only where date is within the next week?
  29. run query in the background
  30. Why is this not updateable
  31. Upper Case Wildcard?
  32. Exporting truncating Memo Fields
  33. Cumulative Totals - Please Help
  34. Sorting Problem
  35. Update Table from Another Table
  36. COUNT 0 query
  37. IIF query not returning result.
  38. SQL querry with parameter
  39. Adding and deleting to a table
  40. a complicated sum query
  41. Subquerie
  42. delete extra fields
  43. number of rows depending on the value
  44. Newbie Dont known where to start my query
  45. I want to save my time
  46. Union Select Query (What am i doing wrong)
  47. Count/Sum Help
  48. still having problem with too many fields
  49. Running a query produce "square" sign
  50. where clause
  51. Please help with delete query
  52. Date Calculations
  53. Help - do I need an update query here?
  54. Sorting ID's to a customer purcharse
  55. Need to have Query Amend a Revised calculation
  56. Multiple grouping criteria
  57. Help on Sums - dates this time + rewriting of data
  58. Iff statement for Query Criteria
  59. Subtracting months from a date in Query
  60. Parameter question
  61. Help needed for Parameter Search!
  62. First letter should be a capital, the rest not
  63. Cumulative Monthly Totals
  64. Cumulative Monthly Totals
  65. Cumulative Monthly Totals?
  66. Queries with no results... results used in forms, reports & queries
  67. Date Format = "Week Of"
  68. Results Formats
  69. elseif type function in query
  70. Writing code for query
  71. Input Criteria into Union query from a Form
  72. Query Help
  73. Blank fields in Crosstab Query based on Previous Query
  74. Modify data using a query
  75. Last of the same data
  76. Query results from Iif statment confusing
  77. IIf Expression
  78. Importing Excel spreadsheet to Access database daily
  79. help with update query
  80. Help with dates in query
  81. Counting unique records in a query
  82. Updating after normalizing
  83. Creating a report from multiple tables/forms
  84. How to identify a charector
  85. Anti-querying?
  86. Describe table
  87. Having or group clause
  88. Number of hour worked
  89. Criteria issue
  90. UNION and inserts/creates its data into a table?
  91. SQL Query Problem
  92. Concatenating fields ignoring blanks
  93. Getting user input for Field and Table on Update Query
  94. Non Storage of Data
  95. Non Storage of Data
  96. Postcode count query
  97. How do I add a variable to LastOf Query?
  98. Urgent help request on query !!!! Please
  99. Last record modified?
  100. A Basic Delete Query Request
  101. autosum in a query
  102. Using checkboxes on forms to modify query parameters
  103. Add Query help for a newbie...
  104. Add Query help for a newbie...
  105. Query help pllllease???
  106. previous working day
  107. Pass-Through Query question
  108. Pass-Through Query question
  109. defining sampling periods using a calculated field
  110. Query – group by 2 like fields in a table
  111. Query expression
  112. Query expression
  113. Query expression
  114. Merging two records together
  115. Update Query Possible?
  116. UTC (GMT) Time to Local time in query. Please help
  117. Selection Query to Form
  118. DLookup syntax problem
  119. Query will not filter by parameter
  120. Creating An Archive
  121. Modal Popup Query
  122. Show records with unique field
  123. Splitting a field’s data into multiple fields
  124. Cached Update Queries
  125. Cannot alter/update records in query
  126. Selecting the most current value
  127. Selecting most current value
  128. Excluding zero Values in a crosstab queries
  129. Complex GROUP BY query
  130. Unique username routine
  131. Query Problem
  132. How to overwrite the result of a query calculation?
  133. Data transfer/conversion nightmares
  134. Left Joins and Group By's?
  135. Delete the actual month date
  136. UPDATE table from query results?
  137. Compare Module Results
  138. Ansi 92 Related
  139. Hide Colums without Data
  140. Filter Criteria - Select one customer or all
  141. Query - JOIN Multiple Tables
  142. Dsum need 2 fields in calc
  143. Access asks for a value - why?
  144. One from Last Record
  145. Query to display data that does not match
  146. email addresses
  147. Capturing most current record (Help)
  148. Date Query
  149. automate the running of a parameter query
  150. seperate date and time fields
  151. Need twp single quotes somewhere
  152. Single Decimal Point?
  153. Date Related query across tables
  154. Lookup values in another table
  155. Importing a text file into access table
  156. Query is too complex
  157. Query is too complex in Ms acess 2.0
  158. CDate function errors
  159. 3 table join, Outer and Inner.
  160. find missing data
  161. Display the max value
  162. NOT Counting Duplicates
  163. Crosstab Qry does recognize another Qry's Between Dates
  164. Help with passthrough query / error 3035
  165. Helpppppppp
  166. Searching a field for specific data
  167. Field Specific Criteria
  168. Cannot find field Name, Pls pls help
  169. beginner's query question!
  170. HOW NOT to send 2 envelopes to the same place
  171. Crazy reference query
  172. Variable input, field sometimes present, sometimes doesn't exist
  173. Simple Default Value
  174. new table permanent table, merging tables?
  175. queries to summarise data
  176. Nz function not working for One-on-One tables
  177. Getting a query into a CSV file
  178. Count records in a query
  179. parameters?!
  180. Transfer Spraedsheet problem
  181. Delete Query Problem
  182. Count and Multiply
  183. Creating a new field
  184. Count taking reference of two field values
  185. SQL to ACCESS query
  186. Comparing to columns
  187. Type Mismatch Error in Query
  188. Two tables with no primary Key but a common field
  189. Peculiar behaviour of query
  190. Append Query Key Violations - Hairy One...
  191. data not showing where no records
  192. Date Query
  193. Date Query
  194. Autofill Query?
  195. Query From (and including) date - Thru (and including) date
  196. Query From (and including) date - Thru (and including) date
  197. Neec a query to pull group of data to multiple forms!?!?
  198. Simply Count Query... why so difficult?
  199. query or vb
  200. How to write query for this database?
  201. displaying query results in a form...
  202. Query for month
  203. Append characters to field data
  204. records older than 24 hrs
  205. ProRate Salary Formula Help
  206. Iif expreesion
  207. Date range
  208. "OUTER JOIN" on Access
  209. DateAdd + Days
  210. Completely Stumped
  211. Finding duplicate records
  212. Query with COUNTing: how to build a normal form for modifying data?
  213. querys and switchbords....
  214. IIF and ISNull in a Query
  215. Inner Join Mutiple Years with 1 query.
  216. How to Make Dynamic Queries
  217. Comparing 2 tables and listing records that dont match
  218. Grouping and Summing Mltpl Records to One Record
  219. Is this kind of count possible?
  220. Comparing data in one column to another column
  221. Complex Calculated Query?
  222. IIF in Query Q - Listing All Entries
  223. Age Calculations Help DEADLINE TODAY
  224. IIF in Criteria
  225. Parameter Query
  226. Subtracting Time
  227. Update Records in a table from another table
  228. Searching Yes/No tick boxes
  229. Append Query for Linked Tables (regularly updating)
  230. Query returning to to much information
  231. Paramater Query that brings up a lookup table
  232. passing unbound value to append query
  233. Date across month calculation
  234. Left Join?
  235. Order by question
  236. Keyword Seach in a Parameter Query
  237. IIf added condition creating dups...
  238. Calculating Days and Hours
  239. Changing Criteria in a query using a form
  240. Query with criteria<>0 problem
  241. Query with criteria<>0 problem
  242. Expression
  243. Union Query - generating from a select query ?
  244. Insert Statement ...order By
  245. Print text based upon field contents
  246. Date value in a Text field problem
  247. Query to select the duplicated records.
  248. query design. current month. ytd, last ytd/month same query
  249. Parse a filed
  250. Adding amounts per record