microsoft.public.access.queries

• Date Index

---

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

We are proud to have Web Hosting and Rack Housing from 9 Net Avenue Deutschland.
(15)