microsoft.public.access.queries
By Thread
2722 messages sorted by: [ date ]
Starting: 11/30/04
Ending: 12/30/04
- how to make IIf statement result show null value GEORGIA (12/30/04)
- Parameter Query Steve S (12/30/04)
- Multi expression in query Michele (12/30/04)
- syntax of call in my query? lpj (12/30/04)
- syntax of call in my query? lpj (12/30/04)
- Date Query Mandy J.S. (12/30/04)
- Query logic - linking a table to itself? MDW (12/30/04)
- searching memo fields geeksdoitbetter (12/30/04)
- Query with a wildcard Angel b1 (12/30/04)
- Change target for a query? LeighB (12/30/04)
- Database Information Storage ethan (12/30/04)
- Calculating the proper price SHIPP (12/30/04)
- Don't Repeat Record? ThePro (12/30/04)
- ALLOWING DOUBLE ENTRY IN UNION QUERY alish (12/30/04)
- Pass-through query Gerrym (12/30/04)
- Telephone Number Format The Grape Hunter (12/30/04)
- dynamic crosstab A2002 Brigitte P (12/30/04)
- SQL Specific Queries (MINUS or JOIN with <>) Rambo from Japan (12/30/04)
- Disappearing results in query... Access rookie (12/30/04)
- query miscalculation Alex (12/30/04)
- line break geeksdoitbetter (12/29/04)
- Complicated query Laura (12/29/04)
- Help on a complicated query!? Access rookie (12/29/04)
- How do I do a query in Access to return results for weekends only. Ryan (12/29/04)
- Re: Can't get crosstab query to work right MarkD (12/29/04)
- Stupid question Alex (12/29/04)
- Updating query Ian (12/29/04)
- Q: Can't get crosstab query to work right MarkD (12/29/04)
- adding information in an append ESUguy (12/29/04)
- how do you do a query, which queries for a latest revision? Querying for a latest revision (12/29/04)
- user prompts Lauren B. (12/29/04)
- Changing the Year in Date Fields Len (12/29/04)
- Selecting the most current values AdmSteck (12/29/04)
- Re: Calculate MEDIAN in queries Ian Belcher (12/29/04)
- Max price vs individual price SHIPP (12/29/04)
- Reduce long number to a single one viddom (12/29/04)
- Sort by Month in a query Eric (12/29/04)
- Assigning for an accendent sequence viddom (12/29/04)
- Need help with a query to display top 3 of a group Ten Twenty via AccessMonster.com (12/29/04)
- calculated column problem agarwalp_at_eeism.com (12/29/04)
- How to daisy chain queries and use the output from one query as parameter for another Karen Middleton (12/29/04)
- Help on Crosstab query Ian Baker (12/29/04)
- Join of a file on a calculated counter Ten Twenty via AccessMonster.com (12/29/04)
- How to show records that don't exist Jacques (12/29/04)
- How do I can count different codes in different fields? Lyn G (12/28/04)
- How do I add the same ID twice in a query line? Frank Martin (12/28/04)
- Need help with a query formula Joe Cilinceon (12/28/04)
- Lost O-E-M Sereial Number for MS Word 2000. Is there HELP? MaxsterG (12/28/04)
- Query Syntax to get 1st 100 records Then 2nd 100 Etc, Etc Frank Lueder (12/28/04)
- Re: Query Syntax to get 1st 100 records Then 2nd 100 Etc, Etc Duane Hookom (12/28/04)
- Re: Query Syntax to get 1st 100 records Then 2nd 100 Etc, Etc Randy Balbuena (12/28/04)
- Re: Query Syntax to get 1st 100 records Then 2nd 100 Etc, Etc Marshall Barton (12/28/04)
- Re: Query Syntax to get 1st 100 records Then 2nd 100 Etc, Etc Frank Lueder (12/29/04)
- Comparing and flagging results Sharon Hoffmann (12/28/04)
- Query for text within a large text field Dan (12/28/04)
- date conversion function not working Ben (12/28/04)
- Design View SLOW christyh (12/28/04)
- Date Field Updates correctly manually & in query grid, but not VBA Access101 (12/28/04)
- Auto Scheduling from Access to Outlook Maria K (12/28/04)
- most current date Josh Henry (12/28/04)
- "Like" operator in a query genojoe (12/28/04)
- changing a checkbox value in my database by using UPDATE zwanz P via AccessMonster.com (12/28/04)
- record count collumn Roy (12/28/04)
- Finding records that are not in a query based on several tables Phil R (12/28/04)
- AND / OR in a form Jeroen (12/28/04)
- Query to export data from Access 2003 to Oracle ? Luqman (12/28/04)
- count workdays access confuse (12/28/04)
- getting a query to ask until seeing a null Guy Story (12/27/04)
- Setting up a criteria Donna S. (12/27/04)
- Criteria Loi (12/27/04)
- Dates Excel GuRu (12/27/04)
- Archiving & deleting a record from the main table Maria K (12/27/04)
- query needed to pull like records from two tables B. Meincke (12/27/04)
- Re: Using Nz with the count function [MVP] S.Clark (12/27/04)
- Need help resolving a previous post Sam B. (12/27/04)
- Non-matching records query Edward (12/27/04)
- Access Query Michael Kintner (12/27/04)
- Example of a append query and a update query Karen Middleton (12/27/04)
- Help - with Year to Data query Karen Middleton (12/27/04)
- Current record number of a table. doyapore (12/27/04)
- "Daisy Chaining" Queries MK (12/27/04)
- Need to register in Outlook- cannot "send " messages unless I use. Brad H (12/27/04)
- Access 2003 ADP and JOIN query Chungalin (12/27/04)
- Help - with Year to Data query Karen Middleton (12/27/04)
- How to Programmatically Retrieve Field & Table Comments Siegfried Heintze (12/26/04)
- Merging in the same table Lare (12/26/04)
- need help with query - please. lp (12/26/04)
- Undefined Funcion error Joaquim Macedo (12/26/04)
- Problem with Time Sysntax error Kenny M. (12/25/04)
- Need help finishing a simple query Sam B. (12/25/04)
- <Not in> solution Serguei Makacharipov (12/25/04)
- Cumulative sum in query Jean-Marie (12/25/04)
- what's wrong with my query? lp (12/25/04)
- Custom Sort in a Crosstab Query Air-ron (12/24/04)
- Re: Query to filter combo box in subform JohnFol (12/24/04)
- One query which generate multi report No Professional Training, WilliamH (12/24/04)
- Can't Include Memo or OLE Object bdehning (12/24/04)
- Re: Can't Include Memo or OLE Object Dale Fye (12/24/04)
- Re: Can't Include Memo or OLE Object bdehning (12/24/04)
- Re: Can't Include Memo or OLE Object John Vinson (12/24/04)
- Re: Can't Include Memo or OLE Object bdehning (12/24/04)
- Re: Can't Include Memo or OLE Object John Vinson (12/24/04)
- Re: Can't Include Memo or OLE Object bdehning (12/24/04)
- Re: Can't Include Memo or OLE Object John Vinson (12/24/04)
- Re: Can't Include Memo or OLE Object bdehning (12/24/04)
- Re: Can't Include Memo or OLE Object John Vinson (12/27/04)
- Re: Can't Include Memo or OLE Object bdehning (12/27/04)
- Re: Can't Include Memo or OLE Object bdehning (12/24/04)
- Re: Can't Include Memo or OLE Object Dale Fye (12/24/04)
- How do I open an existing Access 2000 file in Access XP? bj (12/24/04)
- entering dtaa in the parameter query Sansanee (12/24/04)
- column property of listbox in query? lp (12/24/04)
- Re: Ascending Sort Problem Again PC Datasheet (12/24/04)
- Access sorting problem? Ivan (12/23/04)
- Query mail merge to word document problem jay (12/23/04)
- query refer to a global variable Leon (12/23/04)
- I need an Access programmer analyst (12/23/04)
- Add records from one table to another table in Access Duckula (12/23/04)
- Re: Add records from one table to another table in Access Ken Snell [MVP] (12/23/04)
- Re: Add records from one table to another table in Access Duckula (12/23/04)
- Re: Add records from one table to another table in Access Ken Snell [MVP] (12/23/04)
- Re: Add records from one table to another table in Access Duckula (12/23/04)
- Re: Add records from one table to another table in Access Ken Snell [MVP] (12/24/04)
- Re: Add records from one table to another table in Access Jack MacDonald (12/23/04)
- Re: Add records from one table to another table in Access Duckula (12/24/04)
- Re: Add records from one table to another table in Access Duckula (12/24/04)
- Re: Add records from one table to another table in Access Duckula (12/23/04)
- Re: Add records from one table to another table in Access Ken Snell [MVP] (12/23/04)
- Query Shows Value Incorrectly from a Join Sergio (12/23/04)
- Query results show duplicate data Sergio (12/23/04)
- SendObject Action in a Macro Query Michael D. McGill (12/23/04)
- Query Parameters and form's collection index n2nature (12/23/04)
- convert date to text hermie (12/23/04)
- Records with null values Tony Wainwright (12/23/04)
- can't see the results!!! villi (12/23/04)
- S.O.S-can't see the results! villi (12/23/04)
- REQ: SQL question Robert (12/23/04)
- find unmatched query wizard MattH (12/23/04)
- how to get a value stored in tables and use it in Access Query? Walter (12/23/04)
- Make form filter by user Jacques (12/23/04)
- can I not put a where clause in a Transform query? Richard Hollenbeck (12/23/04)
- Multiple calculations XeniaEagle (12/23/04)
- Re: Multiple calculations Edward G (12/23/04)
- Re: Multiple calculations Randy Balbuena (12/23/04)
- Re: Multiple calculations John Vinson (12/23/04)
- Re: Multiple calculations XeniaEagle (12/23/04)
- Re: Multiple calculations Edward G (12/23/04)
- Re: Multiple calculations XeniaEagle (12/23/04)
- Re: Multiple calculations Edward G (12/23/04)
- Re: Multiple calculations XeniaEagle (12/23/04)
- Re: Multiple calculations John Vinson (12/23/04)
- Re: Multiple calculations XeniaEagle (12/24/04)
- Re: Multiple calculations XeniaEagle (12/24/04)
- Re: Multiple calculations Edward G (12/24/04)
- Re: Multiple calculations XeniaEagle (12/26/04)
- Re: Multiple calculations XeniaEagle (12/23/04)
- Query is not locating all records Susan L (12/22/04)
- SQL syntax to change a primary key? Gary Kahrau (12/22/04)
- grouping memo field Alex (12/22/04)
- Wildcards in queries Samrasr (12/22/04)
- Wildcards in queries Samrasr (12/22/04)
- Sending a query or report with sub-totals in Access 97 Dale via AccessMonster.com (12/22/04)
- Closect Date to KeyField Darren (12/22/04)
- SQL Query missing first number? Randy (12/22/04)
- vbCrLf rml (12/22/04)
- Query question Jeff D. (12/22/04)
- Joining Results of 2 Queries Ed Shanley (12/22/04)
- Dynamic QueryDef Error Message darrep (12/22/04)
- working days calcualation Brent (12/22/04)
- concateing names LtFass (12/22/04)
- Datatype rajashekar (12/22/04)
- qry for forward balances kelli (12/22/04)
- Field conversion viddom (12/22/04)
- Mail Merge between Access and Word (Office 2002) Kevin Anthony Jones (12/22/04)
- Digit re-combination viddom (12/22/04)
- can I change text field size in output table of make table query? PN_Samm (12/22/04)
- Digit selection for a new code VIDAL (12/22/04)
- Help with queries. HELP! enrico1982 (12/22/04)
- Can't make the most simplest of Queries... Mike (12/22/04)
- And , between and or Debra (12/22/04)
- using option group to change multiple field query criteria bicyclops (12/22/04)
- working with time VilMarci (12/22/04)
- Criteria on field calculated form another calculated field Max Moor (12/22/04)
- Upper and Lower Case Todd (12/22/04)
- Eliminating Duplicate Items in a Query The Chinaman (12/22/04)
- Re: Eliminating Duplicate Items in a Query Jeff Boyce (12/22/04)
- Re: Eliminating Duplicate Items in a Query The Chinaman (12/22/04)
- Re: Eliminating Duplicate Items in a Query John Vinson (12/23/04)
- Re: Eliminating Duplicate Items in a Query The Chinaman (12/23/04)
- Re: Eliminating Duplicate Items in a Query John Vinson (12/23/04)
- Re: Eliminating Duplicate Items in a Query The Chinaman (12/23/04)
- Re: Eliminating Duplicate Items in a Query John Vinson (12/23/04)
- Re: Eliminating Duplicate Items in a Query Jeff Boyce (12/23/04)
- Re: Eliminating Duplicate Items in a Query The Chinaman (12/23/04)
- Re: Eliminating Duplicate Items in a Query Jeff Boyce (12/24/04)
- Re: Eliminating Duplicate Items in a Query The Chinaman (12/25/04)
- Re: Eliminating Duplicate Items in a Query Jeff Boyce (12/25/04)
- Re: Eliminating Duplicate Items in a Query The Chinaman (12/26/04)
- Re: Eliminating Duplicate Items in a Query Jeff Boyce (12/26/04)
- Re: Eliminating Duplicate Items in a Query The Chinaman (12/28/04)
- Re: Eliminating Duplicate Items in a Query The Chinaman (12/22/04)
- Re: Eliminating Duplicate Items in a Query Jeff Boyce (12/22/04)
- Entering Data tinab (12/22/04)
- why is my recipient list empty when I use Word to merge with a qu. Alyssa (12/22/04)
- how to exclude certain parameters? _Adrian (12/21/04)
- rebuild master failed with error -1 vncntj_at_hotmail.com (12/21/04)
- Queries Edland (12/21/04)
- User Defined Queries tvt (12/21/04)
- could not delete from specified tables mccloud (12/21/04)
- could not delete from specified tables mccloud (12/21/04)
- New Question Brian Lyons (12/21/04)
- Can not delete from specified tables mccloud (12/21/04)
- use wildcard with parameter? el zorro (12/21/04)
- Find Number of Records for each office Jan (12/21/04)
- adding a comma into imported text Marie (12/21/04)
- How do I get expression code help? Brian Lyons (12/21/04)
- Table, Querie, Report Luis (12/21/04)
- Show linked forms and reports for querries Confused Educator (12/21/04)
- Viewing records for a certain date range. Mayra (12/21/04)
- Deleting a foreign key relationship in SQL Stevio (12/21/04)
- Running a module/function in ADP MSSQL Jamie (12/21/04)
- Case Sensitive in a Criteria with Like MMesarch (12/21/04)
- format function gives back a string Jonas (12/21/04)
- simple query question Dan _at_BCBS (12/21/04)
- Date query Mandy J.S. (12/21/04)
- How do i create a query which can search for data in many tables?. Richie1987 (12/21/04)
- > 100 is causing strange results Dylan Moran (12/21/04)
- Add zeros and remove hyphens Ellen (12/21/04)
- How to turn confirmation - yes, no off Karen Middleton (12/21/04)
- I run a "create query by using wizard" or any wizard I get "Activ. hippynz (12/21/04)
- Using a variable value in an SQL statement R the D (12/21/04)
- convert 'yyyy ww' to an actual date neenmarie (12/21/04)
- Show all cumulative end of month quantites neenmarie (12/21/04)
- quering combinations nattyborn (12/21/04)
- How to update as search & replace ?! Apl quick fly Over (12/21/04)
- Criteria Issue with multiple Option Class sorting. Limo (12/21/04)
- test for string RickM (12/20/04)
- Showing the sum of all records for one field jm3099 (12/20/04)
- Microsoft Access Queries AJ (12/20/04)
- Dlast Frank Dulk (12/20/04)
- Find week of date entered Deb Struble (12/20/04)
- How do I convert lower-case characters to upper-case characters i. D B Helms (12/20/04)
- Update query syntax question Rose (12/20/04)
- How to search for inappropriate characters? _Adrian (12/20/04)
- Returning records NOT in a table Rodtnick (12/20/04)
- Question about union queries John (12/20/04)
- Delete Partial Values of a field Nikhil (12/20/04)
- Attn: John Vinson See JoanOC 10/8:Re Two Tables Problem JoanOC (12/20/04)
- Re:Two Tables Problem Joining JoanOC (12/20/04)
- Creating a query using existing attributes Brad (12/20/04)
- update query to conditionally alter the value of cells DowningDevelopments (12/20/04)
- Concatenating two fields in Make-Table query Jim Hank (12/20/04)
- Re: Concatenating two fields in Make-Table query Rick B (12/20/04)
- Re: Concatenating two fields in Make-Table query Edward G (12/20/04)
- Re: Concatenating two fields in Make-Table query John Vinson (12/20/04)
- Re: Concatenating two fields in Make-Table query Edward G (12/20/04)
- Re: Concatenating two fields in Make-Table query Rick B (12/20/04)
- Re: Concatenating two fields in Make-Table query Edward G (12/20/04)
- Re: Concatenating two fields in Make-Table query Rick B (12/20/04)
- Re: Concatenating two fields in Make-Table query Edward G (12/20/04)
- Re: Concatenating two fields in Make-Table query Rick B (12/20/04)
- Re: Concatenating two fields in Make-Table query Edward G (12/20/04)
- RE: Concatenating two fields in Make-Table query Jim Hank (12/21/04)
- Only weekdays in datediff Y Beckers via AccessMonster.com (12/20/04)
- Dates in queries Songoku (12/20/04)
- Creating unique identifier in query Phil Stokes (12/20/04)
- Counting in a Make Table Query Centaur (12/20/04)
- Increment a Counter and reset it Ten Twenty via AccessMonster.com (12/20/04)
- Aging Report Stefan (12/20/04)
- Query to list only 50 latest records??? Joe M (12/20/04)
- limit output of query to the last 7 days MarySue (12/19/04)
- I am having trouble adding a poem....what am I doing wrong? Lindarose123 (12/19/04)
- query using criteria Donald (12/19/04)
- How do I combine various tables? Keith Hocky (12/19/04)
- ...Ambiguous Field Reference..... Popparod (12/19/04)
- Synchronize... Andreas Andreasson (12/19/04)
- Re: DSUM Ken Snell [MVP] (12/19/04)
- JET error: undefined function "InStrRev" michele (12/18/04)
- EmployeeID & Missing Numbers query Randy (12/18/04)
- criteria - exclude VilMarci (12/18/04)
- SQL MAX() on two tables Mr Kruger (12/18/04)
- E-Miil from field Ady (12/18/04)
- How to pass ">0" from a form to a query Ray Gunderson (12/18/04)
- format adp Lee (12/18/04)
- Automatic Counter using DCount Diggsy (12/17/04)
- Finding a string between other strings drw (12/17/04)
- Specifying a Criteria in a Query Rosemary (12/17/04)
- Records not present Hutch (12/17/04)
- UPDATE with subquery answer Robin Roberts (12/17/04)
- multiple critera problem Matt (12/17/04)
- Can I do this in one Query? Tim (12/17/04)
- Re: Repost: Please Help Tia (12/17/04)
- Parameter query with combo doesn't work GillianHG (12/17/04)
- sorting numbers in text format in query RLiss (12/17/04)
- Counting records queries _Adrian (12/17/04)
- Workaround for Column Naming issue? Doug Lahde (12/17/04)
- LIKE operator? _Adrian (12/17/04)
- UPDATE with a subquery Robin Roberts (12/17/04)
- Search Data vikas (12/17/04)
- Use a Combo Box in the Criteria field of a Query. Matt (12/17/04)
- Re: Use a Combo Box in the Criteria field of a Query. Rick Brandt (12/17/04)
- Re: Use a Combo Box in the Criteria field of a Query. Matt (12/17/04)
- Re: Use a Combo Box in the Criteria field of a Query. Rick Brandt (12/17/04)
- Re: Use a Combo Box in the Criteria field of a Query. Matt (12/17/04)
- Re: Use a Combo Box in the Criteria field of a Query. Rick Brandt (12/17/04)
- Re: Use a Combo Box in the Criteria field of a Query. Matt (12/17/04)
- Re: Use a Combo Box in the Criteria field of a Query. Rick Brandt (12/18/04)
- Re: Use a Combo Box in the Criteria field of a Query. Matt (12/17/04)
- Re: Use a Combo Box in the Criteria field of a Query. Rick Brandt (12/17/04)
- query help PhilGTI (12/17/04)
- sorting yes no fields Jon ajl (12/17/04)
- delete duplicate mark (12/17/04)
- Union Query Brook (12/17/04)
- Missing data in MS Access db records Randy (12/17/04)
- Can I 'autonumber' an append query? Andrew (12/17/04)
- Request with access 97 Jean Marie VIGNEAUD (12/17/04)
- append query repeats some lines jonmarcr (12/17/04)
- Deleting Records Gerrym (12/17/04)
- Union all Query Brook (12/17/04)
- How do I design a query like the Microsoft Help Index menu. edland (12/17/04)
- Before Due Date Help jbento (12/17/04)
- How to recursively query a nested Assembly Item Table. Woo Mun Foong (12/17/04)
- HELP microofficetester (12/16/04)
- HELP microofficetester (12/16/04)
- crosstab query sort by date c (12/16/04)
- Crosstab Macro Iman (12/16/04)
- Re: Crosstab Macro Duane Hookom (12/16/04)
- Re: Crosstab Macro Iman (12/17/04)
- Re: Crosstab Macro Duane Hookom (12/17/04)
- Re: Crosstab Macro Iman (12/17/04)
- Re: Crosstab Macro Duane Hookom (12/18/04)
- Re: Crosstab Macro Iman (12/19/04)
- Re: Crosstab Macro Duane Hookom (12/19/04)
- Re: Crosstab Macro Iman (12/19/04)
- Re: Crosstab Macro Duane Hookom (12/21/04)
- Re: Crosstab Macro Iman (12/22/04)
- Re: Crosstab Macro Duane Hookom (12/22/04)
- Re: Crosstab Macro Iman (12/17/04)
- Re: Crosstab Macro Duane Hookom (12/16/04)
- running sum query Robert (12/16/04)
- comparing years jeanne (12/16/04)
- Is it possible to set a sort order based on... Ted (12/16/04)
- count & sum Dan _at_BCBS (12/16/04)
- Null value in a lookup table Vincdc (12/16/04)
- Calculations in a query coming up incorrect. Melissa (12/16/04)
- Combining Queries Brook (12/16/04)
- Converting a value represention of minutes to actual minutes vzbuster (12/16/04)
- Criteria in a query Ulcom (12/16/04)
- Can queries be developed in Access that allow wildcards in the pa. Zoe (12/16/04)
- Sum two or more Time Durations vzbuster (12/16/04)
- using the results of a function for Criteria John Soarz (12/16/04)
- Sum Time or durrations vzbuster (12/16/04)
- Re: Sum Time or durrations Rick B (12/16/04)
- Re: Sum Time or durrations vzbuster (12/16/04)
- Re: Sum Time or durrations Rick Brandt (12/16/04)
- Re: Sum Time or durrations Rick B (12/16/04)
- Re: Sum Time or durrations vzbuster (12/16/04)
- Re: Sum Time or durrations Rick Brandt (12/16/04)
- Re: Sum Time or durrations Rick B (12/16/04)
- Re: Sum Time or durrations vzbuster (12/16/04)
- Re: Sum Time or durrations Rick Brandt (12/16/04)
- Re: Sum Time or durrations vzbuster (12/17/04)
- Re: Sum Time or durrations Rick Brandt (12/17/04)
- Re: Sum Time or durrations vzbuster (12/17/04)
- Re: Sum Time or durrations vzbuster (12/17/04)
- Re: Sum Time or durrations vzbuster (12/17/04)
- Re: Sum Time or durrations Rick Brandt (12/17/04)
- Re: Sum Time or durrations vzbuster (12/16/04)
- Re: Sum Time or durrations Rick B (12/16/04)
- naming fields unconventionally Michele L (12/16/04)
- Re: What is the SQL Statement for import data from excel file? Immanuel Sibero (12/16/04)
- Query week, month, quarter Ty (12/16/04)
- Count Dan _at_BCBS (12/16/04)
- Help with using the "OR" in Criteria Playa (12/16/04)
- "DateWorked:" Asked as parameter but not desired Ty (12/16/04)
- Is there anyway to dump data from an Access querie to individual . Gerry L. (12/16/04)
- Query Updates Being called from Macro Not Executing ae (12/16/04)
- Update query Ellen (12/16/04)
- Create a query programmatically quartz (12/16/04)
- Wild Card KAnoe (12/16/04)
- NZ Request Ian (12/16/04)
- Find records not present Zirc (12/16/04)
- criteria prompt and like function Bill Gates (12/16/04)
- UNION QUERY NOT WORKING angie (12/16/04)
- use data from other DB Lana (12/16/04)
- Query/rapport madde (12/16/04)
- how can i write ansi sql quires equalent to ms access and sql ser. S.SRIKANTH,GUDIWADA,AP,INDIA (12/16/04)
- format function gives back a string Jonas (12/16/04)
- Passthrough query error richardb (12/16/04)
- Form in Datasheet view accessquestion (12/16/04)
- Parameter query Barry (12/16/04)
- Change Query SQL Programatically AlCamp (12/16/04)
- Query, Form, Sub-Form accessquestion (12/16/04)
- Group by, sum, and Datediff questions regarding a query Ty (12/16/04)
- Re: Group by, sum, and Datediff questions regarding a query John Vinson (12/16/04)
- Can I use a [form]![field] as criteria in a crosstab? Alex (12/16/04)
- Interactive queries SecretCharacter (12/16/04)
- Running total for elapsed time? Fuzzy Logic (12/15/04)
- Summing/Counting, but in GROUPS rgrantz (12/15/04)
- field Is Null/Is Not Null criterion and IIf function J.T. Leeman (12/15/04)
- Type mismatch in expression mittels6 (12/15/04)
- Query report upgraded from 97 Font Large WordHazIt (12/15/04)
- SubQuery or Find Duplicate Query Alex (12/15/04)
- How to update "First" record only? Bill Brinkworth (12/15/04)
- Populating fields based on matching records in Excel Rose (12/15/04)
- parameter query run via ODBC Parameter query executed via ODBC (12/15/04)
- Horizontal to Vertical Help - Please Scott Duncan (12/15/04)
- ODBC --call failed @#! quartz (12/15/04)
- Display only the alpha characters in a field w/both alpha&numeric. Arbo M (12/15/04)
- Show alpha characters(variable) prior to 1st space. ArboM (12/15/04)
- join problem Jonas (12/15/04)
- Format function gibes back a string Jonas (12/15/04)
- CrossTab Query with Multiple Values??? panoffp_at_dteenergy.com (12/15/04)
- hot to change the values of a string in an update query DowningDevelopments (12/15/04)
- Cannot open file - help please Alex H (12/15/04)
- unknown "blank" values DOMNHS (12/15/04)
- Increment a value and return the value using sql Rob Willaar (12/15/04)
- Exiting access error Hans* (12/15/04)
- Average weekly value Kody (12/15/04)
- At Your Survey: Calculate field in cros-tab queries (followup) ButBi (12/15/04)
- Need help writing a query to pull data with six zeros on the end kryn13 (12/15/04)
- What is wrong with this code??? SenFan (12/15/04)
- query Frank Dulk (12/15/04)
- Only show fields with Inactive Stacey (12/15/04)
- Following variables over time. Big Tony (12/14/04)
- Combine tables, removes duplicate, keeping the link with a fourth table Guy Verville (12/14/04)
- AVG Function in a Query JohnL (12/14/04)
- Help to convert a IIf statement to SQL query Zirc (12/14/04)
- Uniting three tables in one, and keeping the link Guy Verville (12/14/04)
- filter out records in query McToba (12/14/04)
- In query, getting "Data type mismatch in criteria expression" mess jsccorps (12/14/04)
- Weekly formula (Access 97) Heathquad (12/14/04)
- Query week to date, month to date, year to date hours Ty (12/14/04)
- filtering for groups of products ChuckW (12/14/04)
- Cant get sql query to work Randy (12/14/04)
- How to create Query in Access that will cull out records that are. Database Weary (12/14/04)
- Update Query David Rivera (12/14/04)
- Update Query - daily update of 31 fields (each day of month) Frank F. (12/14/04)
- At Your Survey: Calculate field in cros-tab queries ButBi (12/14/04)
- 30 day Line Chart showing totals of 3 fields per day Sheryl (12/14/04)
- query takes forever to run seeker53 (12/14/04)
- Counting the Number of Words in a field in Access Amy Baggott (12/14/04)
- Access Queries Daryl (12/14/04)
- I want to Retrieve all records for 1st quarter of current year Kevin (12/14/04)
- finding # Mike (12/14/04)
- Sql query from Access returns no records, but SQL Query Analyser d MikeB in WB (12/14/04)
- Select Query HenryP (12/14/04)
- Update query Bill Brinkworth (12/14/04)
- SQL join---language Josh Henry (12/14/04)
- calculations in currency veryconfused (12/14/04)
- how to average hours, minutes & seconds in a column B (12/14/04)
- Del / Mark Duplicates?? sbcglobal (12/14/04)
- pass sql query to report? MJ (12/14/04)
- Samples of time querys Kenny M. (12/14/04)
- Formatting Zip Code TinleyParkILGal (12/14/04)
- Lookup? Help please. Alan Mitchell (12/14/04)
- Creative solution needed...please help quartz (12/14/04)
- Show current year without parameter Wylie C (12/14/04)
- Help on update query Amir (12/14/04)
- Avg or Sum in Query AlCamp (12/14/04)
- undesrstanding controls ExcessAccess (12/14/04)
- Add a sentence to the end of every cell in a field? ** ExcessAccess (12/13/04)
- RE: Add a sentence to the end of every cell in a field? ** ExcessAccess (12/14/04)
- Re: Add a sentence to the end of every cell in a field? ** Ken Snell [MVP] (12/14/04)
- Re: Add a sentence to the end of every cell in a field? ** Ken Snell [MVP] (12/14/04)
- Re: Add a sentence to the end of every cell in a field? ** ExcessAccess (12/15/04)
- Re: Add a sentence to the end of every cell in a field? ** Ken Snell [MVP] (12/15/04)
- Re: Add a sentence to the end of every cell in a field? ** ExcessAccess (12/15/04)
- Re: Add a sentence to the end of every cell in a field? ** Ken Snell [MVP] (12/15/04)
- Re: Add a sentence to the end of every cell in a field? ** John Vinson (12/15/04)
- Re: Add a sentence to the end of every cell in a field? ** Ken Snell [MVP] (12/15/04)
- Re: Add a sentence to the end of every cell in a field? ** Ken Snell [MVP] (12/15/04)
- Re: Add a sentence to the end of every cell in a field? ** John Vinson (12/14/04)
- Re: Add a sentence to the end of every cell in a field? ** Ken Snell [MVP] (12/14/04)
- RE: Add a sentence to the end of every cell in a field? ** ExcessAccess (12/14/04)
- Data Matching Steve S. (12/13/04)
- Create a non-unique index on a table quartz (12/13/04)
- Sort a table quartz (12/13/04)
- Updatable query - unique values Mary (12/13/04)
- Criteria- "Not like..." Laura (12/13/04)
- Update record AHopper (12/13/04)
- Prompting user for input davidg2356 (12/13/04)
- mini search engine Carlee (12/13/04)
- Find & Replace Chris (12/13/04)
- returning that item is 1 of # Megan (12/13/04)
- dynamic query MJ (12/13/04)
- value comparison smboyd (12/13/04)
- Re: invalid name in update query Michael Miller (12/13/04)
- Linking date fields from unrelated tables Tiago (12/13/04)
- Crosstab Column Headings Chad (12/13/04)
- Can't get query to work... crispywafers_at_yahoo.com (12/13/04)
- Strange behavior on query - Help?? Tim (12/13/04)
- Update - If statement Dan _at_BCBS (12/13/04)
- Re: Update - If statement Ken Snell [MVP] (12/13/04)
- Re: Update - If statement Dan _at_BCBS (12/13/04)
- Re: Update - If statement Ken Snell [MVP] (12/13/04)
- Re: Update - If statement Dan _at_BCBS (12/13/04)
- Re: Update - If statement Ken Snell [MVP] (12/13/04)
- Re: Update - If statement Dan _at_BCBS (12/13/04)
- Re: Update - If statement Ken Snell [MVP] (12/13/04)
- Re: Update - If statement Dan _at_BCBS (12/13/04)
- Re: Update - If statement Ken Snell [MVP] (12/14/04)
- Re: Update - If statement Dan _at_BCBS (12/14/04)
- Re: Update - If statement Ken Snell [MVP] (12/14/04)
- Re: Update - If statement Dan _at_BCBS (12/14/04)
- Re: Update - If statement Ken Snell [MVP] (12/14/04)
- Re: Update - If statement Dan _at_BCBS (12/13/04)
- Re: Update - If statement Ken Snell [MVP] (12/13/04)
- How to set decimal places for a column in the report Karen Middleton (12/13/04)
- Please help can't define a Access report for a query with 29 fields Karen Middleton (12/13/04)
- passing user parameters Pass Through Qry Anthony Viscomi (12/13/04)
- How to use a Access Query that as a parameter into Excel database query Karen Middleton (12/13/04)
- How do I calculate the number of Weekdays in a query? Satchmo368_at_hotmail.com (12/13/04)
- How do I calculate the number of Weekdays in a query? Satchmo368 (12/13/04)
- How do I calculate the number of Weekdays in a query? Satchmo368 (12/13/04)
- Week Number Steve (12/13/04)
- A Delete Query Jim Jones (12/13/04)
- query combo box Lauren J. Bradford (12/13/04)
- Autonumber problem SDITMan (12/13/04)
- crosstab query sort by date c (12/13/04)
- Problem with a select query in Access 2003 Pete McQuilken (12/13/04)
- Seeking SQL solution jsccorps (12/13/04)
- Undefined function 'replace' in expression vidas (12/13/04)
- Problem with between date using Access 02 mickeylin (12/13/04)
- #Error in query-fields in access-2002 Ole Fisker (12/13/04)
- Function to look for errors quartz (12/13/04)
- Using Like/ALike with "*" at the end of a filter dos not longer wo Jan Øystein Lund (12/13/04)
- Re: Using Like/ALike with "*" at the end of a filter dos not longer wo John Vinson (12/13/04)
- Re: Using Like/ALike with "*" at the end of a filter dos not longe Jan Øystein Lund (12/13/04)
- Re: Using Like/ALike with "*" at the end of a filter dos not longe John Vinson (12/13/04)
- Re: Using Like/ALike with "*" at the end of a filter dos not longe Allen Browne (12/14/04)
- Re: Using Like/ALike with "*" at the end of a filter dos not longe Jan Øystein Lund (12/14/04)
- Re: Using Like/ALike with "*" at the end of a filter dos not longe John Vinson (12/13/04)
- Re: Using Like/ALike with "*" at the end of a filter dos not longe Jan Øystein Lund (12/14/04)
- Re: Using Like/ALike with "*" at the end of a filter dos not longe Sylvain Lafontaine (12/14/04)
- Re: Using Like/ALike with "*" at the end of a filter dos not longe Jan Øystein Lund (12/13/04)
- Re: Using Like/ALike with "*" at the end of a filter dos not longer wo John Vinson (12/13/04)
- calculate number of working days in an access date range GarryD (12/13/04)
- How do I change ms access 2002 alike to like in queries? HPTCC (12/13/04)
- Use of the UNION operation Jim Jones (12/13/04)
- Update Record B (12/13/04)
- count in a field jomblo (12/13/04)
- Help on importing sbcglobal (12/13/04)
- Create Index in Make Table Query Brigitte P (12/13/04)
- matches columns for two separate tables tank (12/13/04)
- Doozy - help please quartz (12/12/04)
- Access queries Group By should allow Concatenate drkpotter (12/12/04)
- Showing only one of dublicate entries Robert Raley (12/12/04)
- Crosstab append query J. Shrimp, Jr. (12/12/04)
- How to change a field name quartz (12/12/04)
- splitting a field tgl (12/12/04)
- Need Assistance with Append Query...Thanks Andy (12/12/04)
- .....Hey Steve Schapel...! Popparod (12/12/04)
- How can I collect 4 quieries in one query? Mohamed Helmy Mostafa (12/12/04)
- How can fix the the problem of null value in a query ? Hamada (12/12/04)
- Change the resulting data format in a field Adrian (12/12/04)
- A query based on several other queries when one of the other quer. cwmmd (12/12/04)
- How do I recode data in a query? Jacqueline Harris (12/12/04)
- Updating Record Count into Table smeghead (12/12/04)
- find week dates jjrmy1_at_earthlink.net (12/12/04)
- Grouping by ranges of dates Ann (12/11/04)
- Re: Week Start Date sandip (12/11/04)
- Convert Access table of names ohporter (12/11/04)
- Recommendation for good Access Querry Book ?? Gary Warner (12/11/04)
- ...The Ol' NULL Statement... Popparod (12/11/04)
- Re: ...The Ol' NULL Statement... Duane Hookom (12/11/04)
- Re: ...The Ol' NULL Statement... Steve Schapel (12/11/04)
- Re: ...The Ol' NULL Statement... Popparod (12/11/04)
- Re: ...The Ol' NULL Statement... Popparod (12/12/04)
- Re: ...The Ol' NULL Statement... Popparod (12/12/04)
- Re: ...The Ol' NULL Statement... Popparod (12/12/04)
- Simple query help ross (12/11/04)
- Adding syntax to SQL Statement cvegas (12/11/04)
- Create a query of table names in a mdb Jim Pockmire (12/11/04)
- query to self table salimshahzad_at_gmail.com (12/11/04)
- Help with SQL syntax please cvegas (12/11/04)
- Help with insert query - please quartz (12/11/04)
- Table on top of picture jay (12/11/04)
- Need to fill nulls with zero? quartz (12/11/04)
- Query to merge data - HELP! quartz (12/10/04)
- Trouble Formatting a Formula? Mail Recipients Changing order of fields (12/10/04)
- Obtain records using parameters dg (12/10/04)
- VALIDATION RULE PROBLEMS WITH AN ACCESS 2000 UPDATE QUERY TomK (12/10/04)
- Simple Query help for someone new to Access quartz (12/10/04)
- Need Help with DateSerial Function Christy (12/10/04)
- Query Access database from multiple variables Mike (12/10/04)
- Joining 2 Tables Dar (12/10/04)
- query help with multiple entries in a log Patricia (12/10/04)
- Views Patricia (12/10/04)
- Query by end date Crown Royal (12/10/04)
- Criteria: between the 1 and last day of 2 months ago Alec (12/10/04)
- Re: Criteria: between the 1 and last day of 2 months ago Edward G (12/10/04)
- Re: Criteria: between the 1 and last day of 2 months ago Alec (12/10/04)
- Re: Criteria: between the 1 and last day of 2 months ago tina (12/10/04)
- Re: Criteria: between the 1 and last day of 2 months ago Edward G (12/11/04)
- Re: Criteria: between the 1 and last day of 2 months ago tina (12/11/04)
- Re: Criteria: between the 1 and last day of 2 months ago John Spencer (MVP) (12/13/04)
- Re: Criteria: between the 1 and last day of 2 months ago tina (12/13/04)
- Re: Criteria: between the 1 and last day of 2 months ago Edward G (12/13/04)
- Re: Criteria: between the 1 and last day of 2 months ago Edward G (12/10/04)
- Compare data to itself within a column in Access? Alphadisiac (12/10/04)
- week jjrmy1_at_earthlink.net (12/10/04)
- Calculate date in queries SgtSue (12/10/04)
- Passthrough Query Variable mroby (12/10/04)
- Re: Update on Max(date) DavidS (12/10/04)
- linking query to combo box Lauren J. Bradford (12/10/04)
- Wildcards + Criteria in a table to filter a query Beverly76 (12/10/04)
- Writing =Dlookup() into TextBox.RecordSource using VB at run time. Ilya (12/10/04)
- Query filter for text field: Not Like "MEX" or Not Like "CAN" doe. anthony_hunter_at_cargill.com (12/10/04)
- Re: Troubleshooting on network DavidS (12/10/04)
- Query to Extract Month from Date... Kojones (12/10/04)
- Comparing Dates in 2 different Objects Pat Z. (12/10/04)
- I MEAN: Can I move some data in one field to another field? Matt Meserve (12/10/04)
- Can I move some of that data in one file to another field Matt Meserve (12/10/04)
- drawing amounts from two tables--please--i am beyond desperate Josh Henry (12/10/04)
- assign line numbers Randal (12/10/04)
- Counting Query Steve (12/10/04)
- Question about Calculating Monthly Differences Teebone (12/10/04)
- checkboxes Lauren J. Bradford (12/10/04)
- dates in query smboyd (12/10/04)
- drawing from 2 different tables with a certain criteria---for year Josh Henry (12/10/04)
- Limiting query records output James (12/10/04)
- Date parameter query Big Bob (12/10/04)
- Unique Values query Support (12/10/04)
- invalid argument joan (12/10/04)
- A statement that automatically compile calculation Jerry C.k (12/10/04)
- OpenReport is canceled Petra (12/10/04)
- Open Petra (12/10/04)
- last table killing me jjenn7 (12/10/04)
- data type for null in union query Phil Hellmuth (12/10/04)
- Problem with code in VBA Jay (12/10/04)
- Complex Grouping (I think) and totalling rgrantz (12/10/04)
- I want query to run with summary of records weekly (not by unique. Sandip (12/09/04)
- Like & wildcard kurtn (12/09/04)
- Machine based behavor of Queries - AC2000 vs AC97 Rusty (12/09/04)
- Trim specified characters from Left (in SQL) Vijay (12/09/04)
- ? about Update query David Rivera (12/09/04)
- Crosstab Query in Access 97 Cindy (12/09/04)
- Counting records from multiple queries or tables Barry Phillips (12/09/04)
- Calculate stock's return bet. 2 dates JbL (12/09/04)
- COUNTIF in ACCESS (like in EXCEL)? copper88 (12/09/04)
- How do I add an inline comment to an SQL query? Mark Allan Nelson (12/09/04)
- Top 5 results calcs cause multiple returns Rose (12/09/04)
- capturing records when criteria falls on weekend or holiday Ken D. (12/09/04)
- Datasheet View Petra (12/09/04)
- Table Causes Query Problems Kojones (12/09/04)
- Populate null value with the parameter Alex (12/09/04)
- select text to the left of a comma - Access mosko (12/09/04)
- Using now() and now()+1 in a query... chris (12/09/04)
- Re: query results into string? Michael (12/09/04)
- Convert Address List from one column of data to many ChuckW (12/09/04)
- Re: Switch() causes strange ADO result Lynn Trapp (12/09/04)
- Summing Count queries Barry Phillips (12/09/04)
- CREATE TABLE query Neal Dignan (12/09/04)
- Query using IIF statement based on Check Boxes SMac (12/09/04)
- UNION QUERIS Robert Raley (12/09/04)
- Can a criteria be made to skip repeating information? Polarbear (12/09/04)
- Is there a function to change hexadecimal to decimal similar to h. Jo-Anne (12/09/04)
- Fonts hayley (12/09/04)
- Queries;Calculations BARKAROO (12/09/04)
- Data type mismatch in criteria expression. ian (12/09/04)
- Archived e-mails in Microsoft outlook David O (12/09/04)
- How to calculate values from 2 tables Luke (12/09/04)
- Append Query for records restore jk (12/09/04)
- how to insert a where clause in Insert Into... statement? anonymous_at_discussions.microsoft.com (12/09/04)
- Re: how to insert a where clause in Insert Into... statement? Michel Walsh (12/09/04)
- Re: how to insert a where clause in Insert Into... statement? Allen Browne (12/09/04)
- Re: how to insert a where clause in Insert Into... statement? anonymous_at_discussions.microsoft.com (12/09/04)
- Re: how to insert a where clause in Insert Into... statement? Allen Browne (12/09/04)
- Re: how to insert a where clause in Insert Into... statement? Michel Walsh (12/09/04)
- Re: how to insert a where clause in Insert Into... statement? Allen Browne (12/09/04)
- Re: how to insert a where clause in Insert Into... statement? Michel Walsh (12/09/04)
- Re: how to insert a where clause in Insert Into... statement? anonymous_at_discussions.microsoft.com (12/10/04)
- Re: how to insert a where clause in Insert Into... statement? Michel Walsh (12/10/04)
- Re: how to insert a where clause in Insert Into... statement? anonymous_at_discussions.microsoft.com (12/09/04)
- Q: Easy query? Geoff Jones (12/09/04)
- Query Expression Shabbir (12/09/04)
- Queries heads Βάππας Κωνσταντίνος (12/09/04)
- try to get a last results query Olav (12/09/04)
- OpenRecord is canceled Petra (12/09/04)
- finding text with query gardnertj (12/09/04)
- not able to edit query result set babs (12/08/04)
- Turning off the confirmation messages Maria K (12/08/04)
- SQL TABLES BV (12/08/04)
- DCOUNT criteria with dates Bill (12/08/04)
- Re: DCOUNT criteria with dates Ken Snell [MVP] (12/08/04)
- Re: DCOUNT criteria with dates Bill (12/08/04)
- Re: DCOUNT criteria with dates Bill (12/08/04)
- Re: DCOUNT criteria with dates Ken Snell [MVP] (12/09/04)
- Re: DCOUNT criteria with dates Bill (12/09/04)
- Re: DCOUNT criteria with dates Ken Snell [MVP] (12/09/04)
- Re: DCOUNT criteria with dates Ken Snell [MVP] (12/09/04)
- Re: DCOUNT criteria with dates Bill (12/09/04)
- Re: DCOUNT criteria with dates Ken Snell [MVP] (12/09/04)
- Re: DCOUNT criteria with dates Bill (12/09/04)
- Re: DCOUNT criteria with dates Ken Snell [MVP] (12/10/04)
- Re: DCOUNT criteria with dates Bill (12/08/04)
- Re: DCOUNT criteria with dates Ken Snell [MVP] (12/08/04)
- Criteria from Form Susan (12/08/04)
- New Post on Syntax Help For Ken cvegas (12/08/04)
- What is wrong with this Delete Query? vvenk (12/08/04)
- Re: What is wrong with this Delete Query? LeAnne (12/08/04)
- Re: What is wrong with this Delete Query? John Vinson (12/08/04)
- Mysterious Recordset Changes BCP (12/08/04)
- Date Range (year from entered date) accessquestion (12/08/04)
- Queries comparing text box value to listbox Dave (12/08/04)
- Name table w/ site name Siew-Ming (12/08/04)
- Help with joining 2 queries Robert Raley (12/08/04)
- Searching for data by a daughter table Natalia (12/08/04)
- Extract dates RipperT (12/08/04)
- Iif Statements Ryan W (12/08/04)
- Need to export a pivot chart view of a query AmandaM (12/08/04)
- Re: Need to export a pivot chart view of a query LeAnne (12/08/04)
- Re: Need to export a pivot chart view of a query AmandaM (12/15/04)
- Re: Need to export a pivot chart view of a query LeAnne (12/16/04)
- Re: Need to export a pivot chart view of a query LeAnne (12/16/04)
- Re: Need to export a pivot chart view of a query AmandaM (12/17/04)
- Re: Need to export a pivot chart view of a query LeAnne (12/17/04)
- Re: Need to export a pivot chart view of a query LeAnne (12/17/04)
- Re: Need to export a pivot chart view of a query AmandaM (12/21/04)
- Re: Need to export a pivot chart view of a query AmandaM (12/15/04)
- Re: Need to export a pivot chart view of a query LeAnne (12/08/04)
- drop down list in a parameter query mesage prompt? TGK (12/08/04)
- Query Juan (12/08/04)
- Last Record PR (12/08/04)
- Using IIf with Dates Pat Z. (12/08/04)
- Parameter Question Anthony Viscomi (12/08/04)
- Format question Dale (12/08/04)
- Stumped on Query Design Shoelaces (12/08/04)
- IIF condition Alylia (12/08/04)
- Syntax Help cvegas (12/08/04)
- Help with error Patricia (12/08/04)
- Need to create 1 row per employee from a table of multiple rows Erika Fermaints (12/08/04)
- Re: Need to create 1 row per employee from a table of multiple rows Edward G (12/08/04)
- Re: Need to create 1 row per employee from a table of multiple rows Duane Hookom (12/08/04)
- Re: Need to create 1 row per employee from a table of multiple row Erika Fermaints (12/08/04)
- Re: Need to create 1 row per employee from a table of multiple row Edward G (12/08/04)
- Re: Need to create 1 row per employee from a table of multiple row Duane Hookom (12/08/04)
- Re: Need to create 1 row per employee from a table of multiple row Erika Fermaints (12/08/04)
- Re: Need to create 1 row per employee from a table of multiple row Duane Hookom (12/09/04)
- Re: Need to create 1 row per employee from a table of multiple row Erika Fermaints (12/08/04)
- Adding KenC (12/08/04)
- How to call an Oracle procedure via a pass-through query via ODBC. Mojo110166 (12/08/04)
- RE: Sending hints in SQL Mojo110166 (12/08/04)
- How to call an Oracle Procedure via a pass-thru query via ODBC Mojo110166 (12/08/04)
- Calling an Oracle Procedure via ODBC and Pass-thru Query Mojo110166 (12/08/04)
- Left Join problem Roy Goldhammer (12/08/04)
- PLEASE HELP! Query expression truncated by Access2000! Bilbo (12/08/04)
- Ascending Sort Problem pas926 (12/08/04)
- Checking for empty query Bert nErnie via AccessMonster.com (12/08/04)
- How compare data between 2 tables Charles Tam (12/08/04)
- how do i use if/else in access update query jberv534 (12/08/04)
- how do i use if/else in access update query JErv (12/08/04)
- query that searches from multi fields on a form Steven M. Britton (12/08/04)
- Enter just the year. KAnoe (12/08/04)
- duplicate records logged by different reps counted arezynot (12/08/04)
- Repost: Form does not release locks with record-level locking david epsom dot com dot au (12/07/04)
- Help with a Running sum query Access Newbie (12/07/04)
- Record Limit for Using Transactions, Commit? Brian (12/07/04)
- I want the records but not the field data ** ExcessAccess (12/07/04)
- SQL Query + Percentage If (12/07/04)
- Searching text in memo fields of Access 2003 David (12/07/04)
- is this an impossible query? davas100 (12/07/04)
- Bewtween Date(), SUM QRAMelissa (12/07/04)
- Time/Date expression Dawn (12/07/04)
- Invalid Column Name Error cvegas (12/07/04)
- Changing field names when using make-table query? ExcessAccess (12/07/04)
- How do I build a query parameter ARL (12/07/04)
- Dlookup in a query Jay Cook (12/07/04)
- Automatic Update Query? Dumb Blonde (12/07/04)
- Re: Automatic Update Query? Rick B (12/07/04)
- Re: Automatic Update Query? Dumb Blonde (12/07/04)
- Re: Automatic Update Query? Rick B (12/07/04)
- Re: Automatic Update Query? Dumb Blonde (12/07/04)
- Re: Automatic Update Query? LeAnne (12/07/04)
- Re: Automatic Update Query? Rick B (12/07/04)
- Re: Automatic Update Query? LeAnne (12/08/04)
- Re: Automatic Update Query? tina (12/08/04)
- Re: Automatic Update Query? Dumb Blonde (12/08/04)
- Re: Automatic Update Query? tina (12/08/04)
- Re: Automatic Update Query? Dumb Blonde (12/08/04)
- Re: Automatic Update Query? tina (12/08/04)
- Re: Automatic Update Query? Dumb Blonde (12/08/04)
- Re: Automatic Update Query? Marshall Barton (12/08/04)
- Re: Automatic Update Query? Dumb Blonde (12/07/04)
- Re: Automatic Update Query? John Spencer (MVP) (12/08/04)
- Re: Automatic Update Query? Rick B (12/07/04)
- Parameter Queries tinab (12/07/04)
- sorting in ACCESS 2000 menchi(removethis)_at_dor.state.ma.us (12/07/04)
- Populate table from a query Randy (12/07/04)
- Creating multiple records from one record Marge (12/07/04)
- Date Query Frank (12/07/04)
- Count John (12/07/04)
- calculate a new value from two values in the same field fishcakes (12/07/04)
- How do I find duplicates in Access 2002 without the install cd-rom NYDCC (12/07/04)
- Query error message Placid (12/07/04)
- Replace ":" with "0" RickM (12/07/04)
- Query with Percent Closemofo (12/07/04)
- Expression question lmgraca (12/07/04)
- Spelling numbers lmgraca (12/07/04)
- Simple one to many question Tim (12/07/04)
- I want to randomly select records. BYBaby (12/07/04)
- Query to get output from 2 other queries Toto (12/07/04)
- Re: Query to get output from 2 other queries Rick B (12/07/04)
- Re: Query to get output from 2 other queries Brian (12/07/04)
- Re: Query to get output from 2 other queries Toto (12/07/04)
- Re: Query to get output from 2 other queries Brian (12/07/04)
- Re: Query to get output from 2 other queries Toto (12/07/04)
- Re: Query to get output from 2 other queries Brian (12/07/04)
- Re: Query to get output from 2 other queries Toto (12/07/04)
- Re: Query to get output from 2 other queries John Spencer (MVP) (12/08/04)
- Re: Query to get output from 2 other queries Brian (12/08/04)
- Re: Query to get output from 2 other queries Toto (12/07/04)
- RE: Query to get output from 2 other queries Michael Miller (12/07/04)
- update DSUM error KLM (12/07/04)
- iif condition Alylia (12/07/04)
- Concatenate Date & Currency Fields TinleyParkILGal (12/07/04)
- Re: Using GROUP BY in query expression on MEMO fields it truncates data in MEMO fields to first 255 characters Douglas J. Steele (12/07/04)
- query madde (12/07/04)
- Changing colours Daniel (12/07/04)
- How do I hide message boxes when running a make table query in Ac. FrustratedInNC (12/07/04)
- Query running very slow Daniel-Snack (12/07/04)
- Update query Ilya (12/07/04)
- Getting the SUM of a fiel from an unrelated table Jesse (12/07/04)
- Removing apostrophes Spammastergrand (12/07/04)
- Query Relationship\Multiple Join Carol Giannini (12/07/04)
- How to auto-populate records in query Sam Kuo (12/07/04)
- Merge TinleyParkILGal (12/07/04)
- removing duplicates in a query? Orv (12/07/04)
- Access97 Query expression truncated by Access2000 Bilbo (12/06/04)
- Query - IIf statement.... Bill (12/06/04)
- insert and autonumber TheSniipe (12/06/04)
- Join Problem Kyle (12/06/04)
- moving files and folders in access jay (12/06/04)
- Copy Columns jay (12/06/04)
- Re: Dont want to show duplicates, and want to show how many client J-E (12/06/04)
- beginning and end of event sequences Dale Fye (12/06/04)
- Combine Data From Different Rows TinleyParkILGal (12/06/04)
- Iif Statements Ryan W (12/06/04)
- Re: time tracking stag246 (12/06/04)
- Query to find missing numbers Randy (12/06/04)
- Pass Through query Kpatel (12/06/04)
- Union Query Brad (12/06/04)
- comparing fields stag246 (12/06/04)
- Calculating beginning balance based on ending balance jsccorps (12/06/04)
- Copy Multiple Tables with Relationships dang nguyen via AccessMonster.com (12/06/04)
- is .mdb executable? Wez.k (12/06/04)
- Is there a way to separate 1 name field into separate ones... jacqueline (12/06/04)
- Crosstab query - for every month MaBell (12/06/04)
- Using iif condition Alylia (12/06/04)
- RE: Using iif condition JL (12/06/04)
- RE: Using iif condition Alylia (12/07/04)
- RE: Using iif condition Alylia (12/07/04)
- Re: Using iif condition Duane Hookom (12/07/04)
- Re: Using iif condition Alylia (12/07/04)
- Re: Using iif condition Duane Hookom (12/07/04)
- Re: Using iif condition Alylia (12/08/04)
- Re: Using iif condition Duane Hookom (12/08/04)
- Re: Using iif condition Alylia (12/08/04)
- Re: Using iif condition Alylia (12/07/04)
- Re: Using iif condition Edward G (12/06/04)
- Re: Using iif condition Alylia (12/06/04)
- Re: Using iif condition Alylia (12/06/04)
- Re: Using iif condition Edward G (12/06/04)
- Re: Using iif condition Alylia (12/07/04)
- Re: Using iif condition Lynn Trapp (12/07/04)
- Re: Using iif condition Duane Hookom (12/06/04)
- Re: Using iif condition Alylia (12/07/04)
- Re: Using iif condition Duane Hookom (12/07/04)
- Re: Using iif condition Alylia (12/06/04)
- RE: Using iif condition JL (12/06/04)
- Data from one of three tables not being picked up in query. MCB (12/06/04)
- Using *Count in my querie? Help zwanz P via AccessMonster.com (12/06/04)
- Editing Union results ptb476 (12/06/04)
- Test Scoring Query Help tanorris_at_academicplanet.com (12/06/04)
- queries troubleshooting Βάππας Κωνσταντίνος (12/06/04)
- compare last year and this years sales Mike V T (12/06/04)
- Parameter Queries tinab (12/06/04)
- How do I get YTD totals from 1 of 13 records having the same date? Angey13 (12/06/04)
- Deleting Spacific records Oded Kovach (12/05/04)
- search for part or all of a field TheSniipe (12/05/04)
- Re: Parameters in the query T. W. (12/05/04)
- Find Sunday and Saturday Jerry (12/05/04)
- update fields in a form / subform ??? peter junker (12/05/04)
- Re: Capitalization - only first letter of word Brian (12/05/04)
- Trend Analysis. Bill (12/05/04)
- I have Access 2002 and I can't seem to get a "Create View" SQL st. LoveLee (12/05/04)
- Searching Multiple Fields Steven M. Britton (12/05/04)
- Multiple Columns from One Column jk53110 (12/04/04)
- Quarter and Year out of Date PR (12/04/04)
- How can I run a case-sensitive query in Access? suzyq (12/04/04)
- Append and Update Query Question bdehning (12/04/04)
- Query Calculation David (12/04/04)
- Query to find non numeric characters Jerry (12/03/04)
- how do I have Access display the same data for each day between a. Carie (12/03/04)
- random sample jdmcleod (12/03/04)
- Query Results when Sum is included Lloyd (12/03/04)
- Refining (focusing) a query Rucksack (12/03/04)
- How do I query for blank fields? BereaSue (12/03/04)
- adjusting where clause in SQL statement Josh Henry (12/03/04)
- How do I query for blank fields? BereaSue (12/03/04)
- Overflow message Why am I getting it? Lori Hansen via AccessMonster.com (12/03/04)
- Re: Grouping and Alphabetizing Rebecca (12/03/04)
- "Is not Null" calling up blank fields MNicholas (12/03/04)
- Criteria from ComboBox MN (12/03/04)
- date calculation and decimal places Mary (12/03/04)
- RE: Pass through Query:Invalid precision for Decimal Data Type error LSohn (12/03/04)
- Unmatched Query Martin (12/03/04)
- Update table from Result of Query of same table Steve (12/03/04)
- Append Multiple copies of each record Edgar Thoemmes (12/03/04)
- Query - Omit records troubled (12/03/04)
- Re: Query - Omit records Rick B (12/03/04)
- Re: Query - Omit records Edward G (12/03/04)
- Re: Query - Omit records Rick B (12/03/04)
- Re: Query - Omit records Edward G (12/03/04)
- Re: Query - Omit records Rick B (12/03/04)
- Re: Query - Omit records Edward G (12/03/04)
- Re: Query - Omit records Rick B (12/03/04)
- Re: Query - Omit records Rick B (12/03/04)
- Re: Query - Omit records Edward G (12/03/04)
- Re: Query - Omit records Ted Allen (12/03/04)
- Re: Query - Omit records Rick B (12/03/04)
- Re: Query - Omit records Ted Allen (12/03/04)
- Re: Query - Omit records Rick B (12/03/04)
- Re: Time Calculations Steve Voorhees (12/03/04)
- How to update a list box based on values selected in a combo box? SUHYB (12/03/04)
- update a blank field with a alphnumeric incrementing field peadair (12/03/04)
- sysdate query in ms access sukhwinder (12/03/04)
- Edit foreign keys jma (12/03/04)
- create a new table combining Mr. and Mrs. records Lynn Carlton (12/03/04)
- Min value Ed (12/03/04)
- compare Ed (12/03/04)
- Alternate shading LMB (12/03/04)
- Multiple Table Query Jason (12/03/04)
- Re: Query with mathematics criteria!!?? Help! John Vinson (12/03/04)
- query based on a date field Richard (12/03/04)
- Filter by selction returns wrong records Rookie (12/03/04)
- Obtaining single records George R (12/03/04)
- table already exists davwps1 (12/03/04)
- How to get a single value from a query without open a recordset? Min (12/02/04)
- Filter By Selection Kenny G (12/02/04)
- count rows JAS (12/02/04)
- In MS Access SQL, what does ! do? Bill (12/02/04)
- Re: How to get data from Analysis Services cubes into Access aaron_kempf_at_hotmail.com (12/02/04)
- like statment Joel (12/02/04)
- Microsoft Access using in-clause Henry Schutte (12/02/04)
- Is there a way to parse a street address in Access? MPD (12/02/04)
- Data validition error in append query Robert Sykes (12/02/04)
- using sql to generate invoice numbers hcs (12/02/04)
- convert julian date in access JayG. (12/02/04)
- Sum, group, date finster26 (12/02/04)
- Want CurrentUser as default in parameter Bonnie (12/02/04)
- Convert date type to text type Sirocco (12/02/04)
- Query to calculate difference on group level Christian (12/02/04)
- Help with query jacqueline (12/02/04)
- Query calculation help... jacqueline (12/02/04)
- Automated Field Steve (12/02/04)
- Close down Access Andreas Andreasson (12/02/04)
- Sorting Percentages Yubasus (12/02/04)
- Re: Sorting Percentages John Viescas (12/02/04)
- Re: Sorting Percentages Yubasus (12/02/04)
- Re: Sorting Percentages John Viescas (12/02/04)
- Re: Sorting Percentages Yubasus (12/03/04)
- Re: Sorting Percentages John Viescas (12/04/04)
- Re: Sorting Percentages Yubasus (12/08/04)
- Re: Sorting Percentages John Viescas (12/08/04)
- Re: Sorting Percentages Yubasus (12/08/04)
- Re: Sorting Percentages Yubasus (12/08/04)
- Re: Sorting Percentages John Viescas (12/08/04)
- Re: Sorting Percentages Yubasus (12/09/04)
- Re: Sorting Percentages Yubasus (12/02/04)
- Re: Sorting Percentages John Viescas (12/02/04)
- Class Scheduling Query Sue (12/02/04)
- Re: Is it possible to get a report where every column is sorted the way I want i Peter Gundrum (12/02/04)
- IF U ceate query dynamically, can U create query description too? MaBell (12/02/04)
- Re: IF U ceate query dynamically, can U create query description too? John Viescas (12/02/04)
- Re: IF U ceate query dynamically, can U create query description t MaBell (12/02/04)
- Re: IF U ceate query dynamically, can U create query description t John Viescas (12/02/04)
- Re: IF U ceate query dynamically, can U create query description t MaBell (12/08/04)
- Re: IF U ceate query dynamically, can U create query description t John Viescas (12/08/04)
- Re: IF U ceate query dynamically, can U create query description t MaBell (12/09/04)
- Re: IF U ceate query dynamically, can U create query description t MaBell (12/09/04)
- Re: IF U ceate query dynamically, can U create query description t John Viescas (12/11/04)
- Re: IF U ceate query dynamically, can U create query description t MaBell (12/02/04)
- Re: IF U ceate query dynamically, can U create query description too? John Viescas (12/02/04)
- Deleting duplicate records BG (12/02/04)
- when querying, how do you remove duplicate records within a group eddie (12/02/04)
- Creating query from string - NOT clause MaBell (12/02/04)
- Samples Query Neily (12/02/04)
- Pass Through Query Question Joe Williams (12/02/04)
- Changing Field Properties using queries stag246 (12/02/04)
- MAX(Completion_Date) davidg2356 (12/02/04)
- Calculating subscription length when cancel date = null Don (12/02/04)
- No records Returned Nick (12/02/04)
- Excluding Weekends in Query G. V. (12/02/04)
- How do I enter a table I want to query in access. Same report fo. J KARP (12/02/04)
- novice needs help !! Lee Ellis (12/02/04)
- Help Please - All entries in one cell Lee-Anne Waters via AccessMonster.com (12/02/04)
- ROUNDING QUESTION WWV (12/02/04)
- Key Violation Error on an Append Query BC (12/02/04)
- Make Query Parameters Optional Charles Tam (12/02/04)
- Nested If Statment WDP (12/01/04)
- How to FIND tables and columns in queries James V Dale (12/01/04)
- Time Calculation Query Help Needed S. Smith (12/01/04)
- How do you setup a Query across multiple fields? Hyperboy (12/01/04)
- Joining two queries into one. James Kendall (12/01/04)
- Conditional Formating Bruce (12/01/04)
- How do I Track changes to queries Maddog (12/01/04)
- Environ$ function John Bigness (12/01/04)
- Refering to calculated fields in a visual basic function iansa (12/01/04)
- Event Change Table Petra (12/01/04)
- Look up value Alex (12/01/04)
- Match Today's Date Confused (12/01/04)
- converting date Oded Kovach (12/01/04)
- Changing Output Names on a Group By Charles D Clayton Jr (12/01/04)
- Ranking Results Damien (12/01/04)
- Writing about Access ZZZ (12/01/04)
- ###Divide in a select query### Jimmy (12/01/04)
- order on the months. Rodolfo Fontes (12/01/04)
- Recommendation for query structure Christian (12/01/04)
- How can I get this SQL to work - Access XP Newbie (12/01/04)
- Generating antomatic email notices... is it possible? HOW? HELP! Trial & Error (12/01/04)
- What a strange database and query result ?! EricYuh Taiwan (12/01/04)
- RE: Date Query Larry (12/01/04)
- Rank with conditional value Carlos (12/01/04)
- Correlated Subqueries Springy (12/01/04)
- Extracting Zipcode out of address line Jerry Crosby (11/30/04)
- Complex Append Query Edgar Thoemmes (11/30/04)
- Using BETWEEN function with MAX(Completion_Dates) davidg2356 (11/30/04)
- Re: need help with access query karoaustin (11/30/04)
- Need Top percentage of records rather than Top Values Kenny Markhardt (11/30/04)
- Decimal Places Lost in Query Expression burchr (11/30/04)
- Help with SQL query Mary (11/30/04)
- Re: Criteria to find what isn't there. Resend with error Glenn (11/30/04)
- Date Criteria for a Union Query Ryan W (11/30/04)
- #NAME? problem Lisa (11/30/04)
- I want too use a combox to fill in the criteria off a query paul (11/30/04)
- Like Tequila Elvis (11/30/04)
- Reading Data in a Subform with VBA QEoin_C=2E_Bair=E9ad=22?= (11/30/04)
- How to compare last year's to today's numbers from one table? Olaf Richter (11/30/04)
- show only LAST entry made thrashcat (11/30/04)
- UPDATE Statement (Subquery Error) ADP Danny (11/30/04)
- Re: Query Problem DCFujiwara (11/30/04)
- Queries losing fieldnames, showing Expr: Michael Miller (11/30/04)
- adjusting where clause in SQL statement Josh Henry (11/30/04)
- Trim Query BIll Mills (11/30/04)
- RE: Multiple Table Query Ted Allen (11/30/04)
- Select particular records in a query sph1197 (11/30/04)
- Query not showing desired results James Kendall (11/30/04)
- Hard Return? r. howell (11/30/04)
- Querying MS SQL database in Access Randy (11/30/04)
- MEMO with vbNewLine Query Help Jim Lou (11/30/04)
- Re: calculation on a MAX(DATE) query davidg2356 (11/30/04)
- Re: IF function to show result cursednomore (11/30/04)
- Re: Data Type Ivor Williams (11/30/04)
- Re: Eval("Name of Field") Jeff Boyce (11/30/04)
- Re: Combo box returns numeric values Jeff Boyce (11/30/04)
- Re: Set up an Autonumber Query Jeff Boyce (11/30/04)
- Re: Need help to write query to show records by record number Jeff Boyce (11/30/04)
- Re: Changing Case in Field Jeff Boyce (11/30/04)
- Re: Adding a combo box in a query Ammo (11/30/04)
- Re: Would like a drop down choice when using a parameter query Michel Walsh (11/30/04)
- Re: percentile Michel Walsh (11/30/04)
- Re: ALTER COLUMN question Michel Walsh (11/30/04)
- Confused - Query with multiple tables Peter (11/30/04)
- Re: criteria question Michel Walsh (11/30/04)
- ANy ideas Simonglencross (11/30/04)
- Re: Excluding empty fields from a concatenated string Tim Long (11/30/04)
- Re: nested subselects with exists Jesper F (11/30/04)
- Re: Using values from a message box Nikos Yannacopoulos (11/30/04)
Last message date: 12/30/04
Archived on: 12/31/04 GMT
2722 messages sorted by: [ date ]
