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. Avoiding Null Values using nz() won't work with Access ODBC driver
  2. Query based on continously new created tables
  3. stored procedures and dates
  4. Regarding Microsoft MVP Papajohn claims...........
  5. RE: Query Creation
  6. HELP!!!
  7. Re: Pulling one mailing label per person
  8. Select a day in a month
  9. MIcrosoft MVP Papajohn claims Movie Maker 2 Non-Linear Editing Environment
  10. Find unmatched records
  11. Excluding records based on dates
  12. Group Ranking Problem...
  13. Small Project Need Help
  14. Re: Special Characters in SQL stmt
  15. Calculate the age
  16. Help writting simple query
  17. Need technique to analyze data
  18. Parameter from a function
  19. Removing message boxes associated with append queries
  20. Concatenation
  21. change start value for auto number
  22. convert access qry to ansi 92 equivalent
  23. order totals
  24. Is it possible to use "all" in a paramater query
  25. Is it possible to use "all" in a paramater query
  26. Current date
  27. Problem with IN clause
  28. query returning multiple copies of same record
  29. Change report sort order
  30. Re: Sort Order
  31. Re: finding specific time values in where statement
  32. Re: deleting only certain records
  33. Query to remove mult. lines in table
  34. Select that is not in a table
  35. Duplicate Records
  36. Invalid argument
  37. Default printin gin Access
  38. Union data from two databases
  39. Strip field of AutoNumber
  40. Getting a cummulative total from a one-to-many
  41. Very complex crosstab query question
  42. autonumber selection in access
  43. Screen "freezes"
  44. Selecting data with CHOOSE
  45. wildcards in query from form
  46. Crosstab ?uestion
  47. Multiple criteria through a form
  48. Multiple criteria through a form
  49. Move records between linked tables
  50. Multiple Criteria Query using a form
  51. Showing properties of a QueryDef
  52. Linked Table Layout
  53. Monthly Report
  54. How to add a remark in access query
  55. Caculate Text
  56. unique record based on date query
  57. Creation Of A Query
  58. Icon
  59. Query result is wrong?!
  60. Access Query - Case Sensitive
  61. Adding multiple records linked by a primary key
  62. Simple query
  63. Problem with Aggregating functions in update queries
  64. Quote Marks ( AGHHH!)
  65. Blank Forms
  66. Test for and group consecutive numbered records
  67. Query is too complex (run-time error)
  68. Partial Text String Manipulation
  69. Counting
  70. Criteria
  71. Re: Need Criteria syntax for query "run" by a Form
  72. Copy Data Definition Query to another database
  73. Searching for partial records
  74. Count or Sum consecutives values
  75. Count unique values in a field
  76. Nested Queries with a Parameter
  77. Need parameter query results to populate form and subform fields
  78. a little confused
  79. Date vs DateTime selection in Query
  80. Multiplying Records
  81. Parameter query doesn't work with my format
  82. Most recent entry for each item
  83. lookup query question
  84. change search criteria in a query
  85. Formatting a query calculated field
  86. Counting # of Rows by Age
  87. list columns
  88. Form Query
  89. Populating a report from the results of a query run by a form
  90. Populating a report from the results of a query run by a form
  91. Populating a report from the results of a query run by a form
  92. Populating a report from the results of a query run by a form
  93. Populating a report from the results of a query run by a form
  94. Question about server filter
  95. Re: IIF function error
  96. SQL call to VBA, named or omitted parameters syntax?
  97. Crosstab Query
  98. multiple criteria
  99. multiple criteria
  100. multiple criteria
  101. multiple criteria
  102. multiple criteria
  103. SQL Syntax Help
  104. Between 2 Dates Query
  105. Between 2 Dates Query
  106. Between 2 Dates Query
  107. Between 2 Dates Query
  108. Between 2 Dates Query
  109. Null value for query criteria.
  110. Append Query
  111. sort union query
  112. Evaluating the data in SELECT statement
  113. IIF statement problem
  114. Search Query
  115. Need some query design help....
  116. db size question
  117. Help with a Max Query
  118. Append Query to Split Table
  119. Extract numeric values from string
  120. Split Function in Query
  121. Append query in code
  122. Displaying Latest Date Only
  123. Dcount
  124. Parameters using 'Between Date 1 & Date 2' - Need to use 'Like' too!
  125. Zero value in query
  126. SUM(TIME FIELD)
  127. Date Splitting for Other calculations
  128. Changing the datasheet View on Query
  129. Overflow error from select query
  130. Date & Time Calculations in Queries
  131. Date parameter
  132. Vanishing Posts
  133. Auto input
  134. Finding matching records
  135. Display Last Record
  136. Counting the number of rows by month
  137. RE: Parameter Query Issue
  138. Re: Parameter Query Issue
  139. Counting records
  140. Counting: Query by Scale an Project.
  141. Time Required to run Create Table Query
  142. Query by Scale and Project
  143. How to concatenate several entries to same table
  144. Querying Multple Tables in Access with different fields
  145. calculated fields
  146. Query & calculated field
  147. Update Query
  148. Q: multiple inserts in Access query
  149. Query criteria from open form or if field is null
  150. Create query to return data by week for graph
  151. RE: Logic Question
  152. Referencing a Query in Excel
  153. Date Funtions
  154. Logic Question
  155. Count in Query
  156. Drop down box in a Parameter Query
  157. Join changing mysteriously
  158. How to report combined lookup fields as text?
  159. Networkdays Function in Access?
  160. Copy a field to another - same table
  161. Ask for weekdays only
  162. multiple tables in one query
  163. SQL query
  164. Sorting queries
  165. Using input parameter query for creating charts
  166. Manual Entry of Criteria
  167. Looking back several days
  168. Help with searching for a substring
  169. converting date format from dd-mm-yyyy to yyyy-mm-dd
  170. random help
  171. Can I use a Public Variable as Criteria in QueryDesign View?
  172. text automatically changes
  173. Choose Fields from a FORM (table from combo) for excel export
  174. Choose Fields from a FORM (table from combo) for excel export
  175. Lookup to unrelated table
  176. Query Help
  177. How to code query with text column
  178. Re: BOF ??
  179. Operators
  180. Null Values in a Make Table Qry
  181. QueryProblem
  182. Filtering Selections
  183. Filtering Selections
  184. SELECT * INTO doesn't work
  185. SELECT * INTO Doesn't work
  186. Re: deleting only certain records
  187. Need help with Criteria for Queries Pls
  188. Query Returns No Results, I need to see a 0
  189. Re: BOF ??
  190. Convert ss# text to number
  191. Text file format conversion
  192. Get rid of auto message when about to update query
  193. Unique Record
  194. CLEAN expression for Access to remove nonprinting characters?
  195. Append Mailing Info to records in a table??
  196. Finding Missing data
  197. Help with DateDiff and Count Expression
  198. display sequential list of numbers
  199. Re: comparing similar tables
  200. Query Results - Data Type Discrepancy
  201. Re: Last 8 Weeks....
  202. Adding a calculated column to a query
  203. Queries
  204. Query against - ODBC Connect Oracle Table
  205. Re: BOF ??
  206. Unmatched Query Wizard
  207. Access 2002 Data Validation Rules/Text Help.
  208. DATEDIFF function
  209. Re: DATEDIFF function
  210. 100 records x10records query
  211. Current Month
  212. Re: Multiselection in List box.. I need a little "push"
  213. random sample
  214. crosstab query total column
  215. Can I use an Or statement in five fields?
  216. Q. I need to base a query on 2 different fields.
  217. Query for NAMES first/last
  218. Query for NAMES first/last
  219. Saving an edited query
  220. split records
  221. Networkdays
  222. Filter Weekdays and Intervals
  223. How to get the list of ACCESS tables ?
  224. Custom functions in queries
  225. Changing data type in make table queries
  226. Shifts over two days
  227. Easy question
  228. Searching by month from more than one table
  229. Between Date()-#07:00:00# And Date()+#17:00:00#
  230. Formula
  231. Sum Query
  232. access
  233. Updateting Tables From Previous Database
  234. Can somebody please help me?
  235. Weird Behavior of UNION
  236. Syntax problem - can someone help me please
  237. Form filter
  238. query based on text box value
  239. Subtract minutes from times
  240. Changing the Datasheet View of a Query
  241. Query problem...
  242. current date minus a day!
  243. outside joins (many-to-many)
  244. The date of the start of the financial year
  245. Complicated...I think
  246. Birthday Lists in MS Access
  247. Parameter Queries - Add a lookup
  248. Append Query question
  249. Convert() Problem
  250. AR Aging
  251. ACCESS 2000 and Visual Basic
  252. Re: Query check
  253. Delay
  254. Random # of records based on user input
  255. Updating Field
  256. Flush buffer or simular in form.
  257. applying DISTINCT to only one field
  258. Advance feature of Query
  259. Week of Year
  260. number field
  261. Creating a query column to calculate End Time & Properly format
  262. Criteria for Query
  263. Using "replace" in update query
  264. week numbers
  265. Button to copy and paste a record
  266. Select a control using text manipulation
  267. Query speed affected by sorting
  268. Calculate 6 months out
  269. Function that returns an Array with a Query
  270. queries for deleting data
  271. Date -7 Criteria
  272. Use of variables in a query?
  273. count instances of a name(s)
  274. Format([Hours] * -1,"Fixed") ERROR
  275. union query.
  276. dump fields into a memo field
  277. carry value from SQL to Query
  278. Print only the last date
  279. Re: finding specific time values in where statement
  280. How do I stop Access from asking confirmation to delete a table in a Make-Table Query?
  281. Compiler Error
  282. Access Query
  283. How to select records by month by using a pop up?
  284. Extracting an Area Code from a 10 digit numger in a query
  285. Sequential Numbering
  286. Unwanted Dialog Box
  287. Update query to update more than one table?
  288. Sort on partial field
  289. Editing records in a query
  290. "REPLACE IN FIELD"
  291. Criteria- Help Please
  292. Interesting Question
  293. picking first or last row
  294. Cheap CPU, RAM. PIV2.8E only US$200!!!
  295. create query to select only 1 member of a household based on address
  296. Union Query failing on Order By clause
  297. DATE() issue
  298. Data Type mismath errors after months of no problems
  299. Q. query for space in several fields doesn't work ( =" " )
  300. Simple Sum Calculation but I can't work it out......
  301. complex queries
  302. Comparing field values
  303. Sum Time
  304. Cycle Through two Tables
  305. I have one too...
  306. Another crosstab question...
  307. Crosstab parameter help
  308. Combining different values in the same field in a query
  309. Re: cannot go back 6 months
  310. Records Discrepancy
  311. Rounding?
  312. a character specific query
  313. Average Problem
  314. Re: cannot go back 6 months
  315. Deleting records from find duplicates query
  316. Builing a query from selection criteria on a Form
  317. help with a Query Expression (Builder)
  318. help with a Query Expression (Builder)
  319. Week ending Friday Inventorys
  320. Please help got access query but can't get it to work on sql-server - what's the access specific part ?
  321. Top 3 values tie breaker
  322. Sum Query
  323. Query using max
  324. tuff query
  325. Trouble in writing a result from a calculation back to a field.
  326. Top 5 values by grouping
  327. Using wildcards in queries
  328. Aggregate Function query
  329. INSERT INTO using WHERE??
  330. Inventory Update Query
  331. populating combo box
  332. user input min/max error
  333. Delete Query Question
  334. DCOUNT function in query?
  335. two columns into one
  336. Re: Printing one address label from 2 lists
  337. Two tables where one value is not like the other.`
  338. Crosstabs and Parameters !!??
  339. Distinct Records
  340. user input min/max error
  341. Optimize Select insert and update
  342. A query that returns the record counter
  343. Pad field in query
  344. Calc values from a form viewed back in a query table
  345. Query from Form when "Not Like"
  346. bar charts displaying negative values
  347. Prompt
  348. Export / Query Problem
  349. yes/no
  350. Entering a null value in a field
  351. adding totals across
  352. Multiple queries based on the same table?
  353. Copying text portion of a field to a seperate field
  354. Ranking Within A Totals Query
  355. queries, sort by 2nd choice
  356. Formula for pulling certain data
  357. Comments
  358. List Pulldown Box in Query
  359. Calculating accumalative fields
  360. Re: Access97 Sum function dropping decimals
  361. Re: Need help using "Like" in a programmatic SQL statement
  362. RE: Need help using "Like" in a programmatic SQL statement
  363. Crosstab Query
  364. User Intervention required
  365. How do I search for a name using just the first letter of the last name?
  366. New queries are saving automatically
  367. Referencing Crosstab Query Values
  368. List Boxes not linking
  369. Problems with Count query
  370. Queries blank???
  371. How can i add a counter for duplicate records in a query?
  372. Count/Quantity field
  373. Need help updating records...PLZ HELP ASAP
  374. Merge to Word
  375. Need to update/edit text within a field...HELP
  376. Displaying the most recent date only
  377. Finding calculated values FROM a form to a query
  378. A foolproof way to use dates in queries ?
  379. conditional INSERT
  380. How do I structure the where clause to select rows whose data contains spaces?
  381. "Undefined function 'Date' in Expression"
  382. Parsing out leading Zeros
  383. Installation Error.... Please Help
  384. Summarising by 1st 3 Characters
  385. Using Access Forms with SQL stored procs
  386. Update with incrementing values
  387. Difficult rowsource
  388. Date Issue
  389. Limiting Query Results
  390. Pass thru query help
  391. change data type
  392. layout of output
  393. Custom Function
  394. Multiple Tables and Record Counting
  395. What's wrong with this syntax please
  396. Error when running qry!
  397. 300 nokia games
  398. Can access read values from the registry?
  399. Referring to an external database
  400. allot more help
  401. Datetime Parameter problem
  402. Joined on two fields
  403. Concant a date field and a time field
  404. query help
  405. Calculating percentages in access for survey information
  406. Counting?
  407. counting
  408. update query help
  409. Query for foreign language
  410. adding to two tables in one query
  411. Make table query
  412. Running totals in a query
  413. Displaying an Error dialog box when #Error results
  414. Balance Queries
  415. Excel DateValue Function in Access
  416. I need the calendar to show 7 days forward.
  417. compare records
  418. Date calculation help needed
  419. Date Calander for Query/Report
  420. Now() > DD HH MM query??
  421. Wild Cards in Queries?
  422. Query Help
  423. Query with Function for criteria
  424. changing blanks to null
  425. Recent date query
  426. Impossible query?
  427. including two?
  428. Making dynamic data static at a given period
  429. Only show weekly dates
  430. Delete Query
  431. keyword lookup system guidance needed
  432. Error Messages
  433. Supress Spaces
  434. ALTER COLUMN
  435. Re: Finding Lasts months records
  436. Query Problems
  437. Is this Correct?
  438. Is this Correct?
  439. Display all records or from a Combo Box
  440. UDF in RecordSource: How to promp for parameters?
  441. Sub count???
  442. using form input query
  443. Multiple queries to one table
  444. how can I do a sumif array type function?
  445. Re: UNION query returns as datatype mismatch error
  446. Why sometime dup rows?
  447. New developer newsletter
  448. Re: simple calculation?
  449. Run queries made by code
  450. Re: UNION query returns as datatype mismatch error
  451. Re: UNION query returns as datatype mismatch error
  452. Invalid password when using IN clause
  453. A querry would not run in server but would run in local machine
  454. Updating a Paradox table
  455. How do I add or subtract
  456. Do a calculation on a series of dates linked to a case
  457. Well this is infuriating...bad totals on query
  458. Appending Memo Field
  459. query for field a based on contens field b
  460. Group by
  461. Query for Date
  462. Display All Records
  463. Re: Outer Join Issues - Please Help
  464. Simple Access SQL Query?
  465. Simple Access SQL Query?
  466. Re: Outer Join Issues - Please Help
  467. Cannot Update Data in Query
  468. Outer Join Issues - Please Help
  469. Outer Join Issues - Please Help
  470. How to refer to a query from VBA?
  471. Add result from previous record
  472. "Optimize for N rows" command
  473. Re: Insert carriage return in query
  474. Need help to construct this query...
  475. Sloooow Queries
  476. Pull letters of a text string
  477. Delete query - Linked by CLNG won't work - But why not?!
  478. Duplicate Values in a Query
  479. Calculating Remaining Days
  480. could not delete from specified tables
  481. Multiple queries to one table
  482. Re: simple calculation?
  483. Create a numeric colum in a query using a string
  484. Adding an Item to a Query Result
  485. Export query to Excel
  486. Missing Data
  487. Adding the count total of several fields
  488. Friday inventory report
  489. one simple criteria input box - google style
  490. Inefficient Query - Please HELP
  491. converting string to date
  492. MS Access query failing in ODBC
  493. Multiple queries to one table
  494. Group and Sum Friday-Sunday Orders But Not Other Days
  495. Problem with Many to One Query
  496. 0(Zero) in query
  497. subtract from all previous records
  498. Problems correcting Circular Reference!
  499. Query Truncates Field Data
  500. Date in query
  501. Writing a Query based on Day of Week
  502. query not working
  503. Passing variables to Query Criteria, Can anyone help with this?
  504. Mail merging multiple fields from single lookup table into word via query
  505. select 2nd - 5th records?
  506. time calulations
  507. Re: SQL to Calculate Balances
  508. Day count calculation?
  509. Report Overflow Error
  510. search query by date
  511. URGENT Microsoft Access Inquiry
  512. Iif statement again
  513. Using Variables in an INSERT INTO query
  514. FORMAT and TRIM not working on one lap top
  515. Alot to ask but can you explain?
  516. Query - Filter Duplicates Problem (Easy?)
  517. "Make Query by Form"
  518. Parameter Query
  519. Object variable or With block variable not set (??)
  520. Query's returning values that are double
  521. date()
  522. Query expression needed to edit data
  523. Sum
  524. product key
  525. Update field on form after one field is chosen
  526. Drop Down List in Query
  527. INSERT: Text field with single- and double-quotes
  528. Multiple records
  529. Joins... Urgent
  530. export table
  531. Join a concatenated field
  532. Converting number data to mm:ss format
  533. Expression works in one part of report not another
  534. Help.... Adding/ Sorting
  535. Full Outer Joins
  536. Testing to see if a query is open
  537. Calculating pace for a query
  538. leading zero's were lost
  539. Rounding Down
  540. Automated Import
  541. Error Emailing query in Macro
  542. Find Unmatched Query Wizard Problem
  543. Removing carriage returns
  544. Query for quotes, is this possible?
  545. Missing in sequence query
  546. How to get data in a form from different records out of a query ?
  547. Enter parameter once for multiple queries in a Macro
  548. Access Query
  549. Run queries made by code
  550. Finding duplicate memo fields?
  551. LIKE help
  552. Dates Without Years
  553. Maximum number of "or" statements in a select query
  554. Oracle connection dropped
  555. Query using module variable
  556. Wild Card Concatenation With User Input
  557. DSum
  558. Help me please before I go insane
  559. Thanks
  560. Crazy Join Statement
  561. Qry-data format issue
  562. Products not on master file
  563. Inherited problem joining tables on more than one field.
  564. problems with 'group by' result in select query
  565. Crosstab Column Sum - Impossible??
  566. Very strange Update query needed
  567. Data Tyep Mismatch - Run Time Error
  568. What query works in place of LEAST and GREATEST
  569. What query works in place of LEAST and GREATEST
  570. Multiple data Update
  571. Export date field w/out time data
  572. Saving Querys
  573. Pages
  574. Quarter/Year
  575. Access 2000 problem
  576. > 0
  577. Wild Card Concatenated with User Input
  578. Can an update query do this?
  579. 5 last entries
  580. Re: APPEND QUERY EXCLUDE NULLS
  581. Query for lowercase characters
  582. APPEND QUERY EXCLUDE NULLS
  583. update query for postal code
  584. Create a table
  585. Duplicate field values in 2 tables
  586. query(static ??)
  587. Date Diff in a query or form
  588. Crosstab query with date problem
  589. Display Rows as Columns in Query Result
  590. Function is not available in expressions
  591. Duplicate Update Problem
  592. Pass Thru Query
  593. Converting Select Query to Make Table in Code
  594. Integer Query
  595. Query same field from multiple records
  596. Simple Search? (Oxymoron)
  597. Query Help
  598. At most one record can be returned by this subquery...
  599. Rounding numbers to thousands
  600. sort problem in a report!!!! urgent
  601. Past 12 Months
  602. Past 12 Months
  603. Semi-Duplicate Records
  604. Change entry query
  605. Query Across Two Databases
  606. latest record query
  607. Find bookings for a date
  608. About to give up..... on coding a query
  609. Events for navigation buttons
  610. Error 3061 (Too few parameters, Expected 1) ???
  611. Multiple criteria searches
  612. Mutiple table query
  613. Crosstab query
  614. Simple Update Query
  615. Is this the right way
  616. help with sub select -urgent - please
  617. Can I query where the table name will change?
  618. Repost: Query Return Criteria
  619. query problem
  620. Query Problem
  621. SQL Type conversion in MSAccess 2002
  622. Re: query, subquery, ODBC to DB2 mainframe; all in one! Works, butwhy so SLOW!
  623. .runsql works / .execute fails? help appreciated
  624. Re: refresh a query
  625. Select Update and Export Unique Values
  626. Append and make table concatenates memo fields
  627. Test SQL Statements
  628. Queries?
  629. Why is DAO.QueryDef is so slow
  630. Access 2.0
  631. Need help with query
  632. Date plus 30 days
  633. Re: Combining a field in multiple records into a single memo field
  634. ADO use to show Query Results
  635. Update query strips leading zero from text
  636. Combine multiple rows into single row with sql
  637. Most recent date
  638. Query Logic Problem!
  639. Formatting dates
  640. Month Range
  641. Function to look for similiar text
  642. Function to look for similiar text
  643. Runtime Version of Access 2002? Where?
  644. Sort by Month
  645. PHP Scripting
  646. How do I define field types
  647. create new records from udate query
  648. Query too complex
  649. Function is not available in query expressions
  650. "Constant" value in SELECT query?
  651. CREATE VIEW?
  652. Using SUM in query
  653. Combining Data that is not the same date
  654. DateDiff
  655. Re: Combining fields from multiple records into a single memo field
  656. "External table not in expected format"
  657. Avoid duplicate entry
  658. Clear contents ofg a field after ticking a check box
  659. SUM 15+ fields based on Date & Location
  660. Query to Access : does'nt see tables
  661. Querying changes over time
  662. Help plz..........?
  663. Sub Select Help
  664. ADDING Amount to get ONE TOTAL~!
  665. number of digits
  666. blank date
  667. Calculate short time
  668. conditional formatting of date in query
  669. linking tables where data-type is not equal
  670. Access is incorrectly rounding numbers that end w/ .50 down
  671. Rounding Numbers UP
  672. access query
  673. "Constant" value placed in all records?
  674. "Constant" value placed in all records?
  675. "Constant" value placed in all records?
  676. Overflow Error Message
  677. Query
  678. Union Query issue
  679. preserving the sql format
  680. Expression Builder
  681. update query error
  682. AbsSum Won't Work With Null Values
  683. dates
  684. Quartile Calculation - from a Newbie
  685. running a query to compare 2 date fields
  686. running a query to compare 2 date fields
  687. running a query to compare 2 date fields
  688. Proper Case
  689. Special Crosstab
  690. Counting Offices
  691. Counting Offices
  692. Multiple Prints
  693. Simple select query problem
  694. Correct SQL in Code Please
  695. In Crosstab Query If Any Values Are Null I Want Sum to Be Null
  696. Query objects
  697. Recordset
  698. Concatenating Numbers/Converting Dates to Integers
  699. Concatenating Numbers/Converting Dates to Integers
  700. Concatenating Numbers/Converting Dates to Integers
  701. Proper Case
  702. Overflow (Error when running a query)
  703. Removing Input Masks
  704. Parameter Query - Action Query
  705. Top Values
  706. Removing weekends from a date range
  707. FYI - Sql for splitting a delimited concatenated string into separate strings/rows.
  708. IIF SQL 2002
  709. Retrieve most recent date.
  710. Create numbering
  711. Multiple outer joins in access
  712. Access reserved error, Access2002.
  713. Query Problem
  714. Finding One Example From Several Categories
  715. an unusual query?
  716. IF in T-SQL Column Expression
  717. IF in T-SQL Column Expression
  718. updating (using a unbound box on a diff form)
  719. SQL subquery problem - bookings database
  720. Query to group mostly-alike rows
  721. Multiple instances
  722. Access 97 Reference Books
  723. Proper Case
  724. numerical value of text
  725. Latest Date Query
  726. Error 3163 Couldn't Insert or Paste; Data Too Long for Field
  727. Output month as name
  728. Action Query??
  729. Action Query??
  730. More query help needed!
  731. Date Query
  732. Using data from global variable in SQL statement
  733. Archive data from joined tables to joined tables
  734. Changing Data Format
  735. to add a # of days... not including holidays/weekends
  736. problem creating a query that searches for field created by control source
  737. Query
  738. Parameter Query with a Condition
  739. Division in an expression
  740. Querying from the same table
  741. assigning values to dates
  742. Showing Total in design
  743. One Select 2 databases
  744. I am confused on a querry
  745. Can you refer to a variable in a hard query?
  746. Query
  747. Word Wrap
  748. Make Table Query v Select Query
  749. Top Values
  750. table contents to string