microsoft.public.access.queries

• Thread Index

---

• Re: using query returns to create new columns
  • From: Marshall Barton
• RE: Group By Qtr
  • From: KARL DEWEY
• RE: Converting text to a number in query
  • From: Stephanie
• Sum values of column
  • From: NeoFax
• Group By Qtr
  • From: acss
• RE: Converting text to a number in query
  • From: KARL DEWEY
• Re: Average Records between date range
  • From: Michel Walsh
• RE: Converting text to a number in query
  • From: Stephanie
• Re: using query returns to create new columns
  • From: John Spencer
• Re: Help with a query...
  • From: John Spencer
• Re: using query returns to create new columns
  • From: Marshall Barton
• Re: Average Records between date range
  • From: Love Buzz
• RE: using query returns to create new columns
  • From: KARL DEWEY
• RE: Converting text to a number in query
  • From: KARL DEWEY
• Re: SQL Statement
  • From: Joe Gonzalez
• Re: Using SELECT DISTINCT
  • From: John Spencer
• Re: Query for two fields in one record that do not match
  • From: John Spencer
• Help with a query...
  • From: Nuno Gomes
• Re: SQL Statement
  • From: John Spencer
• Re: Duplicating values to empty field
  • From: John Spencer
• Re: Queries without duplicates
  • From: puppypaws
• Re: Queries without duplicates
  • From: adam . vogg
• RE: Queries without duplicates
  • From: scubadiver
• Re: Query for two fields in one record that do not match
  • From: adam . vogg
• Re: Duplicating values to empty field
  • From: DanBakerUSAF
• Re: Copying data from one table to another
  • From: Jeff Boyce
• RE: Converting text to a number in query
  • From: Stephanie
• Re: Nested SQL Statements causing slowness and errors
  • From: jlute
• Re: Ungrouping in DSUM
  • From: acss
• Re: Ungrouping in DSUM
  • From: Michel Walsh
• Re: Why do queries automaticly rearange columns?
  • From: Michel Walsh
• Re: Why do queries automaticly rearange columns?
  • From: Michel Walsh
• Re: Using SELECT DISTINCT
  • From: Leslie Isaacs
• Re: Filtering for "Not Something"
  • From: Bob Barrows [MVP]
• Re: Using Filter by Form to create a Query and then a Report
  • From: Allen Browne
• Re: Time difference between multiple times and dates
  • From: Allen Browne
• Re: Using Filter by Form to create a Query and then a Report
  • From: HWhite
• Re: Using Filter by Form to create a Query and then a Report
  • From: HWhite
• Re: Filtering for "Not Something"
  • From: John Spencer
• Re: Using SELECT DISTINCT
  • From: John Spencer
• Re: Crosstab query - I need aditional information
  • From: John Spencer
• Re: Using Filter by Form to create a Query and then a Report
  • From: John Spencer
• Re: Duplicating values to empty field
  • From: John Spencer
• Re: Filtering for "Not Something"
  • From: Rick Brandt
• Re: Using SELECT DISTINCT
  • From: Bob Barrows [MVP]
• Time difference between multiple times and dates
  • From: dietmarhannam@xxxxxxx
• Re: Duplicating values to empty field
  • From: DanBakerUSAF
• Re: Using SELECT DISTINCT
  • From: Leslie Isaacs
• Re: Using SELECT DISTINCT
  • From: Dennis
• Re: Duplicating values to empty field
  • From: DanBakerUSAF
• pivot chart legend shows "Sum of"
  • From: matthijs
• Re: Filtering for "Not Something"
  • From: Bob Barrows [MVP]
• Re: Using SELECT DISTINCT
  • From: Leslie Isaacs
• Re: Expression Builder
  • From: Bob Barrows [MVP]
• Using SELECT DISTINCT
  • From: Leslie Isaacs
• D&G shoes - Best High Quality D&G shoes www.luxury-gift.org
  • From: yxs040
• MARNI handbags handbags - Best High Quality MARNI handbags handbags www.luxury-gift.org
  • From: yxs040
• help with a query
  • From: Nuno Gomes
• Re: Using Filter by Form to create a Query and then a Report
  • From: Allen Browne
• RE: Using Filter by Form to create a Query and then a Report
  • From: HWhite
• Using Filter by Form to create a Query and then a Report
  • From: HWhite
• Re: Expression Builder
  • From: Elizabeth Reynolds
• Re: Duplicating values to empty field
  • From: John Spencer
• Re: Unmatched Query creativity needed - date field
  • From: Jane Schuster
• Re: Ungrouping in DSUM
  • From: Wolfgang Kais
• Re: Expression Builder
  • From: Bob Barrows [MVP]
• Re: Expression Builder
  • From: Bob Barrows [MVP]
• Re: Limiting the total time for dancing to 15 mins [900 sec]
  • From: Julian
• Re: Continuous Form Loading Problem
  • From: Wolfgang Kais
• Re: Limiting the total time for dancing to 15 mins [900 sec]
  • From: Bob Barrows [MVP]
• Re: Transform Access SQL to SQL server 2005 or SQLExpress
  • From: Juan Robledo
• Re: Unmatched Query creativity needed - date field
  • From: Ken Sheridan
• Re: Limiting the total time for dancing to 15 mins [900 sec]
  • From: Julian
• Re: Limiting the total time for dancing to 15 mins [900 sec]
  • From: Bob Barrows [MVP]
• Re: Transform Access SQL to SQL server 2005 or SQLExpress
  • From: Bob Barrows [MVP]
• Re: Limiting the time in a Query
  • From: Bob Barrows [MVP]
• RE: Count Check boxes and create short report
  • From: Ken Sheridan
• Re: Transform Access SQL to SQL server 2005 or SQLExpress
  • From: Juan Robledo
• Re: Parameter Query Problem
  • From: raskew via AccessMonster.com
• Re: Date Format
  • From: Jeff Boyce
• Re: Transform Access SQL to SQL server 2005 or SQLExpress
  • From: Bob Barrows [MVP]
• Re: Transform Access SQL to SQL server 2005 or SQLExpress
  • From: Juan Robledo
• Re: Limiting the time in a Query
  • From: Bob Barrows [MVP]
• Limiting the time in a Query
  • From: Julian
• Re: Transform Access SQL to SQL server 2005 or SQLExpress
  • From: Bob Barrows [MVP]
• Re: Transform Access SQL to SQL server 2005 or SQLExpress
  • From: Juan Robledo
• Re: Count Check boxes and create short report
  • From: Bob Barrows [MVP]
• Re: Unmatched Query creativity needed - date field
  • From: raskew via AccessMonster.com
• Re: Unmatched Query creativity needed - date field
  • From: pietlinden@xxxxxxxxxxx
• Re: Count Check boxes and create short report
  • From: pietlinden@xxxxxxxxxxx
• Re: Time Difference > 24 Hours
  • From: pietlinden@xxxxxxxxxxx
• RE: Complex for me but may be a very simple query for you experts.
  • From: knavlekar
• RE: Count Check boxes and create short report
  • From: goodkitty
• Re: Count Check boxes and create short report
  • From: goodkitty
• RE: Count Check boxes and create short report
  • From: Ken Sheridan
• Re: Count Check boxes and create short report
  • From: Bob Barrows [MVP]
• Re: Parameter Query Problem
  • From: CollegeTry
• Re: Count Check boxes and create short report
  • From: goodkitty
• Re: SQL Syntax
  • From: Bob Barrows [MVP]
• Re: Transform Access SQL to SQL server 2005 or SQLExpress
  • From: Bob Barrows [MVP]
• Re: How to use symbol=["Ticker" "Enter ticker"] with Microsoft Excel 2
  • From: Bob Barrows [MVP]
• Re: SQL Syntax
  • From: Bob Barrows [MVP]
• Re: SQL Syntax
  • From: louisjohnphillips
• Re: Count Check boxes and create short report
  • From: pietlinden@xxxxxxxxxxx
• Transform Access SQL to SQL server 2005 or SQLExpress
  • From: Juan Robledo
• Re: inventory query
  • From: Bob Barrows [MVP]
• Re: inventory query
  • From: Bob Barrows [MVP]
• Re: inventory query
  • From: C Parkins
• RE: Cross Tab Query with DateSerial
  • From: Duane Hookom
• Re: inventory query
  • From: Bob Barrows [MVP]
• Re: inventory query
  • From: C Parkins
• Re: Change Sequence of Characters
  • From: Allen Browne
• Re: Change Sequence of Characters
  • From: John Spencer
• Re: Complex for me but may be a very simple query for you experts.
  • From: Allen Browne
• Re: inventory query
  • From: Bob Barrows [MVP]
• Complex for me but may be a very simple query for you experts.
  • From: knavlekar
• RE: inventory query
  • From: C Parkins
• Change Sequence of Characters
  • From: Leona Leal Educator
• RE: same error
  • From: Duane Hookom
• Re: Need to find latest date in a query
  • From: Jeff Boyce
• RE: make query to return a subset only if not in another subset
  • From: KARL DEWEY
• Need to find latest date in a query
  • From: DPCpresto via AccessMonster.com
• find all 5 fields with Max date
  • From: Mitchell_Collen via AccessMonster.com
• Re: Time/Date problem
  • From: Georgie via AccessMonster.com
• same error
  • From: ken957
• Re: Time/Date problem
  • From: Bob Barrows [MVP]
• Re: Time/Date problem
  • From: Georgie via AccessMonster.com
• Re: Time/Date problem
  • From: Bob Barrows [MVP]
• Re: Time/Date problem
  • From: Georgie
• Re: Time/Date problem
  • From: Bob Barrows [MVP]
• RE: Eliminate 0 value in crosstab
  • From: KARL DEWEY
• Re: Time/Date problem
  • From: Georgie
• RE: Syntax for If then Conditional Statement
  • From: Melissa
• RE: Eliminate 0 value in crosstab
  • From: Rbirdie
• RE: Time/Date problem
  • From: KARL DEWEY
• Re: Totals Query
  • From: John Spencer
• Re: Removing text from a field, leaving a number
  • From: PK
• Re: Different results in SQL and Access
  • From: Bob Barrows [MVP]
• Re: Time/Date problem
  • From: Bob Barrows [MVP]
• RE: Time/Date problem
  • From: Georgie
• Re: Removing text from a field, leaving a number
  • From: Michel Walsh
• Re: Date Format
  • From: Bob Barrows [MVP]
• Re: Totals Query
  • From: Michel Walsh
• Re: Query as data source for form
  • From: Jeff Boyce
• Re: Make table query combining records of two tables into a third tabl
  • From: Michel Walsh
• Make table query combining records of two tables into a third tabl
  • From: carl jordan
• RE: Joined table: Returns duplicated record
  • From: Duane Hookom
• Time/Date problem
  • From: Georgie
• Re: Syntax for If then Conditional Statement
  • From: Marshall Barton
• Re: top N per employee
  • From: raskew via AccessMonster.com
• RE: Joined table: Returns duplicated record
  • From: KC_Cheer_Coach
• Re: Continuous Form Loading Problem
  • From: sexton75 via AccessMonster.com
• Re: Date Format
  • From: Jeff Boyce
• Re: updating a field with a count
  • From: John Spencer
• Re: DAO parameter length
  • From: Bob Barrows [MVP]
• Re: Continuous Form Loading Problem
  • From: Wolfgang Kais
• Re: Access Query: get first date field
  • From: Rob Parker
• Access Query: get first date field
  • From: tonyrulesyall
• Re: Query as data source for form
  • From: News Boy
• Re: if statements in queries
  • From: Ken Snell \(MVP\)
• Re: updating a field with a count
  • From: bhicks11 via AccessMonster.com
• Continuous Form Loading Problem
  • From: sexton75 via AccessMonster.com
• Re: if statements in queries
  • From: sandpking
• Re: Copying data from one table to another
  • From: sexton75 via AccessMonster.com
• Re: analyze a queries with excel
  • From: pietlinden@xxxxxxxxxxx
• RE: Training schedule -need qry to return all employees for that month
  • From: KARL DEWEY
• Re: Please need help with query
  • From: fredg
• Re: Access 2003 INNER JOIN
  • From: KC_Cheer_Coach
• Training schedule -need qry to return all employees for that month
  • From: fossy
• Re: Date Groups
  • From: Michel Walsh
• Re: Please need help with query
  • From: fredg
• Re: parameter query
  • From: Michel Walsh
• Re: Easy query criteria question
  • From: Marshall Barton
• Re: Counting in a Query
  • From: Marshall Barton
