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. Query of donors by number of donations made
  2. SQL Syntax
  3. Guidance Please
  4. Update Date in Table
  5. How do I ignore duplicates?
  6. Compare Query
  7. how to take pictures from ipod back to computer
  8. Create group to assign policies.
  9. Loss of Data when joiing tables
  10. Datatype Mismatch
  11. dividing a month into 5 production weeks
  12. Re: Crosstab column naming problme
  13. queary help
  14. Can't fine project or library
  15. Make Multiple Tables via Query
  16. MS Jet Network File access
  17. parsing address into house #, Street name, street type
  18. Tracing JET engine execution
  19. How to do MAX-MIN on groups of records?
  20. how do i use count to sum ID numbers
  21. Query and reports "Show"
  22. Access ADO parameter query
  23. Criteria IIf
  24. Problem with a cross tab query
  25. Filtering query by month and year
  26. forcing blank field
  27. String Extraction
  28. Delete Query based on Two Tables
  29. dsum in access query returns null
  30. Converting Access 87 to Access 2003
  31. Crosstab - if no data, then no heading
  32. Help with timesheet query
  33. Top Values...?
  34. Expression help
  35. SQL Programming Book Recomendations
  36. Help with nulls, Nz, etc
  37. Combining counts
  38. Running SQL querries
  39. Query to search by month .. how do I format???
  40. Multiple columns from one set of data?
  41. Query - finding dublicates
  42. My fields won't add toegther in Access (VALUE:([VALUE1]+[VALUE2])
  43. List of database and table Properties in Oracle
  44. Updating fields from one table to another
  45. QUERY DESIGN HELP
  46. Why does query with linked tables return duplicated data?
  47. Advice and guidance please
  48. Crosstab concatenation -- reproduce in Crystal Reports?
  49. Update Query, updating wrong table
  50. Access Query with relationships Too Slow
  51. Count as zero when no data
  52. Update Query, updating wrong table
  53. no zeroes returned
  54. Query for a Quartely Report
  55. Null records with Between operator
  56. Crosstab-force rows
  57. Problem with my Query
  58. Create a SQL on a calculated filed
  59. Append Same Records
  60. Merging With Microsoft Word
  61. Report Query
  62. Make-Table Query Ranking Sum
  63. I need help on my formula
  64. Count totals for each group/set by how many occurrences they appea
  65. Query problem when adding two fields
  66. Max Function Help
  67. Parameter query question
  68. Record Number automated in Query
  69. Jobcodes!
  70. Jobcodes!
  71. How To Find Missing Text Data?
  72. Incorrect "yyyy" for "ww" when using DatePart
  73. Plz Help
  74. I need an SQL expert
  75. Multiple criteria from a single field in a Select Query
  76. selection
  77. select a crteria for a txt feild
  78. Help - Query for Report
  79. Edit a Querry
  80. Creating a zero return
  81. Form based on a query
  82. Convert text to number
  83. Error 3700
  84. CrossTab quiry with Parameters
  85. Null to Zero in a crosstab
  86. reformatting a name
  87. sequential numbering in a query
  88. Can I query more than one parameter in a single field?
  89. Simple requery?
  90. date format
  91. In([variable])
  92. Re: Crosstab column naming problme
  93. run a series of queries
  94. running SQL in vb
  95. 6 Months Due
  96. Cross Tab Query Help!
  97. Union Query question from FoxPro database
  98. Getting Query to show calculation for all records
  99. How do I ask the user to enter the day of the week to search for?
  100. Return just the first record that fits the parameter
  101. Sum of Time
  102. Summing across rows in a query
  103. Use a query to find incomplete fulfillment orders
  104. Divide by zero in Stored procedure (MS Access project)
  105. Duplicate Field Names
  106. Running Sum in Union query
  107. Find a MOnth
  108. Append query problem - "duplicate output destination"
  109. Problem on update query
  110. GLOBAL OFFLINE DATA ENTRY JOBS
  111. GLOBAL ONLINE DATA ENTRY JOBS
  112. GLOBAL FOREX ENTERPRISES
  113. SQL Query Question (<>)
  114. tables merge or math
  115. Quering on a portion of data in a field
  116. Query with criteria for long data type but criteria is double
  117. Last Date
  118. Unique data from Union Query
  119. VB 6.0 - Getting Sql View Text
  120. Birthday
  121. select distinct and another column...
  122. Between/And statement
  123. Using Average In Select Query
  124. Eliminate duplicates from query
  125. Numbering records in a query
  126. Using parameters in Pass_Through queries
  127. Previous Month name
  128. I want to separate data (text) by the space between the words?
  129. Rounding problems with query
  130. the save action was cancelled
  131. Can't update data in query..
  132. Subquery or not ?
  133. Cross Tab Query: "0" in null box
  134. Wildcard for non matching records between tables
  135. Forcing categories in rows
  136. Concatenation
  137. [Select] the results of 2 queries
  138. Updateable Query
  139. SQL query, include all fields except specific fields
  140. VBA query syntax error
  141. Concatenating
  142. quries start with ~
  143. Access not accepting functions in queries
  144. Sequential Numbering on field in Access
  145. Date()-1
  146. Query Issue - Error message 3071 (too complex to be evaluated)
  147. No duplicates question
  148. I don't think this is easy!!!
  149. Updateable query error
  150. sorting question
  151. SQL Incremental numbers
  152. Long-winded question about limiting choices displayed in combo box
  153. SQL Syntax help
  154. Update only one record
  155. Why is my Running Total not working?
  156. combining Select Query with Summary Query included
  157. Return all appointment types
  158. Combine fields
  159. Noob question - Data Type Mismatch
  160. Queries with date fields
  161. Duplicate Entry in Query Return
  162. OT--database design forgot about twins
  163. Join Memo fields
  164. Help with this quey
  165. Suggestions on matching names
  166. How do I have zero values in a query show as blank
  167. Crosstab Worries
  168. access query
  169. time since last high tide
  170. Simple concatenation of fields
  171. Getting Values
  172. Working days
  173. FORM - after update event
  174. Delete matching records from two tables
  175. Updating a field that is a part of the composite primary key
  176. Making list box border disappear when printing
  177. Only show most recent invoice?
  178. Consecutive months
  179. Eliminating Duplicates - Subtracting COUNT values
  180. List box Selection
  181. NZ function
  182. date criteria
  183. Need help with Expression
  184. How to auto fill different rows in the same table
  185. text data in table gets converted to a number
  186. Extracting from a query!
  187. Decimal places in Calculated Field
  188. updating combo box content
  189. Date Add question
  190. Cannot format a date in Query- returns a blank
  191. query sorting question
  192. sql query help
  193. Re: Using two Parameter in one query
  194. adding Time / time Formats
  195. RE: how do I group dates according to month in a query in Access?
  196. Query not working
  197. expression question
  198. calculation based on criteria
  199. RE: Grouping clients by creation date
  200. Query Design Grid IIf Function
  201. Customer Penetration
  202. Datediff
  203. Sum by month query
  204. How to extract numeric portion of alphanumeric data
  205. Like statement
  206. expression in query
  207. Still getting #error in the results
  208. RE: Format Month
  209. Problems with Data Format
  210. Seach multiple tables at once
  211. Can I return the fields that are in a table with a Query (Access)
  212. Combining queries
  213. Invalid alias name
  214. How to display values from the range
  215. Subtraction of 2 (texts) fields.
  216. Re: Using LIKE in a JOIN
  217. Re: How do I delete characters using a query?
  218. Count field values
  219. query criteria
  220. IIF statement in Query Criteria
  221. Re: Append multiple queries into an empty table via code -- code
  222. Not In (Select...) and Outer Join yields diff. result
  223. RE: Format Month
  224. Access/Query Help
  225. Advanced Query question
  226. Access 2007
  227. access 2003 column to row
  228. and or statment
  229. Using a form as a field name
  230. Matching Time-In and Time-Out based on 3 fields
  231. Maturity Date Calculation
  232. Top Value to obtain Top Child for each Parent
  233. The Many Flavors of SQL - Can a SQL Server query work in MS Access?
  234. Re: Append Query Rounding to Nearest Whole Number?
  235. Query with Calculations
  236. Question about Time functions
  237. how do I find employees between 06/10/2006 and 12/31/2006
  238. Append Query - must meet criteria
  239. Re: Multiple field query
  240. wildcard search
  241. Remove commas
  242. Delete Queries and joins - Where clauses
  243. Date Rounding
  244. Query has become uneditable
  245. How to pass a VBA Variable Value to a query
  246. Error: query not updateable
  247. Select field to query based on Combo box
  248. Fill "Month" field from "Date" field
  249. Re: How do I combine records in different rows in one row?
  250. Re: Updating fields in one table to from fields in another table
  251. RE: parameter query only works with one specific record
  252. Query Across Multiple Tables
  253. Re: Query based on Crosstab Qry
  254. queries
  255. Re: Eliminate Duplicates
  256. Lookup Query Help
  257. Re: Query based on a value from Subform
  258. Data Comparison Using Query
  259. Re: Month as Text Parameter
  260. Re: HELP - "Operation must be an updateable query"
  261. Re: Path to field on subform within a tabbed form
  262. Re: Find Monday's Date
  263. Re: Updating fields in one table to from fields in another table
  264. Re: Only want results with three or more entries...?
  265. Query Error - Field too small for data...
  266. Delete Queries Question
  267. Re: Lost password
  268. Date criteria
  269. Re: ORDER BY Clause
  270. Problem with query.
  271. Re: Only 5 results from calculated field
  272. Overflow
  273. ora-00936 in Oracle PT/SQL
  274. Re: select all fields from source table and hide one in resultant quer
  275. Random non-repeating queries MS Access
  276. "Aggregate" error when running query
  277. Re: Please help! Query and Link Table issue
  278. Return all items including letters "bird"
  279. Parameters + Union queries + Order By = Unexpected Result
  280. Where function ???
  281. Re: Query criteria on certain date ranges
  282. Query problem..
  283. Not Like Wildcard in Module code
  284. Query calculations across different records. Is it possible?
  285. RE: Solving problem when hours croos 24h and stating a new day
  286. I dont't know how to tell what the problem is
  287. Delete record from table using a list box
  288. Transforming vertical data to horizontal data
  289. Re: Need help using Select Into or Insert Into with Union function
  290. Re: Use of "LIKE" in a SQL string
  291. Re: Crosstab total question
  292. Re: Solving problem when hours croos 24h and stating a new day
  293. Re: Append multiple queries into an empty table via code
  294. Re: huge problem in querie
  295. Re: Criteria
  296. Re: my criteria should work and it's not
  297. Re: Using LIKE in a JOIN
  298. Re: Using Functions or form controls as criteria in a select query
  299. Combo box conditional row source
  300. Re: Using LIKE in a JOIN
  301. Space Issue
  302. Re: Return a list using highest (most recent) date
  303. Re: Find Unmatched Query Wizard (Access 2003)
  304. move all characters before first comma - help!
  305. concatenate field in a query
  306. Awkward Query Idea / Help!? Percentiles.
  307. Re: Query criteria on certain date ranges
  308. Re: Query criteria on certain date ranges
  309. Re: Update Query
  310. Zip Codes Help!
  311. VBA and Access - Reference Book Recommendation Please
  312. Re: Getting Rows into Columns
  313. Re: Unique Counting -- use Group By
  314. Re: Getting Rows into Columns -- Crosstab Query
  315. Stuck with GROUP BY query
  316. Shipping Labels
  317. Varying Query Performance
  318. Query: Remove all but the first occurance
  319. Two Criteria
  320. Re: Listing the Last two results by date (Complicated)
  321. Not It Query
  322. RE: group by / count question
  323. First() won't work - subquery question
  324. Need correct order for month names in cross tab
  325. Re: parameter query
  326. Re: Setting row numbers
  327. Re: Access Querry
  328. Re: how can i get all records with the first name i enter in access?
  329. Re: parameter query
  330. What Field is Not Matching in Unmatched Query
  331. Re: Gotta be simple. I have a Date field and a Day field...
  332. Re: Gotta be simple. I have a Date field and a Day field...
  333. Re: Gotta be simple. I have a Date field and a Day field...
  334. Re: Gotta be simple. I have a Date field and a Day field...
  335. Re: how can i get all records with the first name i enter in access?
  336. Access Query Help!
  337. Re: Eliminating Duplicates in a Query
  338. Update table using partial word match
  339. Count of query records
  340. Re: Add rows by user specified range
  341. Dynamic query filters, like Excel's Autofilter
  342. Re: Finding a non-existant field
  343. Nest iif - can't get the syntax right!
  344. Current date less 2 months
  345. Append qry only works the second time
  346. Can I append to 2 different tables?
  347. Difficulty in downloading Eboot.bin using Jump code
  348. Re: Expression Queries
  349. Re: find record with max date less than or equal to today
  350. RE: Calculate moving range
  351. Re: Problems with Date Filter
  352. append query posting data entry line too
  353. RE: how to clear a parameter in a Crosstab query
  354. Date Fields in Queries Access 2000
  355. Sum Top n Scores
  356. Tics to minuts
  357. Re: Change Values in a Query
  358. Selection between dates for computed field
  359. Update Query Problem
  360. Update Query using date in text format?
  361. Qry to group & Sum all data but only returning the location of where Max Pts was
  362. Querying for postcodes within an address against another masters t
  363. combine multiple rows in same field
  364. Eternally Functional Criteria
  365. RE: Enter Parameter Value Issue when running query with 2 tables
  366. RE: Enter Parameter Value Issue when running query with 2 tables
  367. Controlling Query Output with Checkbox on Form
  368. how to create a function w/in a query?
  369. DoCmd.OpenQuery vs CurrentDb.Execute
  370. Query help, date criteria
  371. Input parameter for append query
  372. office outlook
  373. RE: Query by Numeric Value Range
  374. RE: concatenate based on 3 tables (many-to-many) relationship
  375. Re: Build Query Based Upon The Current Record
  376. runtime error record is deleted
  377. Queries
  378. Re: Calculating averages of dates
  379. Re: Calculating averages of dates
  380. RE: Random choices for creating a sequential list
  381. Re: accumulating total
  382. Re: Update SQL
  383. RE: calculate average of records selectively counted
  384. Enter Dates into Table with SQL
  385. Re: Delete query criteria
  386. Re: convert to multiple columns
  387. Re: crosstab query the date columns are not in order
  388. Re: DateDiff Expression
  389. RE: find record with max date less than or equal to today
  390. Union query (I thinK)
  391. Automatic append from form to tables
  392. Restricting the data displayed with record navigation buttons
  393. Apostrophe Problem
  394. Generate a new table
  395. Counting number of events per month...?
  396. Total Query
  397. Newbie Query Question
  398. Update Query???
  399. A case sensitive version of "SELECT DISTINCT" for Jet SQL
  400. Search 2 fields for ANY word in TextBox criteria
  401. Delete X characters from end of string
  402. interesting query issue...
  403. Re: content of the listbox to merge a result in a textbox
  404. Re: Criteria in Yes/No Field
  405. Re: Grouping by Date
  406. restricting records in a combo field in a datasheet
  407. Track and save changes to records
  408. RE: Archiving
  409. RE: Query with multiple fields and search combinations
  410. Help with Date Query and Report
  411. Timestamp Criteria in Query
  412. Re: Update Query Replacing text within HTML code Conversion Failure ER
  413. Re: Problems with Duplicate info.
  414. Re: How to make a parameter query give a drop down list
  415. Re: How to make a parameter query give a drop down list
  416. Runtime Error '3075'
  417. Label Count
  418. Re: Multiple fields, same criteria
  419. text to number format or preceeding 0
  420. Two or more consecutive days
  421. Re: Pulling known data from tables FMR
  422. Re: merge databases
  423. Re: Non-Updateable Query
  424. Re: Updateable query
  425. Re: ROUNDING TO THE NEAREST NICKEL
  426. Re: Identify Unmatched Records
  427. using queries on source safe
  428. SUM OF DISTENCE
  429. month based update query
  430. DE-Concatenate but maintain relationship and record structure
  431. Forward dating and then grouping
  432. how to round?
  433. Re: Unmatched query - help please.
  434. Sum <
  435. Re: I Need to replace many text area in a field with replace function.
  436. Multiselect parameter query
  437. Lost automatic Like operator???
  438. Re: Add record if not updateable
  439. Union Queries involving 2 Queries
  440. Re: Unique key count
  441. Re: If, then in a query
  442. Re: Deleting commas in a field query
  443. Need help with account rec aging
  444. DLookup Problem
  445. Repeating Query
  446. How to delete first n records from table in ms access
  447. RE: multi calculations
  448. Query does not show last date.
  449. RE: Parameter Query- Query not using other criteria
  450. Re: Numbering Records Sequentially within Each Day
  451. Limiting records returned from query
  452. Re: index fields on SQL tables
  453. Open directely to Pivot Table
  454. RE: Odd or even
  455. RE: Blank Columns Everytime
  456. SQl query in VBA - SELECT inside an INSERT INTO
  457. Re: Odd or even
  458. Re: conditionally round decimal numbers from 8 places to 6 places
  459. Re: Why does this query "work" this way?
  460. Date Issues
  461. Re: conditionally round decimal numbers from 8 places to 6 places
  462. Re: drop down list within a query?
  463. date add
  464. Re: conditionally round decimal numbers from 8 places to 6 places
  465. Use Replace function to reduce postcode to postcode region
  466. Accessing Row from 2nd Query in Form using On Current
  467. Drop down box of saved queries?
  468. Re: Date and Time stamp
  469. Re: Date and Time stamp
  470. A Challenge: Summary and Append Queries
  471. RE: Narrow crosstab results
  472. INLIST()???
  473. Splitting field
  474. Re: Combine Query Results without Duplicating Data
  475. Re: How do I query similar fields from different tables
  476. PLEASE HELP !
  477. RE: How do I query similar fields from different tables
  478. RE: Combine Query Results without Duplicating Data
  479. Re: combining different data types into memo field
  480. Mysterious quote marks appearking in Notepad
  481. Specific Dates vs. YTD
  482. Problem running query in code
  483. Re: problems with exporting query to excel
  484. Re: Counting the number of DATES in a Project Field
  485. Help with 'NOT' query please.
  486. Re: Create number used for barcode
  487. Combining Multiple Records
  488. Find inbetween date
  489. Recursive query
  490. troubles with calling function from a query -
  491. Drawn and Quartered
  492. Stop Me Please
  493. put data into one row
  494. Use result of expression in another expression??
  495. Re: Automatiically Fill in column
  496. "If - Then" Return These Records
  497. Prices on Date Schedule
  498. Get value for "Field" in a Query from a combo box in a form
  499. Obtaining a return value from a query
  500. Show whole dollar amount only
  501. Prompt to Select Query to Run
  502. Re: show items not included in query results?
  503. RE: students taking only one course
  504. Calculate a calculation result
  505. Re: date issue zero fill dates
  506. Parameter dialogue instead of my form problem
  507. All or Nothing..
  508. How to write a query which will allow me to capture multiple events
  509. Vartype question
  510. Invalid use of vertical bars error
  511. Need help with Access query following an "Upsizing"
  512. missing sequential numbers query
  513. Re: date issue zero fill dates
  514. Re: Fixing a value
  515. "Stepping Through" Queries -- Debugging Tool
  516. Re: split into lname,fname,mi
  517. Re: split into lname,fname,mi
  518. changing the design of a telephone nnumber
  519. Can't figure it out query
  520. RE: Multiple Parameters
  521. RE: Passing value
  522. Re: Converting a name in a text field
  523. Re: values not displaying in queries
  524. Re: Sum Text Field Where Sum Cannot Equal Zero
  525. Re: Multiple Parameters
  526. Help with percentages appreciated
  527. Re: Bold lines within a table in Word
  528. Re: Function or nested IIF in query
  529. Re: query
  530. Modify Sum in a query
  531. Running an insert query on a remote db
  532. Re: Using Case Statement?
  533. Re: Date Query
  534. Setting criteria
  535. RE: Finding Hierarchal level
  536. Setting criteria
  537. query to do counts of yes's in yes/no boxes..
  538. Change field value question??
  539. RE: students taking only one course
  540. Outer join confussion
  541. Missing Expression
  542. Can't get query to select date from form
  543. Re: Primary Key
  544. RE: How do I create an Autonumber in a Union Query to avoid making
  545. Re: Parenthasis issue
  546. Re: Primary Key
  547. ASP LIKE query using parameterized query
  548. RE: Wildcard
  549. Limit query to span of id #s
  550. Re: Help - Query too complex
  551. Re: Need most recent date out of many
  552. Re: Update Query
  553. Re: Help - Query too complex
  554. Re: students taking only one course
  555. Re: Update Query
  556. Re: Wildcard
  557. Re: Query with a sub-table
  558. formatting number as fixed not bahaving as expected
  559. Re: Shouldn't a LEFT JOIN work this way?
  560. Re: yes/no box
  561. Using the result of a calculated field in another calculated field's expression
  562. Re: Create New Table not from Query
  563. Re: select syntax using value in a form field as the where clause.
  564. RE: Date query
  565. Re: Make Table Query
  566. Re: Show just one record each person-different results
  567. Re: Select statement using Variable Data
  568. Re: AutoNumber in a query
  569. Re: Query Help - top 5 values
  570. Re: Display data from another field.
  571. RE: Query Help - top 5 values
  572. Re: report parameter to open table?
  573. Re: Sinlge entry for multiple queries
  574. Re: Problems with IIF
  575. Re: Variable Select Statement (ASSIST PLEASE)
  576. Re: AutoNumber in a query
  577. Re: Sinlge entry for multiple queries
  578. Re: Percentage
  579. Re: SQL INSERT statement in VBA
  580. can't update all the records-PROBLEM
  581. Re: SQL INSERT statement in VBA
  582. Re: Finding records by free text search
  583. Part appending a field (Access 2000)
  584. Re: Percentage
  585. Creating comma delimited values...
  586. Re: Double criteria in one field
  587. Re: Show just one record each person-different results
  588. Re: Finding records by free text search
  589. Viewing Results from Multiple Queries
  590. Faster to use "Group" or "First"?
  591. Cant call stored procedure which uses table variables?
  592. Using Subquery for Criteria
  593. Re: How do I check value of field in multiple records with IIf stateme
  594. Re: getting fields from subform
  595. Re: changing subdatasheet property w/DDL
  596. Re: changing subdatasheet property w/DDL
  597. Re: changing subdatasheet property w/DDL
  598. Re: how do I change value settings from dollars to pounds
  599. Append specific records within a form by using a button!
  600. Advanced Select into statement in Access
  601. Re: RecordCounts
  602. Query by Main form and give the result as input to a combo box sub
  603. Re: "Between" Parameter Query not working with DateAdd
  604. Time Sensitive Calculation Question
  605. RE: Report Layout
  606. RE: Why am I only able to use the primary key as criteria?
  607. Re: Budget v Actual
  608. Re: Why am I only able to use the primary key as criteria?
  609. Query to find longest name of dupe records
  610. Re: can we merge the mdb files?
  611. Re: Query with a sub-table
  612. Re: Update query
  613. Specific data search
  614. Re: "Between" Parameter Query not working with DateAdd
  615. query count records
  616. Insert X records in table based on value from another table
  617. Append Query Question
  618. How do I export stored procedure results to excel?
  619. Re: pass-through query link to local table
  620. Insert X records in table based on value from another table
  621. Re: parse names
  622. Re: Calculation on incrementing record.
  623. Re: Eclude dates
  624. Re: Expression Too Complex
  625. accessing a linked dbase IV file is slow...
  626. Re: "The setting for the ListRows property must be from 1 through 255"
  627. Re: Not enough space on temp disk - Query
  628. Populating an OLE table field using vba
  629. seeing the append query before updating records
  630. Re: how do I avoid "expression too complex" error with nested IIf?
  631. Re: Trying to find a single quote (') within text
  632. Query won't open in design view
  633. Re: Trying to find a single quote (') within text
  634. Re: Covert text (rates) into number
  635. Re: Use a form to pass parameters to a query
  636. How do I export stored procedure results to excel?
  637. Need qry to show 2 records
  638. Re: My Eyes Are Crossing
  639. Re: Random Random Random Query or Make Table HELP PLEASE
  640. Use Query to find due date
  641. Re: how do I avoid "expression too complex" error with nested IIf?
  642. Pivot Records
  643. how to duplicate records
  644. Convert SQL query into Access query
  645. Re: make table query
  646. Query help, please
  647. Re: Complicated update query.
  648. Splitting a field
  649. Missing fields
  650. Re: Can anyone please help
  651. Re: using Max Date on Grouped fields
  652. Re: How do i run a query when on an open form event
  653. Re: Sort Problem when Using Make-Table Query
  654. Count By Hour
  655. Running queries on new record and record modification
  656. Re: query with two tables
  657. Look up - on a query
  658. Weird Parameter problem
  659. If condition in Builder
  660. RE: Email most current record
  661. Cross tab query with more than one data column
  662. Combo Box and SQL
  663. Comparing telephone numbers
  664. Transaction Support in Access
  665. RE: User Defined Pop Up Warning
  666. Update query
  667. Re: Parameter??
  668. Re: Finding a record with given value in a certain string location
  669. Re: Office Online Discussion Groups
  670. Re: Pass Through Query / Make Table
  671. Re: Pass Through Query / Make Table
  672. microsoft access error 3306
  673. Framed Option Group / Nested iif Question
  674. Question Regarding Combining Duplicate Records
  675. Getting distinct counts in a totals query
  676. Re: comment on columns in tables ( ACCESS / SQL )
  677. Re: Office Online Discussion Groups
  678. Re: Groupby not working
  679. Re: Finding a record with given value in a certain string location
  680. TimeValue and #Error in null fields
  681. Re: comment on columns in tables ( ACCESS / SQL )
  682. Re: Update query - incrementing #
  683. Re: Trace a query or a table...
  684. Re: Trace a query or a table...
  685. Query and Chart
  686. update query - memo field
  687. getting data from parameterized query
  688. Re: Simple addition
  689. RE: Simple addition
  690. update query / RND() question
  691. Report Date Range
  692. Pulling data out and understanding total queries
  693. Re: summarizing for parameters across columns
  694. Append Query with VBA and SQL
  695. Data Field Problem
  696. Nest IIF in Access 2002
  697. Filter query using checkbox and IIf function
  698. INSERT UNION QUERY
  699. create() is to DDL as select() is to ???
  700. Can this query be done?
  701. Re: Limit Records Using Table
  702. Change Field Value Depending on Date
  703. Re: make field accept zero in a crosstab query
  704. using access to rename image files
  705. Re: make field accept zero in a crosstab query
  706. Quick code
  707. Opening Query in Design View
  708. Re: Query Using Min
  709. Query to group, then get values associated to smallest grouped number
  710. Re: Combine Fields
  711. Using append/update queries to transfer record data from one Table to another Table
  712. how to use different queries to transfer data from one Table to another Table
  713. how to use different queries to transfer data from one Table to another Table
  714. how to use different queries to transfer data from one Table to another Table
  715. Re: How to calculate the difference between two dates without counting
  716. Query Problem
  717. table population via form & query
  718. search and match TEXT and return what is leftover?
  719. search and match TEXT and return what is leftover
  720. conditional concatenation of fields
  721. search and match TEXT and return what is leftover
  722. Show all machines or only one
  723. DateAdd Frustrations!!!! Please Help!!!!
  724. 2000 MsACCESS concatenate: Combining multiple rows into one row
  725. Re: Access 97 and SQL Server 2005
  726. Date Criteria Issue
  727. Re: using SQL to archive data
  728. Re: Retrieve select record from AutoNumber field
  729. Re: Zero Count not showing?
  730. Re: using SQL to archive data
  731. DateAdd returns Error in calculated date field
  732. Sorting Crosstab Query
  733. SQL How-to question
  734. YTD Subquery problems
  735. Hockey Stats Database Total Help
  736. Re: extract right 3 digits into existing field.
  737. Re: extract right 3 digits into existing field.
  738. Re: I'll rephrase the question
  739. Re: extract right 3 digits into existing field.
  740. Re: Converting Adjacency model to nested set model
  741. Re: Access 97 and SQL Server 2005
  742. Cross Tab Query
  743. Re: Queries - combining fields
  744. Re: #Error on IIF Statement
  745. IIf(IsNull)
  746. Join Yields Unexplainable Results
  747. Re: Create Save Queries
  748. Re: Union Query
  749. How do I exclude data
  750. Percentile function in MS Access