microsoft.public.access.queries
By Thread
3115 messages sorted by: [ date ]
Starting: 08/31/04
Ending: 09/30/04
- Access CrossTab queries DIR (09/30/04)
- Between And Operator in Date Field Ashbee (09/30/04)
- Duplicate records Petra (09/30/04)
- Deactivate Indexes Dominic (09/30/04)
- Count Records from Many Queries Wendy (09/30/04)
- Error Ed (09/29/04)
- pass thru query problems Mark (09/29/04)
- No Current Record Eric Blitzer (09/29/04)
- query for field names shank (09/29/04)
- Query Question - Filter Out Certain Records JD (09/29/04)
- Query Question JD (09/29/04)
- error message when dealing with decimals in query Rudy M. (09/29/04)
- Grouping Headings in A Crosstab query jf (09/29/04)
- Compare fields in query ds (09/29/04)
- Update query validation errors jp (09/29/04)
- search records using a boolean data field as criteria Albert (09/29/04)
- Breaking out totals jpw (09/29/04)
- Data entry Dan (09/29/04)
- How do I run a query in ACCESS within restricted parameters? Sarah (Sustainable Food Center) (09/29/04)
- Preserve order "WHERE IN(...)" Frederik (09/29/04)
- Use wildcards to get query results from data entered on a form Acess Trooubles (09/29/04)
- Parameter queries with custom dialogs Luther (09/29/04)
- Excel Functions Nick (09/29/04)
- Insert Blank Line In Query? MDW (09/29/04)
- Date range in crosstab query ew (09/29/04)
- Find Nearest Value Tom (09/29/04)
- Delete Query Tina (09/29/04)
- Percent of matches Luis (09/29/04)
- Using Case Michael Marquardt (09/29/04)
- Queries using "not" Miaplacidus (09/29/04)
- What causes the "#Name?" error in text box? Richard Hollenbeck (09/29/04)
- Simple upper case question RobertM (09/29/04)
- Query problem jimmy (09/29/04)
- Substring Kieran (09/29/04)
- Can't get Access to run a query with a time field RonSLevy (09/29/04)
- What's the best way to.... (Access Novice) Steve (09/29/04)
- Calendar Query Changes Problem!!!! Richard C (09/29/04)
- Compacting an Access 97 Database with VB6 lappy (09/29/04)
- Insert into problem Mohammad (09/29/04)
- How do you double indent? viv (09/29/04)
- Need help comparing two tables LightShow (09/29/04)
- Max Date Tom (09/29/04)
- Update table from Result of Query JoeCL (09/29/04)
- Complex date query bj (09/29/04)
- How to determine which queries use a specific table Linda (09/28/04)
- Numeric Overflow message Manuel (09/28/04)
- Problem combining SELECT queries Laura McKittrick (09/28/04)
- where do i find windows 98 wordpad download drinkwaterc (09/28/04)
- selecting records based on the position in the database Jo (09/28/04)
- MAX. columns in a query Chris (09/28/04)
- Problem Deleting Raj (09/28/04)
- DISTINCTROW Paul fpvt2 (09/28/04)
- Append Query and function 0421 (09/28/04)
- any idea? any help would be greatly appreciated Josh Henry (09/28/04)
- count months Josh Henry (09/28/04)
- Error 3709 Tim Mooney (09/28/04)
- De-Increment Month Value by 1 Attila Fust (09/28/04)
- query in 1-many relationship cz (09/28/04)
- Can a table be used to search for strings in a text field in a que Naeranth (09/28/04)
- problem with multiple criteria select query...? JDA (09/28/04)
- What kind of SQL statement can do this job? wesbird (09/28/04)
- how to structure many queries Ron (09/28/04)
- Linking two Tables and avoiding having to create an interim Query John Ortt (09/28/04)
- Access Query to ODBC Jimmy (09/28/04)
- OT: Origin of sudden spate of irrelevent posts?!? LeAnne (09/28/04)
- Query Leo (09/28/04)
- separate the Text from the first two Characters of the post codes Sasi (09/28/04)
- SQL database record locks Vaughan (09/28/04)
- Retrieving records in order jk (09/28/04)
- clarify display / show query Jimbo (09/28/04)
- calendar Reports zotos (09/28/04)
- Automatically Delete Duplicated Data in Table faxylady (09/28/04)
- How do I set up the dolookup command in access? lahti (09/28/04)
- customized message ela (09/28/04)
- Kilometres Query Steved (09/28/04)
- Making Queries Faster Anna S (09/28/04)
- Consolidate records in ACCESS cstemm (09/27/04)
- Compare Fields RITRAM (09/27/04)
- Retrieve records for the day before Iris Faber (09/27/04)
- Advanced Math Matthew Ellis (09/27/04)
- COMPARE FIELDS RITRAM (09/27/04)
- Query management question Dana809904 (09/27/04)
- Using wildcards in a popup Peter MacInnis (09/27/04)
- Undefined function Trim in Expression ChuckW (09/27/04)
- Store Criteria Input for Future Use neenmarie (09/27/04)
- Query part of string Mary (09/27/04)
- Re: Order within Group - possible? Brian Camire (09/27/04)
- Addition in a Access 97 query Eric (09/27/04)
- Collecting the results of many queries Jessica_O (09/27/04)
- Query Criteria = TODAY MrMike (09/27/04)
- how do i fill down data in access? cell_at_discussions.microsoft.com (09/27/04)
- Query about log in and log out of users Fabio CH (09/27/04)
- query not working-urgent anonymous_at_discussions.microsoft.com (09/27/04)
- I've been asked to do something insane RobertM (09/27/04)
- Zero Fill a Field and remove decimal ms (09/27/04)
- Re: Zero Fill a Field and remove decimal Tom Ellison (09/27/04)
- Re: Zero Fill a Field and remove decimal ms (09/27/04)
- Re: Zero Fill a Field and remove decimal Tom Ellison (09/27/04)
- Re: Zero Fill a Field and remove decimal ms (09/27/04)
- Re: Zero Fill a Field and remove decimal Tom Ellison (09/27/04)
- Re: Zero Fill a Field and remove decimal ms (09/27/04)
- Re: Zero Fill a Field and remove decimal Tom Ellison (09/28/04)
- Re: Zero Fill a Field and remove decimal ms (09/27/04)
- Re: Zero Fill a Field and remove decimal John Spencer (MVP) (09/28/04)
- Re: Zero Fill a Field and remove decimal ms (09/29/04)
- Re: Zero Fill a Field and remove decimal Tom Ellison (09/27/04)
- 2 Left Join Queries into 1 esi (09/27/04)
- Show records for the past 30 days borris (09/27/04)
- Datasheet to Update constrained SQL tables Petra (09/27/04)
- Update HELP Dan (09/27/04)
- query expression compile error DennisD (09/27/04)
- query expression compile error DennisD (09/27/04)
- query expression compile error DennisD (09/27/04)
- Printing table field names and datatypes Jeff (09/27/04)
- Repeat Records - Please Help? Repeat records (09/27/04)
- Re: Repeat Records - Please Help? Tom Ellison (09/27/04)
- Re: Repeat Records - Please Help? Repeat records (09/28/04)
- Re: Repeat Records - Please Help? Tom Ellison (09/28/04)
- Re: Repeat Records - Please Help? Repeat records (09/29/04)
- Re: Repeat Records - Please Help? Tom Ellison (09/29/04)
- Re: Repeat Records - Please Help? Repeat records (09/29/04)
- Re: Repeat Records - Please Help? Tom Ellison (09/29/04)
- Re: Repeat Records - Please Help? Repeat records (09/29/04)
- Re: Repeat Records - Please Help? Tom Ellison (09/29/04)
- Re: Repeat Records - Please Help? Repeat records (09/28/04)
- Re: Repeat Records - Please Help? Tom Ellison (09/27/04)
- Last Date ci (09/27/04)
- Repeat Records - Nothing Works!!! Repeat records (09/27/04)
- Number of rooms Crown Royal (09/27/04)
- Week not sorted correctly Kevin Labore (09/27/04)
- query results Kevin (09/27/04)
- Managing duplicates when INSERTing. GPO (09/27/04)
- combining queries Doug_Goodwrench (09/27/04)
- Group by Week neenmarie (09/27/04)
- Creating Reports Based Upon Criteria Selection at Runtime Don (09/27/04)
- FINDING DUPLICATES SAM (09/27/04)
- Repeat Records Repeat records (09/27/04)
- lookup table for date JonD (09/27/04)
- Day, month, and current year Bruce (09/27/04)
- IIf statements Ian-s- (09/27/04)
- Problems with data types Steve (09/27/04)
- display when true Jimbo (09/27/04)
- display features if true value Jimbo (09/27/04)
- Select non numeric records news.microsoft.com (09/27/04)
- Convert to date news.microsoft.com (09/27/04)
- Combine 2 fields into 1 via SQL query amelia (09/27/04)
- VBA Date Function Daniel (09/27/04)
- setting the record source of a report in the Report_Open function eddiec (09/27/04)
- How do I reinstall Internet Explorer? W8KZW (09/27/04)
- Updating a Specific Value in a Table of Values JohnC (09/27/04)
- lost microsoft office Ginger 656 _at_aol.com (09/26/04)
- performance: query vs. class module phillip9 (09/26/04)
- could you do me a favor to add find phone number in your al softw. hongli3648 (09/26/04)
- How to list only records that DO NOT match the criteria? Richard Hollenbeck (09/26/04)
- Decimal value in SQL statemen gives error when Regional settings are set to Dutch Luc Gillemot (09/26/04)
- Compare value from text field and table field Paulo Gonçalves (09/26/04)
- Max ( ) - use to return latest date - or is there another way? jonmarcr (09/26/04)
- Multiple Values in Crosstab Query Alec Green (09/26/04)
- data.ms1 marior (09/25/04)
- how to use Active X calendar in a form Terry (09/25/04)
- Storing the query result using VBA Transliteration (09/25/04)
- Why don't MS Access 2003 string functions work? GaryBonk (09/25/04)
- Criteria Steven (09/25/04)
- calculation field in a query and lookup tables? King Kaos (09/25/04)
- changing values in a query mtress (09/25/04)
- is there a query to update a table cell, not add rows RKS (09/25/04)
- Query Expression to Generate Report Keith (09/25/04)
- event clash Joe (09/25/04)
- Week of year Donagh Berry (09/24/04)
- subtotalling query data tjb (09/24/04)
- Form ref in criteria Joss (09/24/04)
- auto numbering in query sinta_at_aol.com (09/24/04)
- incremental ID number in a query FRED (09/24/04)
- Problem showing #s on a form R Massie (09/24/04)
- 2-part query ys (09/24/04)
- page down Patccastel (09/24/04)
- Query Help find match and delete. Raj (09/24/04)
- a simple query with date Gonsior Andreas (09/24/04)
- How do I set up Date query in a crosstab query? Doddysgirl (09/24/04)
- Filtering by a calculated field/control Michelle339 (09/24/04)
- adding null values haggr (09/24/04)
- Return value of prev record if null in query Laura (09/24/04)
- Equivalent for EoDate(x,y) Al (09/24/04)
- Append Query stops Nancy (09/24/04)
- Update date based on another table's dates Mike Binger (09/24/04)
- mail merge problems Katie (09/24/04)
- track rent Josh Henry (09/24/04)
- Union query duplicates SHIPP (09/24/04)
- Access Make Table Query Jayne (09/24/04)
- Number of results TemporaryUser (09/24/04)
- One year from a given date Bruce (09/24/04)
- concatenating EMail addresses Dave Sutton (09/24/04)
- 'Un-Crosstab' colin ashley (09/24/04)
- Query on 3 tables Anton van Rosmalen (09/24/04)
- microsoft ecces support with using a PDA ? huisamen&global.co.za (09/24/04)
- Option Group Checkboxes - Inbedded lalexander (09/24/04)
- Simple Access 2000 query in VBA doesn't work Dave (09/24/04)
- Case Sensitive Cross Tab Query CalLP (09/23/04)
- access queries aannan (09/23/04)
- combining contents of one field Lisa (09/23/04)
- Dates in seperate columns but return latest date anonymous_at_discussions.microsoft.com (09/23/04)
- running parameter qry from form... Lorian (09/23/04)
- Running Param Qry from Form; not filtering... Lorian (09/23/04)
- Append querr that only append new record DLAM (09/23/04)
- Query won't work off of identical databases Drew (09/23/04)
- Appen Query with new records only DLAM (09/23/04)
- Simple count query not so simple... Chris E. (09/23/04)
- combining field contents to one field via a query Lisa (09/23/04)
- Updating field for numeric bins Jessica (09/23/04)
- update field based on the contents of three additional fields Aldricla (09/23/04)
- working with normalized data set PF (09/23/04)
- Bruce Criteria: After this year (09/23/04)
- charts using a query talktobatchu (09/23/04)
- Null criteria in a Query does not work RFJ (09/23/04)
- find last modified record zealousagenda (09/23/04)
- DateDiff and Access VersionDB dwight cornett (09/23/04)
- Parameters in calculation Public Health Sandra (09/23/04)
- Q: Is there a "this expression" option in a query? MarkD (09/23/04)
- weird query hermie (09/23/04)
- Simple Comparison Query Benjamin (09/23/04)
- Mail Merging a Random Select Query Craig (09/23/04)
- Excluding certain records from a query Tony (09/23/04)
- queries to add OLE objects Jordan (09/23/04)
- Comparing two tables in a query David` (09/23/04)
- Problem limiting records based on unrelated field Richard Hollenbeck (09/23/04)
- Extracting and Parsing Gdub58 (09/23/04)
- dates!!! Katie (09/23/04)
- Grouping a Count of Unique Records - Going Round in Circles :( RFJ (09/23/04)
- Calculating a value between a form and a subform Robert Massie (09/23/04)
- MakeTable Query -- Field Must be "Double" vs. "Decimal" Tom (09/23/04)
- Criteria using DateDiff function in SELECT Query. EricB (09/23/04)
- Help Import / export txt file in VB Benjamin (09/23/04)
- Criteria for Append Query? Crispywafers (09/23/04)
- troubleshoot mail merge using Access query Gerry_at_Polo (09/23/04)
- Criteria in a query Krish (09/23/04)
- CrossTab query Krish (09/23/04)
- Query gives wrong Answer - Repost with requested SQL Code RFJ (09/23/04)
- Updating table in datasheet view..2 table query! confused (09/23/04)
- Re: how can i convert a julian date into a date recognised by Access John Vinson (09/23/04)
- Date of Edit Claire (09/23/04)
- open form from returned query row John (09/23/04)
- Datasheet Form Petra (09/23/04)
- using the results of a SQL SELECT(COUNT) statement in VBA Paul James (09/22/04)
- Re: using the results of a SQL SELECT(COUNT) statement in VBA Dan Artuso (09/23/04)
- Re: using the results of a SQL SELECT(COUNT) statement in VBA Paul James (09/23/04)
- Re: using the results of a SQL SELECT(COUNT) statement in VBA Paul Johnson (09/23/04)
- Re: using the results of a SQL SELECT(COUNT) statement in VBA Paul James (09/23/04)
- Re: using the results of a SQL SELECT(COUNT) statement in VBA John Spencer (MVP) (09/23/04)
- Re: using the results of a SQL SELECT(COUNT) statement in VBA Paul Johnson (09/24/04)
- Re: using the results of a SQL SELECT(COUNT) statement in VBA Paul James (09/24/04)
- Re: using the results of a SQL SELECT(COUNT) statement in VBA Paul James (09/23/04)
- Re: using the results of a SQL SELECT(COUNT) statement in VBA Dan Artuso (09/23/04)
- Zero values in query jk (09/22/04)
- Sum List anonymous_at_discussions.microsoft.com (09/22/04)
- How do I use page view of a query. worldlearner (09/22/04)
- grant security access in a macro Jessica E (09/22/04)
- Append Queries DLAM (09/22/04)
- delete query tom (09/22/04)
- sort records by size of items in memo field, or pull those > 255 s PitBullBlonde (09/22/04)
- automated entry of parameters? JR (09/22/04)
- Query Filter Sort Toan Chau (09/22/04)
- Using Current date information MTRacer (09/22/04)
- Need to return last record entered by multiple users to mult. reco Paul (09/22/04)
- using criteria in field that has a look up table AEA (09/22/04)
- repost - 'Undefined function' and 'Too complex' errors Lorian (09/22/04)
- Query to Count in to columns jk (09/22/04)
- Rounding and calculations jderrig (09/22/04)
- Formatting date query Column by week. Raj (09/22/04)
- Query gives wrong output RFJ (09/22/04)
- query related to itself seeker53 (09/22/04)
- Blank Space to Zero Chris (09/22/04)
- Query string to number Benjamin (09/22/04)
- Append Unique Records only! Adam G (09/22/04)
- Cannot see hidden column in query Alex (09/22/04)
- parameter query not returning correct results Darlene (09/22/04)
- COUNT multiple fields Shanin (09/22/04)
- IIF Function Question Robyn H. (09/22/04)
- RE: IIF Function Question Robyn H. (09/22/04)
- Re: IIF Function Question Michel Walsh (09/22/04)
- Re: IIF Function Question Robyn H. (09/22/04)
- Re: IIF Function Question Michel Walsh (09/22/04)
- Re: IIF Function Question Robyn H. (09/22/04)
- Re: IIF Function Question Robyn H. (09/22/04)
- Re: IIF Function Question Michel Walsh (09/22/04)
- Re: IIF Function Question Robyn H. (09/23/04)
- Re: IIF Function Question Michel Walsh (09/23/04)
- Re: IIF Function Question Robyn H. (09/23/04)
- Re: IIF Function Question Michel Walsh (09/23/04)
- Re: IIF Function Question Robyn H. (09/22/04)
- Help!!! sum query Liat (09/22/04)
- How do I retrieve the median value of a field? navman9 (09/22/04)
- Query over several tables Anton van Rosmalen (09/22/04)
- Calculating Proportions of values within a field or grouped Imran J Khan (09/22/04)
- Sorting complex iif statement queries SHABA8331 (09/22/04)
- Problem with decimals in a combobox in an ACCESS 2002-XP form Geo (09/22/04)
- Re: Problem with decimals in a combobox in an ACCESS 2002-XP form Allen Browne (09/22/04)
- Re: Problem with decimals in a combobox in an ACCESS 2002-XP form Geo (09/22/04)
- Re: Problem with decimals in a combobox in an ACCESS 2002-XP form Allen Browne (09/22/04)
- Re: Problem with decimals in a combobox in an ACCESS 2002-XP form Geo (09/22/04)
- Re: Problem with decimals in a combobox in an ACCESS 2002-XP form DebbieG (09/24/04)
- Re2: Problem with decimals in a combobox in an ACCESS 2002-XP form Geo (09/22/04)
- Re: Problem with decimals in a combobox in an ACCESS 2002-XP form Allen Browne (09/22/04)
- Re: Problem with decimals in a combobox in an ACCESS 2002-XP form Geo (09/22/04)
- Re: Problem with decimals in a combobox in an ACCESS 2002-XP form Allen Browne (09/22/04)
- Date Range anonymous_at_discussions.microsoft.com (09/22/04)
- Total query which concatenates text values Larry (09/22/04)
- using wild card with criteria David (09/22/04)
- Calculated Query Fields Using DateDif Function Bill Hamill (09/22/04)
- Rounding numbers Ivor Williams (09/21/04)
- In operator question Tony (09/21/04)
- Re: How can I open an Excel spreadsheet I got in an email? Wayne Morgan (09/21/04)
- Count Unique Records - from a Newbie (Repost) RFJ (09/21/04)
- Design Grid not visible Mike (09/21/04)
- Extracting Part of a Text field in Query bmistry (09/21/04)
- Another Seqence Number Question - But With A Twist James Cox (09/21/04)
- Summing the Top Five problem Mandy (09/21/04)
- Croossab Query Dan (09/21/04)
- Count Unique Records - from a Newbie RFJ (09/21/04)
- How can I convert the date/time format in a SQL query on Access inside a ASP script ? Bruno Baguette (09/21/04)
- USING AN UNBOUND, MULTISELECT LISTBOX, HOW DO I RETRIVE THE SELEC. kslattery (09/21/04)
- COMBO BOX CHANGE RAF (09/21/04)
- how to get unique resultset djc (09/21/04)
- Go to new record if no results Mike Rotch (09/21/04)
- Number of days in a given month Hallgeir (09/21/04)
- Order. Rodolfo Fontes (09/21/04)
- Error: Function is not available johnsmithweb (09/21/04)
- Date Format Aurora (09/21/04)
- MS ACCESS digvijay singh (09/21/04)
- Rounding numbers Raj (09/21/04)
- MS ACCESS Nifty (09/21/04)
- Select query for zero amts jk (09/21/04)
- help needed with union query CarolM (09/21/04)
- Sorting Dates in Queries tbd (09/21/04)
- PivotTableExportToExcel Redapples (09/21/04)
- Using MakeTable and UpDate Queries Sandra Grawunder (09/21/04)
- loop verifycation... jojofv (09/21/04)
- split table by range on records ferio (09/21/04)
- Only want update a part of records? Gary (09/21/04)