microsoft.public.access.queries

• Thread Index

---

• Re: Calculating amount due using changing rates
  • From: Lord Kelvan
• RE: Simple Query
  • From: KARL DEWEY
• Re: at a loss
  • From: Lord Kelvan
• RE: Search for "contains" works like "equals"
  • From: KARL DEWEY
• RE: Help write SQL statement to retrieve data
  • From: KARL DEWEY
• RE: Simple Query
  • From: Sammy
• Re: calculated field, changing value for check box in report
  • From: Jerry Whittle
• Re: Top N Records on multiple fields
  • From: Natasha
• RE: Simple Query
  • From: KARL DEWEY
• RE: Quarterly position change for this year only
  • From: KARL DEWEY
• Re: Convert a Number data type to Text using a query
  • From: John Spencer
• Search for "contains" works like "equals"
  • From: BlueWolverine
• Re: calculated field, changing value for check box in report
  • From: John Spencer
• Re: How to specify table to delete records.
  • From: John Spencer
• Re: Update query changes when saved
  • From: John Spencer
• Re: Possible to sort by 3rd word?
  • From: strive4peace
• Re: Simple Query
  • From: Marshall Barton
• Re: Query field name changes from "Aug-08" to "Aug-8"
  • From: strive4peace
• Re: Convert a Number data type to Text using a query
  • From: Marshall Barton
• RE: Simple Query
  • From: Sammy
• Re: How to specify table to delete records.
  • From: Marshall Barton
• RE: Criteria of One query based on a field in another query
  • From: DawnP277
• RE: Simple Query
  • From: Sammy
• Re: Divide Date Time Stamp
  • From: Jeff Boyce
• Re: calculating an area value
  • From: jlute
• RE: Simple Query
  • From: KARL DEWEY
• Simple Query
  • From: Sammy
• Re: How to specify table to delete records.
  • From: AndrewB
• Re: Unwanted multiplication
  • From: Diogo
• Re: How to extract the year from a date Field
  • From: Marshall Barton
• Re: Convert a Number data type to Text using a query
  • From: bhicks11 via AccessMonster.com
• Re: How to specify table to delete records.
  • From: Marshall Barton
• Re: Update query changes when saved
  • From: Marshall Barton
• Re: How to extract the year from a date Field
  • From: John Spencer
• Re: Update query changes when saved
  • From: Marshall Barton
• Re: calculating an area value
  • From: John Spencer
• RE: how to write a query to display sum
  • From: Ryan
• RE: How to extract the year from a date Field
  • From: apex77
• Re: calculating an area value
  • From: Al Campagna
• Re: help for the syntax challenged
  • From: John Spencer
• RE: EMERGENCY! How can I update one table from another in a select
  • From: Klatuu
• RE: EMERGENCY! How can I update one table from another in a select
  • From: Bob Dancer
• Criteria of One query based on a field in another query
  • From: DawnP277
• Re: at a loss
  • From: Valix
• Re: update query (date extraction)
  • From: apex77
• calculating an area value
  • From: jlute
• RE: How can I join two queries and avoid duplicate records?
  • From: StratfordWard
• Re: Possible to sort by 3rd word?
  • From: Qury
• Re: Query field name changes from "Aug-08" to "Aug-8"
  • From: cjborntorun
• Re: Need to transform Access columns to rows
  • From: Susan L
• Re: Divide Date Time Stamp
  • From: Eskimo
• Re: Query field name changes from "Aug-08" to "Aug-8"
  • From: cjborntorun
• Re: Possible to sort by 3rd word?
  • From: strive4peace
• Re: Query field name changes from "Aug-08" to "Aug-8"
  • From: strive4peace
• Re: Possible to sort by 3rd word?
  • From: Qury
• Re: Query field name changes from "Aug-08" to "Aug-8"
  • From: cjborntorun
• Re: Possible to sort by 3rd word?
  • From: strive4peace
• Re: How can I join two queries and avoid duplicate records?
  • From: Ron2006
• Re: Query field name changes from "Aug-08" to "Aug-8"
  • From: strive4peace
• Re: Update query changes when saved
  • From: jamestufcfan
• Query field name changes from "Aug-08" to "Aug-8"
  • From: cjborntorun
• Possible to sort by 3rd word?
  • From: Qury
• Re: Update query changes when saved
  • From: Marshall Barton
• Re: help for the syntax challenged
  • From: jlute
• Re: help for the syntax challenged
  • From: John Spencer
• Re: Count columns
  • From: Rick Brandt
• Re: HOW DO I USE COUNTIF FUNCTION ACCESS 2007 ?
  • From: John Spencer
• Re: Simple to Extreme Criteria Queries
  • From: John Spencer
• help for the syntax challenged
  • From: jlute
• Re: How can I join two queries and avoid duplicate records?
  • From: Bob Barrows [MVP]
• Re: HOW DO I USE COUNTIF FUNCTION ACCESS 2007 ?
  • From: bcap
• Re: Save a dynamic query with fixed parameters
  • From: jodamo5 via AccessMonster.com
• HOW DO I USE COUNTIF FUNCTION ACCESS 2007 ?
  • From: Udaya
• Re: How can I join two queries and avoid duplicate records?
  • From: bcap
• Re: Date Problem
  • From: Allen Browne
• Re: excluding dates
  • From: Allen Browne
• Re: some text-formatted numbers rounded, others not
  • From: Lord Kelvan
• Re: Headache on Outer Join with Crosstab
  • From: Lord Kelvan
• Re: Simple to Extreme Criteria Queries
  • From: Pete D.
• Re: Search Date and Time
  • From: Douglas J. Steele
• Re: Simple to Extreme Criteria Queries
  • From: CorporateQAinTX
• Re: some text-formatted numbers rounded, others not
  • From: Lord Kelvan
• Re: some text-formatted numbers rounded, others not
  • From: storyman
• Re: at a loss
  • From: Lord Kelvan
• Re: some text-formatted numbers rounded, others not
  • From: storyman
• Re: some text-formatted numbers rounded, others not
  • From: Lord Kelvan
• Re: Simple to Extreme Criteria Queries
  • From: Pete D.
• Re: at a loss
  • From: Lord Kelvan
• Re: linearize data
  • From: BrianP
• Re: at a loss
  • From: Lord Kelvan
• Re: Is this possible
  • From: SteveG
• Re: Need to transform Access columns to rows
  • From: KARL DEWEY
• Re: Divide Date Time Stamp
  • From: Lord Kelvan
• Re: Need to transform Access columns to rows
  • From: Susan L
• Re: Divide Date Time Stamp
  • From: Jeff Boyce
• Re: at a loss
  • From: John Spencer
• Re: Using IIF to create time intervals
  • From: Marshall Barton
• Re: at a loss
  • From: Lord Kelvan
• Re: at a loss
  • From: Lord Kelvan
• Re: at a loss
  • From: Lord Kelvan
• Re: Need to transform Access columns to rows
  • From: Susan L
• Re: Date Problem
  • From: Neill M. Pinkney
• Re: at a loss
  • From: Valix
• Re: at a loss
  • From: Bob Barrows [MVP]
• Re: Need to transform Access columns to rows
  • From: Bob Barrows [MVP]
• Divide Date Time Stamp
  • From: Eskimo
• RE: Rename fields in Union query?
  • From: CW
• RE: Rename fields in Union query?
  • From: CW
• Re: Date Problem
  • From: Neill M. Pinkney
• RE: Rename fields in Union query?
  • From: Klatuu
• Re: at a loss
  • From: ghetto_banjo
• RE: Rename fields in Union query?
  • From: KARL DEWEY
• Re: at a loss
  • From: ghetto_banjo
• Headache on Outer Join with Crosstab
  • From: Epoh Rio
• Re: How do i calculate the median in access?
  • From: Bob Barrows [MVP]
• How do i calculate the median in access?
  • From: Belinda7237
• Re: Cumulative column in Query
  • From: Carrie_Loos via AccessMonster.com
• RE: Calculations being multiplied
  • From: Jerry Whittle
• Calculations being multiplied
  • From: DawnTreader
• RE: search specific postcodes
  • From: KARL DEWEY
• RE: search specific postcodes
  • From: Jerry Whittle
• RE: make criteria look for a value on form
  • From: fossy
• Re: search specific postcodes
  • From: Jeff Boyce
• Re: query based on form
  • From: Leo Bonnaci
• RE: make criteria look for a value on form
  • From: fossy
• Re: excluding dates
  • From: Todd
• Re: Nearly identical records in a table.
  • From: John Spencer
• Re: query based on form
  • From: Allen Browne
• query based on form
  • From: Leo Bonnaci
• RE: make criteria look for a value on form
  • From: Dennis
• Re: Nearly identical records in a table.
  • From: Michel Walsh
• RE: Multiple forms use one query
  • From: Pyrite
• Nearly identical records in a table.
  • From: James O
• Re: Totals when one or more column has NULL values
  • From: KHogwood-Thompson
• Re: Create string of text from several fields eliminating last com
  • From: Allen Browne
• Re: Create string of text from several fields eliminating last comma
  • From: Bob Barrows [MVP]
• Take fields from Excel and sticking them into Access table
  • From: KK
• Re: Need help!
  • From: Stacy
• Re: Create string of text from several fields eliminating last com
  • From: Nancy
• Re: Need help!
  • From: Bob Barrows [MVP]
• Re: Future Date
  • From: aubrey
• make criteria look for a value on form
  • From: fossy
• Re: Totals when one or more column has NULL values
  • From: Michel Walsh
• Re: Cumulative column in Query
  • From: Michel Walsh
• Re: Need help!
  • From: Stacy
• RE: Convert text to number
  • From: KARL DEWEY
• Re: Need help!
  • From: Bob Barrows [MVP]
• Re: proper case
  • From: Bob Barrows [MVP]
• Re: proper case
  • From: fredg
• Re: Create string of text from several fields eliminating last comma
  • From: Allen Browne
• Re: Create string of text from several fields eliminating last comma
  • From: fredg
• Re: proper case
  • From: Allen Browne
• Re: Query or Report? Need to get addresses by odd or even numbers
  • From: Marshall Barton
• Re: Date Problem
  • From: Allen Browne
• RE: Select a part of a string
  • From: Klatuu
• Re: Query or Report? Need to get addresses by odd or even numbers
  • From: John Spencer
• Re: how to convert uppercase to proper name using update query
  • From: Bob Barrows [MVP]
• Re: how to convert uppercase to proper name using update query
  • From: ceesdatabase
• Re: Where does a Select Statement go?
  • From: Bob Barrows [MVP]
• Re: Search Date and Time
  • From: Bob Barrows [MVP]
• Re: how to convert uppercase to proper name using update query
  • From: Bob Barrows [MVP]
• Query or Report? Need to get addresses by odd or even numbers
  • From: Kate
• RE: Convert text to number
  • From: Kristl via AccessMonster.com
• RE: Temporary ID#
  • From: tedmi
• RE: Grand Total
  • From: ceesdatabase
• Re: Grand Total
  • From: John Spencer
• Re: Multiple forms use one query
  • From: John Spencer
• RE: Multiple forms use one query
  • From: ceesdatabase
• Re: Is this possible
  • From: John Spencer
• Re: Floor rounding
  • From: John Spencer
• Re: Search Date and Time
  • From: John Spencer
• Grand Total
  • From: Ranjit kurian
• Re: Search Date and Time
  • From: Bob Barrows [MVP]
• RE: Is this possible
  • From: ceesdatabase
• RE: Select a part of a string
  • From: Bruno
• Re: Date Problem
  • From: Neill M. Pinkney
• Re: Incrementally Number
  • From: Jeff C
• Re: Incrementally Number
  • From: Allen Browne
• Re: Date Problem
  • From: Allen Browne
• Incrementally Number
  • From: Jeff C
• Re: Date Problem
  • From: Neill M. Pinkney
• Re: IIF with option button
  • From: Allen Browne
• Re: Need help for query
  • From: Allen Browne
• Re: Date Problem
  • From: Allen Browne
• Re: Date Problem
  • From: Neill M. Pinkney
• Re: Date Problem
  • From: Allen Browne
• Re: Need help for query
  • From: sadat
• Date Problem
  • From: Neill M. Pinkney
• Re: Is this possible?
  • From: bhicks11 via AccessMonster.com
• Re: Search Date and Time
  • From: Douglas J. Steele
• Re: excluding dates
  • From: Allen Browne
• Is this possible
  • From: SteveG
• Re: Simple to Extreme Criteria Queries
  • From: CorporateQAinTX
• Re: Simple to Extreme Criteria Queries
  • From: Pete D.
