microsoft.public.access.queries
By Thread
3123 messages sorted by: [ date ]
Starting: 06/30/04
Ending: 07/31/04
- ReRunning Query Scott (07/31/04)
- Group by clause on 3 tables Jack (07/31/04)
- Query for Report Dennis (07/31/04)
- Non-responding Query Jon (07/31/04)
- Select or "ALL" Based on a unbound form Newbie Chris Belcher (07/31/04)
- INSERT INTO problem Ivan Debono (07/31/04)
- Inserting a form based on a crosstab query Greg Horwood (07/31/04)
- Query/Report Question Scott (07/31/04)
- Parameter Query Alexander (07/31/04)
- Re: checkbox Ken Snell (07/31/04)
- Re: Change a field name M.L. Sco Scofield (07/31/04)
- UNION ALL Query Brook (07/31/04)
- Changes made to query aren't saved--Access 2000 vicky0512 (07/30/04)
- Repost: Query to records that occured within "X" number of minutes of each other Dale (07/30/04)
- If for rounding numbers Mike (07/30/04)
- Adding a new record to a query in access project Chris (07/30/04)
- Your advice for Many to many relain.. Tom (07/30/04)
- Partial Name Prompt Question bdehning (07/30/04)
- Partial Name Prompt Question matt (07/30/04)
- RE: Partial Name Prompt Question bdehning (07/30/04)
- Re: Partial Name Prompt Question Gary Walter (07/31/04)
- Re: Partial Name Prompt Question bdehning (07/31/04)
- Re: Partial Name Prompt Question Gary Walter (07/31/04)
- Re: Partial Name Prompt Question bdehning (07/31/04)
- Re: Partial Name Prompt Question Gary Walter (07/31/04)
- Re: Partial Name Prompt Question bdehning (07/31/04)
- RE: Partial Name Prompt Question bdehning (07/30/04)
- Partial Name Prompt Question matt (07/30/04)
- Group By Margaret (07/30/04)
- Replacement bladelock (07/30/04)
- Update a field with data from another field kboy (07/30/04)
- Change Column Headings Automatically Craig (07/30/04)
- Rank Craig (07/30/04)
- Date (Stupid Question) Tim (07/30/04)
- What am I missing in outer join query Sunny (07/30/04)
- "UNION" Query with different fields in the two tables Dkline (07/30/04)
- Max? DMax? Just give me the higher value Colby (07/30/04)
- Repost kasey (07/30/04)
- Merging 2 tables, from 2 DB's JR James Randall (07/30/04)
- DLookup Shanin (07/30/04)
- Delete Query Shanin (07/30/04)
- Invalid Trailing Spaces Match Michael Keck - U of I (07/30/04)
- microsoft access query ethan (07/30/04)
- form criteria Rodolfo Fontes (07/30/04)
- My query broke after 6 years. Todd Heiks (07/30/04)
- Truncating Text Fileds M B (07/30/04)
- Select distinct with memo field Jerry (07/30/04)
- Parameter Query Alexander (07/30/04)
- relationship? Matthew (07/30/04)
- SQL view Information not working Allison (07/30/04)
- Why has Access altered the code george (07/30/04)
- Multiple Option Group Synchronize issue bdehning (07/30/04)
- UPDATE query won't update Richard Hollenbeck (07/30/04)
- Ordering number query JME (07/30/04)
- Code Needed Tammy (07/30/04)
- currency query VIK (07/30/04)
- Comparison of Signs Diane (07/29/04)
- Pilot Time tracking database - related date fun... Richard Perry (07/29/04)
- RE: Query truncating memo field A Dodson (07/29/04)
- Duplicates by text field partition mick bartels (07/29/04)
- Re-Post: Bring 3 queries into one query Ashley (07/29/04)
- negative autonumber aa (07/29/04)
- Filter by Date Query DD (07/29/04)
- Group By Margaret (07/29/04)
- Converting Crosstab Query to a Pass-Through Query Demian Valle (07/29/04)
- Find part number used more than 3 juan (07/29/04)
- Printing Lists of Queries Emily Loomer (07/29/04)
- Parameter in a Cross-tab query Vincdc (07/29/04)
- inventory Kasey (07/29/04)
- Outer join/Null possibility Evan McCutchen (07/29/04)
- Numeric data in text field Mary (07/29/04)
- Split one field into two fields John (07/29/04)
- Formatting Address Fields Michael Bartels (07/29/04)
- Array question PurdueNate (07/29/04)
- Querry Result using Max H. Dwight Cornett (07/29/04)
- Confused, crazy, or maybe just plain dumb? Nick M (07/29/04)
- select query - Appending 2 tables Dennis H (07/29/04)
- generating my own autonumbers lemonade (07/29/04)
- Parameter Query Scott Matheny (07/29/04)
- Counting in a query - need help! JD (07/29/04)
- OE removed access to the following......... Guy (07/29/04)
- OE removed access to the following......... anonymous_at_discussions.microsoft.com (07/29/04)
- :) Scott (07/29/04)
- Complex query Wolfe (07/29/04)
- DELETE query not working Usommer (07/29/04)
- DELETE query not working Usommer (07/29/04)
- back end mdb emiel.alkemade_at_pandora.be (07/29/04)
- Export a MSAccess form to VB6.0 Rocío (07/29/04)
- AutoNumber Alexander (07/29/04)
- Removing html tags from field JA (07/29/04)
- Repost of Problem with Accessing JOINed Data Laurie Eaton (07/29/04)
- need help bob (07/29/04)
- Inner join problem JME (07/29/04)
- Find Unmatched records Tom (07/29/04)
- Dynamic Filter Catherine (07/28/04)
- Populate a second table with info from first table debbyh (07/28/04)
- How to pull 1000 characters JA (07/28/04)
- How to update to Null JA (07/28/04)
- Help!!! Arnoldo Calvo (07/28/04)
- Bring 3 queries into one query Ashley (07/28/04)
- Queries Desmond (07/28/04)
- Access 2003 append query truncates memo fields anonymous_at_discussions.microsoft.com (07/28/04)
- RunSQL vs builder query ctdak (07/28/04)
- Make table query creating new field? M Shannon (07/28/04)
- Expression under new pc with XP Eelke (07/28/04)
- Duplicates Allison (07/28/04)
- Simplify SQL Alan (07/28/04)
- Form to query interace.... Scott Matheny (07/28/04)
- Advice...which is more efficient Carlee (07/28/04)
- How do I run a query for a form with multi-select list box ria (07/28/04)
- Trying to add two more peices of information to an already too-complicated query. Richard Hollenbeck (07/28/04)
- Make Table Query Clayton (07/28/04)
- Trying to add two more peices of information to an already too-complicated query. Richard Hollenbeck (07/28/04)
- Trying to add two more peices of information to an already too-complicated query. Richard Hollenbeck (07/28/04)
- Expressions in Crosstab Queries Johnny Access (07/28/04)
- Trying to add two more peices of information to an already too-complicated query. Richard Hollenbeck (07/28/04)
- Trying to add two more peices of information to an already too-complicated query. Richard Hollenbeck (07/28/04)
- Help BillT (07/28/04)
- Unupdated queries Ray (07/28/04)
- Divison by Zero Error (even using iif) Dan (07/28/04)
- Error when trying to modify design Mike Kirros (07/28/04)
- Question regarding counts in a query JD (07/28/04)
- Combining records Rebecca (07/28/04)
- current form Taher (07/28/04)
- current open form Taher (07/28/04)
- data field type conversion within a query possible? Di (07/28/04)
- Exporting Data from a Crosstab Query to an Access Table Jim Pockmire (07/28/04)
- Continuous Range Lookup from Discrete Table Krishna Khemraj (07/28/04)
- not so simple tast for a query -- help JR (07/28/04)
- Help me please James (07/28/04)
- Working Days_Start and End Tim Loeffelholz (07/28/04)
- IsError Function in Query Jeff (07/28/04)
- Undefined function 'Mid' in expression error Eric _at_ SEASH, Evansville (07/28/04)
- Improper Ascending Function echajmovic (07/28/04)
- Query is too Complex Al V (07/28/04)
- multi column to 1 query Anton (07/28/04)
- Julian date Chris Savedge (07/28/04)
- make-table query james (07/28/04)
- Changing format for a new field Almost There! (07/28/04)
- Problems with inserting european dates with sql sentences hagi (07/28/04)
- Re: Problems with inserting european dates with sql sentences Michel Walsh (07/28/04)
- Re: Problems with inserting european dates with sql sentences Jamie Collins (07/28/04)
- Re: Problems with inserting european dates with sql sentences Michel Walsh (07/28/04)
- Re: Problems with inserting european dates with sql sentences Jamie Collins (07/28/04)
- Re: Problems with inserting european dates with sql sentences Michel Walsh (07/29/04)
- Re: Problems with inserting european dates with sql sentences Jamie Collins (07/30/04)
- Re: Problems with inserting european dates with sql sentences Jamie Collins (07/28/04)
- Re: Problems with inserting european dates with sql sentences Michel Walsh (07/28/04)
- SQL-SELECT FROM a stored procedure with parameters... Hyko (07/28/04)
- from n records become n-square records?? kayak (07/28/04)
- Word cannot "see" all the queries korgman (07/28/04)
- Re: Word cannot "see" all the queries Van T. Dinh (07/28/04)
- Re: Word cannot "see" all the queries korgman (07/29/04)
- Re: Word cannot "see" all the queries Van T. Dinh (07/29/04)
- Re: Word cannot "see" all the queries korgman (07/31/04)
- Re: Word cannot "see" all the queries korgman (07/31/04)
- Re: Word cannot "see" all the queries Douglas J. Steele (07/31/04)
- Re: Word cannot "see" all the queries korgman (07/31/04)
- Re: Word cannot "see" all the queries Douglas J. Steele (07/31/04)
- Re: Word cannot "see" all the queries korgman (07/29/04)
- Re: Word cannot "see" all the queries Gary Walter (07/29/04)
- Re: Word cannot "see" all the queries Van T. Dinh (07/28/04)
- Bring together 2 queries bdehning (07/28/04)
- Appending date from one table to multiple tables Stranger (07/28/04)
- Append one table to multiple tables? Stranger (07/28/04)
- Comparing Records Dale (07/28/04)
- Append query into a table with an autonumber Stanley (07/28/04)
- help!!!! rhaake (07/28/04)
- count multiple fields of one table in one query Flora (07/27/04)
- VB to hide field when [Me] is displayed....? Petra (07/27/04)
- Transpose Query Bill Sturdevant (07/27/04)
- Question on Dates Shanin (07/27/04)
- Office 2003 SP1 Released to public Wayne Morgan (07/27/04)
- Update form results using drop down box M Shannon (07/27/04)
- Top 10 dimwit (07/27/04)
- Web Based Query Maker Tim Weninger (07/27/04)
- INNER JOIN table to query - need to delete query! Haydnw (07/27/04)
- expression is too complex to be evaluated Paul James (07/27/04)
- Data Tranformation thru Query??? Debbie Hatten (07/27/04)
- Complicated Update query PS (07/27/04)
- Calculating time online James (07/27/04)
- parameter query with drop down? sallyt (07/27/04)
- COUNT help bidllc (07/27/04)
- Access 97 date range query arnoldo calvo (07/27/04)
- Update Queries Kay (07/27/04)
- Re-post: Cancel parameter query Ashley (07/27/04)
- Update Query Kay (07/27/04)
- Suppress blank rows in crosstab Rajat (07/27/04)
- First 5 numbers fgwiii (07/27/04)
- Field value contains "#Error" anonymous_at_discussions.microsoft.com (07/27/04)
- Field value contains "#Error" hj (07/27/04)
- Field value contains "#Error" anonymous_at_discussions.microsoft.com (07/28/04)
- Field value contains "#Error" hj (07/28/04)
- Field value contains "#Error" anonymous_at_discussions.microsoft.com (07/28/04)
- Field value contains "#Error" hj (07/28/04)
- Field value contains "#Error" anonymous_at_discussions.microsoft.com (07/28/04)
- Field value contains "#Error" hj (07/28/04)
- Field value contains "#Error" anonymous_at_discussions.microsoft.com (07/28/04)
- Field value contains "#Error" hj (07/29/04)
- Field value contains "#Error" anonymous_at_discussions.microsoft.com (07/29/04)
- Field value contains "#Error" anonymous_at_discussions.microsoft.com (07/28/04)
- Field value contains "#Error" anonymous_at_discussions.microsoft.com (07/28/04)
- Field value contains "#Error" hj (07/27/04)
- working with SUM shank (07/27/04)
- Report on 2 tables with no common field JGreco (07/27/04)
- SELECT Case code failing SabreWolf3 (07/27/04)
- Write the first digit, only an (07/27/04)
- Sum Query Chris M (07/27/04)
- Error 2465 Audit Tracking Pete (07/27/04)
- One or More responses?? drowning (07/27/04)
- Using a Query to total results Chris M (07/27/04)
- Access vs. Excel query w/blank field dutty (07/27/04)
- Problem Accessing JOINed Table Data using Variables Laurie Eaton (07/27/04)
- Compare value for each row in reference table and append in new co Melanie O (07/27/04)
- Access Query to request record with date closest to todays date Pete Sperling (07/27/04)
- Make table query Vincdc (07/27/04)
- Counting records within a group of a table and updating the table Di (07/27/04)
- Pilot Time tracking database: Picking the third-from-last date? Richard Perry (07/27/04)
- Changing the format of a date through a querie for a merge with Wo donotspam (07/27/04)
- Pulling result only if it doesn't exist .... GEORGIA (07/27/04)
- Preventing Duplicates in Query jakeup (07/27/04)
- nested compound boolean IIf statements Linton (07/27/04)
- Crosstab query help SR (07/27/04)
- Query Using Multiple Categories Craig (07/27/04)
- Setting a Password on Delete Queries? Steve C (07/27/04)
- Error message in query without a data match Dave (07/27/04)
- Counting in Queries Tony (07/27/04)
- DLOOKUP vs Multiple Queries Joe Williams (07/27/04)
- Access 97 to Access 2002 conversion KK (07/27/04)
- How do I truncate a numeric result? NeverTooLateToLearn (07/27/04)
- need help ferio (07/27/04)
- Incompatible versions of OS Tom & Roxanne Hanson (07/27/04)
- Formatting a date in a querie for a merge with Word Vickie Ward (07/27/04)
- Cstr/CDate Query vbtoad (07/26/04)
- Results Based upon a Date Teri (07/26/04)
- Unmatched Query in Access 2003??? Nadia (07/26/04)
- Query Desmond (07/26/04)
- Remove Filter by Selection levels sps (07/26/04)
- Forcing alias in columnNames John Hendrix (07/26/04)
- Cancel parameter query Ashley (07/26/04)
- calculating a ranking Mark McCoy (07/26/04)
- Criteria for a query Big Tony (07/26/04)
- How to rank Shezan Rahman (07/26/04)
- CrossTab Queries Marvin Larson (07/26/04)
- Sad Tom Ellison (07/26/04)
- Match and Retrieve Values Todd Huttenstine (07/26/04)
- Need to query missing numbers in list Heather (07/26/04)
- data type mismatch in criteria expression when no criteria specified JR (07/26/04)
- Changing the format of a field ChuckW (07/26/04)
- Report based on two similar queries Molly (07/26/04)
- How to use Recordset.StillExecuting Jeff (07/26/04)
- Ansi SQL to JET SQL Jim (07/26/04)
- need query omko h (07/26/04)
- help me in vba sql MUHAMAMD SALIM SHAHZAD (07/26/04)
- Operation must use an updatable query Joe Au (07/26/04)
- Top 3 items per customer Natalie (07/26/04)
- Three dbs into one george sales (07/25/04)
- Search by parts of keywords Mike (07/25/04)
- Using Like when field contains a # Jim Tinder (07/25/04)
- crosstab query as a subquery? how to do that? Pablo (07/25/04)
- Re: crosstab query as a subquery? how to do that? Tom Ellison (07/25/04)
- Re: "crosstab query as a subquery? how to do that?" and new question concerning parameters for those queries. Pablo (07/25/04)
- Re: "crosstab query as a subquery? how to do that?" and new question concerning parameters for those queries. Tom Ellison (07/25/04)
- Re: "crosstab query as a subquery? how to do that?" and new question concerning parameters for those queries. Pablo (07/25/04)
- Re: "crosstab query as a subquery? how to do that?" and new question concerning parameters for those queries. Tom Ellison (07/25/04)
- Re: "crosstab query as a subquery? how to do that?" and new question concerning parameters for those queries. Gary Walter (07/26/04)
- Re: "crosstab query as a subquery? how to do that?" and new question concerning parameters for those queries. Gary Walter (07/26/04)
- Re: "crosstab query as a subquery? how to do that?" and new question concerning parameters for those queries. Pablo (07/26/04)
- Re: "crosstab query as a subquery? how to do that?" and new question concerning parameters for those queries. Pablo (07/25/04)
- Re: crosstab query as a subquery? how to do that? Tom Ellison (07/25/04)
- Query for Two Tables Sandra (07/25/04)
- Query Match/Merge BVOOKIE (07/25/04)
- Postal Codes dropping first zero Shirl (07/25/04)
- access database Shirley (07/25/04)
- Use of query to add sequential numbers to a table. Frank Martin (07/25/04)
- How do you assign an event to a query? LouD (07/25/04)
- Membership List - One mailing label for family Jeffrey Screeton (07/24/04)
- same database in Access 2000 and '97 Robert Solomon (07/24/04)
- Please help! Regarding design report of client feedback. Terry (07/24/04)
- Help - Access with VB Vrijesh Jeswant (07/24/04)
- translate SQL to Access shank (07/24/04)
- one table, 2 fields sort, for label list Br. Dismas SFO (07/24/04)
- Update a Quantity R. BRADFORD THOMAS (07/23/04)
- IF THEN IF THEN ELSE ... Colby (07/23/04)
- SELECT DISTINCT MacDuff (07/23/04)
- problem with using a query as a basis for a form Kevin (07/23/04)
- linking from a form Larry G (07/23/04)
- Displaying a picture from a linked table in a bound OLE field Kevin (07/23/04)
- Update query: To roll forward a date by 52 weeks using a look-up f Fossil (07/23/04)
- Strings not appearing Evan McCutchen (07/23/04)
- How to obtain a percent of entries? wmoening (07/23/04)
- Calculating dates excluding weekends/holidays? Mark (07/23/04)
- Export Query formatting problems - numeric and date/time Daniel (07/23/04)
- Unmatched Query Bob Mullen (07/23/04)
- Delete query on external db? NoSpamTakeSquareRootOfNumber (07/23/04)
- Please Help with a query with two parameters Emily (07/23/04)
- Criteria too complex IIf and Between MattLe (07/23/04)
- Add Caption to Query Lori LeRoy (07/23/04)
- If Then End If Structure Peter (07/23/04)
- Delete record Todd Huttenstine (07/23/04)
- Query Design Mathew (07/23/04)
- Sunday (First Day of Week) Mary (07/23/04)
- Bound Column Resolves Invalid Values for Field Petra (07/23/04)
- Dynamic Queries AvalonDave (07/23/04)
- drive mappings nikki (07/23/04)
- Add Column in make table query Michael Noblet (07/23/04)
- EXPLICITt or IMPLIED establishment of referential integrity John S. Ford, MD (07/23/04)
- Re: EXPLICITt or IMPLIED establishment of referential integrity Brendan Reynolds (07/23/04)
- Re: EXPLICITt or IMPLIED establishment of referential integrity Douglas J. Steele (07/23/04)
- Re: EXPLICITt or IMPLIED establishment of referential integrity Sandra Daigle (07/23/04)
- Re: EXPLICITt or IMPLIED establishment of referential integrity Van T. Dinh (07/23/04)
- Re: EXPLICITt or IMPLIED establishment of referential integrity Jon (07/23/04)
- Re: EXPLICITt or IMPLIED establishment of referential integrity John S. Ford, MD (07/24/04)
- Combine 3 fields Vic (07/23/04)
- Append Query problem -- producing WAY too many records. Richard Hollenbeck (07/23/04)
- Query Criteria where a single date comes from a form Gary O (07/23/04)
- Pull Fields From Multiple Tables WDP (07/23/04)
- getting query info from a form field maarkr (07/23/04)
- General query problem in ac2003 DR (07/23/04)
- Scheduling Macros GLS (07/23/04)
- Calculated fields in query Christopher (07/23/04)
- list only most recent event in a query lynn atkinson (07/23/04)
- Merge query results in MS Word STDT (07/23/04)
- Format function for quarter Del (07/23/04)
- Drawing Data between 2 dates Andre Skeen (07/23/04)
- How to make a query in which the SQL sentence is created by a function Jordi Pocurull (07/23/04)
- Archiving related tables ????? Andrew T (07/23/04)
- string? please help.... Renatorius (07/23/04)
- Limiting results with JOIN query Xenophobe (07/23/04)
- Proyect Colombiaunida.gov.co Colombia unida (07/23/04)
- Do not Count Duplicates bdehning (07/23/04)
- Re: Do not Count Duplicates Tom Ellison (07/23/04)
- Re: Do not Count Duplicates bdehning (07/23/04)
- Re: Do not Count Duplicates Tom Ellison (07/23/04)
- Re: Do not Count Duplicates bdehning (07/23/04)
- Re: Do not Count Duplicates Tom Ellison (07/24/04)
- Re: Do not Count Duplicates bdehning (07/24/04)
- Re: Do not Count Duplicates Tom Ellison (07/24/04)
- Re: Do not Count Duplicates bdehning (07/24/04)
- Re: Do not Count Duplicates Tom Ellison (07/24/04)
- Re: Do not Count Duplicates bdehning (07/24/04)
- Re: Do not Count Duplicates Tom Ellison (07/24/04)
- Re: Do not Count Duplicates bdehning (07/24/04)
- Re: Do not Count Duplicates Tom Ellison (07/24/04)
- Re: Do not Count Duplicates bdehning (07/24/04)
- Re: Do not Count Duplicates Tom Ellison (07/25/04)
- Re: Do not Count Duplicates Tom Ellison (07/25/04)
- Re: Do not Count Duplicates bdehning (07/27/04)
- Re: Do not Count Duplicates Douglas J. Steele (07/27/04)
- Re: Do not Count Duplicates Gary Walter (07/27/04)
- Re: Do not Count Duplicates Tom Ellison (07/28/04)
- Re: Do not Count Duplicates Gary Walter (07/27/04)
- Re: Do not Count Duplicates Gary Walter (07/27/04)
- Re: Do not Count Duplicates bdehning (07/28/04)
- Re: Do not Count Duplicates Gary Walter (07/27/04)
- Re: Do not Count Duplicates bdehning (07/27/04)
- Re: Do not Count Duplicates bdehning (07/23/04)
- Re: Do not Count Duplicates Tom Ellison (07/23/04)
- value entered isn't valid for this field Petra (07/23/04)
- Delete Query Criteria Bob Mullen (07/23/04)
- Switch Function Pam (07/22/04)