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. Creating a CD w/ a database
  2. Run Query error
  3. Transpose Vertical to Horizontal
  4. Prior record
  5. Making a Query compare entries in seperate tables
  6. "IN"
  7. a query to view all the invoice numbers and their totals
  8. Getting a percentage
  9. Change sub-form using combo box & query?
  10. Update query- update a copy of entire table
  11. How do a make a query see a text string for criteria as a Variable not a Value?
  12. showing columns and a column's sum
  13. Adding two fields together
  14. passing a parameter to LIKE "*.....*"
  15. DATE CONTROLED AUTO ENTRY
  16. related ranking prob.....
  17. Action will reset the current code in break mode - bug?
  18. Using NZ function & Allow Zero Length
  19. parameter query
  20. Lookup in a query???
  21. Max Date?
  22. "data type mismatch in criteria expression"
  23. Export query result to .xls file
  24. Beginner here ...
  25. AutoNumber in Query
  26. Subquery problem
  27. Using calculations in ACCESS
  28. create an accumulated field
  29. Sum of more then 80 values in one record
  30. URGENT!
  31. Using value from Combo box in query
  32. using LIKE
  33. Query w/ User Input
  34. Re: forat to Days, Hours and Minutes
  35. Re: forat to Days, Hours and Minutes
  36. Paged query
  37. multiselect listbox value
  38. Re: weird problem
  39. Re: weird problem
  40. Re: Help please
  41. Calculated query from a calculated query
  42. conditons for queries
  43. query question
  44. Update query
  45. Re: Type mismatch error in SQL expression...
  46. Help with report query.
  47. Urgent Help Required
  48. Delete query problem...
  49. Rounding problem
  50. Update two fields in a Query
  51. Representing related records in a single row.
  52. need to know who if there are no records
  53. Duplicate Value
  54. How do I extract a return value from a pass-through Query using code?
  55. Query combo box on tab question
  56. Query combo box on tab question
  57. Query combo box on tab question
  58. Query combo box on tab question
  59. Query combo box on tab question
  60. Currency and Number data type
  61. Number of digits displayed
  62. error message "not enough space on temporary disk"
  63. Join two table with one to many relation
  64. RE: Top Values View- Please Help
  65. Querry result to form field?
  66. Using IN statement in Query Criteria Field
  67. How to split the columns
  68. Top Values View- Please Help
  69. Sorting in an Access Query
  70. RE: Totals Query
  71. Convert data type in query
  72. relationships
  73. Query for an Invoice Report
  74. how to show an entire date span
  75. Query Running TOO SLOOOOW!
  76. Query for importing data from Excel
  77. looking for samples on how functions are used
  78. looking for samples on how functions are used
  79. Query more than 1 table?
  80. reporting revisits from a query
  81. Repeating Parameters
  82. table analyzer
  83. Query using crosstab data
  84. "insert into" query
  85. Date Format
  86. Stripping Out Carriage Returns
  87. Limit query output
  88. dates
  89. Round as calculator
  90. Break Excel into Header/Footer
  91. Updating Field to a new format
  92. Crosstab counts aggregated by day ranges
  93. date problem
  94. listings (records) in query
  95. Proper syntax for DLookup criteria
  96. Help! Have I lost my query?
  97. Query for importing data from Excel
  98. Update error.
  99. How do I 'add' results produced by the 'greatest' macro?
  100. Possible to Get prior records?
  101. StatusID's on 1 line?
  102. Transform Query
  103. TOP doesn't work with ORDER BY correctly, please help
  104. EXPRESSION BUILDING
  105. Dropdown list prompt running query
  106. User input into a query
  107. summation of deliveries
  108. Trying to glean log information
  109. Outer Joins msquery vs access
  110. Dates
  111. Re: XQuery capabilities in Access
  112. Is a query with a field subquery updatable?
  113. Dcount Records
  114. Update Query
  115. Value of an Query PARAM in VBA
  116. Excluding multiple criteria in a field
  117. Counter in a Query
  118. Re: Access 2003 delete query
  119. Re: query with date restrictions
  120. Overlapping Time Intervals
  121. Get column names from Access crosstab query via ADO?
  122. Re: Delete a Parent record if NO CHILD is found ?
  123. shuffle answers
  124. Re: Delete a Parent record if NO CHILD is found ?
  125. Comparing similar text fields?
  126. calculate age on specific date
  127. Mass query execution
  128. Creating an Indexed Field in a Make Table query
  129. Re: microsoft jet sql reference... where is it??
  130. new access need helps with run sum query
  131. running sum in query
  132. run sum
  133. Uneditable Query
  134. DELETE query - Could Not Delete From Specified Tables
  135. Select the last memo
  136. query help
  137. Running Sum Total in Query question
  138. (+) and @variable in SQL query?
  139. Database Queries Using DATE
  140. qry help requested
  141. Queries in a Listbox
  142. Mail Merge from a Query where it looks for values in a form.
  143. Append query that parses data
  144. Combining crosstab Queries
  145. Adding a carriage return in a query
  146. Query skips input for Where clause if second table or query added or if prompt contains blanks in the prompt string
  147. "Bottom" SQL
  148. Switch()
  149. union query to limit dates
  150. "Or" option using INSTR() Function?
  151. Need Quarter Report
  152. Updating table1 with table2
  153. minute
  154. Query that also includes records with NULL values
  155. SQL question
  156. Validation Rule Question
  157. Crosstab query?
  158. Function and AS
  159. I Need a Chart Expert
  160. Updating calculated fields
  161. query with null values
  162. Inner join
  163. Using query for mail merge
  164. Adding a new row
  165. How To Open File
  166. dBase III export from Query
  167. dBase III export from Query
  168. dBase III export from Query
  169. dBase III export from Query
  170. Show If
  171. Parsing data
  172. Lookup a definition/field in a query or a report
  173. iif statement not working
  174. iif statement not working
  175. iif statement not working
  176. iif statement not working
  177. % of Total
  178. Send an email based on a query...
  179. Cummulative Function
  180. HELP! Access Subsheet Problems
  181. Queries filter?
  182. Create query
  183. Q: Probably simple but..
  184. Re: INSERT...INTO
  185. Grouping Within A Query
  186. Quarterly Reports
  187. Re: INSERT...INTO
  188. Alter Table trouble
  189. Page Totals in Report
  190. Splitting Full Names into two fields
  191. calculating age in a query
  192. Re: list the updates enteries
  193. CrossTab Query
  194. Stumped by query results
  195. SQL Date/Time Question
  196. Need to populate a field in a record based on criteria
  197. Prevent Deleting Records
  198. Formatting of Query Results
  199. Re: Nested IIf statements and size limitations
  200. Dumb but Urgent Question about Most Recent Date
  201. Simple query not working
  202. Join multiple columns ?
  203. Rounding in Pivot Table View
  204. update query
  205. Re: Create count query
  206. Syntax error in FROM clause
  207. Re: Formating of query
  208. Date Range conversions
  209. updating new field
  210. Query with no results
  211. Concatenate two fields into one
  212. Selecting records with most recent date...
  213. I appreciate the help
  214. displaying records between tables when one table doesn't have a corresponding...
  215. Non updatable recordset help
  216. Access subsheet issues...
  217. Aggregate problem
  218. You People Are Awesome
  219. RE: How prevent Access messages when INSERTing ??
  220. Re: inserting a default value
  221. SQL Subquery
  222. crosstab Date parameter
  223. How do I do this query?
  224. Totals Query
  225. Expression handling
  226. Displaying different fields based on condition
  227. Search a word in whole database
  228. Smart Deleting
  229. Making a query
  230. Dynamic field in a query
  231. ignore Overflow error
  232. Re: group by question
  233. Overflow error
  234. Dynamic date in my query
  235. How to select values in a column n put it in new column
  236. Totals Query?
  237. Separating Addresses
  238. Querying Dates
  239. search on anniversary date
  240. Re: Time series query,
  241. Automated Field entry based on another field
  242. update query and phone/fax format
  243. Parsing Memo field
  244. sum of groups
  245. Delete query but want to keep 2 fields
  246. Group Records by Cumulative Value
  247. Input Parameter/Data Type conflict
  248. Format and Format$ Functions Not Recognized
  249. SORT QUESTION
  250. Re: Combo Box
  251. Query sometimes returns incomplete results
  252. SQL If statement
  253. criteria
  254. Re: Combo Box
  255. Concatenate rows
  256. Find near duplicates
  257. SQL
  258. Parameter query with null entry...
  259. Accumulative Totals
  260. A query to return the range of a sum of values
  261. Field Name with Leading Zero in a Query
  262. iif statement in the query
  263. Group by date and time with configurable blocking
  264. Duplicate query
  265. Using Between in criteria
  266. Make Table Query
  267. Using linked Oracle tables
  268. Null Columns
  269. Lookup queries
  270. merge tables
  271. Sort Error
  272. Hopefully simple query question
  273. Data Read in VBA
  274. Access Query
  275. ADOX stored procedures ?
  276. Parameter query with a variable "IN" clause
  277. Re: Help - Sorting
  278. Concantenate vertical information
  279. Elapsed Time
  280. How do I compare 2 tables?
  281. Parameter Query Error
  282. Parameter from Form??
  283. Turn this query into a parameter query
  284. Renumbering a duplicate ID field...
  285. Re: "vlookup" function in access
  286. "vlookup" function in access
  287. Re: Help - Sorting
  288. Statistics via a subreport?
  289. Crosstab Query error message
  290. Logic problem
  291. Extracting Month From Date
  292. function is not available
  293. Trying to get the last 12mths sum of sales
  294. Trying to use Year as a variable
  295. Case sensitive replace query and international sorting
  296. Totals in Crosstab Query
  297. convert "text.00" to "text"
  298. Comparing records in two tables
  299. INCREASING FIELD VALUE WITH A FIXED NUMBER
  300. SQL prompt for input
  301. Re: Cross Tab Query
  302. Query question
  303. Using TransterText
  304. How to extract part of a field?
  305. Why does my parameter query repeat?
  306. Re: Cross Tab Query
  307. Run Access Queries at a specified time each week systematically
  308. Read-only?
  309. sorting records
  310. How to make a message
  311. Query by Form Output
  312. Query
  313. Update or Append Help with Criteria
  314. Crosstab problem
  315. Ascending/Descending
  316. Median & Mode Calculation
  317. Query to find the first date a customer purcahsed an item
  318. Query the database about itself
  319. Append Query
  320. calculating age
  321. Remove a space in the middle of a String?
  322. Re: query weirdness
  323. featch all data from tables into one table
  324. Date parameter query
  325. Calculations in queries
  326. Refering to a query using a combo box
  327. Type
  328. More Select in a query
  329. Current Month and Previous Month
  330. Create a query that leaves out blank fields
  331. I have *** strings, how to replace them
  332. Complex query
  333. Another cross-tab query
  334. Counting Records
  335. Date problem in query
  336. Removing duplicate records based on certain criteria
  337. Selecting numbers from text string and placing in new fields
  338. Combo Box in Query
  339. join question
  340. Distributing access on computers that do not have office installed
  341. Query: Which employee had the most orders... for each day
  342. SQL calculate percent group by
  343. multiple reports - same parameters
  344. FAO Steve Clarke (Query Creation)
  345. access problem
  346. Trying to join month, day and year fields
  347. Queries with date/time format prob
  348. Student Project Problems
  349. Can I get the answer with a query
  350. Still need technique to analyze data
  351. IIF condition
  352. (Desperate) How to Qry on the Fields that an Image is there?????
  353. Nested Queries
  354. ms access stored procedures again
  355. Specifying number of each records returned
  356. reverse query??
  357. Selecting the most recent record
  358. Parameter query
  359. trying to extract a date within a text field
  360. Re: split field into two
  361. Backwards database...
  362. Calculate in and out time
  363. :MS Access Query / IB6 ODBC Problem
  364. Running Total - Query
  365. Running Totals in a query Microsoft article 290136
  366. Select 1st value info repeated in table
  367. Select 1st value info repeated in table
  368. Dynamic Query Form
  369. Re: Crosstab query question
  370. A pretty easy one for the experts
  371. cleaning data
  372. Help with query on a Date field for UK date style dd/mm/yyyy ???
  373. Re: looking for the first character in a text string that is a number
  374. group_concat
  375. group_concat
  376. Still need help with multiplying records
  377. IIF THEN
  378. Parameter Query and wild card character
  379. Generating a numbered column in a query
  380. Need to Calculate ThruPut Time
  381. Re: split field into two
  382. Nested If in Access Query or Report
  383. crosstab converts Zeros to Nulls workaround?
  384. Re: formatting a Field in an update Query
  385. QUERY
  386. Access SQL dialect documentation?"
  387. removing characters in a text string
  388. Querry can't figure out
  389. CONCATENATE
  390. RE: formatting a Field in an update Query
  391. Re: Error when creating an index
  392. Re: percentages in quries
  393. Date Format Problem
  394. Date Format Problem
  395. Queries using parameter queries, assigning values to for params in called query, is it possible?
  396. add a query in a texte field in a form...
  397. Avoiding Null Values using nz() won't work with Access ODBC driver
  398. Query based on continously new created tables
  399. stored procedures and dates
  400. Regarding Microsoft MVP Papajohn claims...........
  401. RE: Query Creation
  402. HELP!!!
  403. Re: Pulling one mailing label per person
  404. Select a day in a month
  405. MIcrosoft MVP Papajohn claims Movie Maker 2 Non-Linear Editing Environment
  406. Find unmatched records
  407. Excluding records based on dates
  408. Group Ranking Problem...
  409. Small Project Need Help
  410. Re: Special Characters in SQL stmt
  411. Calculate the age
  412. Help writting simple query
  413. Need technique to analyze data
  414. Parameter from a function
  415. Removing message boxes associated with append queries
  416. Concatenation
  417. change start value for auto number
  418. convert access qry to ansi 92 equivalent
  419. order totals
  420. Is it possible to use "all" in a paramater query
  421. Is it possible to use "all" in a paramater query
  422. Current date
  423. Problem with IN clause
  424. query returning multiple copies of same record
  425. Change report sort order
  426. Re: Sort Order
  427. Re: finding specific time values in where statement
  428. Re: deleting only certain records
  429. Query to remove mult. lines in table
  430. Select that is not in a table
  431. Duplicate Records
  432. Invalid argument
  433. Default printin gin Access
  434. Union data from two databases
  435. Strip field of AutoNumber
  436. Getting a cummulative total from a one-to-many
  437. Very complex crosstab query question
  438. autonumber selection in access
  439. Screen "freezes"
  440. Selecting data with CHOOSE
  441. wildcards in query from form
  442. Crosstab ?uestion
  443. Multiple criteria through a form
  444. Multiple criteria through a form
  445. Move records between linked tables
  446. Multiple Criteria Query using a form
  447. Showing properties of a QueryDef
  448. Linked Table Layout
  449. Monthly Report
  450. How to add a remark in access query
  451. Caculate Text
  452. unique record based on date query
  453. Creation Of A Query
  454. Icon
  455. Query result is wrong?!
  456. Access Query - Case Sensitive
  457. Adding multiple records linked by a primary key
  458. Simple query
  459. Problem with Aggregating functions in update queries
  460. Quote Marks ( AGHHH!)
  461. Blank Forms
  462. Test for and group consecutive numbered records
  463. Query is too complex (run-time error)
  464. Partial Text String Manipulation
  465. Counting
  466. Criteria
  467. Re: Need Criteria syntax for query "run" by a Form
  468. Copy Data Definition Query to another database
  469. Searching for partial records
  470. Count or Sum consecutives values
  471. Count unique values in a field
  472. Nested Queries with a Parameter
  473. Need parameter query results to populate form and subform fields
  474. a little confused
  475. Date vs DateTime selection in Query
  476. Multiplying Records
  477. Parameter query doesn't work with my format
  478. Most recent entry for each item
  479. lookup query question
  480. change search criteria in a query
  481. Formatting a query calculated field
  482. Counting # of Rows by Age
  483. list columns
  484. Form Query
  485. Populating a report from the results of a query run by a form
  486. Populating a report from the results of a query run by a form
  487. Populating a report from the results of a query run by a form
  488. Populating a report from the results of a query run by a form
  489. Populating a report from the results of a query run by a form
  490. Question about server filter
  491. Re: IIF function error
  492. SQL call to VBA, named or omitted parameters syntax?
  493. Crosstab Query
  494. multiple criteria
  495. multiple criteria
  496. multiple criteria
  497. multiple criteria
  498. multiple criteria
  499. SQL Syntax Help
  500. Between 2 Dates Query
  501. Between 2 Dates Query
  502. Between 2 Dates Query
  503. Between 2 Dates Query
  504. Between 2 Dates Query
  505. Null value for query criteria.
  506. Append Query
  507. sort union query
  508. Evaluating the data in SELECT statement
  509. IIF statement problem
  510. Search Query
  511. Need some query design help....
  512. db size question
  513. Help with a Max Query
  514. Append Query to Split Table
  515. Extract numeric values from string
  516. Split Function in Query
  517. Append query in code
  518. Displaying Latest Date Only
  519. Dcount
  520. Parameters using 'Between Date 1 & Date 2' - Need to use 'Like' too!
  521. Zero value in query
  522. SUM(TIME FIELD)
  523. Date Splitting for Other calculations
  524. Changing the datasheet View on Query
  525. Overflow error from select query
  526. Date & Time Calculations in Queries
  527. Date parameter
  528. Vanishing Posts
  529. Auto input
  530. Finding matching records
  531. Display Last Record
  532. Counting the number of rows by month
  533. RE: Parameter Query Issue
  534. Re: Parameter Query Issue
  535. Counting records
  536. Counting: Query by Scale an Project.
  537. Time Required to run Create Table Query
  538. Query by Scale and Project
  539. How to concatenate several entries to same table
  540. Querying Multple Tables in Access with different fields
  541. calculated fields
  542. Query & calculated field
  543. Update Query
  544. Q: multiple inserts in Access query
  545. Query criteria from open form or if field is null
  546. Create query to return data by week for graph
  547. RE: Logic Question
  548. Referencing a Query in Excel
  549. Date Funtions
  550. Logic Question
  551. Count in Query
  552. Drop down box in a Parameter Query
  553. Join changing mysteriously
  554. How to report combined lookup fields as text?
  555. Networkdays Function in Access?
  556. Copy a field to another - same table
  557. Ask for weekdays only
  558. multiple tables in one query
  559. SQL query
  560. Sorting queries
  561. Using input parameter query for creating charts
  562. Manual Entry of Criteria
  563. Looking back several days
  564. Help with searching for a substring
  565. converting date format from dd-mm-yyyy to yyyy-mm-dd
  566. random help
  567. Can I use a Public Variable as Criteria in QueryDesign View?
  568. text automatically changes
  569. Choose Fields from a FORM (table from combo) for excel export
  570. Choose Fields from a FORM (table from combo) for excel export
  571. Lookup to unrelated table
  572. Query Help
  573. How to code query with text column
  574. Re: BOF ??
  575. Operators
  576. Null Values in a Make Table Qry
  577. QueryProblem
  578. Filtering Selections
  579. Filtering Selections
  580. SELECT * INTO doesn't work
  581. SELECT * INTO Doesn't work
  582. Re: deleting only certain records
  583. Need help with Criteria for Queries Pls
  584. Query Returns No Results, I need to see a 0
  585. Re: BOF ??
  586. Convert ss# text to number
  587. Text file format conversion
  588. Get rid of auto message when about to update query
  589. Unique Record
  590. CLEAN expression for Access to remove nonprinting characters?
  591. Append Mailing Info to records in a table??
  592. Finding Missing data
  593. Help with DateDiff and Count Expression
  594. display sequential list of numbers
  595. Re: comparing similar tables
  596. Query Results - Data Type Discrepancy
  597. Re: Last 8 Weeks....
  598. Adding a calculated column to a query
  599. Queries
  600. Query against - ODBC Connect Oracle Table
  601. Re: BOF ??
  602. Unmatched Query Wizard
  603. Access 2002 Data Validation Rules/Text Help.
  604. DATEDIFF function
  605. Re: DATEDIFF function
  606. 100 records x10records query
  607. Current Month
  608. Re: Multiselection in List box.. I need a little "push"
  609. random sample
  610. crosstab query total column
  611. Can I use an Or statement in five fields?
  612. Q. I need to base a query on 2 different fields.
  613. Query for NAMES first/last
  614. Query for NAMES first/last
  615. Saving an edited query
  616. split records
  617. Networkdays
  618. Filter Weekdays and Intervals
  619. How to get the list of ACCESS tables ?
  620. Custom functions in queries
  621. Changing data type in make table queries
  622. Shifts over two days
  623. Easy question
  624. Searching by month from more than one table
  625. Between Date()-#07:00:00# And Date()+#17:00:00#
  626. Formula
  627. Sum Query
  628. access
  629. Updateting Tables From Previous Database
  630. Can somebody please help me?
  631. Weird Behavior of UNION
  632. Syntax problem - can someone help me please
  633. Form filter
  634. query based on text box value
  635. Subtract minutes from times
  636. Changing the Datasheet View of a Query
  637. Query problem...
  638. current date minus a day!
  639. outside joins (many-to-many)
  640. The date of the start of the financial year
  641. Complicated...I think
  642. Birthday Lists in MS Access
  643. Parameter Queries - Add a lookup
  644. Append Query question
  645. Convert() Problem
  646. Re: Query check
  647. AR Aging
  648. ACCESS 2000 and Visual Basic
  649. Re: Query check
  650. Re: Query check
  651. Delay
  652. Random # of records based on user input
  653. Updating Field
  654. Flush buffer or simular in form.
  655. applying DISTINCT to only one field
  656. Advance feature of Query
  657. Week of Year
  658. number field
  659. Creating a query column to calculate End Time & Properly format
  660. Criteria for Query
  661. Using "replace" in update query
  662. week numbers
  663. Button to copy and paste a record
  664. Select a control using text manipulation
  665. Query speed affected by sorting
  666. Calculate 6 months out
  667. Function that returns an Array with a Query
  668. queries for deleting data
  669. Date -7 Criteria
  670. Use of variables in a query?
  671. count instances of a name(s)
  672. Format([Hours] * -1,"Fixed") ERROR
  673. union query.
  674. dump fields into a memo field
  675. carry value from SQL to Query
  676. Print only the last date
  677. Re: finding specific time values in where statement
  678. How do I stop Access from asking confirmation to delete a table in a Make-Table Query?
  679. Compiler Error
  680. Access Query
  681. How to select records by month by using a pop up?
  682. Extracting an Area Code from a 10 digit numger in a query
  683. Sequential Numbering
  684. Unwanted Dialog Box
  685. Update query to update more than one table?
  686. Sort on partial field
  687. Editing records in a query
  688. "REPLACE IN FIELD"
  689. Criteria- Help Please
  690. Interesting Question
  691. picking first or last row
  692. Cheap CPU, RAM. PIV2.8E only US$200!!!
  693. create query to select only 1 member of a household based on address
  694. Union Query failing on Order By clause
  695. DATE() issue
  696. Data Type mismath errors after months of no problems
  697. Q. query for space in several fields doesn't work ( =" " )
  698. Simple Sum Calculation but I can't work it out......
  699. complex queries
  700. Comparing field values
  701. Sum Time
  702. Cycle Through two Tables
  703. I have one too...
  704. Another crosstab question...
  705. Crosstab parameter help
  706. Combining different values in the same field in a query
  707. Re: cannot go back 6 months
  708. Records Discrepancy
  709. Rounding?
  710. a character specific query
  711. Average Problem
  712. Re: cannot go back 6 months
  713. Deleting records from find duplicates query
  714. Builing a query from selection criteria on a Form
  715. help with a Query Expression (Builder)
  716. help with a Query Expression (Builder)
  717. Week ending Friday Inventorys
  718. Please help got access query but can't get it to work on sql-server - what's the access specific part ?
  719. Top 3 values tie breaker
  720. Sum Query
  721. Query using max
  722. tuff query
  723. Trouble in writing a result from a calculation back to a field.
  724. Top 5 values by grouping
  725. Using wildcards in queries
  726. Aggregate Function query
  727. INSERT INTO using WHERE??
  728. Inventory Update Query
  729. populating combo box
  730. user input min/max error
  731. Delete Query Question
  732. DCOUNT function in query?
  733. two columns into one
  734. Re: Printing one address label from 2 lists
  735. Two tables where one value is not like the other.`
  736. Crosstabs and Parameters !!??
  737. Distinct Records
  738. user input min/max error
  739. Optimize Select insert and update
  740. A query that returns the record counter
  741. Pad field in query
  742. Calc values from a form viewed back in a query table
  743. Query from Form when "Not Like"
  744. bar charts displaying negative values
  745. Prompt
  746. Export / Query Problem
  747. yes/no
  748. Entering a null value in a field
  749. adding totals across
  750. Multiple queries based on the same table?