• Re: calculating currency formatted fields
  • From: John Spencer
• Re: calculating currency formatted fields
  • From: John Spencer
• Re: Easy query criteria question
  • From: John Spencer
• Re: Counting in a Query
  • From: John Spencer
• Re: Nested SQL Statements causing slowness and errors
  • From: Joel Maxuel
• Easy query criteria question
  • From: Bongard
• Counting in a Query
  • From: Susan L
• Re: parameter query
  • From: jlute
• RE: Query with IF statements and lookups
  • From: KARL DEWEY
• Re: parameter query
  • From: Allen Browne
• Re: Nested SQL Statements causing slowness and errors
  • From: jlute
• Re: Average multiple colums
  • From: John Spencer
• Re: Copying data from one table to another
  • From: Jeff Boyce
• Re: parameter query
  • From: Michel Walsh
• Copying data from one table to another
  • From: sexton75 via AccessMonster.com
• Re: Remove numbers from beginning of social security number
  • From: John Spencer
• Re: parameter query
  • From: Allen Browne
• Re: Nested SQL Statements causing slowness and errors
  • From: jlute
• Re: Remove numbers from beginning of social security number
  • From: Ron2006
• Re: Update query problem
  • From: John Spencer
• parameter query
  • From: jlute
• Re: Different results in SQL and Access
  • From: BruceM
• Re: Why do queries automaticly rearange columns?
  • From: Michel Walsh
• Re: Different results in SQL and Access
  • From: Bob Barrows [MVP]
• Re: SELECT DISTINCT query is not deduplicating
  • From: Michel Walsh
• RE: tough one regarding adding two columns :)
  • From: Accessghostrider via AccessMonster.com
• RE: tough one regarding adding two columns :)
  • From: Accessghostrider via AccessMonster.com
• RE: tough one regarding adding two columns :)
  • From: scubadiver
• RE: tough one regarding adding two columns :)
  • From: Accessghostrider via AccessMonster.com
• Re: Update query problem
  • From: bhicks11 via AccessMonster.com
• RE: tough one regarding adding two columns :)
  • From: Accessghostrider via AccessMonster.com
• Re: Different results in SQL and Access
  • From: BruceM
• RE: SELECT DISTINCT query is not deduplicating
  • From: scubadiver
• Re: Update Query for Current Record Only
  • From: Ron2006
• Re: DAO parameter length
  • From: John Spencer
• Re: Parameter Query Problem
  • From: MGFoster
• tough one regarding adding two columns :)
  • From: Accessghostrider via AccessMonster.com
• tough one regarding adding two columns :)
  • From: Accessghostrider via AccessMonster.com
• tough one regarding adding two columns :)
  • From: Accessghostrider via AccessMonster.com
• SELECT DISTINCT query is not deduplicating
  • From: shannonsider
• Re: IS this DLOOKUP possible within a query?
  • From: Stu
• Re: IS this DLOOKUP possible within a query?
  • From: Allen Browne
• Re: IS this DLOOKUP possible within a query?
  • From: Stu
• Re: Set default value to 0 with ALTER TABLE
  • From: Allen Browne
• Re: IS this DLOOKUP possible within a query?
  • From: Allen Browne
• IS this DLOOKUP possible within a query?
  • From: Stu
• Re: Average multiple colums
  • From: pietlinden@xxxxxxxxxxx
• Re: Date Format
  • From: Bob Barrows [MVP]
• Re: Different results in SQL and Access
  • From: Bob Barrows [MVP]
• RE: Can't access design view
  • From: Chris O'C via AccessMonster.com
• RE: Ranking customer service metrics - Query issue
  • From: Nicholas Scarpinato
• Re: Can't access design view
  • From: Chris O'C via AccessMonster.com
• Re: Ranking customer service metrics - Query issue
  • From: raskew via AccessMonster.com
• RE: Ranking customer service metrics - Query issue
  • From: KARL DEWEY
• Re: Operation must use an updateable query.
  • From: Skip
• Re: Average multiple colums
  • From: John Spencer
• RE: Can't access design view
  • From: Klatuu
• Average multiple colums
  • From: esoller
• Re: SubQuery Syntax
  • From: Jerry Whittle
• Re: SubQuery Syntax
  • From: Michel Walsh
• Re: SubQuery Syntax
  • From: john . bartlett
• Re: SubQuery Syntax
  • From: john . bartlett
• Re: Can't access design view
  • From: Chris O'C via AccessMonster.com
• RE: Can't access design view
  • From: Don
• Re: Not-in Query
  • From: SDMFG
• Re: SubQuery Syntax
  • From: Michel Walsh
• Re: Not-in Query
  • From: Michel Walsh
• Re: Different results in SQL and Access
  • From: Michel Walsh
• Re: Mutiple Tables Duplicate Field Query
  • From: DaveAP
• Re: Mutiple Tables Duplicate Field Query
  • From: John Spencer
• Re: Update Query for Current Record Only
  • From: Ron2006
• Re: Is there a way to do a not INNER JOIN?
  • From: John Spencer
• SubQuery Syntax
  • From: john . bartlett
• Re: Is there a way to do a not INNER JOIN?
  • From: John Spencer
• Re: Mutiple Tables Duplicate Field Query
  • From: Jeff Boyce
• Re: Any execution sequence in Access?
  • From: Luting
• RE: Calculated Field
  • From: OldGuy
• Re: Access 2003 INNER JOIN
  • From: Jeff Boyce
• Re: Different results in SQL and Access
  • From: BruceM
• Re: UPDATE TOP value
  • From: john . bartlett
• Re: Not-in Query
  • From: Michel Walsh
• Re: Datediff question
  • From: Klatuu
• Re: Different results in SQL and Access
  • From: Bob Barrows [MVP]
• Re: Datediff question
  • From: Bob Barrows [MVP]
• Re: Different results in SQL and Access
  • From: BruceM
• RE: Calculated Field
  • From: KARL DEWEY
• Re: Old form references in MSysQueries and MSysObjects
  • From: Allen Browne
• RE: Calculated Field
  • From: Klatuu
• Re: Query as data source for form
  • From: Jeff Boyce
• Changing Criteria in Access Queries
  • From: dlunn01
• One Field from Form to Populate Two Tables
  • From: Vylent Fyre
• Re: Datediff question
  • From: Klatuu
• Re: SQL Syntax Error
  • From: DS
• Re: SQL Syntax Error
  • From: DS
• Re: SQL Syntax Error
  • From: DS
• Re: How to make update a field of a table
  • From: Marshall Barton
• Re: Datediff question
  • From: Bob Barrows [MVP]
• modify crosstab query to fiscal qtrs rather than calandar qtrs
  • From: Lisacu
• Re: Export crosstab query to Excel: Decimal problem
  • From: Song Su
• Re: Update query help
  • From: Neal Ostrander
• Is there a way to do a not INNER JOIN?
  • From: magickarle
• Re: Update Query for Current Record Only
  • From: Ron2006
• Re: SQL Syntax Error
  • From: Allen Browne
• Re: SQL Syntax Error
  • From: Bob Barrows [MVP]
• Re: SQL Syntax Error
  • From: Michel Walsh
• Calculated Field
  • From: OldGuy
• Re: Different results in SQL and Access
  • From: Bob Barrows [MVP]
• SQL Syntax Error
  • From: DS
• Re: Export crosstab query to Excel: Decimal problem
  • From: John Spencer
• Re: Write a query to retain records based on certain criteria‏
  • From: John Spencer
• Re: Different results in SQL and Access
  • From: BruceM
• Re: Paste errors when copying column name in a group by function
  • From: bhicks11 via AccessMonster.com
• Re: Different results in SQL and Access
  • From: Bob Barrows [MVP]
• Re: Operation must use an updateable query.
  • From: Bob Barrows [MVP]
• Operation must use an updateable query.
  • From: Sanju
• Re: How do I set Reverse Joins in Access 2007?
  • From: Allen Browne
• Re: Update Query for Current Record Only
  • From: Adrian
• How to make update a field of a table
  • From: David Bowen
• Re: Export crosstab query to Excel: Decimal problem
  • From: Song Su
• Re: Running Sum in a Query
  • From: NEWER USER
• Re: Running Sum in a Query
  • From: Allen Browne
• Re: Update query help
  • From: Allen Browne
• Re: Linked SQL query performance after upgrade 97 to 2003
  • From: Tony Toews [MVP]
• Re: Addition/Subtraction
  • From: Allen Browne
• Re: UPDATE query - Macros??? Visual Basic??? SQL??? Help!
  • From: John Spencer
• Re: UPDATE TOP value
  • From: John W . Vinson
• Re: UPDATE TOP value
  • From: John Spencer
• Re: Crosstab Query: Column Headings Replicating Fields!
  • From: John Spencer
• Re: Write a query to retain records based on certain criteria‏
  • From: Jean
• Re: Query as data source for form
  • From: News Boy
• Re: Full text not showing in report
  • From: fredg
• Full text not showing in report
  • From: Brandon Baum
• Re: Update Query for Current Record Only
  • From: fredg
• Re: Update Query for Current Record Only
  • From: bhicks11 via AccessMonster.com
• Re: Multiple queries vs. one query
  • From: shannaj via AccessMonster.com
• Re: UPDATE TOP value
  • From: john . bartlett
• Re: Crosstab Query: Column Headings Replicating Fields!
  • From: raskew via AccessMonster.com
• RE: run-time error 1004
  • From: Golfinray
• Re: Multiple queries vs. one query
  • From: shannaj via AccessMonster.com
• Re: Crosstab Query: Column Headings Replicating Fields!
  • From: Kath
• RE: run-time error 1004
  • From: Larue
• RE: run-time error 1004
  • From: Golfinray
• Re: UPDATE TOP value
  • From: john . bartlett
• Re: Export crosstab query to Excel: Decimal problem
  • From: John Spencer
• Re: UPDATE TOP value
  • From: John Spencer
• RE: Find the first value in a crosstab query
  • From: John
• Re: Export crosstab query to Excel: Decimal problem
  • From: Song Su
• UPDATE TOP value
  • From: john . bartlett
• Re: Access 2003 INNER JOIN
  • From: KC_Cheer_Coach
• Re: Access 2003 INNER JOIN
  • From: Jeff Boyce
• Re: Crosstab Query: Column Headings Replicating Fields!
  • From: John Spencer
• Re: Union Queries - Parameter Value Prompt
  • From: John Spencer
• Crosstab Query: Column Headings Replicating Fields!
  • From: Kath
• Access 2003 INNER JOIN
  • From: KC_Cheer_Coach
• RE: Find the first value in a crosstab query
  • From: KARL DEWEY
• Re: Export crosstab query to Excel: Row hight and Decimal
  • From: John Spencer
• Re: Query as data source for form
  • From: Jeff Boyce
• Re: Query to create new table format
  • From: Jeff Boyce
• Re: Combine crosstab with other query info
  • From: KARL DEWEY
• Re: Crosstab Query: Column Headings!
  • From: J_Goddard via AccessMonster.com
• Re: Multiple queries vs. one query
  • From: Allen Browne
• Re: Can I use a drop-down list from a table as source 4 a parameter qu
  • From: Jeff Boyce
• Re: Input and return multiple values from a query
  • From: Bob Barrows [MVP]
• Re: How to make update a field of a table
  • From: Marshall Barton
• Multiple queries vs. one query
  • From: shannaj via AccessMonster.com
• Re: Crosstab Query: Column Headings!
  • From: Bob Barrows [MVP]
• Export crosstab query to Excel: Row hight and Decimal
  • From: Song Su
• Re: Combine crosstab with other query info
  • From: LadyIlsebet
• Re: Date Format
  • From: Jeff Boyce
• RE: Find the first value in a crosstab query
  • From: John
• How to make update a field of a table
  • From: David Bowen
• Can I use a drop-down list from a table as source 4 a parameter qu
  • From: venajoe
• Re: Date and Time Problems
  • From: Allen Browne
• Re: whitespace at end of data
  • From: John Spencer
• Re: Date and Time Problems
  • From: John Spencer
• RE: whitespace at end of data
  • From: Golfinray
• Re: whitespace at end of data
  • From: bhicks11 via AccessMonster.com
• Re: whitespace at end of data
  • From: banem2
• Re: Update - fill blank fields based on match
  • From: John Spencer
• Re: Date and Time Problems
  • From: Allen Browne
• Re: Using wildcards in iif in expression builder
  • From: Allen Browne
• Re: Using wildcards in iif in expression builder
  • From: filip