• Re: Is this possible?
  • From: Laura
• Re: Search Date and Time
  • From: Bob Barrows [MVP]
• Re: Is this possible?
  • From: bhicks11 via AccessMonster.com
• Re: Multiple large queries vs. One big/several small queries
  • From: Jeff Boyce
• Re: Search Date and Time
  • From: Douglas J. Steele
• Re: Floor rounding
  • From: raskew via AccessMonster.com
• Re: Floor rounding
  • From: strive4peace
• Cumulative column in Query
  • From: Carrie_Loos via AccessMonster.com
• Re: Floor rounding
  • From: Jessica
• Re: Future Date
  • From: Marshall Barton
• Re: Maybe an entirely different approach is needed?
  • From: Marshall Barton
• Re: Incremental Number Based on Criteria
  • From: strive4peace
• Re: Floor rounding
  • From: strive4peace
• Re: update duplicates question
  • From: strive4peace
• Re: I added an Iif statement to a query now it returns nothing
  • From: MS_Access_Neophyte
• excluding dates
  • From: Todd
• Re: Maybe an entirely different approach is needed?
  • From: Marshall Barton
• Incremental Number Based on Criteria
  • From: teddyb777
• Re: Count # of Characters of a certain type in a record
  • From: Marshall Barton
• Re: Retaining the most recent value associated with multiple dates
  • From: John Spencer
• Re: stratified sample
  • From: Michel Walsh
• Maybe an entirely different approach is needed?
  • From: dustinb via AccessMonster.com
• Re: Multiple large queries vs. One big/several small queries
  • From: Jeff Boyce
• Re: Select a part of a string
  • From: strive4peace
• Re: Data Collection E-mail Query
  • From: Michel Walsh
• RE: parameter with iif statement in query criteria
  • From: Noel
• Re: Configureable Query or otherwise
  • From: Michel Walsh
• Re: update duplicates question
  • From: strive4peace
• Re: Critera in Crosstab Query
  • From: Joy
• Re: Need help for query
  • From: Allen Browne
• Re: Critera in Crosstab Query
  • From: Allen Browne
• Re: Adding another Totals Column in Crosstab query
  • From: John Spencer
• Re: Adding another Totals Column in Crosstab query
  • From: Jomark
• Re: Search Date and Time
  • From: Bob Barrows [MVP]
• Re: I added an Iif statement to a query now it returns nothing
  • From: Bob Barrows [MVP]
• Re: Default query print to Landscape
  • From: Brendan Reynolds
• Re: Finding similar data in two fields
  • From: Brendan Reynolds
• update duplicates question
  • From: lez08
• Re: Adding another Totals Column in Crosstab query
  • From: Allen Browne
• Re: Access 2007 - Cannot open database.
  • From: RL
• Re: Access 2007 - Cannot open database.
  • From: RL
• Re: I added an Iif statement to a query now it returns nothing
  • From: MS_Access_Neophyte
• Re: I added an Iif statement to a query now it returns nothing
  • From: MS_Access_Neophyte
• Re: Save a dynamic query with fixed parameters
  • From: jodamo5 via AccessMonster.com
• Re: Save a dynamic query with fixed parameters
  • From: John W . Vinson/MVP
• Re: Search Date and Time
  • From: John W . Vinson/MVP
• Re: Search Date and Time
  • From: Bob Barrows [MVP]
• Re: Search Date and Time
  • From: Bob Barrows [MVP]
• Re: Search Date and Time
  • From: Floyd Forbes
• Re: Search Date and Time
  • From: John W . Vinson/MVP
• Re: Save a dynamic query with fixed parameters
  • From: jodamo5 via AccessMonster.com
• Search Date and Time
  • From: Floyd Forbes
• Re: Save a dynamic query with fixed parameters
  • From: Marshall Barton
• Save a dynamic query with fixed parameters
  • From: jodamo5 via AccessMonster.com
• Re: Multiple large queries vs. One big/several small queries
  • From: Jeff Boyce
• Re: Sorting in Access 2K
  • From: Tony
• Re: I added an Iif statement to a query now it returns nothing
  • From: Erez Mor
• Multiple large queries vs. One big/several small queries
  • From: J Sedoff
• Re: Overriding table caption in query
  • From: bcap
• Re: Append/Delete/Update Query
  • From: Ken Sheridan
• Filtering
  • From: Richard
• RE: Append/Delete/Update Query
  • From: MikeinPhoenix
• Re: Append/Delete/Update Query
  • From: MikeinPhoenix
• Decimal format
  • From: Jasper Recto
• Decimal format
  • From: Jasper Recto
• Decimal format
  • From: Jasper Recto
• RE: Append/Delete/Update Query
  • From: Ken Sheridan
• Re: Append/Delete/Update Query
  • From: Jeff Boyce
• Re: Query to take count and find most likely
  • From: Jordan
• Re: Combining Fields
  • From: Bob Barrows [MVP]
• RE: query to sort nos
  • From: KARL DEWEY
• Re: Query to take count and find most likely
  • From: Klatuu
• Re: Combining Fields
  • From: Student Databaser
• Re: Query to take count and find most likely
  • From: John Spencer
• RE: Query to take count and find most likely
  • From: Klatuu
• RE: query to sort nos
  • From: KARL DEWEY
• Query to take count and find most likely
  • From: Jordan
• Re: Nearest matching date value
  • From: John Spencer
• Re: Access 2007 - Cannot open database.
  • From: John Spencer
• Re: I added an Iif statement to a query now it returns nothing
  • From: Bob Barrows [MVP]
• Re: Sort out earliest date
  • From: vitality via AccessMonster.com
• Re: filter a query
  • From: gibsol
• Nearest matching date value
  • From: Pam80
• Re: query to sort data
  • From: Allen Browne
• query to sort nos
  • From: cliff
• Re: query to sort data
  • From: cliff
• I added an Iif statement to a query now it returns nothing
  • From: MS_Access_Neophyte
• Re: Sort out earliest date
  • From: Allen Browne
• Sort out earliest date
  • From: vitality
• RE: Last date in a date range
  • From: Ken Sheridan
• Re: query to sort data
  • From: Allen Browne
• Re: Directions to Resources
  • From: Allen Browne
• Re: Posting Calculated Data to a Table
  • From: Jeff Boyce
• Re: How to calculate an accumulated balance
  • From: Laxanh via AccessMonster.com
• query to sort data
  • From: cliff
• Re: Adding items from another query in a form
  • From: MGFoster
• Re: random number generator
  • From: John W . Vinson/MVP
• Re: Posting Calculated Data to a Table
  • From: Marshall Barton
• Posting Calculated Data to a Table
  • From: Sean Bishop
• Re: How to calculate an accumulated balance
  • From: Marshall Barton
• Re: New query in front-end: " is not a valid name
  • From: bcap
• Re: New query in front-end: " is not a valid name
  • From: PattiB
• Re: How to calculate an accumulated balance
  • From: Laxanh
• Re: Update data in linked tables, How? (One==>Many relation)
  • From: Rick Brandt
• Re: How to calculate an accumulated balance
  • From: Marshall Barton
• How to calculate an accumulated balance
  • From: Laxanh
• Re: New query in front-end: " is not a valid name
  • From: bcap
• Re: New query in front-end: " is not a valid name
  • From: PattiB
• Re: New query in front-end: " is not a valid name
  • From: PattiB
• Re: New query in front-end: " is not a valid name
  • From: Bob Barrows [MVP]
• Re: New query in front-end: " is not a valid name
  • From: Jeff Boyce
• Re: Recognizing Concurrent Users
  • From: smartin
• Re: New query in front-end: " is not a valid name
  • From: PattiB
• Re: New query in front-end: " is not a valid name
  • From: Jeff Boyce
• Re: Null Expression
  • From: Bob Barrows [MVP]
• Re: Sorting in Access 2K
  • From: John Spencer
• Re: count off
  • From: John Spencer
• Re: Unwanted multiplication
  • From: John Spencer
• Re: Null Expression
  • From: Steve
• Re: Recognizing Concurrent Users
  • From: H0MELY
• New query in front-end: " is not a valid name
  • From: PattiB
• Re: Null Expression
  • From: Bob Barrows [MVP]
• RE: Last date in a date range
  • From: KARL DEWEY
• Last date in a date range
  • From: woods1119
• RE: Query Help Again
  • From: KARL DEWEY
• Re: Null Expression
  • From: Bob Barrows [MVP]
• Re: Null Expression
  • From: Steve
• Re: Null Expression
  • From: Bob Barrows [MVP]
• Re: Null Expression
  • From: Steve
• Re: Access records from table
  • From: FindSolution
• Re: How to Calculate days since a date
  • From: Jeff Boyce
• Re: Null Expression
  • From: Bob Barrows [MVP]
• Re: Null Expression
  • From: Jeff Boyce
• RE: Append to table with 2 fields in Primary Key - last is an autonumb
  • From: John D
• Re: Unwanted multiplication
  • From: Diogo
• Re: Pickup numbers from a field
  • From: raskew via AccessMonster.com
• Re: Unwanted multiplication
  • From: Diogo
• Re: random number generator
  • From: Marshall Barton
• Re: random number generator
  • From: raskew via AccessMonster.com
• Re: Numeric Field Overflow
  • From: KWhamill
• Re: Null Expression
  • From: Jeff Boyce
• Re: I'm out of ideas. Help please
  • From: Bob Barrows [MVP]
• Null Expression
  • From: Steve
• Re: How can I do this??
  • From: Marco Silva
• Re: Pickup numbers from a field
  • From: CAM
• Re: DSum - running total
  • From: bcap
• Re: Sum in Query
  • From: Allen Browne
• Re: Pickup numbers from a field
  • From: Stefan Hoffmann
• Pickup numbers from a field
  • From: CAM
• Re: MSACCESS 97 APPLICATION ERROR CONVERTING FROM TEXT TO MEMO
  • From: David W. Fenton
• Re: MSACCESS 97 APPLICATION ERROR CONVERTING FROM TEXT TO MEMO
  • From: David W. Fenton
• Re: Update query.
  • From: smartin
• Re: Recognizing Concurrent Users
  • From: smartin
• Re: Value over ride in Query, Choose the highest value in Query, need
  • From: Marshall Barton
• RE: How do I subtract a date w/ time from a previous date with tim
  • From: Biederboat
• Re: OUTLOOK 2007 Address book nightmare
  • From: John W . Vinson/MVP
• RE: How do I subtract a date w/ time from a previous date with tim
  • From: Klatuu
• Re: cross tabg query
  • From: ANDY-N via AccessMonster.com
• Re: cross tabg query
  • From: ANDY-N via AccessMonster.com
• Re: Value over ride in Query, Choose the highest value in Query, need
  • From: ANDY-N via AccessMonster.com
• Cannot delete from 1 side if no mathing on many side
  • From: Song
• Re: How can I do this??
  • From: John W . Vinson/MVP
• How do I subtract a date w/ time from a previous date with time
  • From: Biederboat
• Re: tie multiple values from second table to first table
  • From: John W . Vinson/MVP
• cross tabg query
  • From: JRS
• Re: IIf statement with a Nz
  • From: Todd
• Re: Delete Last Months Data From Table
  • From: MJ
• days of occupancy
  • From: Georgie047
• Convert text to number
  • From: Kristl via AccessMonster.com
• Re: Delete Last Months Data From Table
  • From: MJ
• Re: MSACCESS 97 APPLICATION ERROR CONVERTING FROM TEXT TO MEMO
  • From: Bird_e_boy
• Re: Linked Query not Updateable
  • From: John W . Vinson/MVP
• Re: Sorting in Access 2K
  • From: John W . Vinson/MVP
• Re: Delete Last Months Data From Table
  • From: John W . Vinson/MVP
• Re: Delete Last Months Data From Table
  • From: Bob Barrows [MVP]
• RE: Linked Query not Updateable
  • From: Golfinray
• Re: Access records from table
  • From: raskew via AccessMonster.com
• Re: Access Queries
  • From: bhicks11 via AccessMonster.com
• Re: Delete Last Months Data From Table
  • From: raskew via AccessMonster.com
• Re: Delete Last Months Data From Table
  • From: ANDY-N via AccessMonster.com
• Sorting in Access 2K
  • From: Tony
• Re: IIf statement with a Nz
  • From: Allen Browne
• Re: Delete Last Months Data From Table
  • From: MJ
• Re: IIf statement with a Nz
  • From: Todd
• Re: Approximation of Values
  • From: Allen Browne
• Re: count off
  • From: JRS
