microsoft.public.access.queries
By Thread
3063 messages sorted by: [ date ]
Starting: 03/31/04
Ending: 04/30/04
- logic and < Greg (04/30/04)
- SQL in Report Dennis (04/30/04)
- Re: I'm struggling with my limited knowledge of code tina (04/30/04)
- Help!! Problem with query gene (04/30/04)
- Query criteria referencing field name no longer works Matt (04/30/04)
- Urgent Update Query Bill (04/30/04)
- adding records in a query dola (04/30/04)
- Test for no records returned Brian C (04/29/04)
- Printing Queries Properties B. W. (04/29/04)
- Data from previous record Alan Nicoll (04/29/04)
- hidden queries Jeanne (04/29/04)
- Using If/When type expressions in a report Linda Wampach (04/29/04)
- Help with code to run query and test a field in the record Kate (04/29/04)
- rounding a number in a query Saskatoon (04/29/04)
- Record Ranking Rachel (04/29/04)
- Appending two tables DSmith (04/29/04)
- Linked DBIII Table Maureen (04/29/04)
- Help with hiding/showing forms Katie (04/29/04)
- Splitting a record in two Alan Nicoll (04/29/04)
- Access Query with MS Driver crashing Oracle DB??? Rebecca (04/29/04)
- Field properties in a Query Alan Nicoll (04/29/04)
- Q: Appending crosstab query having dynamic variables MarkD (04/29/04)
- forum input field bob (04/29/04)
- forum input field crazyITguy (04/29/04)
- DoCmd.RunSQL error Help Kate (04/29/04)
- Queries and reports run slow zooeyhall (04/29/04)
- Switch is overloaded! Bonnie (04/29/04)
- Please help with a query Al (04/29/04)
- Convert ROW data to COLUMN JackP (04/29/04)
- 'Query does not exist' message but it does !?! David (04/29/04)
- Help with SQL Syntax CJ (04/29/04)
- Problem with Function Date() in query Rafał (04/29/04)
- Compare 2 table & show detail both table Mal (04/29/04)
- DECODE equivalent patricia (04/29/04)
- reports Dave B (04/29/04)
- Need help to remove tbas, carriage retrun, and other!!! Will (04/29/04)
- Help, Sorting Query bug mike (04/29/04)
- outer join paul (04/29/04)
- dec2hex Donna (04/29/04)
- Bin Laden Captured - photos and video jamiewalker_at_wp.shawcable.net (04/29/04)
- Query won't list more than 25 records Scott (04/29/04)
- Crosstab error George Schneider (04/29/04)
- Pass-Through, Default DSN? Gerard (04/29/04)
- Save a filter (from table) as a query Sandy (04/29/04)
- Self Join query question Convoy (04/29/04)
- Please help me with when I can use my key field Kate (04/29/04)
- Difference in days from multiple records Fredrick Smith (04/29/04)
- Date Range Tina (04/29/04)
- How do I test for no records returned in code? Kate (04/29/04)
- Between...And Operator Randal (04/29/04)
- SQL Statement anonymous_at_discussions.microsoft.com (04/29/04)
- Query ti list records that have been modified Daniel P (04/29/04)
- Can you make my SQL do what I want? Please! Kate (04/29/04)
- Make-Table query - Adding table description DK (04/29/04)
- date range query Greg (04/29/04)
- Search between two dates query Greg (04/29/04)
- help with delete query Allen Clark (04/29/04)
- Count Based on Date Frolickin (04/29/04)
- Link table alternative B Nieds (04/29/04)
- Saving a CSV file in a memo field CaribSoft (04/29/04)
- Functions in Access queries Need Help Please! (04/29/04)
- Formula Works but not as Criteria fred (04/28/04)
- changing query parameter with an on-click event nergdergler (04/28/04)
- Error when copying record (Access 97 on W2K or XP) Judy Rudek (04/28/04)
- What does this error mean? Kate (04/28/04)
- Sub Queries Hotfirewire (04/28/04)
- appending records without creating duplicates in a non-indexed table Applebaum (04/28/04)
- Combine Excel into Access (1 Record) WDP (04/28/04)
- Autonumber Brian (04/28/04)
- data type Randal (04/28/04)
- Current Effective date Chris (04/28/04)
- Page break by groups of data Teresa (04/28/04)
- Changing Query Selection criteria Andy (04/28/04)
- Query Months "January to September" etc. Randy (04/28/04)
- searching by month/quarter Calvin (04/28/04)
- Query Help!!!!!!!!!!! msandy (04/28/04)
- SQL Insert Brian C (04/28/04)
- Append verses Update Query George Schneider (04/28/04)
- Query Question George Schneider (04/28/04)
- Web-Based Query Kathy (04/28/04)
- Using special Character Such as * Jim (04/28/04)
- Crosstab query result question +Andrew (04/28/04)
- Managing queries based on other queries Fred Boer (04/28/04)
- Parameters in a Crosstab Querie Jack Stoudt (04/28/04)
- how to check if the result of a query =0 records? A.J.M. van Rijthoven (04/28/04)
- DefaultValue on a Query Filipe Taborda (04/28/04)
- ambiguous outer joins Doug (04/28/04)
- Displaying 1 / All records Steve (04/28/04)
- Help! Sue (04/28/04)
- Add new field in query Cowdog Gal (04/28/04)
- Update Queries Cora Mc (04/28/04)
- inventory project Amanda (04/28/04)
- Implicit Type Conversion For Queries MDW (04/28/04)
- Nothing happens when I press datasheet view MK (04/28/04)
- Joining two fields into one Novice (04/28/04)
- Need help desperately, Problem Generating Errors for currentdb.execute zippy (04/28/04)
- Question on querie for a sum Les (04/28/04)
- Please need help with interesting Cross Join query Max (04/28/04)
- IIf statement Stan (04/28/04)
- Update Stewart Walker (04/28/04)
- Queries not recognizing field names??? Jennifer (04/28/04)
- Group by Weeks - Year Wrap Charles D Clayton Jr (04/28/04)
- access97 query icon is greyed out dk (04/28/04)
- Access XP Font size Michael Burkhardt (04/28/04)
- Re: query variable Vsn (04/28/04)
- Building a string Bob H (04/28/04)
- Multiple table query Gwynn (04/28/04)
- Re: "Expression too Complex" kbath (04/28/04)
- Newby help! Creating user-input defined search queries... Ed G (04/28/04)
- Using Access97!! John Harrop (04/28/04)
- system resource exceeded ody (04/28/04)
- Combining Separate Tables into single Query for Report sctvoice (04/28/04)
- Finance Query for a Newby (2nd time) Vic (04/28/04)
- Print report Page Header on 2nd page and onward Eric (04/28/04)
- Passing same parameter value from 3 different forms Eric (04/28/04)
- Append Query SQL Eric G (04/28/04)
- ADO returns EOF Tausif Alam (04/28/04)
- How to use WORKSPACES? greatmacoy (04/28/04)
- How to use WORKSPACES? greatmacoy (04/28/04)
- How to use WORKSPACES? greatmacoy (04/28/04)
- How to use WORKSPACES? greatmacoy (04/28/04)
- Syntax to Average a time duration (hh:mm:ss). Sid (04/28/04)
- Re: Syntax to Average a time duration (hh:mm:ss). Duane Hookom (04/28/04)
- Re: Syntax to Average a time duration (hh:mm:ss). Sid (04/28/04)
- Re: Syntax to Average a time duration (hh:mm:ss). Sid (04/28/04)
- Re: Syntax to Average a time duration (hh:mm:ss). Duane Hookom (04/28/04)
- Re: Syntax to Average a time duration (hh:mm:ss). Sid (04/28/04)
- Re: Syntax to Average a time duration (hh:mm:ss). Duane Hookom (04/29/04)
- Re: Syntax to Average a time duration (hh:mm:ss). Sid (04/29/04)
- Re: Syntax to Average a time duration (hh:mm:ss). Duane Hookom (04/29/04)
- Re: Syntax to Average a time duration (hh:mm:ss). Sid (04/29/04)
- Re: Syntax to Average a time duration (hh:mm:ss). Duane Hookom (04/29/04)
- Re: Syntax to Average a time duration (hh:mm:ss). Duane Hookom (04/28/04)
- Report based on two tables (first posted in reports) eb1mom (04/27/04)
- Wildcard not happening for me ... help Dale (04/27/04)
- Query to find multiple records for Customer_ID anonymous_at_discussions.microsoft.com (04/27/04)
- qrytoCalculateincome riz (04/27/04)
- Really struggling with SQL Brian C (04/27/04)
- Custom Data Set Paola (04/27/04)
- Problem Genetating Errors zippy (04/27/04)
- Calling an Access query containing function from VB Ray (04/27/04)
- Random Selects in Access Brian (04/27/04)
- MAJOR Dillema anonymous_at_discussions.microsoft.com (04/27/04)
- query Darren Spooner (04/27/04)
- strip dashs in query LOIS (04/27/04)
- Parse a string of text from a linked .txt file Steven M. Britton (04/27/04)
- Change data within a query Al Mackay (04/27/04)
- Print out Query Multiple Times Christine (04/27/04)
- Can this be done? uma1919 (04/27/04)
- Use make table query and changed linked field property Lurch (04/27/04)
- Sorting by Month problems with Combobox Elizabeth (04/27/04)
- Sorting by Month problems with Combobox anonymous_at_discussions.microsoft.com (04/27/04)
- Re: Sorting by Month problems with Combobox MGFoster (04/27/04)
- Re: Sorting by Month problems with Combobox John Vinson (04/27/04)
- Re: Sorting by Month problems with Combobox Elizabeth (04/27/04)
- Re: Sorting by Month problems with Combobox John Vinson (04/28/04)
- Re: Sorting by Month problems with Combobox Elizabeth (04/28/04)
- Re: Sorting by Month problems with Combobox ELizabeth (04/28/04)
- Re: Sorting by Month problems with Combobox John Vinson (04/28/04)
- Re: Sorting by Month problems with Combobox Elizabeth (04/28/04)
- Re: Sorting by Month problems with Combobox John Vinson (04/29/04)
- Re: Sorting by Month problems with Combobox Elizabeth (04/29/04)
- Re: Sorting by Month problems with Combobox Elizabeth (04/27/04)
- Query on table with a lookup Jen (04/27/04)
- Timestamp Tara (04/27/04)
- Outer Join problem Somayaji (04/27/04)
- Current Date AntRig (04/27/04)
- Reurning to a form after a query. Tim Holmgren (04/27/04)
- Can't join on memo or ole object MK (04/27/04)
- Query Based On User Selection Chuck (04/27/04)
- Querie from table. Krefty (04/27/04)
- Blank records LJ (04/27/04)
- Saving design changes in Access 2000 locks out ADO, why? Michael Edwards (04/27/04)
- Re: Sort Order -- Random? Allen Browne (04/27/04)
- 3 columns with different dates Jenn (04/27/04)
- Query SQL keeps getting erased Jeremy Ames (04/27/04)
- SELECT FROM function in Access 2000 Paolo Bormida (04/27/04)
- Filter by form values in a Crosstab Query Becca (04/27/04)
- Printing a Query Mike Kaendera (04/27/04)
- Using one query multiple times w/different parameters in a report David G. (04/27/04)
- Query Criteria - Substring Jim Miller (04/27/04)
- Using multiple criteria in Like Operator Luqman (04/27/04)
- creating a query based on a yes/no field nergdergler (04/27/04)
- Checking values in returned records Brian C (04/27/04)
- Repost updating records with data from multiple forms Brian C (04/27/04)
- UNION order MK (04/27/04)
- missing fields Erik p (04/27/04)
- house numbers Tom McD (04/27/04)
- How to group data and display some of the details in a column? Shirley (04/27/04)
- Query Problems James (04/27/04)
- SQL Recordset MK (04/27/04)
- What's wrong with this query?? muenchr_at_ozemail.com.au (04/27/04)
- Finance Query for a Newbie Vic (04/27/04)
- Create a primary key in a make table query Nigel (04/27/04)
- Help converting rows to columns Cowdog Gal (04/27/04)
- Update and Create statements Brian C (04/27/04)
- Process multiple records Brian C (04/27/04)
- new at queries-can I do this one? zirkerc (04/27/04)
- Books Peter (04/27/04)
- Update a given number juliambuchholz (04/27/04)
- Query Parameters from a List Box JoeCL (04/26/04)
- I Need Help Building A Query JCrowe (04/26/04)
- group by errors Sean (04/26/04)
- Running balance from record to record Randy (04/26/04)
- posting to multiple forums Brian C (04/26/04)
- Help with queries Brian C (04/26/04)
- Challenging Query Diana (04/26/04)
- Adding fields to tables Alan Nicoll (04/26/04)
- Querying Dates Andrew Thorpe (04/26/04)
- Tough Challenge...Alias, Nested Query? mj (04/26/04)
- Nesting IIf statements ron b (04/26/04)
- How do I create a query that will only select a single record? Jimtno (04/26/04)
- Re: splitting text fild BDP (04/26/04)
- Re: Splitting Full Names into two fields BDP (04/26/04)
- switch cared ian.uk (04/26/04)
- DCount problem Alan Nicoll (04/26/04)
- Current On-Hand-Quantity Dale Fye (04/26/04)
- Please help with coding Sheela (04/26/04)
- First day of current year Tara (04/26/04)
- Syntax error BrianC (04/26/04)
- query criteria msandy (04/26/04)
- wild search sheela (04/26/04)
- Multiple Name Query Kelly (04/26/04)
- Access pass through queries bhorwitz_at_zachys (04/26/04)
- Complicated Query George Schneider (04/26/04)
- error with query expression Janey Baker (04/26/04)
- working with combo boxes Calvin (04/26/04)
- updates across forms Brian C (04/26/04)
- Query keeps returning blank records Josh S (04/26/04)
- Running a query using data from a form Brian C (04/26/04)
- Extracting month from date field anonymous_at_discussions.microsoft.com (04/26/04)
- UGH! Next month Quary? Justin (04/26/04)
- Re: Counter in a Query Vern (04/26/04)
- access 97 out of mem error Antz (04/26/04)
- Count function returns nothing Sandra (04/26/04)
- Date Query Issue Shaji (04/26/04)
- Query Help George Schneider (04/26/04)
- Help with Query James (04/26/04)
- parameter query not working ... Grace (04/26/04)
- The Find Unmatched Query doesn't run Shilps (04/26/04)
- Username? Rickard Sjöberg (04/26/04)
- MS Access run-time error 3610 on XP machine KK (04/26/04)
- using result of REPLACE function as the criteria for query anonymous_at_discussions.microsoft.com (04/26/04)
- using result of REPLACE function as the criteria for query chaosunplugged (04/26/04)
- Re: using result of REPLACE function as the criteria for query Gary Walter (04/26/04)
- Re: using result of REPLACE function as the criteria for query anonymous_at_discussions.microsoft.com (04/27/04)
- Re: using result of REPLACE function as the criteria for query Gary Walter (04/27/04)
- Re: using result of REPLACE function as the criteria for query anonymous_at_discussions.microsoft.com (04/28/04)
- Re: using result of REPLACE function as the criteria for query anonymous_at_discussions.microsoft.com (04/28/04)
- Re: using result of REPLACE function as the criteria for query anonymous_at_discussions.microsoft.com (04/28/04)
- Re: using result of REPLACE function as the criteria for query anonymous_at_discussions.microsoft.com (04/28/04)
- Re: using result of REPLACE function as the criteria for query Gary Walter (04/29/04)
- Re: using result of REPLACE function as the criteria for query Gary Walter (04/26/04)
- using result of REPLACE function as the criteria for query chaosunplugged (04/26/04)
- update query adding 2 records WWV (04/26/04)
- Can I create a query (or any nifty easy way) to do this? jj (04/26/04)
- Start\End Date Query Rohit Thomas (04/25/04)
- Norton Antivirus Admin (04/25/04)
- combining several records into one Jenny (04/25/04)
- Update Query Michael Cooper (04/25/04)
- Query returns blank gary (04/25/04)
- Query the most recent transaction for each customer Fred (04/25/04)
- can't find tables used in query Buboy (04/25/04)
- Syntax Error in String in Expression...? James (04/24/04)
- Run Saved Query from ASP Page Ryan Barnes (04/24/04)
- record number in a query Finn Jensen (04/24/04)
- Open word document Dennis (04/24/04)
- SQL restructured incorrectly by MS Access Daniel S (04/24/04)
- How do I use data from other fields in a found record A.J.M. van Rijthoven (04/24/04)
- Default Datasheet Layout SANJAY SHAH \(MICROBRAIN Computers Pvt. Ltd.\) (04/24/04)
- New Column in Make Table Query Cowdog Gal (04/24/04)
- Returning query results to form Tim (04/23/04)
- Count Function Joel (04/23/04)
- Excluding related records and a subquery NOT IN clause Scott Millhisler (04/23/04)
- Help With SQL Zane (04/23/04)
- Work Hours w/o Weekend ty (04/23/04)
- Prompt User for Input to Query Dijait (04/23/04)
- Querying the two most recent entries benb (04/23/04)
- XXX Action Query XXX bladelock (04/23/04)
- using auto date and Date() jennifer (04/23/04)
- Ltrim function error marv (04/23/04)
- Deleting records where two fields match... Trevor (04/23/04)
- Frustrated! Field to join 2 queries Mary (04/23/04)
- Query SQL Michele Zenna (04/23/04)
- Manipulate data in a field Alan Gordon (04/23/04)
- Count Function JoeL (04/23/04)
- Update Products Cyp (04/23/04)
- Update Products Cyp (04/23/04)
- Update Products Cyp (04/23/04)
- Update Products Cyp (04/23/04)
- One parameter entry needed Mike Z (04/23/04)
- Week Day Functions Tim Legg (04/23/04)
- XXX SQL Query XXX bladelock (04/23/04)
- Unexpected results in a query Mike (04/23/04)
- Dynamic Table Reference Sam (04/23/04)
- incorrect data to data adapter carl morahan (04/23/04)
- Automate make table query Allison (04/23/04)
- SQL Time Syntax referring to a form control Sid (04/23/04)
- xxx SQL Queries xxx bladelock (04/23/04)
- Re: SQL Date/Time Question Sid (04/23/04)
- Beastialit Gone Wrong Home Pics dereksimpson_at_vs.shawcable.net (04/23/04)
- query Jan Newton (04/23/04)
- Parameter query where the parameter is the value of a TextBox Richard (04/23/04)
- cutting last digits Pjero Nizeteo (04/23/04)
- Subtotal in a Query Gus (04/23/04)
- combine normal query vs crosstab query Ezekiël (04/23/04)
- Re: Feeding a top records query marcusjb (04/23/04)
- Accessing hierarchies Sajid (04/23/04)
- Date Format complications Tej S. (04/23/04)
- weekday Name Function Clyde Lomax (04/23/04)
- Refering to a detail section on a form Spammastergrand (04/22/04)
- Help on an expression Amanda (04/22/04)
- Counting Records in Query Alan Nicoll (04/22/04)
- For Next Loop Sean (04/22/04)
- Combining Columns in one query Carol M (04/22/04)
- "Optional feature not implenented" dwa (04/22/04)
- Update Query Follow-up Luther (04/22/04)
- Microsoft Query GenoP (04/22/04)
- Use ombo box to select parameter Jim (04/22/04)
- How do I count Uses rather than Dates Kathy (04/22/04)
- How can I put the value of a previous record field in a query? Jayes (04/22/04)
- Need help with Date Query Daniel Brown (04/22/04)
- Parameter Dan (04/22/04)
- Multiple Filters anonymous_at_discussions.microsoft.com (04/22/04)
- DateDiff David (04/22/04)
- "Find Highest and Lowest" Query Jason W. (04/22/04)
- complicated query Bob Brannon (04/22/04)
- I simple issue. Please advise! nest (04/22/04)
- SQL help !!! Walter (04/22/04)
- Crosstab Form reference Steve (04/22/04)
- Simple Filter Question Zane (04/22/04)
- Multiple Numbers Or'd as criteria from Form JoeWM (04/22/04)
- Make Table Dropping Records M (04/22/04)
- sum function opeyemi1 (04/22/04)
- sum function opeyemi1 (04/22/04)
- sum function opeyemi1 (04/22/04)
- sum function opeyemi1 (04/22/04)
- Zane Simple Filter Question (04/22/04)
- Queries Marie (04/22/04)
- ms-dos file handles Rhonda (04/22/04)
- Passing Parameters Erna Henderson (04/22/04)
- IS null Jean (04/22/04)
- SELECT QUERY to REPORT / DATA VIEW within ACCESS SUB (04/22/04)
- select distinct doesn;t work Nikos (04/22/04)
- Comparing to prior record anonymous_at_discussions.microsoft.com (04/22/04)
- Combining Three Queries into one Daniel P (04/22/04)
- Date format in queries Derick Reinecke (04/22/04)
- Date format in Access Derick Reinecke (04/22/04)
- Criteria, Between two times... Sid (04/22/04)
- Odd Behavior with a URL Frolickin (04/22/04)
- Problems with tables and updating Kentucky5 (04/22/04)
- Query field length??? Rohn (04/22/04)
- Delete records based upon query results on another table Ryan Barnes (04/21/04)
- Crosstab Problems Steve (04/21/04)
- ComboBox with a query problem Mark (04/21/04)
- Query to revise data in a table Randy (04/21/04)
- catpuring data Nelson (04/21/04)
- Another left join problem Brad (04/21/04)
- Update Query Luther (04/21/04)
- Help with K Dale's Syntax! Alan Nicoll (04/21/04)
- Count in a Query Lauri (04/21/04)
- Joining two tables by a max or min value Bob (04/21/04)
- Crosstap Queries ALYEA (04/21/04)
- Working with multiple combo boxes Calvin (04/21/04)
- Date Parameter Shaji (04/21/04)
- finding the number of characters in a memo field mrtwice (04/21/04)
- finding the number of characters in a memo field anonymous_at_discussions.microsoft.com (04/22/04)
- Re: finding the number of characters in a memo field mrtwice (04/22/04)
- Re: finding the number of characters in a memo field mrtwice (04/22/04)
- Re: finding the number of characters in a memo field mrtwice (04/22/04)
- Re: finding the number of characters in a memo field mrtwice (04/22/04)
- finding the number of characters in a memo field mrtwice (04/21/04)
- finding the number of characters in a memo field mrtwice (04/21/04)
- Academic Year date criteria in a query Noel (04/21/04)
- Getting to may reocrd back, Tim (04/21/04)
- SQL Text for Query Kirk P. (04/21/04)
- Sort on Random Number field not working gary b (04/21/04)
- No sort on Random Number field gary b (04/21/04)
- SEPARATE NAMES T Jones (04/21/04)
- Query multiple fields at the same time TerryB (04/21/04)
- Multi-Select List Boxes Erna Henderson (04/21/04)
- Query Logic RShuman (04/21/04)
- Autonumber jayfischer91_at_hotmail.com (04/21/04)
- Help with accumulating totals Alan Nicoll (04/21/04)
- Query question George Schneider (04/21/04)
- xxxHELP on query countingxxx blade (04/21/04)
- Pulling from Table won't work. Krefty (04/21/04)
- Counting records if all associated records have a date Daniel P (04/21/04)
- how to pull anything NOT a number or character? scott (04/21/04)
- parameter prompt Don (04/21/04)
- last price paid: query with max in date Dimitri de Failly (04/21/04)
- Help WHERE Elliot (04/21/04)
- criteria in cross-tab query Loon (04/21/04)
- My new nipple and vagina piercings karendavis_at_optonline.net (04/21/04)
- Avg of Min Michael Beatty (04/21/04)
- Records Meeting Two Criteria K. Bryan (04/21/04)
- Query Design Help Frolickin (04/21/04)
- Query for Sub form B Nieds (04/21/04)
- Union Queries BNaylor (04/21/04)
- Repeating Records In Queries Asa Kaplan (04/21/04)
- UnionQry $ not showing DD (04/21/04)
- filter question FBC3 (04/21/04)
- Built-In Text Functions & Queries anonymous_at_discussions.microsoft.com (04/21/04)
- cross tab query and select query angel (04/20/04)
- Be prompt from a View Eleonora (04/20/04)
- update query w/ totals Jerrym (04/20/04)
- Query Datasheet Help Rich (04/20/04)
- access 97 floor function Marv (04/20/04)
- Desperatey needs help on query project Milly (04/20/04)
- pop up query Dan (04/20/04)
- Rank Function in a Query Matt (04/20/04)
- Variable duplicate payment queries Tony (04/20/04)
- Help with a Sort Zane (04/20/04)
- union query duplicates mkm (04/20/04)
- MAX Value DavidW (04/20/04)
- Calculating Time between Dates jbc (04/20/04)
- Trapping a user's selection of Crosstab Results AccessDevlpr (04/20/04)
- Removing Filter Charles D Clayton Jr (04/20/04)
- problem agian with outer joins, pls. Help sheela (04/20/04)
- "Paired" records Duncan Bachen (04/20/04)
- Join switches to different field by itself after save Dannette (04/20/04)
- HELP! Date Criteria From Form Galen (04/20/04)
- Complex probability query Mike P (04/20/04)
- Calculated field that uses another calculated field - possible? Carrie (04/20/04)
- Crosstab Query Cheri (04/20/04)
- ASAP need help please...i keep getting duplicates Nadia (04/20/04)
- Xtab compute value from second row heading JH Higgins (04/20/04)
- Repost.. Using Just Yearear in criteria for Long Date Field Noel (04/20/04)
- Max 10 files by date Angela (04/20/04)
- Pivot problem martin (04/20/04)
- isnummeric Koen (04/20/04)
- Keep getting duplicates.. HELP!! Nadia (04/20/04)
- stop negative autonumber field Shailesh Patel (04/20/04)
- Using an "if" statement in an update query Sue Burns (04/20/04)
- Unexpected results in a query.... Mike (04/20/04)
- query to pull certain format? Scott (04/20/04)
- Getting total per month carmen (04/20/04)
- Combining COUNT and DISTINCT Dave Holmes (04/20/04)
- Count & Yes/No fields Peter (04/20/04)
- use query or calculated control? Cheryl (04/20/04)
- multiple records shown in query kesk (04/20/04)
- Date/Time Expression with Parameter Query ED Deeny (04/20/04)
- Calculation of Totals for multiple fields Bob Mullen (04/20/04)
- Help with expression builder and IF Statements Mike Fellows (04/20/04)
- exporting into e-mail claire (04/20/04)
- Reference a field by using the value of another Dave (04/20/04)
- Dcount : Att Graham Seach DD (04/20/04)
- Query causing me problems DebbieG (04/20/04)
- Expression across rows Bruce (04/20/04)
- using VIEWs in place of dynamic SQLs Leonard Poon (04/20/04)
- Append Query with Combo List Rod (04/20/04)
- calculations Tim (04/20/04)
- Format Phone in Query Expression Tom (04/20/04)
- Calculated Field Expression Bob Mullen (04/20/04)
- Converting augustus (04/20/04)
- Lookup for data and put in a table Kentucky5 (04/20/04)
- Two Primary fields???????????? Kentucky5 (04/20/04)
- Re: Trying to join month, day and year fields DebbieG (04/20/04)
- Escape characters Chen (04/19/04)
- Filtering by Month Zane (04/19/04)
- Criteria & Joins in Queries ADodson (04/19/04)
- Multi-table query problem... Dave Furey (04/19/04)
- Query on Duration ken (04/19/04)
- Design of Query Allison (04/19/04)
- Make-table help Allen Clark (04/19/04)
- Month Format Mary (04/19/04)
- Count Specific Characters James Buck (04/19/04)
- Autonumbers Betsy (04/19/04)
- Re-using queries Bill (04/19/04)
- Filtering for a unique values in a single field David P. Donahue (04/19/04)
- extract part of string cshow (04/19/04)
- pass throug query smk2 (04/19/04)
- Customising Aggregate queries Bearman (04/19/04)
- help in a simple query Ale (04/19/04)
- Calculating Avg for Date Range Rebecca Ford (04/19/04)
- show all data in a totals query Wei (04/19/04)
- Pass Through to Stored Procedure Brian (04/19/04)
- Parsing a string Ted Allen (04/19/04)
- Re: Calculate a moving average query Zac (04/19/04)
- pass variable to criteria anonymous_at_discussions.microsoft.com (04/19/04)
- Multi-Record queries Derek Wittman (04/19/04)
- Query from a Form Meghan (04/19/04)
- Duplicates Parameter Query Hanif Merali (04/19/04)
- Error in merging queries to Word after upgrade from 97 to XP JW (04/19/04)
- Dates in Query James (04/19/04)
- need help using IIf condition in a query scaramanga (04/19/04)
- need help using IIf condition in a query scaramanga (04/19/04)
- need help using IIf condition in a query scaramanga (04/19/04)
- need help using IIf condition in a query scaramanga (04/19/04)
- Selecting records David Mitchell (04/19/04)
- RE: Exclude weekends/holidays in crosstab query Basil (04/19/04)
- Where to place the parameter? Hallgeir (04/19/04)
- replacing of semi-joins Leonard Poon (04/19/04)
- query record length Andrew L. (04/19/04)
- count occurances in an option group Bruce (04/19/04)
- function in query executes more than once? sparkane (04/19/04)
- convert access crosstab to sqlview? Maureen (04/18/04)
- Re: convert access crosstab to sqlview? Duane Hookom (04/18/04)
- Re: convert access crosstab to sqlview? Maureen (04/19/04)
- Re: convert access crosstab to sqlview? Duane Hookom (04/19/04)
- Re: convert access crosstab to sqlview? Maureen (04/20/04)
- Re: convert access crosstab to sqlview? Gary Walter (04/19/04)
- Re: convert access crosstab to sqlview? Duane Hookom (04/19/04)
- Re: convert access crosstab to sqlview? Maureen (04/20/04)
- Re: convert access crosstab to sqlview? Maureen (04/19/04)
- Re: convert access crosstab to sqlview? Duane Hookom (04/18/04)
- Jet SQL vs. standard SQL Bill Todd (04/18/04)
- Select query from Option Group Curt (04/18/04)
- Sort fields with checkboxes chicagoro (04/18/04)
- Combobox filter in a query for a report? Sapper (04/18/04)
- Query Error Message Dkline (04/18/04)
- SET Function in SQL Query? Kentucky5 (04/18/04)
- Compare 2 tables kolbd (04/18/04)
- Little Sister Giving a Handjob davidsanxter_at_vf.shawcable.net (04/18/04)
- Forms Wizard Graham Feeley (04/18/04)
- Newbie: Help with Roll-up Vic (04/18/04)
- Queries are not executed MAC (04/17/04)
- Replacement DFIRST for SQL John Cosmas (04/17/04)
- How to format the date to show weekly intervals Tim (04/17/04)
- Creating a Select Query from another table Ian (04/17/04)
- Update query : Access 97 Céline Brien (04/17/04)
- Re: Update query : Access 97 Steve Schapel (04/18/04)
- Re: Update query : Access 97 Tom Ellison (04/18/04)
- Re: Update query : Access 97 Steve Schapel (04/18/04)
- Re: Update query : Access 97 Tom Ellison (04/18/04)
- Re: Update query : Access 97 Steve Schapel (04/18/04)
- Re: Update query : Access 97 Tom Ellison (04/18/04)
- Re: Update query : Access 97 Steve Schapel (04/18/04)
- Re: Update query : Access 97 Céline Brien (04/18/04)
- Re: Update query : Access 97 Tom Ellison (04/18/04)
- Re: Update query : Access 97 Steve Schapel (04/18/04)
- Tables and Subtables Tiffany (04/17/04)
- Total rows in a query Michael Beatty (04/17/04)
- Cross Tab Query Criteria Robert W (04/17/04)
- Access2000: Arvi Laanemets (04/17/04)
- User Registration Process... Nugs (04/17/04)
- Query with combo boxes Karen (04/17/04)
- Is it possible ? _at_pollo (04/17/04)
- RE: Query with dates Megan (04/17/04)
- New Table Query? JT (04/17/04)
- Query on identical fields in two tables Scott (04/17/04)
- Averaging the data in a row with access Michael Beatty (04/17/04)
- Input Text into fields with query Kentucky5 (04/17/04)
- Re: Input Text into fields with query Cheryl Fischer (04/17/04)
- Re: Input Text into fields with query Kentucky5 (04/17/04)
- Re: Input Text into fields with query Cheryl Fischer (04/17/04)
- Re: Input Text into fields with query Kentucky5 (04/17/04)
- Re: Input Text into fields with query Kentucky5 (04/17/04)
- Re: Input Text into fields with query Gary Walter (04/17/04)
- Re: Input Text into fields with query Kentucky5 (04/17/04)
- Re: Input Text into fields with query Kentucky5 (04/17/04)
- Re: Input Text into fields with query Cheryl Fischer (04/17/04)
- My little sister giving a handjob janderson_at_optonline.net (04/17/04)
- Period sign for SELECT SQL statement Augustus (04/17/04)
- Query asking for date parameter 2x Joseph (04/17/04)
- Trimming Numeric Values From Text. Nick (04/17/04)
- User Query Fernando (04/16/04)
- query failure rschum_at_compufort.com (04/16/04)
- Match then update query Matt (04/16/04)
- Copy filed value to use a query criteria Evan (04/16/04)
- Unique ID system and multiple data sources Jason (04/16/04)
- Query and dates Megan (04/16/04)
- stupid question Average aggregate function Michael Beatty (04/16/04)
- yes/no datatype stefan (04/16/04)
- Can a query do ... Daniel P (04/16/04)
- outer join is not working sheela (04/16/04)
- queries for duplicates and max date opeyemi1 (04/16/04)
- Macro to "TransferSpreadsheet" Mark (04/16/04)
- Querying on yes/no field check box? Cynthia (04/16/04)
- query with Enter date Tbyird (04/16/04)
- query with Enter date Tbyird (04/16/04)
- Re: Query Help Please! MGFoster (04/16/04)
- Re: Stored date in a query MGFoster (04/16/04)
- Make Table versus Append Query Mark (04/16/04)
- Crosstab query question Dale Peart (04/16/04)
- Re: Crosstab query question Tom Ellison (04/16/04)
- Re: Crosstab query question Dale Peart (04/16/04)
- Re: Crosstab query question Tom Ellison (04/17/04)
- Re: Crosstab query question dbpeart (04/17/04)
- Re: Crosstab query question Tom Ellison (04/17/04)
- Re: Crosstab query question Dale Peart (04/19/04)
- Re: Crosstab query question Tom Ellison (04/19/04)
- Re: Crosstab query question Dale Peart (04/20/04)
- Re: Crosstab query question Tom Ellison (04/20/04)
- Re: Crosstab query question Dale Peart (04/22/04)
- Re: Crosstab query question Dale Peart (04/16/04)
- Re: Crosstab query question Tom Ellison (04/16/04)
- Correlated Subquery depth R Avery (04/16/04)
- Re: Filter on blank dates John Vinson (04/16/04)
- Query results JulieB (04/16/04)
- how do you supress a confrimation on a query when it is giving a message of setting to null anonymous_at_discussions.microsoft.com (04/16/04)
- RE: Suggestions Needed Rowan (04/16/04)
- show minutes not portions of hours in calculation Cheryl (04/16/04)
- Re: show minutes not portions of hours in calculation Ken Snell (04/16/04)
- Re: show minutes not portions of hours in calculation anonymous_at_discussions.microsoft.com (04/17/04)
- Re: show minutes not portions of hours in calculation Ken Snell (04/17/04)
- Re: show minutes not portions of hours in calculation anonymous_at_discussions.microsoft.com (04/19/04)
- Re: show minutes not portions of hours in calculation Ken Snell (04/19/04)
- Re: show minutes not portions of hours in calculation anonymous_at_discussions.microsoft.com (04/19/04)
- Re: show minutes not portions of hours in calculation anonymous_at_discussions.microsoft.com (04/17/04)
- Re: show minutes not portions of hours in calculation Ken Snell (04/16/04)
- Access Query to Make Query Table Shaundra (04/16/04)
- HELP with counting Querie PLEASE Kathy (04/16/04)
- Counting Records/Limiting Vel. (04/16/04)
- number records in a query mikiep (04/16/04)
- RE: Inventory - Field Comparison Rowan (04/16/04)
- Re: Running an Update Subquery Nikos Yannacopoulos (04/16/04)
- Re: Unable to update in filtered query John Vinson (04/16/04)
- Re: add queries John Vinson (04/16/04)
- MS97: Date Calculation Mark (04/16/04)
- Field as a lookup from a 2nd table B Nieds (04/16/04)
- Re: selecting newer values John Spencer (MVP) (04/16/04)
- Update query using values from list box Jen (04/15/04)
- Duplicate Results in Query Rudy (04/15/04)
- Re: Update Subquery Spammastergrand (04/15/04)
- Complex Query - need help R Avery (04/15/04)
- Automatic Entry Stephen (04/15/04)
- Automatic Entry Stephen (04/15/04)
- Numeric field overflow. (Error 3349) CReitsma (04/15/04)
- Numeric field overflow. (Error 3349) CReitsma (04/15/04)
- Last day of last year Saskatoon (04/15/04)
- Crosstab query with date criteria Dennis Hansen (04/15/04)
- Wild cards Denis (04/15/04)
- How do I get Update Query to prompt for update info? Lyn (04/14/04)
- all records for past 2 weeks Annelie (04/14/04)
- Functions in queries DataDay (04/14/04)
- Adding Many Records Stephen (04/14/04)
- Delete query + variable Yohann (04/14/04)
- Append query from two tables with different fieldnames -- easy linking? Jason (04/14/04)
- Combo Box in a Query meghan (04/14/04)
- Do Not Display Empty Records markmidwest (04/14/04)
- Adding Ranking to a Query Joe From Jersey (04/14/04)
- Date parameter causes select query to fail Dave (04/14/04)
- Suppress "#Error" result in query? Gregg Eckhardt (04/14/04)
- Cropping Dates Nina (04/14/04)
- queries with pulldowns Rawley (04/14/04)
- Square root function Jessica (04/14/04)
- Counting the number of groupings www.ttdown.com (04/14/04)
- Query Criteria Dan Young (04/14/04)
- mysterious field "<>" from crosstab query Wei (04/14/04)
- Find and Replace Miker (04/14/04)
- Select Help...No Pun intended Ted (04/14/04)
- Access 97 convert a xtab query into a make table query Kirk P (04/14/04)
- count distinctive records Kristof (04/14/04)
- Slow Query jeff (04/14/04)
- latest date marta (04/14/04)
- Simple Multiplication Keith (04/14/04)
- building a query using other queries Paul James (04/14/04)
- Re: building a query using other queries david epsom dot com dot au (04/15/04)
- Re: building a query using other queries Paul James (04/15/04)
- Re: building a query using other queries david epsom dot com dot au (04/16/04)
- Re: building a query using other queries Paul James (04/16/04)
- Re: building a query using other queries david epsom dot com dot au (04/18/04)
- Re: building a query using other queries Paul James (04/20/04)
- Re: building a query using other queries david epsom dot com dot au (04/22/04)
- Re: building a query using other queries Paul James (04/25/04)
- Re: building a query using other queries Paul James (04/15/04)
- Re: building a query using other queries david epsom dot com dot au (04/15/04)
- Re: building a query using other queries david epsom dot com dot au (04/15/04)
- Comparing two tables and updating one of them Daniel P (04/14/04)
- sum MikeJ (04/14/04)
- Query for specific fields FROTO (04/14/04)
- Format Function - Percent MDW (04/14/04)
- passing input to a SQL query brian (04/14/04)
- Limit Records in a Parameter Query DD (04/14/04)
- Append problem Basil (04/14/04)
- Learning Queries Dan Young (04/14/04)
- maximum number of queries web_time (04/14/04)
- E-Mail addresses exported from Access 2000 John (04/14/04)
- Microsoft Access 97 Erna Henderson (04/14/04)
- Undefined function InParam in expression. David (04/14/04)
- Parameter Query - Limit Records to 14 Days DD (04/14/04)
- Use a query as an email distribution list Kent (04/14/04)
- Too many records EB (04/14/04)
- Summing a "short time" field Art (04/14/04)
- Pass-Through Query Rounding Off Brad (04/14/04)
- Case Statement Rowan (04/14/04)
- filter just duplicate entries cowbell (04/14/04)
- interactive query Taco (04/14/04)
- UPDATE Query Darren Line (04/14/04)
- Convert text to Number Jason (04/14/04)
- Subform skipped after first record Bdehning (04/14/04)
- export wizard Gals (04/14/04)
- Excluding Data Amy Johnson (04/14/04)
- Append and delete Ohio5 (04/14/04)
- Forms and Subforms Dennis (04/14/04)
- Duplicates don't show up in my Union Query Teri (04/14/04)
- Change field from UCase to LCase Rick Dunmire (04/13/04)
- Query Concatenate Issue Craig (04/13/04)
- Only showing related that are most current Deb (04/13/04)
- Select query help! KimberlyC (04/13/04)
- Outer Join in Xtab Query doesn't work Chris (04/13/04)
- No records are displayed Tina (04/13/04)
- Query from Field markmidwest (04/13/04)
- help on a cross tab query Michael Beatty (04/13/04)
- handle Null Wei (04/13/04)
- Parent Records Don't Show When Children Records = 0 Jonathan Mulder (04/13/04)
- Query Problem George Schneider (04/13/04)
- Stock Control - Query David (04/13/04)
- counting characters in a column? scott (04/13/04)
- Function isn't available in expressions Micah (04/13/04)
- Update Query Should Bring up Warning Dialog Box w/ Text Entry Tom (04/13/04)
- Stumped on one query for a form Please help Curt (04/13/04)
- Eliminating Duplicate Records Paul Fenton (04/13/04)
- Count Text JT (04/13/04)
- Make up table Query sue (04/13/04)
- Word merge using Access Query Linda (04/13/04)
- Parameters? Please help. Arch (04/13/04)
- Query Designer and outer joins sqlvs (04/13/04)
- Reverse Cross-Tab query Jeremy (04/13/04)
- Times and a 24hr clock RedForeman ©® (04/13/04)
- Re: Times and a 24hr clock George Nicholson (04/13/04)
- Re: Times and a 24hr clock Gary Walter (04/13/04)
- Re: Times and a 24hr clock RedForeman ©® (04/13/04)
- Re: Times and a 24hr clock Gary Walter (04/13/04)
- Re: Times and a 24hr clock RedForeman ©® (04/13/04)
- Re: Times and a 24hr clock Rick Brandt (04/13/04)
- Re: Times and a 24hr clock RedForeman ©® (04/13/04)
- Re: Times and a 24hr clock Douglas J. Steele (04/13/04)
- Re: Times and a 24hr clock RedForeman ©® (04/14/04)
- Re: Times and a 24hr clock RedForeman ©® (04/13/04)
- How to "pad" a field Darrell Childress (04/13/04)
- Counting the number of events Tom Tripicchio (04/13/04)
- Update Queries Rob Sykes (04/13/04)
- shared property Basil (04/13/04)
- SQL Statements carole (04/13/04)
- Simple Query Heather (04/13/04)
- Simple Query Heather (04/13/04)
- Date/Time Field Mary (04/13/04)
- Leap Year Date Problem Cathy (04/13/04)
- Linking tables to Sybase ODBC Tom Wood (04/13/04)
- to create a Query with 2 Tables Markus Mortsiefer (04/13/04)
- Selecting REMAINING records by excluding others Meryl (04/13/04)
- Expression Problem Gavin (04/13/04)
- Pass Through Queries Max Amsterdam (04/13/04)
- No Current Record error on Yes/No field Caroline Middlebrook (04/13/04)
- Re - Stripping carriage returns & line breaks Function James (04/13/04)
- Records counter in a query Mike (04/13/04)
- Find all references to a query in it's MS Access DB RWM (04/13/04)
- How to perform calculations for working days/hours <field type> date/time yp_ng.osp_at_olympus.com.sg (04/13/04)
- Cross tab query with counts Heather (04/13/04)
- DATEPART FUNCTION Abul Hasan (04/13/04)
- Delete Diane (04/12/04)
- Help Please !! Simple Query and I cannot get it to work !! James (04/12/04)
- Delete Diane (04/12/04)
- Summary Question in a Query Graham Feeley (04/12/04)
- Sum Function messing up date sorting bomantas (04/12/04)
- Sum Function messing up date sorting bomantas (04/12/04)
- Sum Function messing up date sorting bomantas (04/12/04)
- Drop-down list in Query Kyle (04/12/04)
- Relative position of record Stephen (04/12/04)
- Using crosstab queries as the source for reports Karen (04/12/04)
- MS suggestion box is where? Martin (04/12/04)
- How do I comment SQL in a DB2 passthrough query Jeff Hag (04/12/04)
- Average Duration of time ken (04/12/04)
- Too many records... I can't find a solution Vicente Rodriguez Eguibar (04/12/04)
- RACI Help alavery7 (04/12/04)
- Report based on a query NG (04/12/04)
- (+ or -) $ Query RC (04/12/04)
- **Append/Update Query HELP** UBSara (04/12/04)
- Decimal places in crosstab report Susy (04/12/04)
- Order by in Union Query daisy (04/12/04)
- Keyword search Lori (04/12/04)
- Leading zeros in converted ADP query Zachariah (04/12/04)
- Sales Month query Keith (04/12/04)
- Filter saved as a query ctdak (04/12/04)
- Query problem Joe lebrecht (04/12/04)
- Find the right tables to Query???? Steve B (04/12/04)
- Access97 Pass-Thru Query giving Numeric Value out of range(#0) CLM (04/12/04)
- Suppress "year" in a date field Patti (04/12/04)
- Are recursive queries possible? Todd A. Anderson (04/12/04)
- Update Query Ron (04/12/04)
- Union queries Penny (04/12/04)
- Query a table w/o using column names?` MDW (04/12/04)
- When to use make table queries Randal (04/12/04)
- Function Documentation Rob_RSD (04/12/04)
- how to get previous calculated field MacLean (04/12/04)
- Update query help Judd (04/12/04)
- Union query error ken (04/12/04)
- Insert blank rows between groups? Muppet (04/12/04)
- Add new record in form view. Stephen (04/12/04)
- Query opens linked workbook Tod (04/12/04)
- Delete unmatched ID#s Ellen (04/12/04)
- Query crieria help please Andy (04/12/04)
- adding a record in a query with relationships difined only in query Stephen (04/12/04)
- Dynamic Crosstab Query Report Wahab (04/12/04)
- Query All Fields But Sort One Gary Schuldt (04/12/04)
- jet correlated subquery fails david epsom dot com dot au (04/12/04)
- "Syntax error in ALTER TABLE statement.", again... alexttp (04/12/04)
- Queries Performance Clyde Ellingwood (04/12/04)
- Hopefully a simple query Michael Beatty (04/12/04)
- eliminate marfado (04/11/04)
- eliminate date() marfado (04/11/04)
- Trying to remove very similar (not quite duplicate) records h.a. collins (04/11/04)
- Multiple queries Adam (04/11/04)
- Nested query??? Vicente Rodriguez Eguibar (04/11/04)
- Nested query??? Vicente Rodriguez Eguibar (04/11/04)
- Update Total from one Table into another Jeff (04/11/04)
- Sums in a Union Query Jim Pockmire (04/11/04)
- sql insert into 1aae (04/11/04)
- Many to one Tables Dennis (04/11/04)
- Only showing related that are most current Deb (04/11/04)
- probably simple Access query help. Michael Beatty (04/11/04)
- Append Querys? David Miller (04/11/04)
- Check Boxes Asa Kaplan (04/11/04)
- How to Show All 30 Days or Older Deb (04/11/04)
- Local access to Access 2002 Steve (04/10/04)
- Storing query criteria in a Table GimpBoy (04/10/04)
- Query-Run Douglas (04/10/04)
- Form & Queries Robert Raley (04/10/04)
- Quotes and apostrophes in WHERE clause DARAB (04/10/04)
- finding a single record from many John Thomson (04/10/04)
- Calculating Stepped Amounts Emma Hope (04/10/04)
- link to previous record query david epsom dot com dot au (04/10/04)
- Rounding a price in Excel KLAUS (04/10/04)
- Criteria from table GimpBoy (04/10/04)
- Multilingual Queries Babar Rahim (04/10/04)
- assigning auto numbers to groups of records in a table DayStar (04/09/04)
- Modification of LEN and LEFT functionality Tom (04/09/04)
- Multi-Table Query Ripper (04/09/04)
- Query Date Joseph (04/09/04)
- Delete query problem Michael O'Dell (04/09/04)
- Convert nz > iif problem - stumped Larry Marshall (04/09/04)
- Importing info from one excel file to another Judd (04/09/04)
- Last Question on Select Query ken (04/09/04)
- Format Function BlackSun (04/09/04)
- Need help with query expression Tom (04/09/04)
- Conditional Criteria Nathan C. Lee (04/09/04)
- Incorrect display in Query Ian (04/09/04)
- Another Question about Select Queries ken (04/09/04)
- aggregate function on union query george (04/09/04)
- Is this subquery possible? Mykal73 (04/09/04)
- Delete duplicate records Ellen (04/09/04)
- How to specify the field type for a calculated field Rob LMS (04/09/04)
- Query problem in regards to Item Collection Stacey (04/09/04)
- Re: Query problem in regards to Item Collection Gerald Stanley (04/09/04)
- Re: Query problem in regards to Item Collection anonymous_at_discussions.microsoft.com (04/09/04)
- Re: Query problem in regards to Item Collection Gerald Stanley (04/09/04)
- Re: Query problem in regards to Item Collection anonymous_at_discussions.microsoft.com (04/09/04)
- Re: Query problem in regards to Item Collection Gerald Stanley (04/09/04)
- Re: Query problem in regards to Item Collection anonymous_at_discussions.microsoft.com (04/09/04)
- Re: Query problem in regards to Item Collection anonymous_at_discussions.microsoft.com (04/09/04)
- Re: Query problem in regards to Item Collection Gerald Stanley (04/09/04)
- Turn off confirmations for action queries Rob LMS (04/09/04)
- Getting wrong information in query Karen (04/09/04)
- Dynamic Query to show/not show field Tom (04/09/04)
- Select Query ken (04/09/04)
- field names Dennis (04/09/04)
- SQL Insert Into (Join) Glenn (04/09/04)
- query LOIS (04/08/04)
- Date Queries Shaji (04/08/04)
- Repeating values Jim (04/08/04)
- Set Value JOHN (04/08/04)
- using a percentage in a calculated statistic query Maria (04/08/04)
- Partial String Update Wayne Emminizer (04/08/04)
- condition in query woyo (04/08/04)
- Duplicates Eric (04/08/04)
- Access crashes when I try to save some queries John (04/08/04)
- Using criteria prompts in crosstab Donna Brooks (04/08/04)
- page break on group value JIM.H. (04/08/04)
- => Query to copy tbl1 split entries into tbl2 Rhonda Fischer (04/08/04)
- Query range starting with 1 John (04/08/04)
- Re: URGENT!!! parameter queries Jim (04/08/04)
- Sintax error Rodolfo Fontes (04/08/04)
- Deplete records from a table with every successive query MJ (04/08/04)
- queries on calculated date abe espinosa (04/08/04)
- Domain Aggregate Query W/ Criteria MDW (04/08/04)
- SQL Kirk P (04/08/04)
- use currentuser as criteria for a query Rick (04/08/04)
- Unix Time, Query criteria, and Null values Johnny (04/08/04)
- how to get previous calculated field MacLean (04/08/04)
- SQL-function to encrypt password like password() in mySQL? Hyko (04/08/04)
- Emulate SQL Type Conversion "ALTER TABLE - CHANGE" in ACCESS 97 TDN (04/08/04)
- "Numeric->Text" Type conversion in "Make Table" Query TDN (04/08/04)
- adding records and relationships in queries. relationship types Stephen. (04/08/04)
- Query with LIke Statement Tausif Alam (04/08/04)
- INSERT INTO (JOIN) Glenn (04/08/04)
- exporting delim file Gals (04/08/04)
- Delete Query Help Please!!! Michael O'Dell (04/08/04)
- How to break a selection query if possible Frank M. (04/08/04)
- Program crashes? not (04/08/04)
- Auto Duplicate of Records Daniel (04/08/04)
- Parameter Query Craig (04/07/04)
- Invalid Argument error when using a update query ecat1921 (04/07/04)
- update fields Kelly Z. (04/07/04)
- Query produces no records Craig (04/07/04)
- Need to build array of ranges - Partition Function not enough CJ (04/07/04)
- Query criteria and dates Gavin (04/07/04)
- Criteria in a Crosstab Query Donna Brooks (04/07/04)
- parameter query on two fields Tom Nichol (04/07/04)
- Parameter Query on two fields Tom Nichol (04/07/04)
- Hierarchy Adam (04/07/04)
- Parameter Query Craig (04/07/04)
- Limiting Decimal Places in a Crosstab Union Query Susy (04/07/04)
- Query Criteria from Forms Carol (04/07/04)
- Category Report George Schneider (04/07/04)
- Finding length of time Jason (04/07/04)
- Find Matches Query: Is there a maximum length to a search string? Stuart E. Wugalter (04/07/04)
- Linking two Querys Stuart (04/07/04)
- Conversion of chemical ID numbers Ellen (04/07/04)
- Top 5 Query Problem Paul (04/07/04)
- Query on last sheetID number Rick Patterson (04/07/04)
- Complie error using Dateserial function Zac (04/07/04)
- Complicated delete query Ragnar Midtskogen (04/07/04)
- Query on Large table Michael (04/07/04)
- Re: Memo fields truncated in Group queries mikema15025 (04/07/04)
- print a query in design view? mate (04/07/04)
- Criteria on queries changes to invalid syntax dandman (04/07/04)
- Thanks aa (04/07/04)
- how to quiery and print it???? Luis (04/07/04)
- Re: finding missing numbers in a sequence Brad Grove (04/07/04)
- query calculation question Joe (04/07/04)
- Delete query Ellen (04/07/04)
- Query Problem Steven Scaife (04/07/04)
- recordset is not updateable lynn atkinson (04/07/04)
- Acccess --> Oracle (unix Solaris) JJZZ (04/07/04)
- Unable to modify a query Chris (04/07/04)
- very weird query problem Julian Cropley (04/07/04)
- Find Matching records Dunderhead (04/07/04)
- Weird query giving unexpected results. Julian (04/07/04)
- Access database gajendra.chouhan_at_siemens.com (04/07/04)
- Duplicate Records in my Query Joy Mendleson (04/07/04)
- Access question MIchael (04/07/04)
- Checklist Query Chip (04/07/04)
- Get current row Hai Ly Hoang (04/07/04)
- Get current row Hai Ly Hoang (04/07/04)
- Stock Transaction Query depawl (04/07/04)
- Creating mailing address Terri (04/06/04)
- Help with General Approach Alan Nicoll (04/06/04)
- SQL commenting II Martin (04/06/04)
- Append queries for Access Dummies Dee (04/06/04)
- Networkdays in Access Ellen (04/06/04)
- Adding "is Null" to a query produces unexpected results Matt (04/06/04)
- Lookup Score in table on Variables C. Houk (04/06/04)
- Query gone Missing Brian (04/06/04)
- Simulate VLookup from Excel in Access Brian (04/06/04)
- SQL commenting Martin (04/06/04)
- Median & Mode Calcuation (Con't) ES (04/06/04)
- 3rd Business Day Manuel (04/06/04)
- If Statement not working Heather (04/06/04)
- RE: Invalid Argument Error Ann (04/06/04)
- Query compilation and speed Andrew Smith (04/06/04)
- Adding fields to a Query Please Help (04/06/04)
- Criteria Expression geohawk (04/06/04)
- DIVIDING TEXT sUSAN (04/06/04)
- Updateable Max Query Charles D Clayton Jr (04/06/04)
- query prompts SPM2 (04/06/04)
- SQL Query - a little tricky John (04/06/04)
- converting record info into fields Dale Peart (04/06/04)
- adding records and relationships in queries. relationship types Stephen (04/06/04)
- NETWORKIO?!?! Jason McClellan (04/06/04)
- Setting a new value Calvin Shane (04/06/04)
- multiple search joe (04/06/04)
- help with a query (probably simple) Clay (04/06/04)
- Do not understand the result of a query from 4 tables Le Tran (04/06/04)
- select distinct Matt Pollicove (04/06/04)
- Cumulative Queries with a twist Derek Wittman (04/06/04)
- Calculating Date over 1 year chris wass (04/06/04)
- Moving Average Ted (04/06/04)
- Query calculation question? Mike (04/06/04)
- Re: Query calculation question? John Viescas (04/06/04)
- Re: Query calculation question? MGFoster (04/06/04)
- Re: Query calculation question? Mike Pallos (04/06/04)
- Re: Query calculation question? John Viescas (04/07/04)
- Re: Query calculation question? Mike Pallos (04/08/04)
- Re: Query calculation question? John Viescas (04/08/04)
- Re: Query calculation question? Mike Pallos (04/08/04)
- Re: Query calculation question? MGFoster (04/08/04)
- Re: Query calculation question? Mike Pallos (04/08/04)
- Re: Query calculation question? Mike Pallos (04/06/04)
- RE: Criteria for Yes/No and Check Box anonymous_at_discussions.microsoft.com (04/06/04)
- List field names Marie (04/06/04)
- Split Single Address Field into Component Parts Ben Johnson (04/06/04)
- Two subforms - joins in query Natalie (04/06/04)
- Parameter Values? Peter (04/06/04)
- Count or Sum??? Graham Feeley (04/06/04)
- Help finding all of the correct records in a query Jason M Canady (04/06/04)
- need to merge 2 tables joined on a field Muppet (04/06/04)
- VBA - Import *.txt to Access marcus. (04/06/04)
- Combining fields Jason McClellan (04/06/04)
- Query to Pull Last Date Frolickin (04/06/04)
- Sum Function Problem bomantas (04/06/04)
- RE: QueryDefs.Delete Djoezz (04/06/04)
- Code in Form Dennis (04/06/04)
- Concatenate and Append Kentucky (04/06/04)
- Duplicate Output Destination Bonnie (04/06/04)
- Query for Averageing RobinF (04/05/04)
- Truncated text fields in unique value query Gwen (04/05/04)
- Non Equi Join C. Houk (04/05/04)
- Query prompt for table? Andrew (04/05/04)
- Using Combo Box to Select Date Range Ripper (04/05/04)
- discovering duplicated values through SQL rocco (04/05/04)
- Creating Drop Down Menus James (04/05/04)
- MS Query installation error Mike (04/05/04)
- Event procedure -Query Adrienne (04/05/04)
- Access 2002 Queries Cathie (04/05/04)
- Update query to convert names to Proper format? Amit (04/05/04)
- Is query being used? Leisha (04/05/04)
- Automatic Deleting of Records in Table Faxylady (04/05/04)
- combining queries in sql Danny Boukhris (04/05/04)
- Number of Workdays in a month.... Lynndyhop (04/05/04)
- Using Global Vars in queries greghedberg (04/05/04)
- Find Duplicate/Unmatched Budd R. (04/05/04)
- Somewhat Duplicate Records Jason Silva (04/05/04)
- Date format HEG (04/05/04)
- Invalid argument Paul Camilleri (04/05/04)
- Sorting with null / blank fields last justme_at_iou.com (04/05/04)
- Duplicate records Le Tran (04/05/04)
- Need to add hyphens Ellen (04/05/04)
- Query quandry gail (04/05/04)
- Incrementing a variable on a field in the current table Michael (04/05/04)
- Collasping fields Ellen (04/05/04)
- Insert/update of MEMO data using RunSQL nermal (04/05/04)
- Query parametre period of time sotiris_s (04/05/04)
- add record in query with related links Stephen. (04/05/04)
- count empty boxes Sabine (04/05/04)
- upgrade to access 2003 help brittany (04/05/04)
- Getting latest count quantities Mark (04/05/04)
- Please Help Kirst (04/05/04)
- export query - vba marcus. (04/05/04)
- Parameter query criteria for null dates John Baker (04/05/04)
- Mult. Queries One report NigelP (04/05/04)
- How to specify the name of the database to export to in a make table query Neil Robbins (04/05/04)
- Re: How to specify the name of the database to export to in a make table query Chris2 (04/05/04)
- Re: How to specify the name of the database to export to in a make table query Neil Robbins (04/05/04)
- Re: How to specify the name of the database to export to in a make table query Michael Cheng (04/05/04)
- Re: How to specify the name of the database to export to in a make table query Neil Robbins (04/05/04)
- Re: How to specify the name of the database to export to in a make table query Chris2 (04/05/04)
- Re: How to specify the name of the database to export to in a make table query Neil Robbins (04/08/04)
- Re: How to specify the name of the database to export to in a make table query Michael, Cheng [MST] (04/12/04)
- Re: How to specify the name of the database to export to in a make table query Yan-Hong Huang[MSFT] (04/14/04)
- Re: How to specify the name of the database to export to in a make table query Neil Robbins (04/05/04)
- Re: How to specify the name of the database to export to in a make table query Chris2 (04/05/04)
- Saving a quiry to a disc for forwarding other than by e-mail Joe (04/05/04)
- Workday Travis Grob (04/05/04)
- Picture Query Domo (04/04/04)
- Two Column Table R. BRADFORD THOMAS (04/04/04)
- Active or Open Records Bob (04/04/04)
- CREATE TEMPORARY TABLE ...problem matthew (04/04/04)
- DATE() William Gargan (04/04/04)
- Tab Control problem Dennis (04/04/04)
- Problem with Make Table Query - Resultant Table not allowed to have more than one AutoNumber field. Neil Robbins (04/04/04)
- Emailing Data... Pommy_g (04/04/04)
- Re: XQuery capabilities in Access Anders Tomilsson (04/04/04)
- Pass Function Return to Query Pat G (04/04/04)
- Update query to update filds with password newbie (04/03/04)
- Upgrading Office 97 to Office XP Student Edition DenisP_at_discussions.microsoft.com (04/03/04)
- Query referencing dialog box Jenn (04/03/04)
- Re: Query Criteria from a Selection anonymous_at_discussions.microsoft.com (04/03/04)
- update query JIM.H. (04/03/04)
- Show last donation by each Company borris (04/03/04)
- question ... query and filtering Andy_HR (04/03/04)
- Re: Query merge to Word problem denfille (04/03/04)
- Dynamically updating Query Criteria Bob (04/03/04)
- Network access - table locks up Noni Ledford (04/03/04)
- Initial caps sbsmith (04/02/04)
- Re: Problem mailmerging query data into MS Word Danhur (04/02/04)
- Re: querydef help missing. B Nieds (04/02/04)
- HELP!!! with Access 2003 "overflow" dialog box. Todd A. Anderson (04/02/04)
- Join two table query with third table Shailesh Patel (04/02/04)
- Join two table Query with third table Shailesh Patel (04/02/04)
- Pivot Chart and Percentages of Total Bill Unger (04/02/04)
- Too Few Parameters - Access can't find the name 'Enter book' Roger Carlson (04/02/04)
- Re: Too Few Parameters - Access can't find the name 'Enter book' John Viescas (04/02/04)
- Re: Too Few Parameters - Access can't find the name 'Enter book' Gary Walter (04/03/04)
- Re: Too Few Parameters - Access can't find the name 'Enter book' Gary Walter (04/03/04)
- Re: Too Few Parameters - Access can't find the name 'Enter book' Gary Walter (04/03/04)
- Re: Too Few Parameters - Access can't find the name 'Enter book' Roger Carlson (04/05/04)
- Re: Too Few Parameters - Access can't find the name 'Enter book' Gary Walter (04/05/04)
- Re: Too Few Parameters - Access can't find the name 'Enter book' Gary Walter (04/05/04)
- Re: Too Few Parameters - Access can't find the name 'Enter book' Roger Carlson (04/05/04)
- Re: Too Few Parameters - Access can't find the name 'Enter book' Roger Carlson (04/05/04)
- Re: Too Few Parameters - Access can't find the name 'Enter book' Gary Walter (04/03/04)
- Querry on current record Rick Patterson (04/02/04)
- Problems with Unmatched Query and a Filter Chris (04/02/04)
- OR operator not working Perico (04/02/04)
- automating queries question Tom (04/02/04)
- Update Query Tim (04/02/04)
- String representation of a datetime value is out of range SHIPP (04/02/04)
- error in query lavanya (04/02/04)
- CrossTab Query Tom Hart (04/02/04)
- Gridline Printing Problem in Access 2002 Rich Harrington (04/02/04)
- Append Query | Multiple Tables Tom (04/02/04)
- Subtotals David Hoyle (04/02/04)
- Parameter queries Daniel Biancuzzo (04/02/04)
- What type of Query and How Allison (04/02/04)
- Run an Update Query with a filter? Don Seckler (04/02/04)
- separate lastname and first name from colum Danny (04/02/04)
- Drop Primary Key with SQL/VBA gorden blom (04/02/04)
- Bitting off more than I can chew Kenneth John Howie (04/02/04)
- Requery Combo box Nick (04/02/04)
- Parameter query John Baker (04/02/04)
- Calculating fields Robin (04/02/04)
- Re: Syntax error in FROM clause Chris2 (04/02/04)
- Re: SORT QUESTION Chris2 (04/02/04)
- RE: Order by 4 columns at once Michael Cheng (04/02/04)
- Locking queries - datasheet view Matt (04/02/04)
- Need help Jim Toler (04/02/04)
- Simple query executes fast but renders slow... BradP (04/01/04)
- Need Advice Please Tom (04/01/04)
- Append Query Mike C. (04/01/04)
- Query pulling data from a Form Dave (04/01/04)
- Weird problem with make table query! Ragnar Midtskogen (04/01/04)
- duplicate a subset of records in a table Dale (04/01/04)
- IIF statement problem susm (04/01/04)
- Complex IIF Statement George Schneider (04/01/04)
- Who's due for a shot? Donna Brooks (04/01/04)
- Unionizing Queries annamcbeth_at_contres.com (04/01/04)
- Output to Excel File seo-highrankings.com (04/01/04)
- linking multiple tables into one Georgia (04/01/04)
- Rounding MattAccess (04/01/04)
- most recent George (04/01/04)
- Selecting the last two instances per group TJBernard (04/01/04)
- A query that compares with the current date willx (04/01/04)
- ODBC Timeout Randy K. (04/01/04)
- Automatically Delete duplicated Data from a table Faxylady (04/01/04)
- URGENT!! Using IIF in query karen (04/01/04)
- On A Make Table Query Is It Possible to Surpress Prompts? mcl (04/01/04)
- Again... creatiing table for each group Akira (04/01/04)
- Subquery Help Kirk P (04/01/04)
- Re: Delete Query does not work! Renvik (04/01/04)
- Query formating data for another program. Ezra (04/01/04)
- Sort Union query result by two fields Clementius (04/01/04)
- Access Queries wont run and return "Record Deleted" Lisa Theobald (04/01/04)
- Calculations Amy (04/01/04)
- Make Table Formatting Problem anonymous_at_discussions.microsoft.com (04/01/04)
- MS Access update query -Validation rule error just a guy (04/01/04)
- Help with query: DateDiff and counting Emma (04/01/04)
- Microsoft Access set 0 field(s) to Null due to ... krisrajz (04/01/04)
- Alphanumeric sort Dave (04/01/04)
- Totals Query James (04/01/04)
- Re: Totals Query Gerald Stanley (04/01/04)
- Re: Totals Query James (04/02/04)
- Re: Totals Query Gerald Stanley (04/02/04)
- Re: Totals Query James (04/02/04)
- Re: Totals Query Gerald Stanley (04/02/04)
- Re: Totals Query James (04/05/04)
- Re: Totals Query Gerald Stanley (04/05/04)
- Re: Totals Query James (04/05/04)
- Re: Totals Query Gerald Stanley (04/05/04)
- Re: Totals Query Jame (04/06/04)
- Re: Totals Query James (04/02/04)
- Re: Totals Query Gerald Stanley (04/01/04)
- Auto Number Warren (04/01/04)
- Adding to query Book Man (04/01/04)
- Re: Counting Karen (04/01/04)
- Re: Networkdays function in Access Michel Walsh (04/01/04)
- Automating splitting a flat file into related tables. Rob R (04/01/04)
- Field Format Question!! pmsuper (04/01/04)
- Booking Query Cam (04/01/04)
- Re: Queries with no records - John Viescas?? Tony Williams (04/01/04)
- Re: Queries with no records - John Viescas?? John Viescas (04/01/04)
- Re: Queries with no records - John Viescas?? Tony Williams (04/01/04)
- Re: Queries with no records - John Viescas?? John Viescas (04/01/04)
- Re: Queries with no records - John Viescas?? Tony Williams (04/01/04)
- Re: Queries with no records - John Viescas?? John Viescas (04/01/04)
- Re: Queries with no records - John Viescas?? Tony Williams (04/01/04)
- Re: Queries with no records - John Viescas?? John Viescas (04/01/04)
- Re: Queries with no records - John Viescas?? Tony Williams (04/02/04)
- Re: Queries with no records - John Viescas?? Tony Williams (04/01/04)
- Re: Queries with no records - John Viescas?? John Viescas (04/01/04)
- Query outputs wrong results! Ruben Granados (04/01/04)
- Re: Saving complex query blows up Access 2002! Michael Cheng (04/01/04)
- Re: Saving complex query blows up Access 2002! Mark Burns (04/02/04)
- Re: Saving complex query blows up Access 2002! Michael, Cheng [MST] (04/06/04)
- Re: Saving complex query blows up Access 2002! Mark Burns (04/06/04)
- Re: Saving complex query blows up Access 2002! Mark Burns (04/07/04)
- Re: Saving complex query blows up Access 2002! Michael, Cheng [MST] (04/08/04)
- Re: Saving complex query blows up Access 2002! Mark Burns (04/09/04)
- Re: Saving complex query blows up Access 2002! Michael, Cheng [MST] (04/09/04)
- Re: Saving complex query blows up Access 2002! Michael, Cheng [MST] (04/06/04)
- Re: Saving complex query blows up Access 2002! Mark Burns (04/02/04)
- Q. Calculate a column to be included in form and report ? Jim Jones (04/01/04)
- Re: Update 5,000 records at a time John Vinson (04/01/04)
- query grindingly slow! marcus (04/01/04)
- Re: Compare 2 files and delete Dennis (04/01/04)
- average of best 10 George (04/01/04)
- Re: Query? Allen Browne (04/01/04)
- Summarize in Report bomantas (04/01/04)
- Summarize in Report bomantas (04/01/04)
- Max value function dan_johnson_at_hotmail.com (04/01/04)
- Re: Query Syntax error for Concatenate Ken Snell (04/01/04)
- Re: expression and new field on query JulieD (04/01/04)
- Re: Challenging Query/report Sophia (04/01/04)
- Sorting a query on part of a date. Neil Grantham (04/01/04)
- Need help Jim Toler (04/01/04)
- Challenging Query/Report - Reposted Sophia (04/01/04)
- Re: Find records without any corresponding record in another table Brad (03/31/04)
- Big idea goes kablooey Tod (03/31/04)
- Re: Query converted to VBA code Douglas J. Steele (03/31/04)
- Two logical tests in IIF statement Pete Provencher (03/31/04)
- Update Query Adrienne (03/31/04)
- Re: BIZZARE issue can not view data added to table John Vinson (03/31/04)
- It works!!! Thanks, Chris Paul James (03/31/04)
- Re: update query not updatable John Vinson (03/31/04)
- Aggregate fields using query Clementius (03/31/04)
- 4 parameters and the query return no records! Simon (03/31/04)
- Query maggie (03/31/04)
- Re: Rank (Simple Order) John R. Baker (03/31/04)
- RE: Need to select first N rows which meet criteria Mike Klein (03/31/04)
- Renew field for library database Marko (03/31/04)
- Re: multiple Criteria Georgia (03/31/04)
- Programatically Changing Query Criteria Allan Koodray (03/31/04)
- Query on Today's Date markmidwest (03/31/04)
- Re: multiple field "or" criteria nd (03/31/04)
- removing certain entries mate (03/31/04)
- Update Query Not Updatable Kevin (03/31/04)
- Access closes when saving query Tod (03/31/04)
- Re: Missing Numbers Tom Ellison (03/31/04)
- date function query kevin (03/31/04)
- An easy problem treseau (03/31/04)
- An easy problem treseau (03/31/04)
Last message date: 04/30/04
Archived on: 04/30/04 GMT
3063 messages sorted by: [ date ]