• Re: Using wildcards in iif in expression builder
  • From: Allen Browne
• Re: Query to create new table format
  • From: poalman
• Re: Insufficient Memory after XP memory upgrade.
  • From: Michael Shergold
• Re: Insufficient Memory after XP memory upgrade.
  • From: Michael Shergold
• Re: check while appending data
  • From: Ramesh
• Re: Update - fill blank fields based on match
  • From: Allen Browne
• Re: Update - fill blank fields based on match
  • From: John
• Re: Update - fill blank fields based on match
  • From: John
• Re: Update - fill blank fields based on match
  • From: Allen Browne
• Re: if statements in queries
  • From: bhicks11 via AccessMonster.com
• Re: if statements in queries
  • From: Ken Snell \(MVP\)
• Re: more than 3000 letters in a row
  • From: John W . Vinson
• Re: Query as data source for form
  • From: News Boy
• Re: Query as data source for form
  • From: Jeff Boyce
• RE: Form queries
  • From: dksj67 via AccessMonster.com
• RE: Group same records in one field and Total in another
  • From: htherjo
• RE: Find the first value in a crosstab query
  • From: KARL DEWEY
• Query as data source for form
  • From: News Boy
• RE: Group same records in one field and Total in another
  • From: Ken Sheridan
• RE: Find the first value in a crosstab query
  • From: John
• RE: Find the first value in a crosstab query
  • From: KARL DEWEY
• RE: Simple Append Query not Working. I do not have a clue why.
  • From: Jerry Whittle
• Form queries
  • From: dksj67 via AccessMonster.com
• RE: Find the first value in a crosstab query
  • From: John
• Re: counter value
  • From: Michel Walsh
• Re: Any execution sequence in Access?
  • From: Michel Walsh
• Re: Any execution sequence in Access?
  • From: Marshall Barton
• Re: Any execution sequence in Access?
  • From: Bob Barrows [MVP]
• RE: Simple Append Query not Working. I do not have a clue why.
  • From: Fredrik
• Re: Any execution sequence in Access?
  • From: Bob Barrows [MVP]
• RE: Simple Append Query not Working. I do not have a clue why.
  • From: KARL DEWEY
• RE: Simple Append Query not Working. I do not have a clue why.
  • From: Fredrik
• Re: Any execution sequence in Access?
  • From: Klatuu
• Re: if statements in queries
  • From: sandpking
• Re: if statements in queries
  • From: bhicks11 via AccessMonster.com
• Re: Insufficient Memory after XP memory upgrade.
  • From: Bob Barrows [MVP]
• RE: Simple Append Query not Working. I do not have a clue why.
  • From: Jerry Whittle
• Re: Insufficient Memory after XP memory upgrade.
  • From: Bob Barrows [MVP]
• Re: if statements in queries
  • From: sandpking
• Re: Any execution sequence in Access?
  • From: Luting
• RE: Simple Append Query not Working. I do not have a clue why.
  • From: Fredrik
• Insufficient Memory after XP memory upgrade.
  • From: Michael Shergold
• Re: Any execution sequence in Access?
  • From: Bob Barrows [MVP]
• Any execution sequence in Access?
  • From: Luting
• RE: Find the first value in a crosstab query
  • From: KARL DEWEY
• Re: Splitting values in a field based on a space
  • From: John W . Vinson
• Re: I am trying to exclude pulling statuses into my query
  • From: Michel Walsh
• Re: I am trying to exclude pulling statuses into my query
  • From: John Spencer
• RE: Find the first value in a crosstab query
  • From: John
• Re: Access 2003 Currency Formatting
  • From: KC_Cheer_Coach
• Re: Access 2003 Currency Formatting
  • From: KC_Cheer_Coach
• Re: Query to create new table format
  • From: John Spencer
• Re: Parameter Query Problem
  • From: CollegeTry
• Re: Access 2003 Currency Formatting
  • From: John Spencer
• Re: Extracting part of a text value
  • From: John Spencer
• Re: Access 2003 Currency Formatting
  • From: fredg
• Re: Complicated update
  • From: Michel Walsh
• Re: Summarize dates for like records
  • From: Jeff Boyce
• Re: Query to create new table format
  • From: Jeff Boyce
• Query to create new table format
  • From: poalman
• Re: if statements in queries
  • From: bhicks11 via AccessMonster.com
• Re: if statements in queries
  • From: sandpking
• Re: Extracting part of a text value
  • From: raskew via AccessMonster.com
• Re: if statements in queries
  • From: sandpking
• Access 2003 Currency Formatting
  • From: KC_Cheer_Coach
• RE: User Friendly Search
  • From: KARL DEWEY
• Re: Complicated update
  • From: Ashers
• Re: Summarising a large number of queries
  • From: John Spencer
• Re: Date Format
  • From: Jeff Boyce
• Re: Date Format
  • From: Bob Barrows [MVP]
• Re: Date Format
  • From: raskew via AccessMonster.com
• Re: Date Format
  • From: Bob Barrows [MVP]
• Re: Date Format
  • From: raskew via AccessMonster.com
• Re: Complicated update
  • From: Michel Walsh
• Re: Date Format
  • From: Bob Barrows [MVP]
• Re: Date Format
  • From: Bob Barrows [MVP]
• Re: Date Format
  • From: Allen Browne
• RE: Query Help
  • From: Renetta
• RE: Summarising a large number of queries
  • From: scubadiver
• Re: check while appending data
  • From: Ron2006
• Re: HELP?!
  • From: Ron2006
• Re: Parameter Query Problem
  • From: John Spencer
• Re: Top N Records on multiple fields
  • From: Anthony
• Re: Always Round Down
  • From: Allen Browne
• RE: Query Help
  • From: bhicks11 via AccessMonster.com
• Re: Update Query question
  • From: Duane Hookom
• Re: Update Query question
  • From: Stephen Rockower
• RE: Query Help
  • From: Renetta
• Re: Query Help
  • From: Renetta
• RE: Query Help
  • From: bhicks11 via AccessMonster.com
• RE: Query Help
  • From: Renetta
• Update Query question
  • From: Stephen Rockower
• Re: How to create a calculated column in table
  • From: Marshall Barton
• Re: Query Help
  • From: bhicks11 via AccessMonster.com
• Re: Query Help
  • From: Renetta
• Re: Query Help
  • From: bhicks11 via AccessMonster.com
• Re: date ranges
  • From: Bob Barrows [MVP]
• Re: date ranges
  • From: Bob Barrows [MVP]
• Query Help
  • From: Renetta
• Re: date ranges
  • From: Bob Barrows [MVP]
• Re: date ranges
  • From: Bob Barrows [MVP]
• Re: date ranges
  • From: Bob Barrows [MVP]
• Re: date ranges
  • From: Bob Barrows [MVP]
• Re: Merging First and Last Name fields
  • From: Allen Browne
• Re: Extracting the week number from a date
  • From: bhicks11 via AccessMonster.com
• User Friendly Search
  • From: Jeff @ CI
• Re: Extracting the week number from a date
  • From: bhicks11 via AccessMonster.com
• Re: Remove zero from first letter
  • From: John Spencer
• Re: Remove zero from first letter
  • From: raskew via AccessMonster.com
• Re: Linked SQL query performance after upgrade 97 to 2003
  • From: Rick Brandt
• Re: check while appending data
  • From: bhicks11 via AccessMonster.com
• RE: Access 2003 BE with VB2005.net FE
  • From: johnb
• Re: Merging fields in the Query
  • From: Haas
• Re: Merging First and Last Name fields
  • From: Allen Browne
• check while appending data
  • From: Ramesh
• Re: if statements in queries
  • From: Ken Snell \(MVP\)
• Re: if statements in queries
  • From: bhicks11 via AccessMonster.com
• if statements in queries
  • From: sandpking
• Re: Remove zero from first letter
  • From: raskew via AccessMonster.com
• RE: Splitting values in a field based on a space
  • From: S.Clark
• RE: Access 2003 BE with VB2005.net FE
  • From: S.Clark
• Re: Database BEAST
  • From: KC_Cheer_Coach
• Re: Merging fields in the Query
  • From: Bob Barrows [MVP]
• Re: Merging fields in the Query
  • From: Haas
• Re: Database BEAST
  • From: KC_Cheer_Coach
• Re: Repeating rows with same data
  • From: rama
• Re: Can I convert numbers stored as text back to numbers in MS Acc
  • From: Jerry Whittle
• Re: Merging fields in the Query
  • From: Haas
• Re: Write a query to retain records based on certain criteria‏
  • From: Jean
• Re: HELP?!
  • From: Ron2006
• Re: HELP?!
  • From: J_Goddard via AccessMonster.com
• Re: Remove zero from first letter
  • From: Ranjit kurian
• Re: Database BEAST
  • From: John Spencer
• Re: Database BEAST
  • From: Bob Barrows [MVP]
• Re: Can I convert numbers stored as text back to numbers in MS Acc
  • From: zofficedepot
• Re: Can I convert numbers stored as text back to numbers in MS Acc
  • From: zofficedepot
• Re: Remove zero from first letter
  • From: Bob Barrows [MVP]
• Re: Remove zero from first letter
  • From: Bob Barrows [MVP]
• Re: Remove zero from first letter
  • From: Ranjit kurian
• RE: Access 2003 BE with VB2005.net FE
  • From: johnb
• Re: Merging fields in the Query
  • From: Allen Browne
• Re: Please tell me this is possible.
  • From: Lori
• RE: Access 2003 BE with VB2005.net FE
  • From: S.Clark
• Re: Can I convert numbers stored as text back to numbers in MS Access
  • From: fredg
• Re: Please tell me this is possible.
  • From: John Spencer
• RE: Access 2003 BE with VB2005.net FE
  • From: johnb
• Re: Merging fields in the Query
  • From: Haas
• Re: QUERY - AND/OR for search panel
  • From: BlueWolverine
• Re: Nested IIf Headache
  • From: Michel Walsh
• Nested IIf Headache
  • From: David Mulholland
• Re: Compare date to previous date to see if 6 weeks have past
  • From: John Spencer
• Re: Access a subform in a query
  • From: John Spencer
• Re: Linked SQL query performance after upgrade 97 to 2003
  • From: david
• Re: Union Queries - Record Formatting
  • From: Allen Browne
• Re: Access a subform in a query
  • From: Larry Daugherty
• RE: single purchase order with multiple invoices
  • From: Duane Hookom
• Re: Help exporting URL format to Excel from Access Query
  • From: pietlinden@xxxxxxxxxxx
• Re: Temp Variable for Criteria in Query Design
  • From: zofficedepot
• Re: Showing records with one or more null fields
  • From: John Spencer
• Re: Please tell me this is possible.
  • From: cleech
• Re: Repeating rows with same data
  • From: Bob Barrows [MVP]
• Re: Summary query sum from different tables
  • From: BAC
• Temp Variable for Criteria in Query Design
  • From: Chris F via AccessMonster.com
• Re: Parse Address Field
  • From: Dale_Fye via AccessMonster.com
• Repeating rows with same data
  • From: rama
• Re: Summary query sum from different tables
  • From: Bob Barrows [MVP]
• Re: Sorry! Parameter query / Again
  • From: John W . Vinson
• Re: Summary query sum from different tables
  • From: Michel Walsh
• Re: Summary query sum from different tables
  • From: Bob Barrows [MVP]
• Re: Summary query sum from different tables
  • From: Bob Barrows [MVP]
• Re: Summary query sum from different tables
  • From: BAC
• Re: Summary query sum from different tables
  • From: Bob Barrows [MVP]
• Re: Summary query sum from different tables
  • From: Bob Barrows [MVP]
• Re: plus sign applied as &
  • From: zofficedepot
• Re: Summary query sum from different tables
  • From: BAC
• Re: Modified Access query does not respect ORDER!
  • From: Rick Brandt
• Re: Number of Tables in a Access Database File
  • From: Marshall Barton
• Re: plus sign applied as &
  • From: Marshall Barton
• Re: Top N Records on multiple fields
  • From: Michel Walsh
• Number of Tables in a Access Database File
  • From: Akash
• Re: Summary query sum from different tables
  • From: Michel Walsh
• Re: All records in a List_Table as the criteria for query of a Main_Ta
  • From: Marshall Barton
• Re: Summary query sum from different tables
  • From: BAC
• Re: plus sign applied as &
  • From: zofficedepot
• Parse Address Field
  • From: Lisa W.
• RE: Query results with #Error
  • From: Duane Hookom