• Re: filter a query
  • From: John W . Vinson/MVP
• Re: hh:mm to seconds from midnight
  • From: John W . Vinson/MVP
• Re: Delete Last Months Data From Table
  • From: Bob Barrows [MVP]
• RE: Type mismatch in a criteria that used to work
  • From: RobD
• Re: Type mismatch in a criteria that used to work
  • From: RobD
• Re: Sum on Head Count data wrong
  • From: albert . repasky
• Re: hh:mm to seconds from midnight
  • From: quinto via AccessMonster.com
• Re: hh:mm to seconds from midnight
  • From: John Spencer
• Re: Update query.
  • From: John Spencer
• Re: Numeric Field Overflow
  • From: John Spencer
• Re: Days between entries
  • From: KateB
• Re: Report returns id-numbers instead of text from query
  • From: Ed Jordan
• Re: hh:mm to seconds from midnight
  • From: quinto via AccessMonster.com
• Re: hh:mm to seconds from midnight
  • From: quinto via AccessMonster.com
• Re: Access's 'Left' function not working properly
  • From: Keke Lee
• Re: IIf statement with a Nz
  • From: Allen Browne
• RE: IIf statement with a Nz
  • From: Todd
• IIf statement with a Nz
  • From: Todd
• Re: Access query expression issue
  • From: John W . Vinson/MVP
• Re: Counting within a Query
  • From: John W . Vinson/MVP
• Re: Report returns id-numbers instead of text from query
  • From: Ed Jordan
• Re: Numeric Field Overflow
  • From: Chris O'C via AccessMonster.com
• Access query expression issue
  • From: angela . gay
• Re: Report returns id-numbers instead of text from query
  • From: John W . Vinson/MVP
• Re: Query for not 0
  • From: Martin
• Re: Query for not 0
  • From: pietlinden@xxxxxxxxxxx
• Re: Query for not 0
  • From: Martin
• Re: Query for not 0
  • From: Jeff Boyce
• Re: undefined function 'chr' in expresssion
  • From: Upfielddoc
• Query for not 0
  • From: Martin
• Re: undefined function 'chr' in expresssion
  • From: John Spencer
• Re: wildcard searches
  • From: John Spencer
• RE: Eliminating Duplicates via Queries
  • From: Vylent Fyre
• Re: count off
  • From: John Spencer
• Re: Update query / Operation must use an updateable query error me
  • From: Graeme
• Re: Eliminating Duplicates via Queries
  • From: Vylent Fyre
• Re: Eliminating Duplicates via Queries
  • From: NuBie via AccessMonster.com
• undefined function 'chr' in expresssion
  • From: Upfielddoc
• Re: count off
  • From: JRS
• Re: Last 6 months but not last years data
  • From: gregatvrm
• Eliminating Duplicates via Queries
  • From: Vylent Fyre
• Re: count off
  • From: Jeff Boyce
• Re: Quering between 2 large tables involving wildcards
  • From: Bob Dancer
• RE: select a criteria's parameter from a combo box on a form
  • From: NuBie via AccessMonster.com
• Re: Last 6 months but not last years data
  • From: John Spencer
• Re: Putting records in horizontal line
  • From: ANDY-N via AccessMonster.com
• Re: UNION Query
  • From: John Spencer
• RE: select a criteria's parameter from a combo box on a form
  • From: NuBie via AccessMonster.com
• Re: Update query / Operation must use an updateable query error me
  • From: John Spencer
• Re: Month date offset query
  • From: Cesare
• Re: Days between entries
  • From: John Spencer
• Re: rst loop versus For Each
  • From: Nicky
• RE: Query returning many duplicate records
  • From: NuBie via AccessMonster.com
• RE: select a criteria's parameter from a combo box on a form
  • From: fossy
• RE: Help with Union
  • From: Nathan
• RE: Help with Union
  • From: Jerry Whittle
• Re: Make Table Query creates wrong field types...
  • From: John
• RE: select a criteria's parameter from a combo box on a form
  • From: Ryan
• select a criteria's parameter from a combo box on a form
  • From: fossy
• Re: have productids that don't have sales & saleof products not on pro
  • From: Marshall Barton
• RE: Last 6 months but not last years data
  • From: gregatvrm
• RE: Query returning many duplicate records
  • From: Ryan
• Sum on Head Count data wrong
  • From: albert . repasky
• Re: Days between entries
  • From: dustinbrearton via AccessMonster.com
• Re: Days between entries
  • From: dustinbrearton via AccessMonster.com
• Re: Iff statement - current or expired contracts
  • From: Chey
• RE: Query returning many duplicate records
  • From: Roberto
• RE: have productids that don't have sales & saleof products not on
  • From: babs
• Re: UNION Query
  • From: VJ
• RE: have productids that don't have sales & saleof products not on pro
  • From: Ryan
• RE: Query returning many duplicate records
  • From: Ryan
• RE: Query returning many duplicate records
  • From: Roberto
• Re: Data Collection from Two tables
  • From: Bob Barrows [MVP]
• Re: Update query / Operation must use an updateable query error me
  • From: Graeme
• RE: Data Collection from Two tables
  • From: Ryan
• Data Collection from Two tables
  • From: Lisa
• Re: Iff statement - current or expired contracts
  • From: John Spencer
• Re: UNION Query
  • From: John Spencer
• Re: Update query / Operation must use an updateable query error messag
  • From: John Spencer
• Slow running queries/macro
  • From: blavine
• Re: Limit query to one result
  • From: John Spencer
• RE: Iff statement - current or expired contracts
  • From: Dennis
• Re: Limit query to one result
  • From: Stickman64
• UNION Query
  • From: VJ
• Re: max. # of "AND operator" in criteria
  • From: sb2008
• Re: max. # of "AND operator" in criteria
  • From: Marshall Barton
• Re: Is there a way to make positive numbers appear as +XX ?
  • From: MC
• Re: max. # of "AND operator" in criteria
  • From: John Spencer
• Update query / Operation must use an updateable query error messag
  • From: Graeme
• Days between entries
  • From: KateB
• RE: Complex group and sort query to find top record for each group
  • From: pb100
• Re: Is there a way to make positive numbers appear as +XX ?
  • From: Bob Barrows [MVP]
• RE: Parameters in Query
  • From: Rus925
• Re: Is there a way to make positive numbers appear as +XX ?
  • From: John Spencer
• max. # of "AND operator" in criteria
  • From: sb2008
• Re: hh:mm to seconds from midnight
  • From: John Spencer
• Re: Is there a way to make positive numbers appear as +XX ?
  • From: Bob Barrows [MVP]
• Complex group and sort query to find top record for each group
  • From: pb100
• Is there a way to make positive numbers appear as +XX ?
  • From: MC
• Re: Union Query Based on Two Crosstab Queries
  • From: Bob Barrows [MVP]
• Re: Dividing by zero in a calculated field of a query
  • From: Bob Barrows [MVP]
• Re: Dividing by zero in a calculated field of a query
  • From: MC
• Re: Union Query Based on Two Crosstab Queries
  • From: ryguy7272
• Configureable Query or otherwise
  • From: dustinbrearton via AccessMonster.com
• Re: Access's 'Left' function not working properly
  • From: Bob Barrows [MVP]
• Re: Report returns id-numbers instead of text from query
  • From: Ed Jordan
• Re: Report returns id-numbers instead of text from query
  • From: John W . Vinson/MVP
• Re: Access's 'Left' function not working properly
  • From: Keke Lee
• RE: Calculation wrong in sum query
  • From: HeatherD25
• Re: Changing text field to Date
  • From: metalone
• Re: Time in 30-minute increments
  • From: Allen Browne
• Re: Display Relationship Name so I can drop it
  • From: Alan Rose
• Re: Display Relationship Name so I can drop it
  • From: Alan Rose
• Re: Display Relationship Name so I can drop it
  • From: Chris O'C via AccessMonster.com
• Re: Display Relationship Name so I can drop it
  • From: John W . Vinson/MVP
• Re: Parameters in Query
  • From: John W . Vinson/MVP
• Re: hh:mm to seconds from midnight
  • From: John W . Vinson/MVP
• Re: Parameters in Query
  • From: Bob Barrows [MVP]
• Re: Query records that expire (date) in XX days
  • From: smartin
• Display Relationship Name so I can drop it
  • From: Alan Rose
• Re: A tricky select Query for me
  • From: Bob Barrows [MVP]
• Re: A tricky select Query for me
  • From: John Spencer
• hh:mm to seconds from midnight
  • From: quinto via AccessMonster.com
• Re: Type mismatch in a criteria that used to work
  • From: John Spencer
• Changing text field to Date
  • From: metalone
• Re: Changing text field to Date
  • From: John W . Vinson/MVP
• Re: ID numbers in Access records.
  • From: John W . Vinson/MVP
• Re: Make Table Query creates wrong field types...
  • From: John W . Vinson/MVP
• Re: Make Table Query creates wrong field types...
  • From: John W . Vinson/MVP
• Re: Changing text field to Date
  • From: Jeff Boyce
• Re: Make Table Query creates wrong field types...
  • From: John
• Re: Time in 30-minute increments
  • From: John W . Vinson/MVP
• Re: Union Query Based on Two Crosstab Queries
  • From: ryguy7272
• Re: Union Query Based on Two Crosstab Queries
  • From: Bob Barrows [MVP]
• Re: error msg
  • From: John W . Vinson/MVP
• Re: Approximation of Calculated Field
  • From: John W . Vinson/MVP
• Re: Make Table Query creates wrong field types...
  • From: John W . Vinson/MVP
• Re: Time in 30-minute increments
  • From: Michel Walsh
• Re: Getting a null value to display zero in count query
  • From: Michel Walsh
• Re: Sum by week
  • From: Michel Walsh
• RE: Overflow from Calculation - How do I do Calculation?
  • From: Klatuu
• RE: Overflow from Calculation - How do I do Calculation?
  • From: Vylent Fyre
• Re: Dividing by zero in a calculated field of a query
  • From: Bob Barrows [MVP]
• RE: Overflow from Calculation - How do I do Calculation?
  • From: Klatuu
• Re: Removing "As" Clauses
  • From: Bob Barrows [MVP]
• Re: Parameter Not Working
  • From: Bob Barrows [MVP]
• RE: Overflow from Calculation - How do I do Calculation?
  • From: Vylent Fyre
• RE: Overflow from Calculation - How do I do Calculation?
  • From: Klatuu
• RE: Calculation wrong in sum query
  • From: Klatuu
• RE: Overflow from Calculation - How do I do Calculation?
  • From: Vylent Fyre
• RE: Calculation wrong in sum query
  • From: HeatherD25
• Re: group by weekly date
  • From: dustinbrearton
• Re: prevent redundacy in append query
  • From: dandydan9
• group by weekly date
  • From: JRS
• Dividing by zero in a calculated field of a query
  • From: MC
• RE: Calculation wrong in sum query
  • From: Klatuu
• RE: Overflow from Calculation - How do I do Calculation?
  • From: Klatuu
• Re: A tricky select Query for me
  • From: Bob Barrows [MVP]
• RE: Approximation of Calculated Field
  • From: Jerry Whittle
• Re: Why do I have to enter my password everytime I open Access?
  • From: KK
• Re: A tricky select Query for me
  • From: Jeff Boyce
• RE: Query based on two unrelated tables
  • From: ryguy7272
• RE: Calculation wrong in sum query
  • From: HeatherD25
• Re: prevent redundacy in append query
  • From: Amod
• RE: Overflow from Calculation - How do I do Calculation?
  • From: Vylent Fyre
• Re: prevent redundacy in append query
  • From: Jeff Boyce
• RE: Calculation wrong in sum query
  • From: Klatuu
• RE: error msg
  • From: Klatuu
• Re: Concatenate number w/decimal with ascii character
  • From: ShoeHo65
• RE: Overflow from Calculation - How do I do Calculation?
  • From: Klatuu
• Re: Pull Data from Multiple CSV's
  • From: Eskimo
• RE: Calculation wrong in sum query
  • From: Klatuu
• Re: Concatenate number w/decimal with ascii character
  • From: Marshall Barton
• Re: Why do I have to enter my password everytime I open Access?
  • From: Armen Stein
• Re: prevent redundacy in append query
  • From: Amod
• Re: prevent redundacy in append query
  • From: Stefan Hoffmann
• Re: prevent redundacy in append query
  • From: Jeff Boyce
• Concatenate number w/decimal with ascii character
  • From: ShoeHo65
• Re: Pull Data from Multiple CSV's
  • From: Jeff Boyce
• Re: Type mismatch in a criteria that used to work
  • From: Bob Barrows [MVP]
