PDA

View Full Version : Microsoft Access Queries

Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 [79]
  1. using an excel IF function in Access?
  2. Re: Queries/link relationship
  3. Logos and Background in Access
  4. Update query rounds answers to integer
  5. How to give group by in the select query
  6. report to excel
  7. Queries Using Switchboard
  8. Cancel button on query pop-up
  9. convert dates to numeric values
  10. Mark records after mailing
  11. Need to create a crosstab query
  12. querying for a record after a select record
  13. Select query
  14. Re: max columns in query
  15. Re: parameter order backwards
  16. Catching Duplicates
  17. Re: max columns in query
  18. Make table query makes a table automatically
  19. Query By Year
  20. Multi-UNION select
  21. Time Calculations
  22. Duplicate Query
  23. Errors with ACCESS
  24. case sensitive query criteria
  25. Access Queries
  26. Searchable Forms
  27. Need help
  28. Re: Alert Generate
  29. How does access relate to queries
  30. Table or Update Query??
  31. Date difference
  32. Update Query w/ Date from the table
  33. Re: 'Now' formatted as date only
  34. Simple 3 table join popping up a parameter box?
  35. DSum in Query
  36. And another update qurey problem
  37. Grouping by time interval
  38. Re: Crosstab Query or Report is better for my Problem?
  39. Re: Crosstab Query or Report is better for my Problem?
  40. Query showing number instead of text
  41. Re: IIF in a query
  42. Problem with imported data
  43. Duplicates in a query
  44. Export fixed length text file from MS Access 2000
  45. Summing like fields in queries or tables
  46. specifying criteria
  47. form fields in a query in Acc2000
  48. money - try it!
  49. Help
  50. Re: Another update query problem
  51. Append query adding text with null value in the primary key
  52. How does Access handle huge dynasets
  53. Showing Query Calculated Fields in Reports
  54. What to Choose?
  55. Null dates
  56. Delete using a join
  57. Re: Syntax Error
  58. Simple Query
  59. MS Query failure
  60. running a query thru a macro
  61. Re: Crosstab w/Explicit Parameter
  62. DAO to ADO SQL
  63. querying a record after a specific record
  64. Different field names, same data
  65. Entering criteria for values
  66. Re: "removeable" criteria?
  67. Flatten a one to many relationship result in a query
  68. How to give between dats as criteria in the append query
  69. Delimiter
  70. Unspecified field
  71. Circular Reference
  72. ? for Tom E
  73. How to update Rows
  74. autolookup queries
  75. Re: Duplicating Query Entries
  76. Query to find records containing all words
  77. Access 97 queries to search both local & linked tables?
  78. Re: querying a record after certain qualifications.
  79. Make table query, Report, module, macro?
  80. Crostab query as a sub query?
  81. INSERT INTO programmed query failure
  82. Need help w/ difficult query
  83. Speed it up
  84. SQL INSERT Query Master Detail Table
  85. Re: Unexpected results, [Date] Is Null
  86. Re: 'Now' formatted as date only
  87. Setting Query Parameter based on Form Entry
  88. Using server power to run queries
  89. Access Query problems
  90. Can you help with a complex query?
  91. Re: Query based on a table
  92. Best way to weed out duplicates
  93. Re: no. of days
  94. Unexpected results, [Date] Is Null
  95. Re: Good Access (not SQL Server) SQL reference
  96. Speed first use of combo by running query at form load?
  97. Union Select Failing
  98. Re: Using Variables in Expressions
  99. Re: Access Query
  100. Re: 'Now' formatted as date only
  101. Re: 'Now' formatted as date only
  102. aggregate calculations
  103. aggregate calculations
  104. Re: Like Query from 2 tables
  105. quick! convert text field to numeric (WITH negatives)
  106. Comparing Date Fields
  107. Count the number of records a query returns
  108. Displaying Boolean as Text
  109. Extracting Part of Field
  110. Microsoft.Jet.OLEDB.4.0, Visual Studio C++ SP5
  111. How to find out the last inserted row in Access
  112. How to update the table
  113. Invalid Argument
  114. nonuser looking for simple count
  115. Catch-all column in crosstab
  116. Re: IIF Criteria
  117. Flatten a table
  118. Re: Autonumber as a result of a query
  119. Autonumber as a result of a query
  120. Duplicates -- Keep Most Recent Date
  121. Doing the impossible? Totals, Avgs and Counts on a form!
  122. Joining 2 Tables
  123. Unique records
  124. Re: no. of day
  125. Sorting a query/report by text within a queried field
  126. Table Name in field
  127. Update Query Question on a Number Field
  128. Date stuff
  129. no. of day
  130. Re: Writing a Query in Access
  131. Access 2000 Pass Through
  132. IIF statement in a query
  133. Correction to previous post "Help with update qurey"
  134. Re: Difficult ....very difficult
  135. Re: Difficult ....very difficult
  136. Help with "Update" Query
  137. Problem with imported data
  138. Filtering Records with a Form
  139. Autonumber as a result of a query
  140. Generating Alert
  141. Field showing record number
  142. Updating Master information...
  143. Creating controls on fly based on a query
  144. i need an sql or .net expert !
  145. Showing all months
  146. Re: no. of days
  147. Why can't I run this query when others can???
  148. Re: Crosstab w/Explicit Parameter
  149. Undefined Left Function
  150. ErrorMessage - Field Limitation
  151. Using a grouped sum for a calculation
  152. Pass Through Query troubles
  153. How to Max(Date) ?
  154. Re: Data Validation
  155. Re: Blank line between each group
  156. strIng expression
  157. Re: unusual request
  158. update query
  159. Sort is grayed out
  160. Querying from a form
  161. Date range in criteria
  162. Query that returns x number of rows
  163. Pulling non-normalized data and inserting new row
  164. Number Generator
  165. QBF Limit?
  166. DAvg Function
  167. Re: Append Query with a parameter?
  168. Re: Need help with Alter Table Query
  169. Cannot define field more than once
  170. Subtracting time
  171. Query Stumper
  172. Re: Determining Usage Patterns using a Combined Date Field
  173. truncation on query from word to access
  174. Can't delete some records using delete query
  175. max query on query depth
  176. Re: recursive query
  177. Re: Trying to make a memo field hold more than 64000
  178. Re: Can anyone help with the SQL for this?
  179. Need help making a query
  180. parameter query to find field entries in a list
  181. Exporting leading zeros
  182. summing query tutorials?
  183. working day
  184. Re: query criteria expressions based on a form
  185. summing a column
  186. Criteria with user defined function
  187. Transpose data
  188. Re: Query: Tracking problem
  189. Archiving with Queries
  190. Re: Combo Box in Query
  191. Crazy Sorting
  192. Can't get AutoLookup to work
  193. Queries and subdatasheets
  194. updating reports
  195. trailing Zeroes
  196. Re: Combo Box in Query
  197. update query fails
  198. Dates in a date range
  199. sorting records
  200. Query and report differ
  201. How to Update a Rank Function
  202. Possible bug using Clng or iif function
  203. Getting all of the information to appear
  204. I need to find similar data in two columns of a table
  205. Joins and Relationships in Queries
  206. New Records Missing from Queries, Reports
  207. Re: Deleting Records
  208. Similar table record comparison
  209. Joins and Relationships in Queries
  210. Total Entries
  211. Win Server 2000
  212. ODBC/Access LIKE fails for subquery
  213. generating a product ID
  214. This should be simple...
  215. Queries in MS Access 2002 with date field in where clause
  216. Average 4 fields
  217. Multiply Queries
  218. Re: how to query random results?
  219. Find beginning of alpha characters in a string
  220. Multi-Selection List Box
  221. Object Not defined error
  222. Camera_Toy_Videogame_Laptop_sale
  223. Automatic Import Of Picture from a file location
  224. Error while inserting null data in Append Query
  225. Date = Date() idiocy
  226. question about "unique values"
  227. combo/query question
  228. Re: Deleting Records
  229. make serial for output records
  230. opening a query from a form command button
  231. Queries with regular expressions
  232. Query displaying only part of a record
  233. RE: MID function does not work correctly
  234. Re: YTD continued
  235. Problem with "Find Duplicates Query"
  236. Queries, programmatically within Visual Basic
  237. using a combobox to show data in a textbox on the same form
  238. Calculate age
  239. Re: change data format in an append query
  240. Access2002: Case sensitive or insensitive?
  241. PC-PJ2-X3 mebius
  242. DateDiff won't work in query expression
  243. [table]![field] loosing brackets
  244. Re: YTD continued
  245. Duplicating Records
  246. Query problem
  247. Re: Distinct in queries?
  248. beginner query question
  249. calculating average of all records in query
  250. Re: beginner query question
  251. publishing reports in Word
  252. Re: change data format in an append query
  253. Re: YTD continued
  254. Format Not Carried from Make-Table Query to Table
  255. Re: Ranges in queries
  256. Extract Portions from String
  257. Re: Converting Dates to Text ????
  258. Re: Accumulative Totals
  259. Help with a Response
  260. Re: Excluding records in a query
  261. Excluding records in a query
  262. Re: Converting Dates to Text ????
  263. Yet another error - Object doesn't support this property or method
  264. Data Type Mismatch Error on 'Yes/No' fields in Query
  265. grouping by month
  266. Adding Rankings in a Query
  267. Re: Getting a query to Sum data over a period of time
  268. Re: SQL query
  269. Re: Unpacking fields
  270. Switchboard
  271. Count: multi-field count
  272. Time Calculation on a form
  273. PLS HELP: SELECT TOP 100 PERCENT VS. SELECT ALL
  274. Calculations from 1 field used in another
  275. Update Query
  276. Name Seperation
  277. YTD
  278. [table]![field] not retaining brackets
  279. Trim after space
  280. Re: query dependency tree
  281. Data Search Engine
  282. drop down list in query
  283. Re: sql syntax - if .. then update else append
  284. Re: Unpacking fields
  285. Re: Dates in a query
  286. Problem with imported data
  287. Accumulating totals
  288. please help
  289. Re: select records
  290. Concatenating Fields
  291. Error 3021 - No current record -
  292. Re: Dates in a query
  293. Set window position
  294. Transposing from normalized database to "denormalized" version
  295. Re: Help if you know! (carriage return (CR) code)
  296. To modify table through code SQL
  297. Grouping Records Into Date Buckets
  298. Re: Updatable Query
  299. Query Help.
  300. Re: Aggregate Functions on Time Values
  301. yetqwyrt
  302. Realtime
  303. Re: Formating line breaks in queries
  304. function left() is not available in the query
  305. auto fill a date series in make-table query
  306. Calc no of working days in current month
  307. Queries in form view
  308. Search Problems
  309. Camera Sale -Nikon , Canon, Minolta , Sony ,Xcam2 , Fujifilm ,
  310. RE: Access XP: "Invalid Argument" error in make table, append queries
  311. Dates
  312. I'm getting in a real muddle...
  313. Consolidating records
  314. listbox column property does not work in query criteria
  315. update query syntax
  316. WeekDayName Function as criteria in Query
  317. Counting Null Values
  318. interpolation in a query
  319. related fields
  320. advanced queries for a student portfolio
  321. MVPs ?
  322. Re: DATE QUERY
  323. Querying records prior to a certain period
  324. Querying a Date field
  325. Cannot update table via query
  326. update query with left function
  327. Re: Microsoft Access Bug related to query size ??
  328. Highest Value
  329. Query Problem
  330. Re: Limit queries
  331. quires
  332. Re: automating run date in a query
  333. Re: Duplicates in Union Query
  334. minus, difference, where not exists, resources
  335. Re: arriving at balance due
  336. Setting Is Null criterion programmatically
  337. Eval function and Date
  338. tracking changes
  339. I deleted, now I'm depressed.
  340. Duplicate records
  341. Re: tracking changes
  342. Printing Query's Relationships
  343. Calculate date and days.
  344. DSum
  345. Complex Query! For me at least
  346. Re: syntax error (missing operator) query expression
  347. Re: query returns text value, want currency
  348. nesting
  349. Deleting Duplicate Records
  350. Update query against SQL table
  351. Re: Dsum function
  352. Undefined Function 'Replace' in Expression
  353. domenuitem
  354. Date difference
  355. Re: Max of field
  356. Two Queries Inside One?
  357. Dsum function
  358. Last characters of a string
  359. SQL Distinct / Distinctrow
  360. query\adding rows
  361. Several Query Questions
  362. Lookup Queries
  363. Counting Consecutive Hours
  364. Re: Update B4 Query
  365. Cant get rid of Duplicates in query
  366. PC is slow when opening queries
  367. Re: Criteria
  368. Queries versus tables
  369. query
  370. Re: Subtracting numbers if fields
  371. Re: Date Formats
  372. Field's Default Values (SQL)
  373. Finding Specific Data
  374. Trim function doesn't work
  375. Date Query - Access 07
  376. 12 digits format
  377. Re: Use same parameters for several fields
  378. Latest Date Query
  379. Select fielda for report
  380. Re: age
  381. Criteria "Or" Problem
  382. ADV: Free games for life
  383. custom dialog box for entering query parameters
  384. Updating tables
  385. Query problem
  386. Week breakdown to days
  387. Concatenating Fields.
  388. Create Table Query (SQL)
  389. Detailed instructions on creating a query
  390. Re: SQL error
  391. Re: Take param from lstbox on form
  392. Query problem
  393. Concatenating fields
  394. Sorting records by day of the week
  395. Criteria Help
  396. query problem
  397. Re: age
  398. Change row and column positions
  399. numbers of date between many dates: more explanation
  400. Random Sample
  401. Re: Bitwise
  402. Query
  403. Question on Date Range in Query
  404. Re: Total query
  405. converting characters using an update query
  406. Wildcards
  407. AutoLookup Queries
  408. Selecting Date Range in Queries
  409. create table script with boolean field ...
  410. Find Duplicates Query
  411. open access data base in dos batch file
  412. Re: "overflow" Error in a Totals Query
  413. Problem with subquery
  414. query results into text file
  415. Official versus unofficial parameter
  416. Update form B4 run query
  417. Empty Cells
  418. Query data base and create text file
  419. Running Sum
  420. using records in table as query criteria
  421. multiple parameters
  422. Re: SQL Help for a form. (not sure to post in queries or formscoding!)
  423. Re: If query
  424. Missing Operator Error in Access
  425. Query
  426. Simple query
  427. Troubleshooting query
  428. Re: AVG sort error
  429. Next most recent date
  430. Re: Format Date in Query
  431. Query to Return Between And Dates and Unknown Date
  432. Report margins
  433. command if and where
  434. ARCCOSINE FORMULA
  435. Undefined Function Format Error
  436. Slow query when linking to local Access table
  437. Calculated field
  438. Query field property problem
  439. Time interval
  440. Concatenating fields
  441. Notes Truncating from dBaseIV table
  442. Hair Puller - Query Error
  443. Re: problems with Recordset
  444. Updating Query
  445. Total row in Crosstab Query
  446. WHERE(OR....AND)
  447. Re: numbers of date beteween many dates
  448. Re: Identity column and clean up
  449. Re: Operations with fields values in same table
  450. Re: copy table from one db to another in one step
  451. workaround for dates in non date fields <?>
  452. Query problem
  453. Query to count game wins/losses
  454. Using an Excel list as criteria in a query
  455. How to merge two separate append queries
  456. RE: Query use in form displaying records
  457. Union query to add duplicate records together
  458. Crosstab Query Question
  459. probs on left join to another query
  460. deleting
  461. find duplicate entries without exact same field values
  462. Re: Removing Unwanted Prefix
  463. Empty parameter in a query
  464. Re: Commission Query
  465. 2 quick (hopefully) problems
  466. access 97 memory error
  467. Query stops responding Access97
  468. New Query Button Unaccessable
  469. Re: Undefined function Format$ ...
  470. Query Based on the partial contents of a name....
  471. Auto Look-up Queries
  472. Re: Append Query
  473. Re: Append field Total records to another Table
  474. Q: comments in Access SQL
  475. MS Access Query Dependency Add-in
  476. Re: Queries in Access 2000
  477. Re: Auto Look-up Queries
  478. Re: Create table dfault value
  479. Randomly select a given number of records
  480. Re: ADO returns different results from Union Query
  481. troubleshooting append query
  482. show all of the record from one table but filtered by a different table.
  483. Help - Data type mismatch in criteria
  484. Memo only allowing 512 characters
  485. Finding the Median
  486. Re: If then statement in a query
  487. Re: Total Row in a Crosstab query
  488. Dealing with Duplicates after the fact
  489. Find + delete from text field
  490. Re: Q: comments in Access SQL
  491. Re: Concatenate Fields in a Query
  492. Display MS Access Query in Excel
  493. Problem summing 3 fields in a query
  494. Compare similar fields
  495. Re: data type mismatch in criteria expression
  496. List Box in a query
  497. Merging duplicate information
  498. Re: data type mismatch in criteria expression
  499. removing 'extra' key columns from join of crosstabs
  500. Le calcul de taux interet
  501. compacting a repairing
  502. Most Effective Solution
  503. Spaces & Ampersands In Queries
  504. Re: need expression filled when not blank
  505. MS Access on Pocket PC?
  506. Re: DLookUp function
  507. Re: Too many fields defined Error
  508. Re: address problem again!!
  509. Re: Query in form?
  510. Re: query dependency tree
  511. Subtracting Days from a Date
  512. Most recent Date problem
  513. Finding all instances of query usage
  514. Runningsum or Record Number in Query?
  515. ADO returns different results from Union Query
  516. Dcount problem
  517. Find question
  518. JOIN Query question
  519. Re: update a field based on the summation of the other table
  520. Query is doubling my records
  521. Re: address problem again!!
  522. Re: address problem again!!
  523. Re: most recent date
  524. Format Date in SQL Query
  525. the sql and structure
  526. Re: how to select only a certain number of records in a query
  527. query to work out dates
  528. Remove Extra Characters in Phone Field
  529. Re: data type mismatch in criteria expression
  530. Re: multiple values for a parameter
  531. Re: Open Access97 form maximized
  532. Query And Chart/Grapg
  533. Access database for distribution
  534. Running Sum in Union Query
  535. trolling for spam
  536. Help Needed
  537. Re: query a date range
  538. Re: query a date range
  539. CONTAINSTABLE v/s FREETEXT
  540. Execute Query in Access from an ASP Form?
  541. Re: Access Query using IN
  542. Re: Access Query using IN
  543. Defining Combo Box values...
  544. Access Queries with Unknown Number of Params
  545. Upcoming Support Webcasts
  546. Import failure
  547. MSWord - Access single data source problem
  548. Query crashes Access 2000
  549. Re: Lookup Table Help Please
  550. Speed of Jet vs VBA
  551. Re: Lookup Table Help Please
  552. Primary Key Help Please
  553. SQL - Updating Empty Text Field is enterring -1
  554. Re: Training Curricula - Data Extraction
  555. Re: Need help with data analysis