• All records in a List_Table as the criteria for query of a Main_Ta
  • From: PXK
• Re: Modified Access query does not respect ORDER!
  • From: zofficedepot
• RE: Linked SQL query performance after upgrade 97 to 2003
  • From: S.Clark
• RE: Include empty values in crosstab query
  • From: S.Clark
• Re: Top N Records on multiple fields
  • From: Anthony
• RE: date time range criteria
  • From: Jerry Whittle
• Re: Summary query sum from different tables
  • From: Michel Walsh
• Re: Trouble with Criteria
  • From: Bob Barrows [MVP]
• Re: date time range criteria
  • From: inungh
• Re: Update query for null values in multiple lines
  • From: Armen Stein
• Re: Make-Table Destination Table Name
  • From: Michel Walsh
• Re: Trouble with Criteria
  • From: Scott Reed via AccessMonster.com
• date time range criteria
  • From: inungh
• Re: Field >0
  • From: DS
• Re: Trouble with Criteria
  • From: Bob Barrows [MVP]
• Re: Trouble with Criteria
  • From: Scott Reed via AccessMonster.com
• Re: Trouble with Criteria
  • From: Scott Reed via AccessMonster.com
• Re: Trouble with Criteria
  • From: Scott Reed via AccessMonster.com
• Re: Field >0
  • From: Bob Barrows [MVP]
• Re: Trouble with Criteria
  • From: raskew via AccessMonster.com
• Criteria Problem
  • From: Irons
• Trouble with Criteria
  • From: Scott Reed via AccessMonster.com
• Summary query sum from different tables
  • From: BAC
• Field >0
  • From: DS
• RE: Multiple columns of data on the same report based on different dat
  • From: S.Clark
• RE: Include empty values in crosstab query
  • From: Jerry Whittle
• Re: Sub-Query Problem
  • From: DS
• Re: Top N Records on multiple fields
  • From: Michel Walsh
• Re: Date comparisons in query
  • From: John Spencer