• export query data to excel to create a mailer
  • From: Amy Schmid
• Why do I have to enter my password everytime I open Access?
  • From: KK
• Re: Pull Data from Multiple CSV's
  • From: pietlinden@xxxxxxxxxxx
• Re: Make Table Query creates wrong field types...
  • From: John
• Query Criteria With Prompt
  • From: Michael
• Re: Type mismatch in a criteria that used to work
  • From: John Spencer
• Re: Calculating in Queries
  • From: John Spencer
• Re: undefined name in pass-through query
  • From: Brendan Reynolds
• Re: Calculation Query
  • From: John W . Vinson/MVP
• Re: Executing a make-table query using multiple primary keys
  • From: david
• Re: Average Calculation
  • From: Jeff Boyce
• Re: Pull Data from Multiple CSV's
  • From: Jeff Boyce
• Re: Pull Data from Multiple CSV's
  • From: pietlinden@xxxxxxxxxxx
• Re: Type mismatch in a criteria that used to work
  • From: Bob Barrows [MVP]
• RE: Type mismatch in a criteria that used to work
  • From: Jerry Whittle
• Re: Pull Data from Multiple CSV's
  • From: Jeff Boyce
• Re: Type mismatch in a criteria that used to work
  • From: RobD
• Re: Type mismatch in a criteria that used to work
  • From: Bob Barrows [MVP]
• undefined name in pass-through query
  • From: Angie
• RE: Type mismatch in a criteria that used to work
  • From: RobD
• Re: Type mismatch in a criteria that used to work
  • From: Bob Barrows [MVP]
• Re: Calculating in Queries
  • From: Jeff Boyce
• Re: Datasheet view
  • From: Jeff Boyce
• Re: Cannot have aggregate function in expression
  • From: Jeff Boyce
• Re: Parameter Query?
  • From: Hank
• Cannot have aggregate function in expression
  • From: Love Buzz
• Re: Executing a make-table query using multiple primary keys
  • From: NOTdbRanger
• RE: Why doesn't this code from the Access Help menu work??
  • From: Dale Fye
• RE: Calculating in Queries
  • From: Klatuu
• Re: Executing a make-table query using multiple primary keys
  • From: Jeff Boyce
• Re: Calculating in Queries
  • From: Stefan Hoffmann
• Datasheet view
  • From: Jasper Recto
• Why doesn't this code from the Access Help menu work??
  • From: Edward
• Re: select fiscal year on a query
  • From: Allen Browne
• RE: Query Writing Question
  • From: pfm721
• Re: Subquery to return distinct count
  • From: John Spencer
• Re: Sum Query
  • From: John Spencer
• Re: Access's 'Left' function not working properly
  • From: Bob Barrows [MVP]
• Re: Subquery to return distinct count
  • From: Bob Barrows [MVP]
• Re: Subquery to return distinct count
  • From: steve dassin
• Re: Subquery to return distinct count
  • From: Stefan Hoffmann
• RE: Show true "repeated" entries
  • From: "Charles Wang [MSFT]"
• Re: Index Name(s)
  • From: Allen Browne
• Index Name(s)
  • From: easoftware
• Re: Executing a make-table query using multiple primary keys
  • From: david
• Re: Access's 'Left' function not working properly
  • From: Keke Lee
• Re: need help with query
  • From: John W . Vinson/MVP
• Re: need help with query
  • From: nishkrish
• Re: Help with Query for new user
  • From: Meredith9053
• Re: need help with query
  • From: John W . Vinson/MVP
• Re: Make Table Query creates wrong field types...
  • From: John W . Vinson/MVP
• Re: Make Table Query creates wrong field types...
  • From: Chris O'C via AccessMonster.com
• Make Table Query creates wrong field types...
  • From: John
• Re: Parameter Query?
  • From: Bob Barrows [MVP]
• Re: Parameter Query?
  • From: Bob Barrows [MVP]
• Re: Parameter Query?
  • From: Bob Barrows [MVP]
• Re: Vlookup type function
  • From: John W . Vinson/MVP
• Re: Parameter Query?
  • From: Hank
• Re: Parameter Query?
  • From: Bob Barrows [MVP]
• Re: Parameter Query?
  • From: Hank
• Re: Parameter Query?
  • From: Bob Barrows [MVP]
• Re: Calculating the Number of Days between two dates
  • From: raskew via AccessMonster.com
• Re: Calculating the Number of Days between two dates
  • From: Damon Heron
• Re: Parameter Query?
  • From: Hank
• Re: Searching field for Text and Numbers
  • From: Bob Barrows [MVP]
• Re: Parameter Query?
  • From: Bob Barrows [MVP]
• Re: Convert number to time
  • From: Bob Barrows [MVP]
• Parameter Query?
  • From: Hank
• Re: Date Range in Crosstab query
  • From: Allen Browne
• Convert number to time
  • From: Floyd Forbes
• Re: Select query not allowing change
  • From: mav51 via AccessMonster.com
• Re: Equivalent of DROP TABLE IF EXIST?
  • From: Mike Walsh
• Re: Equivalent of DROP TABLE IF EXIST?
  • From: Bob Barrows [MVP]
• Re: Select query not allowing change
  • From: mav51 via AccessMonster.com
• Re: Select query not allowing change
  • From: Dale Fye
• Select query not allowing change
  • From: mav51 via AccessMonster.com
• RE: Crosstab Query shows age 1,2,3,4,5 etc totals, I want 1-2,3-5,
  • From: raskew via AccessMonster.com
• Re: Corrected divide by zero errors, now no formatting of numbers
  • From: Allen Browne
• Re: Equivalent of DROP TABLE IF EXIST?
  • From: Mike Walsh
• Re: Query help needed
  • From: fredg
• Query help needed
  • From: dave
• Re: Error 3071 for dates after July 3 2008
  • From: David W. Fenton
• RE: Update Query - One Field, Mutiple Posibilities...
  • From: John
• RE: Update Query - One Field, Mutiple Posibilities...
  • From: KARL DEWEY
• RE: Update Query - One Field, Mutiple Posibilities...
  • From: John
• RE: Update Query - One Field, Mutiple Posibilities...
  • From: KARL DEWEY
• Re: Sum by week
  • From: louisjohnphillips
• Update Query - One Field, Mutiple Posibilities...
  • From: John
• RE: Union Query
  • From: KARL DEWEY
• Re: Delete Related records
  • From: John Spencer
• Re: Equivalent of DROP TABLE IF EXIST?
  • From: Bob Barrows [MVP]
• RE: Rank after Sort
  • From: KARL DEWEY
• RE: Union Query
  • From: broncojim
• RE: Union Query
  • From: Golfinray
• RE: Equivalent of DROP TABLE IF EXIST?
  • From: Jerry Whittle
• Re: Executing a make-table query using multiple primary keys
  • From: NOTdbRanger
• Rank after Sort
  • From: CJ
• Equivalent of DROP TABLE IF EXIST?
  • From: Mike Walsh
• Re: joining on dates
  • From: Bob Barrows [MVP]
• Re: Sum by week
  • From: Jasper Recto
• Re: Query to show all records of one table and updated info from a
  • From: Marshall Barton
• Re: Limit query to one result
  • From: Stickman64
• Re: joining on dates
  • From: joemeshuggah
• Delete Related records
  • From: stvlai
• Re: Query to show all records of one table and updated info from a
  • From: Bob Dancer
• Re: Query to show all records of one table and updated info from anoth
  • From: Marshall Barton
• Re: joining on dates
  • From: Bob Barrows [MVP]
• Re: joining on dates
  • From: Jeff Boyce
• Re: Error 3071 for dates after July 3 2008
  • From: Ary
• Re: Display parameter used for query
  • From: Pyrite
• Re: Quering between 2 large tables involving wildcards
  • From: ANDY-N via AccessMonster.com
• Re: Display parameter used for query
  • From: louisjohnphillips
• Re: Unwanted multiplication
  • From: Michel Walsh
• Re: Sum by week
  • From: louisjohnphillips
• Sum by week
  • From: Jasper Recto
• RE: Show true "repeated" entries
  • From: J Sedoff
• Re: Unwanted multiplication
  • From: pietlinden@xxxxxxxxxxx
• Unwanted multiplication
  • From: Diogo
• Re: Vlookup type function
  • From: Allen Browne
• Re: DateDiff function
  • From: Allen Browne
• Re: Access's 'Left' function not working properly
  • From: Bob Barrows [MVP]
• Re: Update Query
  • From: pietlinden@xxxxxxxxxxx
• Re: Update Query combine two functions
  • From: Darmahart
• Re: Update Query combine two functions
  • From: John W . Vinson/MVP
• RE: Show true "repeated" entries
  • From: "Charles Wang [MSFT]"
• Re: Hard to explain - multiple update fields query...
  • From: John Spencer
• Re: Error 3071 for dates after July 3 2008
  • From: David W. Fenton
• RE: Union Query
  • From: Royce Schnepp
• RE: Union Query
  • From: KARL DEWEY
• Re: 2 fields of different lenghts
  • From: Jeff Boyce
• RE: Union Query
  • From: Royce Schnepp
• RE: dateadd conditional formating to equal yes or no
  • From: Todd
• Re: extract part of a text value into a date
  • From: louisjohnphillips
• Re: Hard to explain - multiple update fields query...
  • From: David Mulholland
• RE: query based on different devices
  • From: KARL DEWEY
• Re: query based on different devices
  • From: Jeff Boyce
• RE: append query question
  • From: PattiP
• Left Join Query
  • From: Danu
• Re: Error 3071 for dates after July 3 2008
  • From: Ary
• Re: Parameter Queries
  • From: bhicks11 via AccessMonster.com
• RE: append query question
  • From: KARL DEWEY
• Re: append query question
  • From: PattiP
• Re: Parameter Queries
  • From: alecgreen
• Re: Need help with calculation
  • From: Bob Barrows [MVP]
• Re: IIF statement failing
  • From: Hank
• Re: Need help with calculation
  • From: Gary F Shelton
• Re: Update Query for Fiscal Date range
  • From: John W . Vinson/MVP
• Re: Executing a make-table query using multiple primary keys
  • From: Jeff Boyce
• RE: Show true "repeated" entries
  • From: J Sedoff
• Re: Limit query to one result
  • From: John Spencer
• Update Query
  • From: Greg
• RE: Show true "repeated" entries
  • From: Golfinray
• Re: Query an Asterisk in the description
  • From: Allen Browne
• Re: Error 3071 for dates after July 3 2008
  • From: Allen Browne
• Re: Update Query for Fiscal Date range
  • From: John Spencer
• Re: Error when creating make tables
  • From: John Spencer
• Re: Error 3071 for dates after July 3 2008
  • From: Ary
• RE: Show items not null
  • From: mattc66 via AccessMonster.com
• Re: Error 3071 for dates after July 3 2008
  • From: Allen Browne
• Re: Executing a make-table query using multiple primary keys
  • From: NOTdbRanger
• Re: IIF statement failing
  • From: Jeff Boyce
• Re: Error 3071 for dates after July 3 2008
  • From: Ary
• Re: Error 3071 for dates after July 3 2008
  • From: Ary
• IIF statement failing
  • From: Hank
• RE: Union Query
  • From: KARL DEWEY
• Show true "repeated" entries
  • From: J Sedoff
• Re: Passing value to Query Criteria from a ListBox
  • From: bhicks11 via AccessMonster.com
• Re: Passing value to Query Criteria from a ListBox
  • From: Atif
• Re: name error
  • From: Allen Browne
• Compound Select
  • From: JimS
• Re: Parameter Queries
  • From: bhicks11 via AccessMonster.com
• Re: Help with Query for new user
  • From: Bob Barrows [MVP]
• Re: update all records in table
  • From: Michel Walsh
• Re: Limit query to one result
  • From: Stickman64
• Re: Help with Query for new user
  • From: Meredith9053
• Re: Hard to explain - multiple update fields query...
  • From: David Mulholland
• Re: update all records in table
  • From: APINDARA via AccessMonster.com
• Re: Select records from 6 combo boxes
  • From: Al Campagna
• Re: Hard to explain - multiple update fields query...
  • From: John Spencer
• Parameter Queries
  • From: alecgreen
• Re: Convert column Data Type
  • From: Alastair MacFarlane
• Re: Query Help
  • From: pietlinden@xxxxxxxxxxx
• Re: Error 3071 for dates after July 3 2008
  • From: Allen Browne
• Re: Grouping
  • From: Greg
• Re: Help with a query
  • From: John W . Vinson/MVP
• Re: Hard to explain - multiple update fields query...
  • From: pietlinden@xxxxxxxxxxx
• Re: Hard to explain - multiple update fields query...
  • From: John Spencer
• Re: Need help on a Query Calculation
  • From: John Spencer
• Re: Limit query to one result
  • From: John Spencer
• Re: Executing a make-table query using multiple primary keys
  • From: Jeff Boyce
• Re: Getting a query to accept a null value
  • From: TESA0_4
• Re: Show items not null
  • From: Marshall Barton
• Re: Passing value to Query Criteria from a ListBox
  • From: bhicks11 via AccessMonster.com
• Re: Hard to explain - multiple update fields query...
  • From: KARL DEWEY
• Re: append query question
  • From: louisjohnphillips
• Show items not null
  • From: mattc66 via AccessMonster.com
• Re: query numeric values from text
  • From: Jeff Boyce
• Re: Hard to explain - multiple update fields query...
  • From: David Mulholland
• RE: select Statement w/i inner joins
  • From: ToniS
• RE: Hard to explain - multiple update fields query...
  • From: David Mulholland
• Re: Grouping
  • From: John Spencer
• Re: Hard to explain - multiple update fields query...
  • From: John Spencer
• Re: select Statement w/i inner joins
  • From: Bob Barrows [MVP]
• RE: Update query that is updating fields not included in any state
  • From: Todd
• Re: select Statement w/i inner joins
  • From: ToniS
• RE: Doesn't recognize Crosstab gen Fields
  • From: KARL DEWEY
• Re: Limit query to one result
  • From: Bob Barrows [MVP]
• Re: select Statement w/i inner joins
  • From: Bob Barrows [MVP]
• RE: Doesn't recognize Crosstab gen Fields
  • From: KARL DEWEY
• select Statement w/i inner joins
  • From: ToniS
• Grouping
  • From: Greg
• Re: Passing value to Query Criteria from a ListBox
  • From: bhicks11 via AccessMonster.com
• Re: Math calculation
  • From: Ac
• Re: Passing value to Query Criteria from a ListBox
  • From: Michel Walsh
• Re: access 2003 join not returning expected records
  • From: Michel Walsh
• Re: How do you substitue a value for #Error
  • From: Barry
• Re: query numeric values from text
  • From: John Spencer
• Re: query numeric values from text
  • From: Jeff Boyce
• Re: How do you substitue a value for #Error
  • From: John Spencer
• Re: CrossTab Help!
  • From: John Spencer
• Re: I need to subtract5 pallets allready inserted.
  • From: Bob Barrows [MVP]
• RE: Update query that is updating fields not included in any state
  • From: Jerry Whittle
• Re: Math calculation
  • From: Michel Walsh
• Re: insert syntax help required
  • From: Bob Barrows [MVP]
• Re: Passing value to Query Criteria from a ListBox
  • From: bhicks11 via AccessMonster.com
• RE: update all records in table
  • From: APINDARA
• Re: update all records in table
  • From: Michel Walsh
• RE: Doesn't recognize Crosstab gen Fields
  • From: Bonnie A
• Re: insert syntax help required
  • From: vandy
• update all records in table
  • From: APINDARA
• Re: I need to subtract pallets allready inserted.
  • From: Marco
• Re: How do you substitue a value for #Error
  • From: Barry
• Re: access 2003 join not returning expected records
  • From: Michel Walsh
• Re: CrossTab Help!
  • From: John
• Re: I need to subtract5 pallets allready inserted.
  • From: Michel Walsh
• Re: Math calculation
  • From: Michel Walsh
• Re: How do you substitue a value for #Error
  • From: Allen Browne
• Re: CrossTab Help!
  • From: John Spencer
• How do you substitue a value for #Error
  • From: Barry
• RE: Doesn't recognize Crosstab gen Fields
  • From: KARL DEWEY
• Re: insert syntax help required
  • From: Bob Barrows [MVP]
• Re: insert syntax help required
  • From: Carl Rapson
• Re: help needed with date expression
  • From: Allen Browne
• Re: Unique Values blanking out a text field
  • From: Allen Browne
• Re: CrossTab Help!
  • From: John
• help needed with date expression
  • From: Slez via AccessMonster.com
• Re: Please help with Query Criteria
  • From: Please Help
• Re: Suming numbers and text together
  • From: Adam
• Re: Aceess 2003 Query using NOT operator?
  • From: Bob Barrows [MVP]
• Re: Aceess 2003 Query using NOT operator?
  • From: Bob Barrows [MVP]
• Re: Getting a query to accept a null value
  • From: John Spencer
• Re: Aceess 2003 Query using NOT operator?
  • From: Bob Barrows [MVP]
• Re: Aceess 2003 Query using NOT operator?
  • From: Rick Brandt
• Re: CrossTab Help!
  • From: John Spencer
• Re: Numeric Field Overflow from Excel File to new Table in Access
  • From: John Spencer
• Re: Help with Query for new user
  • From: pietlinden@xxxxxxxxxxx
• Re: How do I modify a query and consolidate data?
  • From: Rob Parker
• Re: Please help with Query Criteria
  • From: John W. Vinson/MVP
• Re: Public string var as criteria for query?
  • From: MGFoster
• Help with Query for new user
  • From: Meredith9053
• How do I modify a query and consolidate data?
  • From: Destiny
• Inconsistent return
  • From: LeAnn
• Re: SKUO11.CAB
  • From: haikal Pribadi
• Re: Optimizing my query using MAX
  • From: MGFoster
• Query Property sheet
  • From: BBran
• Re: Calculating difference in time between one record and the next
  • From: Bob Barrows [MVP]
• Re: Calculating difference in time between one record and the next
  • From: billmahon
• Re: Numeric Field Overflow from Excel File to new Table in Access
  • From: Ron2006
• Re: Calculating difference in time between one record and the next
  • From: ANDY-N via AccessMonster.com
• Calculating difference in time between one record and the next
  • From: billmahon
• Re: Inner Join SQL Help
  • From: Ray Todd Jr
• Re: Please help with Query Criteria
  • From: John W. Vinson/MVP
• Re: need help with append query
  • From: John Spencer
• Re: Factorial Function
  • From: Marshall Barton
• Re: Factorial Function
  • From: Jeff Boyce
• Re: Inner Join SQL Help
  • From: John Spencer
• RE: Update query that is updating fields not included in any state
  • From: Todd
• Re: Cross Join - Please Help!
  • From: John Spencer
• Re: Multiple IIf Statements Not Working
  • From: Ron2006
• Re: Multiple IIf Statements Not Working
  • From: AccessIM
• Re: Multiple IIf Statements Not Working
  • From: ANDY-N via AccessMonster.com
• Re: Suming numbers and text together
  • From: Marshall Barton
• Re: Suming numbers and text together
  • From: fredg
• Re: Multiple IIf Statements Not Working
  • From: Marshall Barton
• Re: Multiple IIf Statements Not Working
  • From: Ron2006
• Re: Multiple IIf Statements Not Working
  • From: ANDY-N via AccessMonster.com
• Re: Multiple IIf Statements Not Working
  • From: fredg
• Public string var as criteria for query?
  • From: Rich
• Inner Join SQL Help
  • From: Ray Todd Jr
• Update query that is updating fields not included in any statement
  • From: Todd
• Re: Passing value to Query Criteria from a ListBox
  • From: bhicks11 via AccessMonster.com
• RE: How do I query a query?
  • From: Golfinray
• Re: Convert column Data Type
  • From: Allen Browne
• Re: Calculating Period and Cumulative values...
  • From: Marshall Barton
• Re: Take data from table, make a list of unique values
  • From: KK
• Re: Calculating Period and Cumulative values...
  • From: John
• Re: Take data from table, make a list of unique values
  • From: pietlinden@xxxxxxxxxxx
• Take data from table, make a list of unique values
  • From: KK
• Re: Passing value to Query Criteria from a ListBox
  • From: bhicks11 via AccessMonster.com
• Re: Calculating Period and Cumulative values...
  • From: Allen Browne
• Re: VB Functions not found
  • From: Kevin
• Re: Delete characters up to a space
  • From: Allen Browne
• Re: VB Functions not found
  • From: Bob Barrows [MVP]
• Re: VB Functions not found
  • From: Kevin
• Re: Cross Join - Please Help!
  • From: MichaelR
• Re: need help with append query
  • From: DJTI via AccessMonster.com
• Re: VB Functions not found
  • From: Bob Barrows [MVP]
• Re: Nz problem
  • From: Silvio
• Re: Trying to merge multiple tables with access
  • From: Ron2006
• Re: Nz problem
  • From: John Spencer
• Re: Cross Join - Please Help!
  • From: John Spencer
• Re: Trying to merge multiple tables with access
  • From: Allen Browne
• Re: Format Value within iif statement
  • From: alecgreen
• Re: Trying to merge multiple tables with access
  • From: Jehuty26
• Re: Trying to merge multiple tables with access
  • From: Allen Browne
• Re: Format Value within iif statement
  • From: alecgreen
• Re: Query to update qty on insert in another table
  • From: bcap
• Trying to merge multiple tables with access
  • From: pierrickbe
• Re: Format Value within iif statement
  • From: pietlinden@xxxxxxxxxxx
• Format Value within iif statement
  • From: alecgreen
• Query to update qty on insert in another table
  • From: Daniel
• Re: Expression builder trouble
  • From: Allen Browne
• Re: Like and Multi-criteria with Multi-Values
  • From: Allen Browne
• Re: Nz problem
  • From: Silvio
• Re: Cross Join - Please Help!
  • From: louisjohnphillips
• Re: Group Totals in a Report
  • From: CDG via AccessMonster.com
• Re: VB Code -> Query
  • From: Douglas J. Steele
• Re: VB Code -> Query
  • From: pietlinden@xxxxxxxxxxx
• Re: Count queries -- make zeros show
  • From: Bob Barrows [MVP]
• Re: What's wrong with my IIF Statement?
  • From: raskew via AccessMonster.com
• Re: Count queries -- make zeros show
  • From: Bob Barrows [MVP]
• Re: Count queries -- make zeros show
  • From: kahaymon
• Re: What's wrong with my IIF Statement?
  • From: MB
• Re: Count queries -- make zeros show
  • From: kahaymon
• Re: dropdown decimal places
  • From: Marshall Barton
• Re: What's wrong with my IIF Statement?
  • From: Bob Barrows [MVP]
• Re: What's wrong with my IIF Statement?
  • From: MB
• Re: Nz problem
  • From: Jeff Boyce
• Re: Count queries -- make zeros show
  • From: Bob Barrows [MVP]
• Re: What's wrong with my IIF Statement?
  • From: Bob Barrows [MVP]
• Re: Multi-query issue
  • From: Antavas
• Re: What's wrong with my IIF Statement?
  • From: MB
• Re: What's wrong with my IIF Statement?
  • From: MB
• Re: What's wrong with my IIF Statement?
  • From: Bob Barrows [MVP]
• Re: What's wrong with my IIF Statement?
  • From: John Spencer
• Re: dropdown decimal places
  • From: bhicks11 via AccessMonster.com
• Re: Passing Parameter
  • From: Amy Blankenship
• Passing Parameter
  • From: Atif
• Re: Retrieving variable number of rows
  • From: Amy Blankenship
• Re: Retrieving variable number of rows
  • From: John Spencer
• Re: Nz problem
  • From: Jeff Boyce
• Retrieving variable number of rows
  • From: Amy Blankenship
• Re: Multi-query issue
  • From: Amy Blankenship
• Re: Multi-query issue
  • From: John Spencer
• Re: need help with append query
  • From: John Spencer
• Re: Newbie Question
  • From: strive4peace
• Re: Newbie Question
  • From: strive4peace
• Re: Like and Multi-criteria with Multi-Values
  • From: roccogrand
• RE: What to choose for value in crosstab
  • From: Susan L
• Re: Like and Multi-criteria with Multi-Values
  • From: roccogrand
• need help with append query
  • From: DJTI via AccessMonster.com
• Re: finding duplictes
  • From: Allen Browne
• finding duplictes
  • From: Dave Cullen
• RE: Formula and Table Joining in a Query
  • From: MichaelR
• Re: Adding new records with 3 relationships
  • From: Klatuu
• Re: Newbie Question
  • From: bmacrow
• Re: Newbie Question
  • From: bmacrow
• Re: Multiple Tables in single datagrid A97
  • From: Kahuna
• Re: Newbie Question
  • From: John Spencer
• Re: Multiple Tables in single datagrid A97
  • From: Bob Barrows [MVP]