• jordan shoes supplier paypal payment $28/pairs cnbbiz2008@hotmail.com ( http://photo.163.com/photos/huayuexiehang/118447112/ )
  • From: cnbbiz039
• Re: how to select rows by id and date?
  • From: Bob Barrows [MVP]
• Re: Merging fields in the Query
  • From: Allen Browne
• Re: Merging fields in the Query
  • From: Allen Browne
• Re: Top N Records on multiple fields
  • From: Anthony
• Date comparisons in query
  • From: DPCpresto via AccessMonster.com
• Re: Where 2 columns match, select highest sequence number?
  • From: Allen Browne
• Re: Append Query - Key violation
  • From: louisjohnphillips
• Re: plus sign applied as &
  • From: Marshall Barton
• Re: Parameterizing a SELECT TOP x statement
  • From: John Spencer
• plus sign applied as &
  • From: zofficedepot
• Re: Modified Access query does not respect ORDER!
  • From: Rick Brandt
• Re: Modified Access query does not respect ORDER!
  • From: zofficedepot
• Re: Crosstab Union query
  • From: ragtopcaddy via AccessMonster.com
• Re: Date Range for Query
  • From: Marshall Barton
• Re: Date Range for Query
  • From: pietlinden@xxxxxxxxxxx
• Re: Query for First date in group
  • From: mikebres
• Re: Modified Access query does not respect ORDER!
  • From: pietlinden@xxxxxxxxxxx
• Re: Crosstab Union query
  • From: Bob Barrows [MVP]
• Re: Query for First date in group
  • From: John Spencer
• Modified Access query does not respect ORDER!
  • From: zofficedepot
• Re: Crosstab Union query
  • From: John Spencer
• Re: Crosstab Union query
  • From: ragtopcaddy via AccessMonster.com
• Re: Top N Records on multiple fields
  • From: Michel Walsh
• Re: Compare date to previous date to see if 6 weeks have past
  • From: Bob Barrows [MVP]
• Re: Compare date to previous date to see if 6 weeks have past
  • From: DougNWa
• Re: Compare date to previous date to see if 6 weeks have past
  • From: Bob Barrows [MVP]
• RE: Crosstab Query Question
  • From: KARL DEWEY
• Re: Reports or Queries
  • From: Ron2006
• Re: Compare date to previous date to see if 6 weeks have past
  • From: DougNWa
• RE: Crosstab Query Question
  • From: KARL DEWEY
• Re: Compare date to previous date to see if 6 weeks have past
  • From: DougNWa
• Re: Crosstab Union query
  • From: Bob Barrows [MVP]
• Crosstab Union query
  • From: ragtopcaddy via AccessMonster.com
• Re: Group by, Then Count, Then write out results
  • From: Mel via AccessMonster.com
• Re: Remove zero from first letter
  • From: Bob Barrows [MVP]
• Re: Remove zero from first letter
  • From: Bob Barrows [MVP]
• Re: Query for Obtaining Detail Records
  • From: John Spencer
• Re: Remove zero from first letter
  • From: John Spencer
• Re: Changing CAPS to Lowercase
  • From: John Spencer
• RE: Crosstab Query Question
  • From: DLIP
• Re: Group by, Then Count, Then write out results
  • From: Bob Barrows [MVP]
• Re: Parameter in Crosstab Query
  • From: ryguy7272
• Re: Totaling Groups
  • From: Rob
• Group by, Then Count, Then write out results
  • From: Mel via AccessMonster.com
• Re: Sub-Query Problem
  • From: Bob Barrows [MVP]
• Re: Top N Records on multiple fields
  • From: Anthony
• RE: connecting fields in mulitple tables
  • From: Klatuu
• Re: Sub-Query Problem
  • From: DS
• RE: Joining tables based on strings contained within field
  • From: Jerry Whittle
• Re: Parameter in Crosstab Query
  • From: Allen Browne
• RE: connecting fields in mulitple tables
  • From: buscher75
• Re: Update to Upper Case
  • From: Student Databaser
• Re: Parameter in Crosstab Query
  • From: ryguy7272
• Re: Totaling Groups
  • From: Bob Barrows [MVP]
• RE: connecting fields in mulitple tables
  • From: Klatuu
• RE: Joining tables based on strings contained within field
  • From: chatshah
• Re: Parameter in Crosstab Query
  • From: Allen Browne
• Re: SubSelect in A97
  • From: Bob Barrows [MVP]
• RE: Query for Obtaining Detail Records
  • From: Klatuu
• RE: Query for Obtaining Detail Records
  • From: JWeaver
• RE: Remove zero from first letter
  • From: Ranjit kurian
• RE: Query for Obtaining Detail Records
  • From: Klatuu
• Re: SubSelect in A97
  • From: Kahuna
• RE: Remove zero from first letter
  • From: Klatuu
• Re: SubSelect in A97
  • From: Bob Barrows [MVP]
• Re: SubSelect in A97
  • From: Kahuna
• Re: Update to Upper Case
  • From: Bob Barrows [MVP]
• Re: SubSelect in A97
  • From: Bob Barrows [MVP]
• Re: Changing CAPS to Lowercase
  • From: raskew via AccessMonster.com
• RE: Average Days between several dates in a query
  • From: Jeff G
• Re: more than 3000 letters in a row
  • From: Ranjit kurian
• Re: more than 3000 letters in a row
  • From: Bob Barrows [MVP]
• Re: Sub-Query Problem
  • From: Bob Barrows [MVP]
• Re: Change Format of Date Field
  • From: Bob Barrows [MVP]
• Re: more than 3000 letters in a row
  • From: Ranjit kurian
• Re: Sub-Query Problem
  • From: Bob Barrows [MVP]
• Re: Sub-Query Problem
  • From: DS
• Access crashes on query parsing NMEA (GPS) data
  • From: J.T. van der Wal
• Re: SubSelect in A97
  • From: Kahuna
• Re: Sub-Query Problem
  • From: DS
• Re: Change Format of Date Field
  • From: John Spencer
• Re: Change Format of Date Field
  • From: Jim
• Re: Change Format of Date Field
  • From: Bob Barrows [MVP]
• Re: Inserting blank columns into query
  • From: John Spencer
• Re: SubSelect in A97
  • From: Bob Barrows [MVP]
• Re: Sub-Query Problem
  • From: Bob Barrows [MVP]
• Re: If conditions
  • From: John Spencer
• Re: more than 3000 letters in a row
  • From: Bob Barrows [MVP]
• Re: Inserting blank columns into query
  • From: Bob Barrows [MVP]
• Re: Inserting blank columns into query
  • From: John Spencer
• SubSelect in A97
  • From: Kahuna
• Sub-Query Problem
  • From: DS
• Re: more than 3000 letters in a row
  • From: Ranjit kurian
• If conditions
  • From: Scott
• Re: Inserting blank columns into query
  • From: Bob Barrows [MVP]
• Re: Merging date fields with "if" condition
  • From: Bob Barrows [MVP]
• Re: more than 3000 letters in a row
  • From: Douglas J. Steele
• Re: concatenate question
  • From: John W . Vinson
• Re: concatenate question
  • From: louisjohnphillips
• Re: access to microsoft.* news
  • From: Douglas J. Steele
• Re: access to microsoft.* news
  • From: fredg
• access to microsoft.* news
  • From: MangroveRoot
• Re: Query not updateable
  • From: John W . Vinson
• RE: Query not updateable
  • From: Todd
• RE: " is not a valid name
  • From: Stuart Bratesman
• Re: Phantom Queries
  • From: Jeff Boyce
• Re: Parameterizing a SELECT TOP x statement
  • From: John Spencer
• Re: union crosstab query
  • From: John Spencer
• Re: Parameterizing a SELECT TOP x statement
  • From: Michel Walsh
• Re: Seniority,Rank,Employee
  • From: gbecker via AccessMonster.com
• RE: Lookup
  • From: KARL DEWEY
• Parameterizing a SELECT TOP x statement
  • From: sfleck
• Re: Average Records between date range
  • From: Michel Walsh
• Re: TOP in query user selects amount to return
  • From: Michel Walsh
• Re: Calculating median in a group by query
  • From: raskew via AccessMonster.com
• Re: update queries
  • From: KARL DEWEY
• Re: update queries
  • From: dennis . mccarthy
• Re: update queries
  • From: dennis . mccarthy
• Re: Average Records between date range
  • From: Love Buzz
• union crosstab query
  • From: inungh
• Re: Eliminating data that starts with an astericks
  • From: John Spencer
• Re: more than 3000 letters in a row
  • From: Jeff Boyce
• Re: TOP in query user selects amount to return
  • From: John Spencer
• Re: Calculating median in a group by query
  • From: Jeff Boyce
• update queries
  • From: dennis . mccarthy
• Re: Top N Records on multiple fields
  • From: CodeCrazy
• Mail Merge
  • From: Debbie
• Re: Seniority,Rank,Employee
  • From: Michel Walsh
• Re: will not accept product key supplied with computer
  • From: Michel Walsh
• Re: Top N Records on multiple fields
  • From: Michel Walsh
• Re: TOP in query user selects amount to return
  • From: Michel Walsh
• EXTRACT DATA FROM FIELD
  • From: LOUIS
• Re: Problem with recorded dates.
  • From: Allen Browne
• Re: Rank without doubling up
  • From: Duane Hookom
• Problem with recorded dates.
  • From: hotplate
• Re: acc 2007: help with multiple table outer join syntax
  • From: John Spencer
• Re: Filter criteria for a conditional serialdate field in a query
  • From: John Spencer
• Re: TOP in query user selects amount to return
  • From: John Spencer
• Re: acc 2007: help with multiple table outer join syntax
  • From: Bob Barrows [MVP]
• Re: Rank without doubling up
  • From: scubadiver
• acc 2007: help with multiple table outer join syntax
  • From: vl
• Re: Rank without doubling up
  • From: Tanya
• Re: Iif with And conditions
  • From: John Spencer
• Seniority,Rank,Employee
  • From: gbecker
• Re: IIF Statement In Query Doesn't Work Right
  • From: Daffy
• Re: Remove nonprintable characters from text in Access
  • From: louisjohnphillips
• Re: Calculating median in a group by query
  • From: Matt
• Re: Rank without doubling up
  • From: Duane Hookom
• Re: Calculating median in a group by query
  • From: Jeff Boyce
• RE: query to combine columns
  • From: KARL DEWEY
• RE: Average Days between several dates in a query
  • From: KARL DEWEY
• Re: Using Active X Calendar in query
  • From: Bob Barrows [MVP]
• Re: Using Active X Calendar in query
  • From: Douglas J. Steele
• Remove nonprintable characters from text in Access
  • From: Wendy DePalma
• Calculating median in a group by query
  • From: Matt
• Re: query to combine columns
  • From: Jeff Boyce
• Re: Append to changed
  • From: Jeff Boyce
• Re: Rank without doubling up
  • From: Tanya
• Re: Append to changed
  • From: Jennifer
• Re: Iif with And conditions
  • From: Jeff Boyce
• Re: Append to changed
  • From: Jeff Boyce
• Re: trouble with union query
  • From: Jeff Boyce
• Average Days between several dates in a query
  • From: Jeff G
• query to combine columns
  • From: deb
• Re: trouble with union query
  • From: Effie
• Re: Average Records between date range
  • From: raskew via AccessMonster.com
• Re: Rank without doubling up
  • From: Michel Walsh
• Re: Value variation function
  • From: Michel Walsh
• Re: Average Records between date range
  • From: Michel Walsh
• RE: Value variation function
  • From: Golfinray
• Re: trouble with union query
  • From: Jeff Boyce
• Re: Average Records between date range
  • From: Love Buzz
• Append Query, New Column help
  • From: Rita Brasher
• Re: distinct key word
  • From: Allen Browne
• Re: comparing records with same data in one field and different in
  • From: Kari
• distinct key word
  • From: inungh
• Re: Average Records between date range
  • From: raskew via AccessMonster.com
• Re: Rank without doubling up
  • From: scubadiver
• Re: Average Records between date range
  • From: Michel Walsh
• Re: Average Records between date range
  • From: Michel Walsh
• Re: Average Records between date range
  • From: Love Buzz
• Re: Join / Iff Question
  • From: Allen Browne
• Re: Average Records between date range
  • From: Michel Walsh
• Average Records between date range
  • From: Love Buzz
• Re: Rank without doubling up
  • From: Duane Hookom
• Re: Merging multiple records into one long record...
  • From: Joe
• Re: Rank without doubling up
  • From: Tanya
• Re: Rank without doubling up
  • From: Duane Hookom
• Re: Access query problem - Help
  • From: Phillip Mitchell
• Re: comparing records with same data in one field and different in ano
  • From: Allen Browne
• Re: Multiple Optional Criteria to Generate Query
  • From: Allen Browne
• Re: Merging multiple records into one long record...
  • From: John W . Vinson
• Re: Rank without doubling up
  • From: Tanya
• Re: Multiple Optional Criteria to Generate Query
  • From: HeatherD25
• Merging multiple records into one long record...
  • From: Joe
• Re: Multiple Optional Criteria to Generate Query
  • From: HeatherD25
• Re: There MUST be a better way - calculating intervals between 2 d
  • From: raskew via AccessMonster.com
• Re: There MUST be a better way - calculating intervals between 2 d
  • From: raskew via AccessMonster.com
• Re: There MUST be a better way - calculating intervals between 2 d
  • From: Duane Hookom
• Re: There MUST be a better way - calculating intervals between 2 dates
  • From: Bob Barrows [MVP]
• Re: Sorting out duplicates for every date
  • From: louisjohnphillips
• Re: Sorting out duplicates for every date
  • From: Fredrik
• Re: Rank without doubling up
  • From: Duane Hookom
• Re: Sorting out duplicates for every date
  • From: louisjohnphillips
• Re: Union query returns date as Text which doesn't sort correctly
  • From: raskew via AccessMonster.com
• RE: how to search & replace chr in multiple fields and records
  • From: Ken Sheridan
• Re: Rank without doubling up
  • From: louisjohnphillips
• RE: Rank without doubling up
  • From: Duane Hookom
• Re: how to search & replace chr in multiple fields and records
  • From: raskew via AccessMonster.com
• how to search & replace chr in multiple fields and records
  • From: NewbiePete
• Re: Matching Records in two Tables
  • From: John Spencer
• Re: Sorry! Parameter query / Again
  • From: John W . Vinson
• Re: Mutiple Results
  • From: Bob Barrows [MVP]
• Re: Sorry! Parameter query / Again
  • From: D
• Re: Hiding second set of records
  • From: Bob Barrows [MVP]
• Re: Cell dependent on value of other cell
  • From: Luc Ferrari
• Re: Cell dependent on value of other cell
  • From: Jeff Boyce
• Cell dependent on value of other cell
  • From: Luc Ferrari
• Re: Multiple Optional Criteria to Generate Query
  • From: Allen Browne
• Re: Sorry! Parameter query / Again
  • From: John W . Vinson
• Re: Multiple columns of data on the same report based on different
  • From: Brett
• Re: Multiple columns of data on the same report based on different
  • From: Brett
• Re: Multiple columns of data on the same report based on different
  • From: Brett
• RE: Expression for combining fields
  • From: Chuck
• Re: Parameter Query
  • From: D
• Re: Parameter Query
  • From: D
• Re: Multiple columns of data on the same report based on different
  • From: Brett
• Re: Multiple columns of data on the same report based on different
  • From: Brett
• Re: Multiple columns of data on the same report based on different dat
  • From: Brett
• Re: Query to find the most recent record for each duplicate record
  • From: John Spencer
• RE: calculated field
  • From: Lesa Havert
• Re: calculated field
  • From: Lesa Havert
• RE: calculated field
  • From: KARL DEWEY
• Re: Parameter Query
  • From: Douglas J. Steele
• RE: Sorry! Parameter query / Again
  • From: KARL DEWEY
• RE: Sorry! Parameter query / Again
  • From: D
• RE: calculated field
  • From: Lesa Havert
• Re: Multiple columns of data on the same report based on different dat
  • From: Brett
• RE: Need Query to select records based off a Quantity column.
  • From: Jerry Whittle
• RE: Multiple columns of data on the same report based on different dat
  • From: KARL DEWEY
• RE: calculated field
  • From: KARL DEWEY
• RE: Sorry! Parameter query / Again
  • From: KARL DEWEY
• Re: Sorry! Parameter query / Again
  • From: John W . Vinson
• RE: calculated field
  • From: Lesa Havert
• Re: calculated field
  • From: Lesa Havert
• Multiple columns of data on the same report based on different date parameters
  • From: Brett
• Multiple columns of data on the same report based on different date parameters
  • From: Brett
• RE: Sorry! Parameter query / Again
  • From: D
• RE: query problems
  • From: Jerry Whittle
• RE: how to do a conditional update
  • From: Klatuu
• RE: calculated field
  • From: KARL DEWEY
• RE: Need Query to select records based off a Quantity column.
  • From: KARL DEWEY
• RE: Sorry! Parameter query / Again
  • From: KARL DEWEY
• RE: calculated field
  • From: Lesa Havert
• Re: Sorry! Parameter query / Again
  • From: D
• RE: Sorry! Parameter query / Again
  • From: D
• Re: Help: Need 1 criteria to find many parts of 1 field
  • From: John W . Vinson
• RE: Sorry! Parameter query / Again
  • From: KARL DEWEY
• Re: Sorry! Parameter query / Again
  • From: Jeff Boyce
• Re: Dates
  • From: Jeff Boyce
• RE: Prompting for date range twice
  • From: KARL DEWEY
• RE: Need Query to select records based off a Quantity column.
  • From: Jerry Whittle
• RE: Crosstab Query based on 2 Combo Boxes. How?
  • From: Nathan Lars
• Re: Dates gooing backwards
  • From: Allen Browne
• Re: QUERY - AND/OR for search panel
  • From: Allen Browne
• RE: Crosstab Query based on 2 Combo Boxes. How?
  • From: KARL DEWEY
• RE: Crosstab Query based on 2 Combo Boxes. How?
  • From: Nathan Lars
• RE: Count items
  • From: Chrischik
• Sorry! Parameter query / Again
  • From: D
• Re: QUERY criteria dependent on Is null do A, not is null do B
  • From: Bob Barrows [MVP]
• Re: QUERY criteria dependent on Is null do A, not is null do B
  • From: BlueWolverine
• Re: VB programmer new to Access
  • From: Michel Walsh
• Re: QUERY criteria dependent on Is null do A, not is null do B
  • From: Bob Barrows [MVP]
• Re: QUERY criteria dependent on Is null do A, not is null do B
  • From: Bob Barrows [MVP]
• Re: protect query
  • From: SHETTY
• Re: Parameter Query
  • From: D
• Re: QUERY Criteria dependend on ISNULL or NOt
  • From: John Spencer
• Re: Need 1 criteria to find many parts of 1 field
  • From: BruceM
• Re: DSUM Function
  • From: John Spencer
• Re: QUERY criteria dependent on Is null do A, not is null do B
  • From: Bob Barrows [MVP]
• Re: report using crosstab query problem
  • From: John Spencer
• Re: Need 1 criteria to find many parts of 1 field
  • From: Bob Barrows [MVP]
• Re: Access query problem - Help
  • From: John Spencer
• Re: Query to find the most recent record for each duplicate record
  • From: Eddie Stevens
• Re: Query to find the most recent record for each duplicate record
  • From: John W . Vinson
• Query to find the most recent record for each duplicate record
  • From: Microsoft News Server
• RE: MS Access Counter
  • From: Duane Hookom
• MS Access Counter
  • From: Laura1 via AccessMonster.com
• Re: Access query problem - Help
  • From: Phillip MItchell
• RE: Crosstab Query based on 2 Combo Boxes. How?
  • From: KARL DEWEY
• Re: Parameter Query
  • From: Douglas J. Steele
• RE: Crosstab Query based on 2 Combo Boxes. How?
  • From: Nathan Lars
• RE: Crosstab Query based on 2 Combo Boxes. How?
  • From: KARL DEWEY
• Re: Subtract forecasted usage & return a date?
  • From: Brian Evans
• RE: Access 2007 syntax error
  • From: Jerry Whittle
• Subtract forecasted usage & return a date?
  • From: aero-spaces
• RE: Crosstab Query based on 2 Combo Boxes. How?
  • From: Nathan Lars
• Re: Cancel Button on Parameter Query
  • From: Jeff Boyce
• Re: calculated field
  • From: John W . Vinson
• RE: Argument Error in Union Query
  • From: Eka1618
• Re: Select id of smallest record value
  • From: Fredrated
• RE: Select id of smallest record value
  • From: Fredrated
• Re: Select id of smallest record value
  • From: Brian Evans
• RE: Argument Error in Union Query
  • From: Eka1618
• RE: Argument Error in Union Query
  • From: KARL DEWEY
• RE: Crosstab Query based on 2 Combo Boxes. How?
  • From: KARL DEWEY
• RE: Argument Error in Union Query
  • From: Eka1618
• RE: Argument Error in Union Query
  • From: KARL DEWEY
• RE: The alpha first table in an access 2003 database no longer app
  • From: jas580
• Re: Weekend Date
  • From: raskew via AccessMonster.com
• RE: Crosstab Query based on 2 Combo Boxes. How?
  • From: Nathan Lars
• Weekend Date
  • From: caloy
• Re: things aren't adding up
  • From: Jeff Boyce
• Re: Another replacing value from query question
  • From: Villagio
• Re: currentdb = nothing?
  • From: Allen Browne
• Re: subquery
  • From: John Spencer
• Re: Replace a Value in Crostab Query
  • From: cleech
• RE: Argument Error in Union Query
  • From: Eka1618
• Re: Find the proper record problem
  • From: John Spencer
• Re: Date range in query
  • From: John Spencer
• Re: Not In (sort of) query
  • From: Michel Walsh
• Re: currentdb = nothing?
  • From: Stefan Hoffmann
• Re: Find the proper record problem
  • From: Michel Walsh
• RE: Find the proper record problem
  • From: jschmuck9
• Re: Date range in query
  • From: ladybug via AccessMonster.com
• Re: Returning Blank Dates
  • From: erotisi via AccessMonster.com
• RE: Not Criteria
  • From: Dennis
• Re: Returning Blank Dates
  • From: John Spencer
• Re: Access query problem - Help
  • From: John Spencer
• RE: Rank results
  • From: scubadiver
• Re: Access query expression
  • From: Michel Walsh
• Returning Blank Dates
  • From: erotisi via AccessMonster.com
• RE: Rank results
  • From: Tanya
• Access query problem - Help
  • From: Phillip MItchell
• RE: #Error in calculated field of Datasheet view of query
  • From: DocBrown
• Re: currentdb = nothing?
  • From: Allen Browne
• Re: #Error in calculated field of Datasheet view of query
  • From: Allen Browne
• Query criteria
  • From: ineedhelp
• Re: Create new field within table and populate
  • From: John W . Vinson
• Re: currentdb = nothing?
  • From: kfguardian
• Re: Another replacing value from query question
  • From: John Spencer
• Re: currentdb = nothing?
  • From: Allen Browne
• Re: Another replacing value from query question
  • From: Villagio
• Re: Another replacing value from query question
  • From: John Spencer
• Re: Create new field within table and populate
  • From: Bob Barrows [MVP]
• Re: Create new field within table and populate
  • From: Bob Barrows [MVP]
• Re: a less complicated string?
  • From: John W . Vinson
• Re: Replace a Value in Crostab Query
  • From: Douglas J. Steele
• RE: Problem with Time portions of the day
  • From: KARL DEWEY
• Re: a less complicated string?
  • From: cleech
• Re: Access query expression
  • From: caloy
• Replace a Value in Crostab Query
  • From: cleech
• Re: Create Query to determine if employee is currently punched out
  • From: Gahbeck
• a less complicated string?
  • From: JohnLute
• Re: Query using date information
  • From: pietlinden@xxxxxxxxxxx
• Re: things aren't adding up
  • From: Jeff Boyce
• Re: one character fields name generated by crosstab query
  • From: inungh
• Re: Create Query to determine if employee is currently punched out
  • From: Michel Walsh
• Re: Access query expression
  • From: Michel Walsh
• Re: Nz or Iif?
  • From: Michel Walsh
• Re: crosstab query vs Sum(IIf([MyFiled]="D",1,0)) AS SumD
  • From: Michel Walsh
• Re: Nz or Iif?
  • From: Kristibaer
• Re: Create Query to determine if employee is currently punched out
  • From: Gahbeck
• Access query expression
  • From: caloy
• Re: Nz or Iif?
  • From: John Spencer
• Re: Nz or Iif?
  • From: Kristibaer
• Re: Nz or Iif?
  • From: Kristibaer
• Re: currentdb = nothing?
  • From: kfguardian
• Re: Nz or Iif?
  • From: John Spencer
• crosstab query vs Sum(IIf([MyFiled]="D",1,0)) AS SumD
  • From: inungh
• Re: Create Query to determine if employee is currently punched out or
  • From: Michel Walsh
• Re: Using Switch function properly
  • From: Michel Walsh
• Re: Create new field within table and populate
  • From: John W . Vinson
• one character fields name generated by crosstab query
  • From: inungh
• Using Access to query SQL Server across Web
  • From: csgraham74
• RE: Problem with Time portions of the day
  • From: S.Clark
• Re: Concatenate Error
  • From: jenniferspnc
• RE: After Unmatched Query Runs, Getting the Difference from Totals
  • From: KARL DEWEY
• Re: greater than / less than
  • From: John Spencer
• Re: things aren't adding up
  • From: Jeff Boyce
• things aren't adding up
  • From: JohnLute
• Re: Using Switch function properly
  • From: Student Databaser
• Re: greater than / less than
  • From: JohnLute
• RE: greater than / less than
  • From: JohnLute
• Re: greater than / less than
  • From: Michel Walsh
• RE: greater than / less than
  • From: scubadiver
• Re: greater than / less than
  • From: JohnLute
• RE: greater than / less than
  • From: JohnLute
• RE: After Unmatched Query Runs, Getting the Difference from Totals
  • From: Vylent Fyre
• RE: greater than / less than
  • From: scubadiver
• Re: scheduling
  • From: Michel Walsh
• Re: = or >
  • From: Michel Walsh
• Re: greater than / less than
  • From: Michel Walsh
• RE: Query showing all records from child table
  • From: Jerry Whittle
• RE: greater than / less than
  • From: scubadiver
• RE: Trouble converting excel layout to query does anyone have idea
  • From: KWhamill
• Re: currentdb = nothing?
  • From: Allen Browne
• Re: search name with first letter
  • From: Allen Browne
• Re: IIF Statement In Query Doesn't Work Right
  • From: John Spencer
• Re: IIF Statement In Query Doesn't Work Right
  • From: Allen Browne
• Re: conditional query return records >0 access
  • From: gymphil
• Re: IIf help
  • From: JohnLute
• It's working :-)
  • From: Eka1618
• Re: Is there a flag function in Access that can auto clear daily?
  • From: Rick Brandt
• RE: Using Multiple Combo Boxes as Criteria for Query
  • From: Eka1618
• Re: Create new field within table and populate
  • From: Bob Barrows [MVP]
• Re: create query to combine two tables together
  • From: John Spencer
• Problem with Time portions of the day
  • From: nadav . katz
• Re: Create new field within table and populate
  • From: Bob Barrows [MVP]
• Re: create query to combine two tables together
  • From: Bob Barrows [MVP]
• Re: Count Problem
  • From: Dawn
• Re: group to combine parameters
  • From: Rob Parker
• Is there a flag function in Access that can auto clear daily?
  • From: mcf747
• Access query question
  • From: Phillip MItchell
• create query to combine two tables together
  • From: Associates
• Re: calculated field - Access 2003
  • From: John W . Vinson
• Re: calculated field - Access 2003
  • From: Bob Barrows [MVP]
• RE: Using Multiple Combo Boxes as Criteria for Query
  • From: Ken Sheridan
• RE: After Unmatched Query Runs, Getting the Difference from Totals
  • From: KARL DEWEY
• Re: group to combine parameters
  • From: anil
• Re: calculated field - Access 2003
  • From: Lesa Havert
• Re: calculated field - Access 2003
  • From: Bob Barrows [MVP]
• Re: calculated field - Access 2003
  • From: Bob Barrows [MVP]
• Re: calculated field - Access 2003
  • From: Klatuu
• Connect MS Access Database and Web Page
  • From: Sheila
• Re: Concatenate Error
  • From: Bob Barrows [MVP]
• Re: Concatenate Error
  • From: John Spencer
• Re: calculated field - Access 2003
  • From: Lesa Havert
• Re: Concatenate Error
  • From: Bob Barrows [MVP]
• RE: Query showing all records from child table
  • From: Jesse
• Re: How to find duplicate payments
  • From: utahbiker7
• RE: Query showing all records from child table
  • From: Jesse
• Re: Concatenate Error
  • From: jenniferspnc
• Re: calculated field - Access 2003
  • From: Bob Barrows [MVP]
• Re: add end dates to query by start date
  • From: John Spencer
• Re: Concatenate Error
  • From: John Spencer
• Re: How to find duplicate payments
  • From: John Spencer
• Re: How to find duplicate payments
  • From: utahbiker7
• RE: Concatenate Error
  • From: jenniferspnc
• RE: Complicated Query returning double results
  • From: MStadnik
• RE: Using Multiple Combo Boxes as Criteria for Query
  • From: Eka1618
• Re: assigning a month based on date
  • From: KARL DEWEY
• RE: Complicated Query returning double results
  • From: Klatuu
• Re: Write a query to retain records based on certain criteria‏
  • From: John Spencer
• RE: Using Multiple Combo Boxes as Criteria for Query
  • From: Ken Sheridan
• Re: Report - Sort by related index, replace with values from other tab
  • From: John Spencer
• Re: IIf help
  • From: John Spencer
• Re: Update query based on previous record
  • From: Steve_A
• Re: how can I replicate excel's "workday" function in access?
  • From: Ron2006
• Re: query criteria of month and year, possibly quarter and annually
  • From: Ron2006
• Re: IIf help
  • From: JohnLute
• Re: Easy Query Question
  • From: Bob Barrows [MVP]
• Query Criteria Breaking
  • From: Jake
• Re: assigning a month based on date
  • From: Jeff Boyce
• Re: IIf help
  • From: JohnLute
• Re: Unwanted alphanumeric sort on time, incorrect min/max value
  • From: Jelle
• Re: IIf help
  • From: Bob Barrows [MVP]
• Re: Need a Query Guru with patience!
  • From: Michel Walsh
• Re: Not <> columns
  • From: Bob Barrows [MVP]
• RE: Using Multiple Combo Boxes as Criteria for Query
  • From: Eka1618
• Re: Unwanted alphanumeric sort on time, incorrect min/max value
  • From: Bob Barrows [MVP]
• Not <> columns
  • From: Octet32
• RE: Using Multiple Combo Boxes as Criteria for Query
  • From: Eka1618
• Re: Unwanted alphanumeric sort on time, incorrect min/max value
  • From: Jelle
• Re: 2 complicated queries
  • From: Allen Browne
• Re: assigning a month based on date
  • From: H0MELY
• Re: access query to find unique values
  • From: John Spencer
• Re: Creating query based on no-match
  • From: John Spencer
• Re: Unwanted alphanumeric sort on time, incorrect min/max value
  • From: Bob Barrows [MVP]
• Re: Count Problem
  • From: John Spencer
• Re: Update query based on previous record
  • From: Bob Barrows [MVP]
• access query to find unique values
  • From: tonyrulesyall
• Re: group to combine parameters
  • From: Rob Parker
• Re: Update query based on previous record
  • From: Steve_A
• Re: Customized Label Template Transfer
  • From: Larry Daugherty
• Re: Make Tables Query
  • From: Larry Daugherty
• Re: group to combine parameters
  • From: anil
• Re: Query question
  • From: David W. Fenton
• Re: Update query based on previous record
  • From: Steve_A
• Re: group to combine parameters
  • From: Rob Parker
• Re: Did I fool myself
  • From: Bob Barrows [MVP]
• Re: Update query based on previous record
  • From: Bob Barrows [MVP]
• Did I fool myself
  • From: kkimsj
• Re: Creating query based on no-match
  • From: The Mysterious J
• Re: Creating query based on no-match
  • From: louisjohnphillips
• Re: assigning a month based on date
  • From: Jeff Boyce
• Re: Creating query based on no-match
  • From: The Mysterious J
• RE: query writing dilemma, pt 2
  • From: KARL DEWEY
• Re: Update query based on previous record
  • From: Steve_A
• Re: Creating query based on no-match
  • From: John Spencer
• Re: Date range in query
  • From: John Spencer
• Re: Creating query based on no-match
  • From: louisjohnphillips
• group to combine parameters
  • From: anil
• RE: query writing dilemma, pt 2
  • From: Renee
• RE: query writing dilemma, pt 2
  • From: KARL DEWEY
• Re: Update query based on previous record
  • From: Bob Barrows [MVP]
• RE: query writing dilemma, pt 2
  • From: Renee
• RE: Need a Query Guru with patience!
  • From: TheNovice
• Re: Update query based on previous record
  • From: Steve_A
• RE: query writing dilemma, pt 2
  • From: KARL DEWEY
• query criteria of month and year, possibly quarter and annually
  • From: H0MELY
• how can I replicate excel's "workday" function in access?
  • From: kunkel321
• RE: query writing dilemma, pt 2
  • From: Renee
• Date range in query
  • From: ladybug via AccessMonster.com
• Re: query writing dilemma, pt 2
  • From: Bob Barrows [MVP]
• Re: Update query based on previous record
  • From: Bob Barrows [MVP]
• Re: 2 complicated queries
  • From: Nir N
• Re: 2 complicated queries
  • From: Nir N
• Re: How to find duplicate payments
  • From: John Spencer
• RE: Using Multiple Combo Boxes as Criteria for Query
  • From: Ken Sheridan
• RE: Using Multiple Combo Boxes as Criteria for Query
  • From: Eka1618
• Re: Using a SELECT query as the rowsoruce for another SELECT
  • From: dch3
• Re: How to find duplicate payments
  • From: utahbiker7
• RE: Update query based on previous record
  • From: Steve_A
• Re: Get a Running Sum in a Query
  • From: Michel Walsh
• Re: Need a Query Guru with patience!
  • From: Michel Walsh
• Re: CrossTab Query with Min
  • From: Juan Robledo
• QRe: intervals
  • From: Michel Walsh
• Re: query writing dilemma, pt 2
  • From: Bob Barrows [MVP]
• Re: 2 complicated queries
  • From: Bob Barrows [MVP]
• RE: Get a Running Sum in a Query
  • From: magicdds
• Re: CrossTab Query with Min
  • From: John Spencer
• Re: conditional query return records >0 access
  • From: John Spencer
• conditional query return records >0 access
  • From: gymphil
• Re: Type conversion failure on Append
  • From: albert . repasky
• Re: Circular Reference
  • From: John Spencer
• Re: 2 complicated queries
  • From: Allen Browne
• RE: Query too complex or bringing back too few items
  • From: scubadiver
• Re: access query with 12 columns
  • From: John Spencer
• RE: Query too complex or bringing back too few items
  • From: swilkinson
• RE: Query too complex or bringing back too few items
  • From: scubadiver
• Circular Reference
  • From: asmenend
• Re: Type conversion failure on Append
  • From: albert . repasky
• Re: Sosrting numbers entered as text
  • From: Charles via AccessMonster.com
• Re: Sosrting numbers entered as text
  • From: Charles via AccessMonster.com
• RE: Update query based on previous record
  • From: S.Clark
• RE: Get a Running Sum in a Query
  • From: scubadiver
• Editing Joined Querys
  • From: hfrupn
• Re: Cross Tab
  • From: John Spencer
• Re: Using a SELECT query as the rowsoruce for another SELECT
  • From: John Spencer
• Re: adding a month to a text box
  • From: Bob Barrows [MVP]
• RE: adding a month to a text box
  • From: Dennis
• adding a month to a text box
  • From: tonyrulesyall
• RE: Cross Tab Query for each Month
  • From: Public
• Re: Query question
  • From: Allen Browne
• Re: Sosrting numbers entered as text
  • From: fredg
• Re: Difficult Sort
  • From: Bob Barnes
• Re: Sosrting numbers entered as text
  • From: raskew via AccessMonster.com
• Re: Sosrting numbers entered as text
  • From: quinto via AccessMonster.com
• Sosrting numbers entered as text
  • From: Charles via AccessMonster.com
• Re: many to many relationship with dates
  • From: louisjohnphillips
• Re: update query w some fields null
  • From: louisjohnphillips
• CrossTab Query with Min
  • From: Juan Robledo
• Re: Difficult Sort
  • From: John Spencer
• Re: Difficult Sort
  • From: Bob Barnes
• Re: Extract part of a number
  • From: John Spencer
• Re: Extract part of a number
  • From: raskew via AccessMonster.com
• update query w some fields null
  • From: Ted
• Re: Extract month and year
  • From: Rick Brandt
• Re: LIKE Condition
  • From: John Spencer
• Re: Difficult Sort
  • From: John Spencer
• Re: Extract part of a number
  • From: John Spencer
• Re: Boolean parameters in query
  • From: DKS
• Re: Boolean parameters in query
  • From: Allen Browne
• Re: LIKE Condition
  • From: Allen Browne
• Re: Extract month and year
  • From: Allen Browne
• Re: Extract month and year
  • From: Allen Browne
• Re: adding years to date range
  • From: Allen Browne
• adding years to date range
  • From: tonyrulesyall
• Re: Difficult Sort
  • From: Bob Barnes
• Re: Difficult Sort
  • From: John Spencer
• Re: Extract part of a number
  • From: John Spencer
• Re: Want time period Now()-60 for any one of 3 dates in my query.
  • From: Bob Barrows [MVP]
• Re: Union Querry
  • From: Bob Barrows [MVP]
• Union Querry
  • From: SHETTY
• Re: Adding Memo Fields Using an Append Query
  • From: Laz
• many to many relationship with dates
  • From: tonyrulesyall
• Re: Problems with sorting
  • From: Sue
• Re: Problems with sorting
  • From: Allen Browne
• RE: Make duplicate Records for Wire Labels
  • From: 2GWLAN
• access query with 12 columns
  • From: tonyrulesyall
• Re: Enter parameter value Query1. ...
  • From: Bob Barrows [MVP]
• Re: How to find duplicate payments
  • From: John Spencer
• Re: Enter parameter value Query1. ...
  • From: fredg
• RE: Make duplicate Records for Wire Labels
  • From: KARL DEWEY
• Re: simple select query variable question
  • From: John
• access crosstab queries month range
  • From: tonyrulesyall
• Re: Expressions
  • From: John Spencer
• RE: Make duplicate Records for Wire Labels
  • From: 2GWLAN
• RE: Make duplicate Records for Wire Labels
  • From: KARL DEWEY
• Re: Field for End Date..Please help!
  • From: Julie
• Re: Query of only Records Due to be Installed in 5 Days
  • From: cw via AccessMonster.com
• Re: Group by 2 columns ?
  • From: chemicals
• RE: Make duplicate Records for Wire Labels
  • From: 2GWLAN
• Re: query writing dilemma
  • From: Michel Walsh
• Re: Undefined function "Date" in expression
  • From: Bob Barrows [MVP]
• RE: Undefined function "Date" in expression
  • From: KARL DEWEY
• Re: Ranking - All over again
  • From: Michel Walsh
• Re: Include records even if date is null
  • From: John Spencer
• Re: Expressions
  • From: John Spencer
• Re: Query of only Records Due to be Installed in 5 Days
  • From: John Spencer
• query writing dilemma
  • From: Renee
• Re: Query of only Records Due to be Installed in 5 Days
  • From: KARL DEWEY
• Re: Type conversion failure on Append
  • From: albert . repasky
• Re: Query of only Records Due to be Installed in 5 Days
  • From: Bob Barrows [MVP]
• Re: Query of only Records Due to be Installed in 5 Days
  • From: cw via AccessMonster.com
• Re: Query of only Records Due to be Installed in 5 Days
  • From: Bob Barrows [MVP]
• Re: Query of only Records Due to be Installed in 5 Days
  • From: cw via AccessMonster.com
• Re: Query of only Records Due to be Installed in 5 Days
  • From: Bob Barrows [MVP]
• Re: simple select query variable question
  • From: Bob Barrows [MVP]
• Query of only Records Due to be Installed in 5 Days
  • From: cw via AccessMonster.com
• Re: Type conversion failure on Append
  • From: KARL DEWEY
• RE: IIf help
  • From: Dale_Fye via AccessMonster.com
• Re: simple select query variable question
  • From: Dale_Fye via AccessMonster.com
• Re: Type conversion failure on Append
  • From: albert . repasky
• simple select query variable question
  • From: John
• Re: Type conversion failure on Append
  • From: KARL DEWEY
• Re: Type conversion failure on Append
  • From: John Spencer
• Re: Type conversion failure on Append
  • From: albert . repasky
• Re: Update query based on another table
  • From: apex77
• RE: Import Text File
  • From: S.Clark
• RE: Concatenate ComboBox in Query
  • From: S.Clark
• RE: Have 4 Queries and need to combine results
  • From: Klatuu
• Re: Entering Data with A CrossTab Query
  • From: Allen Browne
• Re: Update query & null values
  • From: Dave
• Re: Conditional Drop-downs in a table
  • From: Ron2006
• Re: Word "Distinct " using problem.
  • From: Bob Barrows [MVP]
• Re: edit mask on a query prompt
  • From: John Spencer
• Re: Update query based on another table
  • From: John Spencer
• Re: Entering Data with A CrossTab Query
  • From: Allen Browne
• Entering Data with A CrossTab Query
  • From: Olivier L
• Re: Word “Distinct “ using problem.
  • From: Dawn
• Re: Word “Distinct “ using problem.
  • From: Allen Browne
• Re: querying tables in a different database?
  • From: Howard
• Re: Display the output from a query in a textbox
  • From: DontKnow
• Re: Date Data type changing to text
  • From: pietlinden@xxxxxxxxxxx
• RE: Have 4 Queries and need to combine results
  • From: Trevor W
• Re: group to combine parameters
  • From: anil
• Re: edit mask on a query prompt
  • From: George Applegate
• RE: edit mask on a query prompt
  • From: Klatuu
• RE: Have 4 Queries and need to combine results
  • From: Klatuu
• Re: Update query & null values
  • From: Bob Barrows [MVP]
• Re: Update query & null values
  • From: John Spencer
• Re: Update query & null values
  • From: Dave
• Re: Concatenate values from mutiple records into single column
  • From: John Spencer
• edit mask on a query prompt
  • From: George Applegate
• querying tables in a different database?
  • From: Howard
• Re: Update query & null values
  • From: Bob Barrows [MVP]
• Re: Create flexible Query - One instead of dozens
  • From: BlueWolverine
• Re: Date Formula ? Conditional on Day of Week
  • From: Klatuu
• Re: Concatenate values from mutiple records into single column
  • From: Bob Barrows [MVP]
• Combine crosstab with other query info
  • From: LadyIlsebet
• contains criteria
  • From: saraua
• Re: Group by 2 columns ?
  • From: Bob Barrows [MVP]
• Re: Cross tab to begin fiscal year
  • From: KARL DEWEY
• Re: Display the output from a query in a textbox
  • From: John Spencer
• Re: Date Formula ? Conditional on Day of Week
  • From: Michel Walsh
• Re: What wrong here? Me or access?
  • From: Marco
• Re: What wrong here? Me or access?
  • From: Bob Barrows [MVP]
• RE: using Dates as a Criteria/Lookup in Query
  • From: Kevin
• Date Data type changing to text
  • From: Octet32
• Re: Cross tab to begin fiscal year
  • From: Nick
• Re: Create flexible Query - One instead of dozens
  • From: Bob Barrows [MVP]
• Re: Cross tab to begin fiscal year
  • From: KARL DEWEY
• Re: Type conversion failure on Append
  • From: KARL DEWEY
• Re: Finding the Percentage of 'Yes'
  • From: Eka1618
• Re: Grouping Distinct
  • From: Allen Browne
• Re: Create flexible Query - One instead of dozens
  • From: BlueWolverine
• Re: Finding the Percentage of 'Yes'
  • From: Michel Walsh
• Re: Grouping Distinct
  • From: Allen Browne
• Re: Cross tab to begin fiscal year
  • From: Nick
• Re: Splitting Names
  • From: FrankM
• Re: Crosstab Query Fields
  • From: DS
• Re: Query with left outer join all of a sudden won't work?
  • From: Michel Walsh
• Re: Display the output from a query in a textbox
  • From: DontKnow
• Re: Most Common Price based on Max Value
  • From: John Spencer
• Re: Type conversion failure on Append
  • From: albert . repasky
• Re: working with time date in a query
  • From: John Spencer
• Re: I need to change all data in two fields
  • From: Bob Barrows [MVP]
• Re: Conditional Drop-downs in a table
  • From: John Spencer
• Re: working with time date in a query
  • From: Bruce
• Re: Subject: Use of Folder in Expression Builder
  • From: John Spencer
• Re: Display the output from a query in a textbox
  • From: John Spencer
• Re: Crosstab Query Fields
  • From: John Spencer
• Re: Most Common Price based on Max Value
  • From: Bruce
• Re: Create combinaison of field
  • From: raskew via AccessMonster.com
• Re: Conditional Drop-downs in a table
  • From: Arjay
• Re: Subject: Use of Folder in Expression Builder
  • From: sonia
• Re: I need to change all data in two fields
  • From: John W . Vinson
• RE: Update query based on another table
  • From: apex77
• Re: Conditional Drop-downs in a table
  • From: John W . Vinson
• Re: Display the output from a query in a textbox
  • From: DontKnow
• Re: I need to change all data in two fields
  • From: Afrosheen
• Question for Ken Snell
  • From: Debbiedo
• group to combine parameters
  • From: anil
• Re: Difference between dates
  • From: John Spencer
• Crosstab Query Fields
  • From: DS
• Re: I need to change all data in two fields
  • From: Bob Barrows [MVP]
• Re: Difference between dates
  • From: Bob Barrows [MVP]
• Re: Splitting Names
  • From: fredg
• Re: Conditional Drop-downs in a table
  • From: Ron2006
• RE: Column Heading for a CrossTab query being the next 12 weeks
  • From: KARL DEWEY
• Re: Query with left outer join all of a sudden won't work?
  • From: Sylvain Lafontaine
• RE: Column Heading for a CrossTab query being the next 12 weeks
  • From: KARL DEWEY
• Re: Query for latest production data
  • From: Bob Barrows [MVP]
• RE: Report Criteria when using subreports
  • From: CMY
• Query for latest production data
  • From: alec_russell
• RE: using Dates as a Criteria/Lookup in Query
  • From: Klatuu
• Re: Create flexible Query - One instead of dozens
  • From: Bob Barrows [MVP]
• RE: Concatenate Error
  • From: jenniferspnc
• RE: Concatenate Error
  • From: S.Clark
• Re: How to find duplicate payments
  • From: utahbiker7
• Re: get "record missing" error
  • From: Ron2006
• Re: Create flexible Query - One instead of dozens
  • From: BlueWolverine
• Re: Field Merge
  • From: PhilT via AccessMonster.com
• Re: want all caps in a field
  • From: fredg
• Re: Using Switch function properly
  • From: Michel Walsh
• Re: Multi-Select List-Box no data in table
  • From: Rick Brandt
• Re: Create flexible Query - One instead of dozens
  • From: Roger Carlson
• Re: How to find duplicate payments
  • From: utahbiker7
• Create flexible Query - One instead of dozens
  • From: BlueWolverine
• RE: Column Heading for a CrossTab query being the next 12 weeks
  • From: MarieT
• get "record missing" error
  • From: JR
• want all caps in a field
  • From: George Applegate
• Re: Using Switch function properly
  • From: Student Databaser
• Re: Limit Records
  • From: DS
• Re: Limit Records
  • From: DS
• Re: Limit Records
  • From: DS
• Re: Help-ODBC Error when query runs
  • From: Roger Carlson
• Type conversion failure on Append
  • From: albert . repasky
• Re: Checkboxes and Query Criteria
  • From: adam . vogg
• Concatenate Error
  • From: jenniferspnc
• Re: Cross tab to begin fiscal year
  • From: KARL DEWEY
• Re: Limit Records
  • From: KARL DEWEY
• Checkboxes and Query Criteria
  • From: adam . vogg
• Re: Limit Records
  • From: John Spencer
• Re: working with time date in a query
  • From: John Spencer
• Re: Help-ODBC Error when query runs
  • From: Roger Carlson
• List Boxes - DESPERATE FOR HELP!!!!
  • From: Karen
• Re: Cross tab to begin fiscal year
  • From: Nick
• Re: Cross tab to begin fiscal year
  • From: John Spencer
• Re: Cross tab to begin fiscal year
  • From: KARL DEWEY
• Re: query design question
  • From: smoknjo
• Re: How to find duplicate payments
  • From: John Spencer
• Re: Cross tab to begin fiscal year
  • From: Nick
• Re: Union Query fails
  • From: Alan
• Re: Limit Records
  • From: Golfinray
• Re: Limit Records
  • From: John Spencer
• Re: protect query
  • From: Jeff Boyce
• Re: Query with left outer join all of a sudden won't work?
  • From: Bob Barrows [MVP]
• Re: Most Common Price based on Max Value
  • From: John Spencer
• Re: Limit Records
  • From: DS
• Re: Multi-Select List-Box no data in table
  • From: Ron2006
• Limit Records
  • From: DS
• Re: Query with left outer join all of a sudden won't work?
  • From: Michel Walsh
• RE: working with time date in a query
  • From: Golfinray
• Re: Multi-Select List-Box no data in table
  • From: Rick Brandt
• Re: No search results equalls debug error
  • From: Allen Browne
• Re: Parsing data with unknown or variable length
  • From: Steve_A
• Re: Query with left outer join all of a sudden won't work?
  • From: Stefan Hoffmann
• Re: Obtaining a filter from a form
  • From: Leslie Isaacs
• Re: Obtaining a filter from a form
  • From: Leslie Isaacs
• Re: Parsing data with unknown or variable length
  • From: John W . Vinson
• Re: separating first and last names when they are in the same cell
  • From: carljordan
• Re: How to find duplicate payments
  • From: utahbiker7
• Re: Adding Memo Fields Using an Append Query
  • From: Ken Snell \(MVP\)
• Re: "locked" query
  • From: Ken Snell \(MVP\)
• Re: Parsing data with unknown or variable length
  • From: John W . Vinson
• Re: query design question
  • From: John W . Vinson
• RE: Crosstab Query based on 2 Combo Boxes. How?
  • From: KARL DEWEY
• Re: separating first and last names when they are in the same cell
  • From: John W . Vinson
• RE: VBA type mismatch error - BUT the same exact query runs fine b
  • From: Rui
• RE: Column Heading for a CrossTab query being the next 12 weeks
  • From: KARL DEWEY
• Re: VBA type mismatch error - BUT the same exact query runs fine b
  • From: Douglas J. Steele
• RE: Crosstab Query based on 2 Combo Boxes. How?
  • From: KARL DEWEY
• Re: separating first and last names when they are in the same cell
  • From: Jeff Boyce
• RE: Crosstab Query based on 2 Combo Boxes. How?
  • From: Nathan Lars
• RE: Crosstab Query based on 2 Combo Boxes. How?
  • From: Nathan Lars
• Re: VBA type mismatch error - BUT the same exact query runs fine b
  • From: Irina
• RE: VBA type mismatch error - BUT the same exact query runs fine b
  • From: Irina
• RE: 2-criteria query; 2nd criteria not regular
  • From: Jerry Whittle
• Re: query criteria format
  • From: KARL DEWEY
• RE: REPOST: Subquery?
  • From: KARL DEWEY
• RE: Crosstab Query based on 2 Combo Boxes. How?
  • From: KARL DEWEY
• RE: Crosstab Query based on 2 Combo Boxes. How?
  • From: Nathan Lars
• RE: UPdate SQL Table Access 2007
  • From: JohnH
• RE: UPdate SQL Table Access 2007
  • From: Klatuu
• Re: Cross tab to begin fiscal year
  • From: John Spencer
• RE: UPdate SQL Table Access 2007
  • From: JohnH
• RE: Cross tab to begin fiscal year
  • From: KARL DEWEY
• RE: UPdate SQL Table Access 2007
  • From: Klatuu
• RE: Crosstab Query based on 2 Combo Boxes. How?
  • From: KARL DEWEY
• RE: UPdate SQL Table Access 2007
  • From: JohnH
• Re: query design question
  • From: John W . Vinson
• Re: Query Uneditable connected to SQL Backend
  • From: Stefan Hoffmann
• Re: Finding Average of Time.
  • From: Jeff Boyce
• Query Uneditable connected to SQL Backend
  • From: pete . trudell
• Re: REPOST: Subquery?
  • From: Michel Walsh
• Re: Finding Average of Time.
  • From: Dale_Fye via AccessMonster.com
• query design question
  • From: smoknjo
• Re: Create an append query
  • From: Michel Walsh
• Re: Access Memo Field Search
  • From: Dale_Fye via AccessMonster.com
• Re: Create an append query
  • From: Michel Walsh
• Re: Create an append query
  • From: Stefan Hoffmann
• Re: VBA type mismatch error - BUT the same exact query runs fine b
  • From: Irina
• RE: selecting the right 'MAX' record
  • From: Duane Hookom
• Re: selecting the right 'MAX' record
  • From: Michel Walsh
• Re: How to choose only the first record from a query
  • From: Michel Walsh
• No search results equalls debug error
  • From: midalwhat
• Re: Display the output from a query in a textbox
  • From: DontKnow
• Re: Display the output from a query in a textbox
  • From: John Spencer
• Re: Obtaining a filter from a form
  • From: John Spencer
• Re: How to choose only the first record from a query
  • From: Marco
• Re: Query with left outer join all of a sudden won't work?
  • From: Stefan Hoffmann
• Re: How to choose only the first record from a query
  • From: Michel Walsh
• Re: How to choose only the first record from a query
  • From: Michel Walsh
• Re: Query with left outer join all of a sudden won't work?
  • From: Michel Walsh
• Re: Obtaining a filter from a form
  • From: Leslie Isaacs
• Re: query criteria format
  • From: ryan . fitzpatrick3
• RE: Query with 3
  • From: nikila40
• RE: Query with 3
  • From: KARL DEWEY
• RE: Query with 3
  • From: nikila40
• RE: Finding Average of Time.
  • From: raskew via AccessMonster.com
• query criteria format
  • From: ryan . fitzpatrick3
• Re: VBA type mismatch error - BUT the same exact query runs fine by it
  • From: Douglas J. Steele
• RE: Is Cross Tab Query The Right Choice
  • From: KARL DEWEY
• RE: Query with 3
  • From: nikila40
• RE: Query with 3
  • From: KARL DEWEY
• RE: Query with 3
  • From: nikila40
• Re: Query with left outer join all of a sudden won't work?
  • From: JenniferW
• Re: query too complex to pass optional parameters
  • From: Michel Walsh
• Re: Query with left outer join all of a sudden won't work?
  • From: Michel Walsh
• RE: Query with 3
  • From: KARL DEWEY
• Re: Query with left outer join all of a sudden won't work?
  • From: JenniferW
• query too complex to pass optional parameters
  • From: inungh
• Re: Show latest action for each customer
  • From: CW
• Re: Query with left outer join all of a sudden won't work?
  • From: Michel Walsh
• Re: Finding Average of Time.
  • From: Jeff Boyce
• Re: Automatic Update on Option Group from a select query
  • From: JYK
• Re: Show latest action for each customer
  • From: John Spencer
• Re: Query with left outer join all of a sudden won't work?
  • From: JenniferW
• Is Cross Tab Query The Right Choice
  • From: cna48
• RE: How do I replace blank fields with a zero in database table
  • From: KARL DEWEY
• Re: "locked" query
  • From: Don
• How do I replace blank fields with a zero in database table
  • From: Marwan
• Re: Concatenate multiple rows
  • From: jenniferspnc
• Re: Find and deleting a # sign in a recordset
  • From: moosecck
• Re: Need help with nested JOIN
  • From: Joe Needs Help
• Automatic Update on Option Group from a select query
  • From: JYK
• 2-criteria query; 2nd criteria not regular
  • From: The Mysterious J
• Re: Calculating Avg with null values
  • From: Maggie
• Re: Calculating Avg with null values
  • From: John Spencer
• How to find the letters 'xy' in a product code
  • From: Grd
• Re: Obtaining a filter from a form
  • From: John Spencer
• Combine Tables
  • From: Alchemist61
• RE: Access freezing as I scroll down queried results
  • From: JJEWELL
• Re: Find and deleting a # sign in a recordset
  • From: Allen Browne
• Re: Calculating Avg with null values
  • From: Maggie
• Find and deleting a # sign in a recordset
  • From: moosecck
• Re: Need help with nested JOIN
  • From: Michel Walsh
• RE: Access freezing as I scroll down queried results
  • From: S.Clark
• Re: Query with left outer join all of a sudden won't work?
  • From: Michel Walsh
• Import Text File
  • From: Nuno Gomes
• Re: Taking Just Domain from Email Address
  • From: BDM via AccessMonster.com
• RE: Query Dates by Week Num then String as Date Range
  • From: laknight
• Re: Years of Employment
  • From: Roger Carlson
• Re: conditional dedupe in Access 2000
  • From: Michel Walsh
• Re: Obtaining a filter from a form
  • From: Leslie Isaacs
• Re: Obtaining a filter from a form
  • From: John Spencer
• RE: Getting erros when exporting to another machine!!!
  • From: Dennis
• Re: Getting erros when exporting to another machine!!!
  • From: John Spencer
• Re: Creating a field entry from multiple other fields.
  • From: John Spencer
• Re: conditional dedupe in Access 2000
  • From: not_an_exit
• Re: conditional dedupe in Access 2000
  • From: not_an_exit
• Re: Obtaining a filter from a form
  • From: Leslie Isaacs
• Re: Adding Memo Fields Using an Append Query
  • From: Laz
• Re: iif statement on another calculated field?
  • From: Sylvain Lafontaine
• Re: Adding Memo Fields Using an Append Query
  • From: Ken Snell \(MVP\)
• Re: "locked" query
  • From: Ken Snell \(MVP\)
• Re: Eliminating duplicate customer records
  • From: Ken Snell \(MVP\)
• Re: How to find duplicate payments
  • From: John Spencer
• Re: Sum only specific records and group by
  • From: John Spencer
• Re: Any activity between 2 dates
  • From: John Spencer
• Re: Any activity between 2 dates
  • From: raskew via AccessMonster.com
• Re: Multiple What IIf Function In Query
  • From: Douglas J. Steele
• Re: Multiple What IIf Function In Query
  • From: Forsi
• Re: Taking Just Domain from Email Address
  • From: Evi
• Re: Any activity between 2 dates
  • From: raskew via AccessMonster.com
• Re: Grouping Into 1/2 Hour Time Buckets
  • From: raskew via AccessMonster.com
• Taking Just Domain from Email Address
  • From: BDM
• Re: Grouping Into 1/2 Hour Time Buckets
  • From: raskew via AccessMonster.com
• Re: Multiple What IIf Function In Query
  • From: Douglas J. Steele
• Re: Multiple What IIf Function In Query
  • From: Forsi
• Re: Multiple What IIf Function In Query
  • From: Douglas J. Steele
• Re: How to filter query in Design view
  • From: Wolfgang Kais