• Multiple Tables in single datagrid A97
  • From: Kahuna
• Re: Newbie Question
  • From: bmacrow
• Re: Newbie Question
  • From: bmacrow
• Re: ANN: GNUstep Software Index is up and running
  • From: Jami Moilanen
• Re: Newbie Question
  • From: strive4peace
• Re: Text Based Queries
  • From: bcap
• Re: Like and Multi-criteria with Multi-Values
  • From: Allen Browne
• Re: running sum for hour and minute
  • From: strive4peace
• Re: Group Totals in a Report
  • From: CDG via AccessMonster.com
• Re: dropdown decimal places
  • From: bhicks11 via AccessMonster.com
• Re: dropdown decimal places
  • From: Marshall Barton
• running sum for hour and minute
  • From: inungh
• Re: Matching account numbers
  • From: bhicks11 via AccessMonster.com
• Re: dropdown decimal places
  • From: bhicks11 via AccessMonster.com
• Matching account numbers
  • From: CAM
• Re: Unexpected results when sorting multi-table query using toolbar button
  • From: JulieS
• Re: Unexpected results when sorting multi-table query using toolbar button
  • From: Allen Browne
• Re: Unexpected results when sorting multi-table query using toolbar button
  • From: JulieS
• Re: debugging query-forms
  • From: News Boy
• Re: Unexpected results when sorting multi-table query using toolbar button
  • From: JulieS
• Re: I need to build a query that asks for a record
  • From: John W . Vinson
• Re: Unexpected results when sorting multi-table query using toolbar button
  • From: Allen Browne
• Re: Group Totals in a Report
  • From: Marshall Barton
• Group Totals in a Report
  • From: CDG via AccessMonster.com
• Re: quartile function on access 2003
  • From: Marshall Barton
• Re: HELP WITH AGGREGATE FUNCTION
  • From: John Spencer
• Re: querying first record for each day
  • From: John Spencer
• Re: Undefine function?
  • From: Chris O'C via AccessMonster.com
• Undefine function?
  • From: CAM
• Re: T-shirt Sizes
  • From: pietlinden@xxxxxxxxxxx
• Re: More than one parameter
  • From: Pete D.
• Re: More than one parameter
  • From: Bob Barrows [MVP]
• Re: More than one parameter
  • From: ampickel
• Re: More than one parameter
  • From: Pete D.
• Unexpected results when sorting multi-table query using toolbar button
  • From: JulieS
• Re: More than one parameter
  • From: ampickel
• Re: Creating OR, AND query in access and getting parametrs frm access
  • From: pietlinden@xxxxxxxxxxx
• Re: More than one parameter
  • From: pietlinden@xxxxxxxxxxx
• Re: Counting in a query
  • From: RoBo
• Re: Counting in a query
  • From: Bob Barrows [MVP]
• Re: Counting in a query
  • From: RoBo
• Re: Counting in a query
  • From: Bob Barrows [MVP]
• Re: Reports and queries displayed on website
  • From: pietlinden@xxxxxxxxxxx
• Re: access 2003 join not returning expected records
  • From: pietlinden@xxxxxxxxxxx
• Re: debugging query-forms
  • From: louisjohnphillips
• Re: querying first record for each day
  • From: louisjohnphillips
• RE: Formula and Table Joining in a Query
  • From: KARL DEWEY
• RE: What to choose for value in crosstab
  • From: KARL DEWEY
• RE: Problem of dateAdd() function
  • From: KARL DEWEY
• RE: Formula and Table Joining in a Query
  • From: MichaelR
• Re: Adding new records with 3 relationships
  • From: albert . repasky
• Re: Problem of dateAdd() function
  • From: Amy Blankenship
• Problem of dateAdd() function
  • From: Luting
• RE: Dinamically Build a CrossTab
  • From: John
• debugging query-forms
  • From: News Boy
• RE: Dinamically Build a CrossTab
  • From: KARL DEWEY
• Re: append table query
  • From: Michel Walsh
• Dinamically Build a CrossTab
  • From: John
• Re: if statements in queries
  • From: bhicks11 via AccessMonster.com
• Re: Crosstab Query Multiple
  • From: Ben Pelech
• Re: if statements in queries
  • From: sandpking
• Re: Update from other fields
  • From: John Spencer
• Update from other fields
  • From: Student Databaser
• Re: Crosstab Query Multiple
  • From: Michel Walsh
• Re: Crosstab Query Multiple
  • From: Ben Pelech
• Re: Deleting all values in a field
  • From: Marshall Barton
• Re: Deleting all values in a field
  • From: Allen Browne
• Re: Crosstab Query Multiple
  • From: Ben Pelech
• RE: I need to build a query that asks for a record
  • From: Golfinray
• Access XP & 2003 - Analyze with Excel
  • From: CP
• Re: Crosstab Query Multiple
  • From: Michel Walsh
• Re: Crosstab
  • From: Michel Walsh
• Re: Get Distict records from a recordset multiple time using subqu
  • From: bhicks11 via AccessMonster.com
• Re: Get Distict records from a recordset multiple time using subquery
  • From: bhicks11 via AccessMonster.com
• Re: Crosstab
  • From: Ticotion
• Re: Sum Query Incorrect
  • From: Allen Browne
• Re: Remove text from a field
  • From: John Spencer
• Remove text from a field
  • From: StratfordWard
• Re: Customizing query fields based on form input
  • From: Rus925
• Re: Customizing query fields based on form input
  • From: Rus925
• Re: Crosstab Query Multiple
  • From: Ben Pelech
• Re: Customizing query fields based on form input
  • From: Michel Walsh
• Re: Crosstab Query Multiple
  • From: Michel Walsh
• Re: Sum Query Incorrect
  • From: NeonSky via AccessMonster.com
• Re: Adding new records with 3 relationships
  • From: Klatuu
• Re: Adding new records with 3 relationships
  • From: albert . repasky
• Re: Customizing query fields based on form input
  • From: Rus925
• Re: Calculate Year from Current Year
  • From: pddxxx
• RE: Query that
  • From: KARL DEWEY
• RE: Query that
  • From: ANDY-N via AccessMonster.com
• Re: Calculate Year from Current Year
  • From: MB
• Re: Crosstab Query Multiple
  • From: Michel Walsh
• Re: Calculate Year from Current Year
  • From: John Spencer
• Re: Customizing query fields based on form input
  • From: Michel Walsh
• RE: Adding new records with 3 relationships
  • From: Klatuu
• Re: Adding new records with 3 relationships
  • From: Jeff Boyce
• Re: Crosstab Query Multiple
  • From: Ben Pelech
• Adding new records with 3 relationships
  • From: albert . repasky
• Re: Crosstab Query Multiple
  • From: Ben Pelech
• Re: Sum Query Incorrect
  • From: Michel Walsh
• Re: Customizing query fields based on form input
  • From: Michel Walsh
• Re: Sum Query Incorrect
  • From: Michel Walsh
• Re: Sum Query Incorrect
  • From: NeonSky via AccessMonster.com
• Re: Sum Query Incorrect
  • From: NeonSky via AccessMonster.com
• Re: Crosstab Query Multiple
  • From: Michel Walsh
• Re: Sum Query Incorrect
  • From: Allen Browne
• Sum Query Incorrect
  • From: NeonSky via AccessMonster.com
• Re: Question on Query Comparing 2 values
  • From: Joe C
• Re: Delete query
  • From: Allen Browne
• Re: Need help with query linked to form.
  • From: Allen Browne
• Re: Delete query
  • From: Bob Barrows [MVP]
• Re: Need help with query linked to form.
  • From: Dan
• Re: Access SQL Question
  • From: bcap
• Re: Question on Query Comparing 2 values
  • From: Allen Browne
• Re: Access SQL Question
  • From: Allen Browne
• Re: Need help with query linked to form.
  • From: Allen Browne
• Re: Crosstab
  • From: Michel Walsh
• Question on Query Comparing 2 values
  • From: Joe C
• Re: Need help with query linked to form.
  • From: Dan
• RE: Deranged Calculation
  • From: KARL DEWEY
• Re: Need help with query linked to form.
  • From: Allen Browne
• Re: A couple of text parsing questions
  • From: Michel Walsh
• Re: Need help with query linked to form.
  • From: Dan
• Re: Produce a list of names based on data from two fields
  • From: Allen Browne
• Re: A couple of text parsing questions
  • From: fredg
• Re: Need help with query linked to form.
  • From: Allen Browne
• Re: Simple Query Question, can't figure it out
  • From: Michel Walsh
• RE: Deranged Calculation
  • From: KWhamill
• Re: Delete all modules but 1
  • From: auujxa2 via AccessMonster.com
• Re: Produce a list of names based on data from two fields
  • From: magicdds
• Re: Delete all modules but 1
  • From: auujxa2 via AccessMonster.com
• Not enough space on temporary disk
  • From: Bev
• Re: SQL and Query results don't Match
  • From: Ron2006
• Re: Microsoft Access 2003 Update Query to a null value
  • From: John Spencer
• Re: Delete all modules but 1
  • From: John Spencer
• Re: multiple condition queries
  • From: Allen Browne
• multiple condition queries
  • From: stuart
• Re: Picking up last 4 letters from a field
  • From: Graham R Seach
• Picking up last 4 letters from a field
  • From: CAM
• Re: Conditional Criteria within a query
  • From: Allen Browne
• Re: Produce a list of names based on data from two fields
  • From: Allen Browne
• Re: Conditional Criteria within a query
  • From: Kerry
• Re: Conditional Criteria within a query
  • From: Allen Browne
• Re: Conditional IIF question/null value
  • From: Allen Browne
• Re: Offer a Default in a Criteria
  • From: Ross
• Re: Help with complicated query?
  • From: fktx
• Re: Need help with query linked to form.
  • From: Allen Browne
• Re: Offer a Default in a Criteria
  • From: Allen Browne
• Re: Help with complicated query?
  • From: Bob Barrows [MVP]
• Offer a Default in a Criteria
  • From: Ross
• Re: Help with complicated query?
  • From: Bob Barrows [MVP]
• Re: Help with complicated query?
  • From: Bob Barrows [MVP]
• Re: Need help with calculation
  • From: Bob Barrows [MVP]
• Re: Adding A Leading Space - Update Query
  • From: Bob Barrows [MVP]
• Re: Delete all modules but 1
  • From: John Spencer
• RE: Help with complicated query?
  • From: fktx
• RE: IIF/UpdateQuery/AppendQuery???
  • From: KARL DEWEY
• Re: Missing Records in a 2 Table Query
  • From: Itenoeth
• Delete all modules but 1
  • From: auujxa2 via AccessMonster.com
• Re: Missing Records in a 2 Table Query
  • From: Michel Walsh
• Missing Records in a 2 Table Query
  • From: Itenoeth
• Re: Query only showing specific records - i need all - please help
  • From: Michel Walsh
• RE: Dues Query
  • From: Klatuu
• RE: Queries and reports
  • From: BlueWolverine
• Re: Query only showing specific records - i need all - please help
  • From: Yula
• RE: Queries and reports
  • From: Jerry Whittle
• Re: crosstab query question
  • From: ragtopcaddy via AccessMonster.com
• RE: Deranged Calculation
  • From: KARL DEWEY
• RE: Query ??
  • From: dazoloko via AccessMonster.com
• Re: Concatenate in a query - Access 2003
  • From: PhilT via AccessMonster.com
• RE: Deranged Calculation
  • From: KWhamill
• Re: Deranged Calculation
  • From: Marshall Barton
• RE: Query ??
  • From: KARL DEWEY
• Re: Query ??
  • From: Dale_Fye via AccessMonster.com
• Re: Query INSTR function?
  • From: Stefan Hoffmann
• Re: Query INSTR function?
  • From: Allen Browne
• Query INSTR function?
  • From: William
• Query ??
  • From: dazoloko via AccessMonster.com
• Re: Need help with calculation
  • From: Gary F Shelton
• Re: crosstab query question
  • From: John Spencer
• Re: Problem with fConcatChild
  • From: Amy Blankenship
• Re: crosstab query question
  • From: ragtopcaddy via AccessMonster.com
• Re: Adding A Leading Space - Update Query
  • From: Singinbeauty
• RE: IIF Statement - HELP!
  • From: susan
• Re: Compare dates
  • From: Michel Walsh
• Re: GRUOPING + SUMMING AND COUNTING
  • From: Michel Walsh
• Problem with fConcatChild
  • From: dalecorey1 via AccessMonster.com
• Re: Percentile Formula for Access
  • From: Michel Walsh
• Re: Need help with calculation
  • From: Bob Barrows [MVP]
• Re: need to calculate the quartile in ms access
  • From: Bob Barrows [MVP]
• Re: splitting fields of ids and title.
  • From: Bob Barrows [MVP]
• Re: autonumber - function
  • From: Bob Barrows [MVP]
• Re: GRUOPING + SUMMING AND COUNTING
  • From: Bob Barrows [MVP]
• GRUOPING + SUMMING AND COUNTING
  • From: Haas
• Re: Table not in List to Append to
  • From: MIG
• Re: Table not in List to Append to
  • From: MIG
• splitting fields of ids and title.
  • From: Database User
• RE: append to a linked excel table
  • From: scubadiver
• Re: Copy records without dupliacates
  • From: Allen Browne
• Copy records without dupliacates
  • From: cmweb via AccessMonster.com
• autonumber - function
  • From: learning_codes@xxxxxxxxxxx
• Re: Update Query Question
  • From: Douglas J. Steele
• Re: Table not in List to Append to
  • From: Jeanette Cunningham
• RE: Update Query Question
  • From: NeonSky via AccessMonster.com
• Re: Can you put an IF statement in a query expression?
  • From: John Spencer
• Re: crosstab query question
  • From: John Spencer
• Update Query Question
  • From: NeonSky via AccessMonster.com
• Unformat Phone Number Field
  • From: Brad
• Re: left "_" & "-"
  • From: Marshall Barton
• Re: Adding A Leading Space - Update Query
  • From: Bob Barrows [MVP]
• Re: left "_" & "-"
  • From: fredg
• Re: left "_" & "-"
  • From: Bob Barrows [MVP]
• Re: Adding A Leading Space - Update Query
  • From: Bob Barrows [MVP]
• RE: crosstab query question
  • From: ragtopcaddy via AccessMonster.com
• Re: User Select Top Value Percentage
  • From: DaveAP
• Re: Formula for quering a range of numbers
  • From: Michel Walsh
• RE: crosstab query question
  • From: KARL DEWEY
• Re: dates in queries
  • From: bhicks11 via AccessMonster.com
• Re: dates in queries
  • From: Marshall Barton
• RE: User Select Top Value Percentage
  • From: DaveAP
• dates in queries
  • From: Debbie S.
• Re: IF statement
  • From: John Spencer
• Re: Query one table against part of a cell of another
  • From: Michel Walsh
• Re: Formulas
  • From: Devan
• Re: Formulas
  • From: Bob Barrows [MVP]
• Re: Formulas
  • From: Bob Barrows [MVP]
• Re: Query as data source for form
  • From: Jeff Boyce
• Re: Query one table against part of a cell of another
  • From: apex77
• Re: Formulas
  • From: Devan
• RE: using the Or criteria
  • From: Klatuu
• Re: Query as data source for form
  • From: Jeff Boyce
• RE: How do I build a countif expression in Access
  • From: Ryan
• RE: Stuck on a date issue
  • From: Ryan
• RE: Stuck on a date issue
  • From: Sue
• Re: How do I build a countif expression in Access
  • From: fredg
• Re: Formulas
  • From: Bob Barrows [MVP]
• Re: How do I build a countif expression in Access
  • From: Michel Walsh
• Re: Stuck on a date issue
  • From: Michel Walsh
• Re: Stuck on a date issue
  • From: Bob Barrows [MVP]
• Re: Formulas
  • From: Michel Walsh
• Re: crosstab query question
  • From: ragtopcaddy via AccessMonster.com
• Re: IF statement
  • From: Florida Analyst
• crosstab query question
  • From: ragtopcaddy via AccessMonster.com
• Re: Formulas
  • From: Devan
• Re: Stuck on a date issue
  • From: Michel Walsh
• Re: Query one table against part of a cell of another
  • From: Michel Walsh
• Re: Formulas
  • From: Michel Walsh
• Re: using the Or criteria
  • From: Michel Walsh
• Re: Query only showing specific records - i need all - please help
  • From: Michel Walsh
• Re: IF statement
  • From: Florida Analyst
• Re: Query only showing specific records - i need all - please help
  • From: Yula
• Formulas
  • From: Devan
• Re: IF statement
  • From: Bob Barrows [MVP]
• Re: IF statement
  • From: Dale_Fye via AccessMonster.com
• Table not in List to Append to
  • From: MIG
• Re: IF statement
  • From: John Spencer
• RE: Union Query to a Table
  • From: Klatuu
• Re: Union Query to a Table
  • From: Bob Barrows [MVP]
• Union Query to a Table
  • From: miss_mas
• Re: Using DLOOKUP with totals (aggregate) queries?
  • From: Dominic Greco via AccessMonster.com
• RE: append to a linked excel table
  • From: Octet32
• Re: Next item in line
  • From: Allen Browne
• Re: Outer Join Question - "join expression not supported"
  • From: Michel Walsh
• Re: Duplicate values
  • From: Michel Walsh
• Outer Join Question - "join expression not supported"
  • From: Raven
• Re: Duplicate values
  • From: Allen Browne
• RE: append to a linked excel table
  • From: scubadiver
• Re: Query only showing specific records - i need all - please help
  • From: Michel Walsh
• Re: Using DLOOKUP with totals (aggregate) queries?
  • From: Michel Walsh
• Re: Access: problem with outer join - "Join Expression not Supported"
  • From: Michel Walsh
• Using DLOOKUP with totals (aggregate) queries?
  • From: Dominic Greco via AccessMonster.com
• Re: filtering in queries
  • From: bhicks11 via AccessMonster.com
• Duplicate values
  • From: Nuno Gomes
• Re: filtering in queries
  • From: NES
• Access: problem with outer join - "Join Expression not Supported"
  • From: Axel
• Re: filtering in queries
  • From: bhicks11 via AccessMonster.com
• Re: SQL WHERE = Query Results
  • From: John Spencer
• Re: Next item in line
  • From: Allen Browne
• Re: Months are different from days
  • From: fredg
• Re: Left Join Question
  • From: Grace
• Re: Limiting A Query by Using a text format
  • From: Rob Parker
• Limiting A Query by Using a text format
  • From: Brad
• Re: No Value returning from query
  • From: John Spencer
• Re: Query Too Complex
  • From: david
• RE: Filtering by week
  • From: KARL DEWEY
• Re: Turning off "null propagation" when adding fields
  • From: fredg
• Turning off "null propagation" when adding fields
  • From: rdra90
• Re: SQL WHERE = Query Results
  • From: Marshall Barton
• Re: SQL WHERE = Query Results
  • From: auujxa2 via AccessMonster.com
• Re: SQL WHERE = Query Results
  • From: Marshall Barton
• RE: SQL WHERE = Query Results
  • From: auujxa2 via AccessMonster.com
• Re: Query as data source for form
  • From: News Boy
• SQL WHERE = Query Results
  • From: auujxa2 via AccessMonster.com
• Re: Query as data source for form
  • From: News Boy
• Re: follow-up
  • From: Michel Walsh
• follow-up
  • From: BryanK
• Re: Using prompts in a switch statement.
  • From: Michel Walsh
• RE: run-time error 1004
  • From: Larue
• Re: Limit Rows returned in a query
  • From: Marshall Barton
• Re: "Record Deleted"
  • From: Pwyd
• Re: rst loop versus For Each
  • From: auujxa2 via AccessMonster.com
• Re: rst loop versus For Each
  • From: auujxa2 via AccessMonster.com
• Re: rst loop versus For Each
  • From: Marshall Barton
• Re: Limit Rows returned in a query
  • From: Bob Barrows [MVP]
• Re: Month date offset query
  • From: Bob Barrows [MVP]
• RE: Month date offset query
  • From: Jerry Whittle
• rst loop versus For Each
  • From: auujxa2 via AccessMonster.com
• RE: Month date offset query
  • From: chemicals
• RE: Month date offset query
  • From: Jerry Whittle
• Re: Can you create a table from the output of a query?
  • From: Jeff Boyce
• Re: update blank fields
  • From: pietlinden@xxxxxxxxxxx
• Re: Updating and Erasing Data
  • From: pietlinden@xxxxxxxxxxx
• Re: Month date offset query
  • From: pietlinden@xxxxxxxxxxx
• Month date offset query
  • From: chemicals
• Updating and Erasing Data
  • From: taco
• Re: Querry with User Input and Search the columns
  • From: John Spencer
• Re: Problem to write a query result in a text file.
  • From: Marco
• Re: Problem to write a query result in a text file.
  • From: Marco
• Re: Create Update Query
  • From: John W . Vinson
• Re: Access 2003 INNER JOIN
  • From: KC_Cheer_Coach
• Re: Update/Append Query
  • From: pietlinden@xxxxxxxxxxx
• Re: Change field Value using update query
  • From: Jeanette Cunningham
• Re: Create Update Query
  • From: Jeanette Cunningham
• Re: Left Join Question
  • From: pietlinden@xxxxxxxxxxx
• Re: Querry with User Input and Search the columns
  • From: pietlinden@xxxxxxxxxxx
• Left Join Question
  • From: Grace
• Re: How to count a value in a field
  • From: fredg
• Re: How to count a value in a field
  • From: pietlinden@xxxxxxxxxxx
• Re: How to count a value in a field
  • From: dave
• Re: How to count a value in a field
  • From: fredg
• How to count a value in a field
  • From: dave
• Re: Query to show ALL
  • From: dave
• Re: Query to show ALL
  • From: Douglas J. Steele
• Re: Challenging Date Query help needed
  • From: John Spencer
• Re: if statement results
  • From: Chris O'C via AccessMonster.com
• Re: Query Too Complex
  • From: cpsaltis
• Re: Query Too Complex
  • From: cpsaltis
• Re: Challenging Date Query help needed
  • From: Marshall Barton
• RE: Duplicate entries in a query
  • From: Ken Sheridan
• Re: Query Too Complex
  • From: david
• Change field Value using update query
  • From: shoeb
• Re: Date - Beginning of Month
  • From: Rob Parker
• Re: Query Join on Multiple Field Indexes
  • From: strive4peace
• Re: Query Join on Multiple Field Indexes
  • From: John D
• RE: Duplicate entries in a query
  • From: tedmi
• Chloe Boots RCB071002 - www.luxury-gift.org
  • From: blog629
• Re: Expression Builder
  • From: Elizabeth Reynolds
• Re: most close return
  • From: louisjohnphillips
• Re: Duplicate entries in a query
  • From: John Spencer
• Re: most close return
  • From: John Spencer
• Re: Expression Builder
  • From: Elizabeth Reynolds
• Re: most close return
  • From: Marshall Barton
• Re: How to look-up ID#
  • From: John W . Vinson
• Re: Query Too Complex
  • From: cpsaltis
• Re: most close return
  • From: Marshall Barton
• Re: most close return
  • From: louisjohnphillips
• Re: Query Too Complex
  • From: louisjohnphillips
• Re: most close return
  • From: inungh
• Re: most close return
  • From: Duane Hookom
• Duplicate entries in a query
  • From: Oldsfan
• Re: Query Too Complex
  • From: cpsaltis
• Re: most close return
  • From: Michel Walsh
• Re: Problem to write a query result in a text file.
  • From: Chris O'C via AccessMonster.com
• Re: Formatting a Number in a Query Field
  • From: Brad
• Re: Query Too Complex
  • From: louisjohnphillips
• Re: Formatting a Number in a Query Field
  • From: fredg
• Formatting a Number in a Query Field
  • From: Brad
• Re: most close return
  • From: louisjohnphillips
• Re: most close return
  • From: Michel Walsh
• Re: Help to select record by checking multiple child items
  • From: Marshall Barton
• Re: most close return
  • From: louisjohnphillips
• Re: Help to select record by checking multiple child items
  • From: louisjohnphillips
• Re: most close return
  • From: inungh
• Re: most close return
  • From: louisjohnphillips
• RE: most close return
  • From: scubadiver
• RE: How to look-up ID#
  • From: jmuirman
• most close return
  • From: inungh
• Help to select record by checking multiple child items
  • From: Renaud_D
• Re: Simple update query question
  • From: fredg
• Re: Simple update query question
  • From: John Spencer
• Re: Really weird query responses.
  • From: bmacrow
• Re: Really weird query responses.
  • From: Allen Browne
• Really weird query responses.
  • From: bmacrow
• Re: Subtract positive number from negative number
  • From: Brett
• Re: Subtract positive number from negative number
  • From: Brett
• Re: Query Join on Multiple Field Indexes
  • From: strive4peace
• Subtract positive number from negative number
  • From: Brett
• Re: Crosstab Query Rows
  • From: Andrew Glennie
• Re: Crosstab Query Rows
  • From: Rob Parker
• Re: Can you create a table from the output of a query?
  • From: BobC
• Re: Can you create a table from the output of a query?
  • From: BobC
• Re: Can you create a table from the output of a query?
  • From: BobC
• Re: Can you create a table from the output of a query?
  • From: Jeff Boyce
• Re: Can you create a table from the output of a query?
  • From: Douglas J. Steele
• Can you create a table from the output of a query?
  • From: BobC
• Re: Record Count
  • From: Ken Snell \(MVP\)
• Re: query tables using multiple listed values from another table
  • From: John Spencer
• Re: Ranking query
  • From: John Spencer
• RE: Record Count
  • From: Kay
• Record Count
  • From: Kay
• Re: 'Current Row' or similar for query-based combo box
  • From: Dan Smith - Sojourn
• Re: Ranking query
  • From: Jim Murray
• Re: writing syntax
  • From: strive4peace
• Re: WHERE help for button code
  • From: strive4peace
• Re: 'Current Row' or similar for query-based combo box
  • From: John Spencer
• Re: WHERE help for button code
  • From: jlute
• Re: 'Current Row' or similar for query-based combo box
  • From: Dan Smith - Sojourn
• Re: Case or IIF?
  • From: NBullock
• RE: Count number of times an entry for list B shows up in List A (cont
  • From: Ken Sheridan
• Re: writing syntax
  • From: aubrey
• Re: User Select Top Value Percentage
  • From: Ken Sheridan
• Re: WHERE help for button code
  • From: strive4peace
• Re: writing syntax
  • From: strive4peace
• Re: Query Question - I don't know
  • From: Michel Walsh
• Re: Help Designing a Query to Count Classes
  • From: Robert T
• Re: Help needed with SELECT query
  • From: John Spencer
• Re: writing syntax
  • From: fredg
• Re: User Select Top Value Percentage
  • From: John Spencer
• Re: Help needed with SELECT query
  • From: Allen Browne
• Re: Help Designing a Query to Count Classes
  • From: Bob Barrows [MVP]
• Re: User Select Top Value Percentage
  • From: Ken Sheridan
• Help needed with SELECT query
  • From: PO
• Re: Help Designing a Query to Count Classes
  • From: scubadiver
• Re: Help Designing a Query to Count Classes
  • From: Robert T
• RE: Checkbox & Textbox Used As Criteria For A Query
  • From: hfrupn
• Re: Query Question - I don't know
  • From: Michel Walsh
• Re: Query Question - I don't know
  • From: Bob Barrows [MVP]
• Re: Crosstab Query
  • From: Michel Walsh
• Re: Case or IIF?
  • From: NBullock
• Query Question - I don't know
  • From: Golfinray
• Re: Help Designing a Query to Count Classes
  • From: scubadiver
• Re: Crosstab Query Rows
  • From: Rob Parker
• Re: Combo box use as a Query... any help
  • From: Michel Walsh
• Re: Help Designing a Query to Count Classes
  • From: Robert T
• Re: Help Designing a Query to Count Classes
  • From: John Spencer
• Re: WHERE help for button code
  • From: jlute
• Re: User Select Top Value Percentage
  • From: John Spencer
• Re: Crosstab Query Rows
  • From: Andrew Glennie
• Re: "Setwarnings" option not available
  • From: Allen Browne
• Re: writing syntax
  • From: strive4peace
• Re: writing syntax
  • From: louisjohnphillips
• Re: Crosstab Query Rows
  • From: Rob Parker
• RE: User Select Top Value Percentage
  • From: Ken Sheridan
• Re: Crosstab Query Rows
  • From: Andrew Glennie
• RE: Checkbox & Textbox Used As Criteria For A Query
  • From: KARL DEWEY
• Re: Case or IIF?
  • From: Bob Barrows [MVP]
• Re: Combo box use as a Query... any help
  • From: fossy
• Re: Can anyone translate this SQL statement for me?
  • From: John Spencer
• Re: Annual update of Queries
  • From: John Spencer
• Re: Can anyone translate this SQL statement for me?
  • From: Douglas J. Steele
• Re: User Select Top Value Percentage
  • From: pietlinden@xxxxxxxxxxx
• Re: Case or IIF?
  • From: NBullock
• Re: Case or IIF?
  • From: NBullock
• Re: Case or IIF?
  • From: NBullock
• Can anyone translate this SQL statement for me?
  • From: tmwilkin
• Re: Switch not working
  • From: Student Databaser
• RE: Total count for crosstab query
  • From: KARL DEWEY
• Re: Annual update of Queries
  • From: Jeff Boyce
• Re: Annual update of Queries
  • From: RBear3
• Re: Case or IIF?
  • From: Bob Barrows [MVP]
• Re: Switch not working
  • From: John Spencer
• Re: Case or IIF?
  • From: John Spencer
• Re: Switch not working
  • From: Bob Barrows [MVP]
• User Select Top Value Percentage
  • From: DaveAP
• Re: Combo box use as a Query... any help
  • From: Michel Walsh
• RE: "Setwarnings" option not available
  • From: theintern
• Re: Switch not working
  • From: Michel Walsh
• Re: Switch not working
  • From: Bob Barrows [MVP]
• PivotTable View
  • From: Jasper Recto
• RE: Query set-up help
  • From: KARL DEWEY
• Re: Case or IIF?
  • From: NBullock
• RE: Total count for crosstab query
  • From: HOCSMGR
• Re: Case or IIF?
  • From: Bob Barrows [MVP]
• Re: Which Query
  • From: Jeff Boyce
• Re: Case or IIF?
  • From: Bob Barrows [MVP]
• Re: Switch not working
  • From: Student Databaser
• Re: Number format resulting from an aggregate query
  • From: Sajit
• Re: Which Query
  • From: DNork
• Re: IIf AND
  • From: John Spencer
• Re: Case or IIF?
  • From: NBullock
• Re: IIf AND
  • From: fredg
• Re: Switch not working
  • From: John Spencer
• Re: IIf AND
  • From: NBullock
• Re: Case or IIF?
  • From: NBullock
• Re: Which Query
  • From: Jeff Boyce
• IIf AND
  • From: Gringarlow
• Re: Switch not working
  • From: Student Databaser
• RE: Total count for crosstab query
  • From: KARL DEWEY
• Re: Switch not working
  • From: Michel Walsh
• RE: Converting text to a number in query
  • From: Stephanie
• Re: Case or IIF?
  • From: NBullock
• Re: memo field in the select query
  • From: Marshall Barton
• RE: Converting text to a number in query
  • From: KARL DEWEY
• Re: memo field in the select query
  • From: John Spencer
• Re: Calculate Age nearest
  • From: Bob Barrows [MVP]
• Re: Inventory Control Query?
  • From: pietlinden@xxxxxxxxxxx
• Re: Number format resulting from an aggregate query
  • From: Michel Walsh
• Re: Calculate Age nearest
  • From: J
• Re: Calculate Age nearest
  • From: J
• RE: Create multiple queries in Access with a single sql statement
  • From: Klatuu
• RE: Create multiple queries in Access with a single sql statement
  • From: Ron
• Checkbox & Textbox Used As Criteria For A Query
  • From: hfrupn
• RE: Number format resulting from an aggregate query
  • From: Sajit
• Re: Number format resulting from an aggregate query
  • From: Sajit
• memo field in the select query
  • From: inungh
• Re: Case or IIF?
  • From: Michel Walsh
• Re: Count Distinct Values In Several Columns or Fields
  • From: Ron2006
• RE: Converting text to a number in query
  • From: Stephanie
• Re: display top 5 records for each subcategory
  • From: Michel Walsh
• RE: Count Distinct Values In Several Columns or Fields
  • From: HSL
• Re: display top 5 records for each subcategory
  • From: Michel Walsh
• Re: Case or IIF?
  • From: Michel Walsh
• Re: 'Current Row' or similar for query-based combo box
  • From: John Spencer
• Re: Help with a query...
  • From: Nuno Gomes
• Re: Select records by employee
  • From: John Spencer
• Re: Number format resulting from an aggregate query
  • From: Michel Walsh
• Re: Calculating Working Hours that cross over midnight
  • From: Jurrasicway
• Re: Count Distinct Values In Several Columns or Fields
  • From: Allen Browne
• Re: Calculating Working Hours that cross over midnight
  • From: Jeff Boyce
• Re: 'Current Row' or similar for query-based combo box
  • From: Jeff Boyce
• RE: Adding Calcs to a Crosstab? Or Form?
  • From: carriey
• Re: Select records by employee
  • From: Mark.M.Sweeney@xxxxxxxxx
• Re: Calculating Working Hours that cross over midnight
  • From: fredg
• RE: Want a counter for Access Query results
  • From: KARL DEWEY
• RE: Converting text to a number in query
  • From: KARL DEWEY
• Re: Case or IIF?
  • From: Bob Barrows [MVP]
• Select records by employee
  • From: Mark.M.Sweeney@xxxxxxxxx
• RE: Want a counter for Access Query results
  • From: Stegra
• Case or IIF?
  • From: NBullock
• Re: Query on a Query
  • From: John Spencer
• IIF or Case? Please help, there has to be a better way.
  • From: NBullock
• RE: Converting text to a number in query
  • From: Stephanie
• RE: Want a counter for Access Query results
  • From: KARL DEWEY
• Re: Query on a Query
  • From: Brampton76
• RE: Adding Calcs to a Crosstab? Or Form?
  • From: KARL DEWEY
• Re: Inventory Control Query?
  • From: Suzann
• RE: Adding Calcs to a Crosstab? Or Form?
  • From: carriey
• RE: Sum values of column
  • From: KARL DEWEY
• RE: Adding Calcs to a Crosstab? Or Form?
  • From: KARL DEWEY
• RE: Want a counter for Access Query results
  • From: Stegra
• RE: Converting text to a number in query
  • From: KARL DEWEY
• RE: Split two data elements that are in one field
  • From: Jerry Whittle
• Re: Query on a Query
  • From: John Spencer
• RE: Converting text to a number in query
  • From: Stephanie
• Re: Roundup Function
  • From: Allen Browne
• Re: My criteria doesn't work.
  • From: John Spencer
• Re: Help with a query...
  • From: Bob Barrows [MVP]
• Re: Help with a query...
  • From: John Spencer
• Re: calculation of difference using different fields depending on prod
  • From: pietlinden@xxxxxxxxxxx
• Re: Inventory Control Query?
  • From: pietlinden@xxxxxxxxxxx
• Re: My criteria doesn't work.
  • From: adam . vogg
• Re: My criteria doesn't work.
  • From: Marshall Barton
• Re: Help with a query...
  • From: Nuno Gomes
• Re: My criteria doesn't work.
  • From: adam . vogg
• RE: Converting text to a number in query
  • From: KARL DEWEY
• Re: Easy query criteria question
  • From: Bongard
• RE: display top 5 records for each subcategory
  • From: lay
• Re: using query returns to create new columns
  • From: John Spencer
• RE: display top 5 records for each subcategory
  • From: lay
• RE: Converting text to a number in query
  • From: Stephanie
• Re: delete duplicates
  • From: Allen Browne
• Re: using query returns to create new columns
  • From: Marshall Barton
• Re: Calculate Age nearest
  • From: Bob Barrows [MVP]
• Re: Different results in SQL and Access
  • From: Bob Barrows [MVP]
• Re: Calculate Age nearest
  • From: Bob Barrows [MVP]
• Re: Different results in SQL and Access
  • From: Pat Backowski
• Re: Help with a query...
  • From: John Spencer
• Re: using query returns to create new columns
  • From: John Spencer
• Re: Calculate Age nearest
  • From: Douglas J. Steele
• Re: Calculate Age nearest
  • From: Bob Barrows [MVP]
• Re: Different results in SQL and Access
  • From: Bob Barrows [MVP]
• Re: Help with a query...
  • From: Nuno Gomes
• Re: Crosstab Query Rows
  • From: Rob Parker
• Re: Make table query combining records of two tables into a third
  • From: carl jordan
• Re: Selecting and counting records in one query
  • From: Bob Barrows [MVP]
• Re: Selecting and counting records in one query
  • From: mokihi
• RE: Converting text to a number in query
  • From: KARL DEWEY
• Re: One Command Button for different reports
  • From: pietlinden@xxxxxxxxxxx
• Re: display top 5 records for each subcategory
  • From: pietlinden@xxxxxxxxxxx
• Re: Selecting and counting records in one query
  • From: Bob Barrows [MVP]