microsoft.public.access.queries

• Date Index

---

• Create a specific sort order, Access Joe
• Asterix, Love Buzz
• An Inner Join on an Inner Join, David Wetmore
• Why does this Nested IIF statement add AS fields, jacqelynl
  • Re: Why does this Nested IIF statement add AS fields, strive4peace
  • RE: Why does this Nested IIF statement add AS fields, KARL DEWEY
    • RE: Why does this Nested IIF statement add AS fields, jacqelynl
      • RE: Why does this Nested IIF statement add AS fields, jacqelynl
• Attributes (Hidden), Annie
  • Re: Attributes (Hidden), BruceM
  • Re: Attributes (Hidden), strive4peace
    • Re: Attributes (Hidden), BruceM
      • Re: Attributes (Hidden), strive4peace
• Query lacks Specific Criteria, MotoTraining
  • Re: Query lacks Specific Criteria, strive4peace
• How to run an append Query in VBA on a recordset, magicdds-
• union query of complex queries, Effie
• RE: A query that shows repeats, Rob
  • RE: A query that shows repeats, Duane Hookom
• RE: color column in datasheet view, OCTTAR
• text to Date/time, PAG
• How do I select the maximum of a subset of records?, Rachel Garrett
  • Re: How do I select the maximum of a subset of records?, Marshall Barton
    • Re: How do I select the maximum of a subset of records?, Rachel Garrett
      • Re: How do I select the maximum of a subset of records?, Rachel Garrett
      • Re: How do I select the maximum of a subset of records?, Rachel Garrett
• convert to number, Rich
  • Re: convert to number, Marshall Barton
• Ranking query, BruceM
  • RE: Ranking query, Dale Fye
    • Re: Ranking query, BruceM
      • Re: Ranking query, Dale Fye
• Query results and display nulls?, CR
  • RE: Query results and display nulls?, KARL DEWEY
  • Re: Query results and display nulls?, John Spencer
• Query: Everything Works Except the Sum, Robert T
  • RE: Query: Everything Works Except the Sum, KARL DEWEY
    • RE: Query: Everything Works Except the Sum, Robert T
      • RE: Query: Everything Works Except the Sum, KARL DEWEY
      • RE: Query: Everything Works Except the Sum, Robert T
• Query Criteria, ladybug via AccessMonster.com
  • Re: Query Criteria, Marshall Barton
    • Re: Query Criteria, ladybug via AccessMonster.com
      • Re: Query Criteria, Marshall Barton
      • Re: Query Criteria, ladybug via AccessMonster.com
      • Re: Query Criteria, Marshall Barton
  • RE: Query Criteria, KARL DEWEY
    • RE: Query Criteria, raskew via AccessMonster.com
    • RE: Query Criteria, KARL DEWEY
      • RE: Query Criteria, ladybug via AccessMonster.com
      • RE: Query Criteria, KARL DEWEY
• Another trim problem, Golfinray
  • Re: Another trim problem, Evi
    • Re: Another trim problem, KARL DEWEY
• using a vairable in expression builder, S Green
  • RE: using a vairable in expression builder, Dennis
• delete key not working in office, artistmandy
  • Re: delete key not working in office, strive4peace
• Extracting records, Hassan
  • Re: Extracting records, strive4peace
• Splitting Text Data, Justin
  • Re: Splitting Text Data, strive4peace
  • Re: Splitting Text Data, John Spencer
• cumulative history of purchases by referrals, corebe
• Query With Ranges in output?, Sydneyej
  • RE: Query With Ranges in output?, KARL DEWEY
• problem caused by sync profile, sb
  • Re: problem caused by sync profile, Michel Walsh
• Quarterly Billing for Partial periods, Lori
  • Re: Quarterly Billing for Partial periods, Michel Walsh
    • Re: Quarterly Billing for Partial periods, Lori
• Trouble with 2 tables connected by reference table, jwb96
  • Re: Trouble with 2 tables connected by reference table, Michel Walsh
    • Re: Trouble with 2 tables connected by reference table, jwb96
• Error in Access 2002, Ken
  • RE: Error in Access 2002, Ken
• Date Diff, Dan @BCBS
  • RE: Date Diff, KARL DEWEY
    • RE: Date Diff, Dan @BCBS
  • Re: Date Diff, Marshall Barton
• Action Queries . . . i think, Student Database Disaster!
  • Re: Action Queries . . . i think, Michel Walsh
    • Re: Action Queries . . . i think, Student Database Disaster!
      • Re: Action Queries . . . i think, John W . Vinson
      • Re: Action Queries . . . i think, Student Database Disaster!
• How to force fields to have a specific lengh, Marco
  • Re: How to force fields to have a specific lengh, John Spencer
  • RE: How to force fields to have a specific lengh, Jerry Whittle
• Difference between to table and union, ecwhite
  • Re: Difference between to table and union, John Spencer
  • RE: Difference between to table and union, KARL DEWEY
• How to create a telephone list with both customers and suppliers, Grd
  • Re: How to create a telephone list with both customers and suppliers, John Spencer
    • Re: How to create a telephone list with both customers and supplie, Grd
• delete record, r brooks
  • Re: delete record, Evi
  • RE: delete record, Dennis
• Problem with expression (sum), Qaspec
  • Re: Problem with expression (sum), Michel Walsh
• Synchronization Module, Lisa
  • Re: Synchronization Module, David W. Fenton
    • Re: Synchronization Module, Ron2006
      • Re: Synchronization Module, Lisa
• Import txt error, Lotto
  • RE: Import txt error, Jerry Whittle
• Adjusting Date and Time, rjvega
  • Re: Adjusting Date and Time, John Spencer
• A little confused, Golfinray
  • RE: A little confused, Golfinray
  • Re: A little confused, Evi
• Can I add a sequence / autonumber field to my Make Table Query?, KevinC
  • Re: Can I add a sequence / autonumber field to my Make Table Query?, John Spencer
• Single-record append query without warnings on duplicates, HH
  • Re: Single-record append query without warnings on duplicates, Marshall Barton
• Please, help with Select query, Sergio
  • RE: Please, help with Select query, KARL DEWEY
• Query returning negative number - what's wrong with this SQL?!, Emelina Bumsquash
  • Re: Query returning negative number - what's wrong with this SQL?!, Stefan Hoffmann
    • Please help with Select query, Sergio
      • Re: Please help with Select query, Stefan Hoffmann
    • Re: Query returning negative number - what's wrong with this SQL?!, Emelina Bumsquash
  • Re: Query returning negative number - what's wrong with this SQL?!, John Spencer
    • Re: Query returning negative number - what's wrong with this SQL?!, Emelina Bumsquash
      • Re: Query returning negative number - what's wrong with this SQL?!, John Spencer
      • Re: Query returning negative number - what's wrong with this SQL?!, Emelina Bumsquash
• trim before and after "-", Irene
  • Re: trim before and after "-", strive4peace
    • Re: trim before and after "-", Irene
      • Re: trim before and after "-", strive4peace
• Determine character length in field, alecgreen
  • Re: Determine character length in field, raskew via AccessMonster.com
  • Re: Determine character length in field, John Spencer
• development of query, sverre
  • Re: development of query, John Spencer
• How to combine to related queries into one., Dawn
  • Re: How to combine to related queries into one., strive4peace
    • Re: How to combine to related queries into one., Dawn
      • Re: How to combine to related queries into one., strive4peace
• Can this be done with access 2007, Need Help
• Help need to complete query, Need Help
• Query Not working with newly imported table, SkinsFan2626
  • Re: Query Not working with newly imported table, Jeanette Cunningham
• parameter with iif statement in query criteria, Doug Glancy
  • RE: parameter with iif statement in query criteria, Klatuu
    • Re: parameter with iif statement in query criteria, Doug Glancy
  • Re: parameter with iif statement in query criteria, Marshall Barton
    • Re: parameter with iif statement in query criteria, Doug Glancy
      • Re: parameter with iif statement in query criteria, Marshall Barton
  • RE: parameter with iif statement in query criteria, Ken Sheridan
    • Re: parameter with iif statement in query criteria, Doug Glancy
• combining 2 fields that are in the same column, into 1 field, Freida
  • RE: combining 2 fields that are in the same column, into 1 field, mscertified
    • RE: combining 2 fields that are in the same column, into 1 field, Freida
      • Re: combining 2 fields that are in the same column, into 1 field, John Spencer
• Switch formula in query results in "Text too long to be edited.", anwest75
  • RE: Switch formula in query results in "Text too long to be edited.", KARL DEWEY
  • RE: Switch formula in query results in "Text too long to be edited.", Klatuu
  • Re: Switch formula in query results in "Text too long to be edited.", John Spencer
• iif function, Todd
  • RE: iif function, KARL DEWEY
    • RE: iif function, Todd
• criteria question, DEI
  • RE: criteria question, Golfinray
  • Re: criteria question, Michel Walsh
    • Re: criteria question, DEI
      • Re: criteria question, John Spencer
      • Re: criteria question, DEI
      • Re: criteria question, John Spencer
  • RE: criteria question, KARL DEWEY
• Renaming field in query, alecgreen
  • Re: Renaming field in query, Amy Blankenship
  • Re: Renaming field in query, Marshall Barton
    • Re: Renaming field in query, alecgreen
• Parameter Problem, Nancy
  • RE: Parameter Problem, Golfinray
  • Re: Parameter Problem, Marshall Barton
    • Re: Parameter Problem, Nancy
      • Re: Parameter Problem, Marshall Barton
      • Re: Parameter Problem, Nancy
      • Re: Parameter Problem, Nancy
      • Re: Parameter Problem, Marshall Barton
• Right join not working now, Mark
  • RE: Right join not working now, Mark
    • Re: Right join not working now, Michel Walsh
• updateable query, Skunk
  • Re: updateable query, Jeff Boyce
    • Re: updateable query, Skunk
      • Re: updateable query, Jeff Boyce
      • Re: updateable query, Skunk
      • Re: updateable query, Skunk
      • Re: updateable query, Jeff Boyce
• Format Problem, DS
  • Re: Format Problem, Marshall Barton
    • Re: Format Problem, DS
• union query using query, Souris
  • RE: union query using query, KARL DEWEY
• Query for Left(String,5) - Access 2007, JohnH
  • RE: Query for Left(String,5) - Access 2007, Klatuu
    • RE: Query for Left(String,5) - Access 2007, JohnH
      • RE: Query for Left(String,5) - Access 2007, Klatuu
      • RE: Query for Left(String,5) - Access 2007, JohnH
      • RE: Query for Left(String,5) - Access 2007, Klatuu
      • RE: Query for Left(String,5) - Access 2007, JohnH
      • Re: Query for Left(String,5) - Access 2007, John Spencer
      • Re: Query for Left(String,5) - Access 2007, Klatuu
      • Re: Query for Left(String,5) - Access 2007, JohnH
      • Re: Query for Left(String,5) - Access 2007, John Spencer
      • Re: Query for Left(String,5) - Access 2007, JohnH
      • Re: Query for Left(String,5) - Access 2007, JohnH
      • Re: Query for Left(String,5) - Access 2007, JohnH
      • Re: Query for Left(String,5) - Access 2007, John Spencer
      • Re: Query for Left(String,5) - Access 2007, JohnH
      • Re: Query for Left(String,5) - Access 2007, JohnH
      • Re: Query for Left(String,5) - Access 2007, JohnH
• Union help, Golfinray
  • RE: Union help, KARL DEWEY
• replace existing record with updated record, NewtoComputing
  • RE: replace existing record with updated record, mscertified
    • RE: replace existing record with updated record, NewtoComputing
  • RE: replace existing record with updated record, Klatuu
    • RE: replace existing record with updated record, NewtoComputing
      • RE: replace existing record with updated record, Klatuu
• Query or report, Need Help
  • Re: Query or report, John Spencer
    • Re: Query or report, Michel Walsh
      • Re: Query or report, John Spencer
• Re: Filter Query via Tickbox, Hassan
• Query parameters via form, DJ
  • Re: Query parameters via form, John Spencer
    • Re: Query parameters via form, DJ
• update 4 columns in one query?, Accessghostrider via AccessMonster.com
  • Re: update 4 columns in one query?, John Spencer
    • Re: update 4 columns in one query?, Ron2006
      • Re: update 4 columns in one query?, Accessghostrider via AccessMonster.com
      • Re: update 4 columns in one query?, John Spencer
      • Re: update 4 columns in one query?, Accessghostrider via AccessMonster.com
      • Re: update 4 columns in one query?, John Spencer
• View a random set of records, Ben
  • Re: View a random set of records, Michel Walsh
• This should be a simple fix..., ddobrzenski
  • RE: This should be a simple fix..., Duane Hookom
• Inner Join Syntax Problems, David Wetmore
  • Re: Inner Join Syntax Problems, Dale Fye
• Combine Multilple Tables, glg4e
  • Re: Combine Multilple Tables, Evi
    • Re: Combine Multilple Tables, glg4e
      • Re: Combine Multilple Tables, John W . Vinson
      • Re: Combine Multilple Tables, Evi
  • Re: Combine Multilple Tables, Dale Fye
    • Re: Combine Multilple Tables, glg4e
      • Re: Combine Multilple Tables, Evi
• combo box based on a second combo box not working, magicdds-
  • Re: combo box based on a second combo box not working, John Spencer
  • RE: combo box based on a second combo box not working, Ken Sheridan
• Find a Date, liukaiyuan
• how do i set up the formula to calculation 10% off in a query ., wobblyfoil
  • Re: how do i set up the formula to calculation 10% off in a query ., John Spencer
• updating a sorted numerical field to absolute position in recordset?, gerardianlewis
  • Re: updating a sorted numerical field to absolute position in recordset?, Evi
    • Re: updating a sorted numerical field to absolute position in recordset?, gerardianlewis
  • Re: updating a sorted numerical field to absolute position in recordset?, John Spencer
    • Re: updating a sorted numerical field to absolute position in recordset?, gerardianlewis
      • Re: updating a sorted numerical field to absolute position in recordset?, John Spencer
• Retrieving one to many in different columns, Stan Leeds
  • Re: Retrieving one to many in different columns, Ken Snell \(MVP\)
  • <Possible follow-ups>
  • Re: Retrieving one to many in different columns, Stan Leeds
• create date records, M. Murphy
  • Re: create date records, Evi
    • Re: create date records, M. Murphy
      • Re: create date records, Evi
      • Re: create date records, M. Murphy
      • Re: create date records, Dale Fye
      • Re: create date records, Evi
      • Re: create date records, Dale Fye
      • Re: create date records, Dale Fye
• How to add my own functions to access 2007: to select in "build", Beepa
• Search Multi Yes, Lost
  • Re: Search Multi Yes, Evi
• Query iiF Woes, DS
  • Re: Query iiF Woes, Evi
    • Re: Query iiF Woes, DS
• Create Query to display three fields for every record in a table., AJRoad
  • RE: Create Query to display three fields for every record in a table., Duane Hookom
    • RE: Create Query to display three fields for every record in a tab, AJRoad
    • RE: Create Query to display three fields for every record in a tab, AJRoad
      • RE: Create Query to display three fields for every record in a tab, Duane Hookom
• Queries & calculations, ShaAnne
  • Re: Queries & calculations, Evi
    • Re: Queries & calculations, ShaAnne
      • Re: Queries & calculations, Evi
      • Re: Queries & calculations, Evi
• Inserting values from previous row into null cells, acccessaccess2003
  • Re: Inserting values from previous row into null cells, John Spencer
    • Re: Inserting values from previous row into null cells, acccessaccess2003
• How to find out if students still signed in?, Song Su
  • Re: How to find out if students still signed in?, Evi
    • Re: How to find out if students still signed in?, Song Su
      • Re: How to find out if students still signed in?, Evi
      • Re: How to find out if students still signed in?, Song Su
      • Re: How to find out if students still signed in?, Evi
      • Re: How to find out if students still signed in?, Song Su
• Help to optimize qureries, Aino
• Formatting sums in crosstab?, Elizabeth Swoope
  • RE: Formatting sums in crosstab?, Duane Hookom
    • RE: Formatting sums in crosstab?, Elizabeth Swoope
  • Re: Formatting sums in crosstab?, Evi
    • Re: Formatting sums in crosstab?, Elizabeth Swoope
      • Re: Formatting sums in crosstab?, Evi
      • Re: Formatting sums in crosstab?, Elizabeth Swoope
      • Re: Formatting sums in crosstab?, Elizabeth Swoope
• Inner Join Query Questions, David Wetmore
  • Re: Inner Join Query Questions, Rick Brandt
• A query to return the opposite value, Sonja
  • Re: A query to return the opposite value, Ken Snell \(MVP\)
• joining two queries, DD
• Order Query, Hardhit
• Query Selection and Criteria, AJRoad
  • Re: Query Selection and Criteria, Evi
• How to count 2 datasets and then subtract the difference?, Jon
  • RE: How to count 2 datasets and then subtract the difference?, KARL DEWEY
  • Re: How to count 2 datasets and then subtract the difference?, John Spencer
    • Re: How to count 2 datasets and then subtract the difference?, Jon
• Union Query-Multiple Parameters-Table Name, Tina
  • RE: Union Query-Multiple Parameters-Table Name, KARL DEWEY
    • RE: Union Query-Multiple Parameters-Table Name, Tina
      • RE: Union Query-Multiple Parameters-Table Name, KARL DEWEY
      • RE: Union Query-Multiple Parameters-Table Name, Tina
      • Re: Union Query-Multiple Parameters-Table Name, John W . Vinson
• Shift data, ironwood9 via AccessMonster.com
  • Re: Shift data, Jeff Boyce
    • Re: Shift data, ironwood9 via AccessMonster.com
• SQL Query UPDATE & SELECT COUNT does not work, pacman
• Table Top from Poss, shenlishu520
• Re: Query Filter by Entering Criteria, Leo
• Rename two fields and calculate the difference using the new etiqu, sverre
  • RE: Rename two fields and calculate the difference using the new etiqu, Duane Hookom
• Kind of new to Access....., Tony
  • Re: Kind of new to Access....., NoodNutt
• Max Function from Union Query - why simple function not working??!, Emelina Bumsquash
  • RE: Max Function from Union Query - why simple function not working??!, Ken Sheridan
    • RE: Max Function from Union Query - why simple function not workin, Emelina Bumsquash
• appending a Learner and Aims set of records to a txt file, Rob DSO Llandrillo
  • Re: appending a Learner and Aims set of records to a txt file, Evi
    • Re: appending a Learner and Aims set of records to a txt file, Rob DSO Llandrillo
      • Re: appending a Learner and Aims set of records to a txt file, Rob DSO Llandrillo
      • Re: appending a Learner and Aims set of records to a txt file, Evi
• Access 2007 Records Totals sum missing from List box, agent86oz
  • Re: Access 2007 Records Totals sum missing from List box, John Spencer
    • Re: Access 2007 Records Totals sum missing from List box, agent86oz
• Query error, Sanju
  • Re: Query error, Brendan Reynolds
• Moving Data to "history" database, Smieszek
  • Re: Moving Data to "history" database, NoodNutt
  • Re: Moving Data to "history" database, John W . Vinson
• This may seem like a very newb question..., mCassidy
  • Re: This may seem like a very newb question..., NoodNutt
  • Re: This may seem like a very newb question..., John W . Vinson
• Is there anyway of created a query................, Tony
  • RE: Is there anyway of created a query................, Duane Hookom
• Default date for Null field, lrgm
  • Re: Default date for Null field, Evi
    • Re: Default date for Null field, Ken Sheridan
      • Re: Default date for Null field, Evi
  • Re: Default date for Null field, Rick Brandt
  • Re: Default date for Null field, John W . Vinson
• What put the bang! in my subquery, Evi
  • Re: What put the bang! in my subquery, John W . Vinson
    • Re: What put the bang! in my subquery, Evi
• Crosstab Query Chart, Pam
  • Re: Crosstab Query Chart, Evi
    • Re: Crosstab Query Chart, PHisaw
• text then date ascending count, Cameron
  • RE: text then date ascending count, KARL DEWEY
    • RE: text then date ascending count, Cameron
• determine number of weeks between 2 date with decimal, Question Boy
  • Re: determine number of weeks between 2 date with decimal, Marshall Barton
    • Re: determine number of weeks between 2 date with decimal, Question Boy
• About SQL Statement, March
  • RE: About SQL Statement, March
    • RE: About SQL Statement, KARL DEWEY
• Update query issue, patti
  • RE: Update query issue, Klatuu
    • RE: Update query issue, patti
      • RE: Update query issue, Klatuu
      • RE: Update query issue, patti
      • RE: Update query issue, Klatuu
• Sale Price Haurex Raptor Watches Fake - Haurex Minimum Price Wholesale, watches0814
• Validation Rule?, Dug
  • Re: Validation Rule?, John Spencer
    • Re: Validation Rule?, Dug
      • Re: Validation Rule?, Dug
• Unbound controls and subforms, Lambi000
  • Re: Unbound controls and subforms, Marshall Barton
• return all after specific character. left, right, mid???, Scubadaisy
  • RE: return all after specific character. left, right, mid???, Jerry Whittle
    • RE: return all after specific character. left, right, mid???, Scubadaisy
  • Re: return all after specific character. left, right, mid???, fredg
    • Re: return all after specific character. left, right, mid???, Scubadaisy
      • Re: return all after specific character. left, right, mid???, John Spencer
  • Re: return all after specific character. left, right, mid???, Marshall Barton
• group by name having 2 different groups ( weeks ), vepha
  • RE: group by name having 2 different groups ( weeks ), Jerry Whittle
    • RE: group by name having 2 different groups ( weeks ), vepha
  • RE: group by name having 2 different groups ( weeks ), KARL DEWEY
    • RE: group by name having 2 different groups ( weeks ), vepha
      • RE: group by name having 2 different groups ( weeks ), KARL DEWEY
      • RE: group by name having 2 different groups ( weeks ), vepha
      • RE: group by name having 2 different groups ( weeks ), KARL DEWEY
      • RE: group by name having 2 different groups ( weeks ), vepha
• Re: Top 5, Franklin Smith
• Filter Query by Year on a form, idtjes3
  • Re: Filter Query by Year on a form, Ron2006
    • Re: Filter Query by Year on a form, Ron2006
    • Re: Filter Query by Year on a form, idtjes3
  • RE: Filter Query by Year on a form, KARL DEWEY
    • RE: Filter Query by Year on a form, idtjes3
      • RE: Filter Query by Year on a form, KARL DEWEY
  • RE: Filter Query by Year on a form, Klatuu
    • RE: Filter Query by Year on a form, idtjes3
      • RE: Filter Query by Year on a form, Klatuu
      • RE: Filter Query by Year on a form, idtjes3
      • RE: Filter Query by Year on a form, KARL DEWEY
      • RE: Filter Query by Year on a form, idtjes3
  • Re: Filter Query by Year on a form, Rick Brandt
• Rewrite query, ielmrani via AccessMonster.com
  • RE: Rewrite query, KARL DEWEY
    • RE: Rewrite query, ielmrani via AccessMonster.com
  • Re: Rewrite query, Marshall Barton
    • Re: Rewrite query, ielmrani via AccessMonster.com
      • Re: Rewrite query, Marshall Barton
      • Re: Rewrite query, ielmrani via AccessMonster.com
• Searching Multiple Columns in Acess, JezLisle
  • RE: Searching Multiple Columns in Acess, Duane Hookom
    • RE: Searching Multiple Columns in Acess, JezLisle
      • RE: Searching Multiple Columns in Acess, Duane Hookom
      • RE: Searching Multiple Columns in Acess, JezLisle via AccessMonster.com
      • Re: Searching Multiple Columns in Acess, John Spencer
• How to Get Particular Records from ACCESS, humptydumpty
  • Re: How to Get Particular Records from ACCESS, John Spencer
• Count Query, Question Boy
  • RE: Count Query, Jerry Whittle
    • RE: Count Query, Question Boy
      • RE: Count Query, Jerry Whittle
    • RE: Count Query, Question Boy
      • RE: Count Query, Jerry Whittle
    • RE: Count Query, Question Boy
      • RE: Count Query, Jerry Whittle
  • Re: Count Query, John Spencer
• and or statements together, Afia
  • Re: and or statements together, Ron2006
  • RE: and or statements together, Dale Fye
  • Re: and or statements together, Evi
• how do I search for an * in a text field?, jahfish
  • Re: how do I search for an * in a text field?, John Spencer
• Combining Arguments, James Frater
  • Re: Combining Arguments, John Spencer
    • Re: Combining Arguments, James Frater
      • Message not available
      • Message not available
      • Message not available
      • Message not available
      • Re: Combining Arguments, John Spencer
      • Re: Combining Arguments, James Frater
• How to find out the difference between two tables?, Dawn
  • Re: How to find out the difference between two tables?, John Spencer
  • RE: How to find out the difference between two tables?, Dale Fye
  • RE: How to find out the difference between two tables?, Dawn
• Run Time Error - 3075, Monish
  • Re: Run Time Error - 3075, Jeanette Cunningham
    • Re: Run Time Error - 3075, Monish
      • Re: Run Time Error - 3075, Jeanette Cunningham
      • Re: Run Time Error - 3075, Monish
• How get records not in another table?, mscertified
  • Re: How get records not in another table?, John W . Vinson
    • Re: How get records not in another table?, John Spencer
      • Re: How get records not in another table?, John W . Vinson
      • Re: How get records not in another table?, mscertified
      • Re: How get records not in another table?, John Spencer
• Wholesale Conference Microphone - Chinese Conference Microphone Manufacturer, blog212
• OEM Mics - OEM OEM Mics Manufacturer, blog212
• INSERT INTO With AutoNumber field, Darrell
  • Re: INSERT INTO With AutoNumber field, Darrell
    • Re: INSERT INTO With AutoNumber field, John Spencer
  • Re: INSERT INTO With AutoNumber field, Evi
• Over Due Task query, JoeV
  • RE: Over Due Task query, KARL DEWEY
• Setting #Error to Null, mcl
  • Re: Setting #Error to Null, Evi
• Wildcard in Instr?, mcl
  • Re: Wildcard in Instr?, George Nicholson
  • Re: Wildcard in Instr?, Marshall Barton
• Dlookup inside IIf in 2 Table Update Query, cleech
  • Re: Dlookup inside IIf in 2 Table Update Query, John Spencer
• The alpha first table in an access 2003 database no longer appears in the append query table list, jgfaughnan
  • RE: The alpha first table in an access 2003 database no longer appears, Texernie1
• Can I set destination field data types in an Access update query?, Nails
  • Re: Can I set destination field data types in an Access update query?, John Spencer
• a top n query where the n is field in another table?, Howard
  • RE: a top n query where the n is field in another table?, KARL DEWEY
    • Re: a top n query where the n is field in another table?, Howard
  • Re: a top n query where the n is field in another table?, John Spencer
• Is there a 'Not in' function?, PatrickM
  • Re: Is there a 'Not in' function?, fredg
    • Re: Is there a 'Not in' function?, KARL DEWEY
• Like operator and wildcards, compare fields, titlepusher
  • Re: Like operator and wildcards, compare fields, John W . Vinson
• Access equivalent of Excel's Product(), bismuth83
  • RE: Access equivalent of Excel's Product(), Golfinray
  • Re: Access equivalent of Excel's Product(), bismuth83
• Checkbox qry into Report, CD27
  • Re: Checkbox qry into Report, Evi
  • Re: Checkbox qry into Report, Marshall Barton
    • Re: Checkbox qry into Report, CD27
      • Re: Checkbox qry into Report, Marshall Barton
• Access query returning duplicated records, EA
  • RE: Access query returning duplicated records, Golfinray
• Retieve last dates in a query, Frikkie
  • Re: Retieve last dates in a query, Jeff Boyce
    • Re: Retieve last dates in a query, Frikkie
• Weird Query Problem, Golfinray
  • RE: Weird Query Problem, KARL DEWEY
    • RE: Weird Query Problem, Golfinray
      • RE: Weird Query Problem, Klatuu
      • RE: Weird Query Problem, KARL DEWEY
  • RE: Weird Query Problem, Klatuu
• Parameter Queries, OV Brian
  • Re: Parameter Queries, Evi
  • Re: Parameter Queries, John Spencer
• Cannot get an equation editor, Carl Gross
  • RE: Cannot get an equation editor, KARL DEWEY
    • RE: Cannot get an equation editor, Carl Gross
• need help with expression, erick-flores
  • RE: need help with expression, KARL DEWEY
  • RE: need help with expression, Jerry Whittle
  • Re: need help with expression, John Spencer
    • Re: need help with expression, erick-flores
• Use QBE Grid with Double-Quotes and/or Apostrophe, ryguy7272
  • Re: Use QBE Grid with Double-Quotes and/or Apostrophe, Jeanette Cunningham
    • Re: Use QBE Grid with Double-Quotes and/or Apostrophe, ryguy7272
• Search subform, goto record on main form., suguy
• Can I write this crosstab query as a select query?, erick-flores
  • RE: Can I write this crosstab query as a select query?, KARL DEWEY
  • Re: Can I write this crosstab query as a select query?, John Spencer
    • Re: Can I write this crosstab query as a select query?, erick-flores
• Changing Data Type of Column in Query., Bird_e_boy
  • Re: Changing Data Type of Column in Query., John Spencer
• MIN/MAX not working, jutlaux
  • RE: MIN/MAX not working, Jerry Whittle
• Help with runtime error 3075, croth68 via AccessMonster.com
  • Re: Help with runtime error 3075, suguy
    • Re: Help with runtime error 3075, croth68 via AccessMonster.com
  • Re: Help with runtime error 3075, John Spencer
    • Re: Help with runtime error 3075, croth68 via AccessMonster.com
• Row fix-up/updatable join on linked tables broken in Access 2007?, Brian Camire
  • Re: Row fix-up/updatable join on linked tables broken in Access 2007?, Brian Camire
• Please help! Clipboard, auujxa2 via AccessMonster.com
• Duplicate data in query, Beth Eadie
  • Re: Duplicate data in query, Evi
    • Re: Duplicate data in query, Beth Eadie
      • Re: Duplicate data in query, Evi
      • Re: Duplicate data in query, Beth Eadie
      • Re: Duplicate data in query, Evi
      • Re: Duplicate data in query, Beth Eadie
      • Re: Duplicate data in query, Evi
• Union Query, rml
  • Re: Union Query, John Spencer
    • Re: Union Query, rml
      • Re: Union Query, John Spencer
      • Re: Union Query, rml
      • Re: Union Query, John Spencer
      • Re: Union Query, rml
      • Re: Union Query, rml
• Deleting Duplicate Records in a single table, Mike P
  • Re: Deleting Duplicate Records in a single table, Jeanette Cunningham
• Excluding empty fields, emc
  • Re: Excluding empty fields, Jeanette Cunningham
    • Re: Excluding empty fields, emc
      • Re: Excluding empty fields, Jeanette Cunningham
      • Re: Excluding empty fields, emc
• Updateing multiple tables, B+ve
  • Re: Updateing multiple tables, John Spencer
• update for running sum, miss031
  • Re: update for running sum, Evi
• similar Records, Justin
  • Re: similar Records, Evi
    • Re: similar Records, Justin
• Wholesale AAA Shturmanskie Navigator Gagarin Men's Watch 31681-1743458-42 Replica, blog016
• Wholesale AAA Cartier Must 21 Steel Ladies Watch W10109T2 Replica, blog141
• Wholesale AAA Ebel Beluga Tonneau Diamond Ladies Mini Watch 1215448 Replica, blog141
• Using a Form to Select Query Values for Report, serno001
  • Re: Using a Form to Select Query Values for Report, Klein-4
    • Re: Using a Form to Select Query Values for Report, John Spencer
• SubDataSheet ability comes and goes without reason, topmind
• How do I remove zero length string from the fields in my table?, Todd
  • RE: How do I remove zero length string from the fields in my table?, KARL DEWEY
    • RE: How do I remove zero length string from the fields in my table, Todd
  • Re: How do I remove zero length string from the fields in my table?, Jeff Boyce
    • Re: How do I remove zero length string from the fields in my table, Todd
• Ave function, Linda RQ
  • Re: Ave function, John Spencer
    • Re: Ave function, Linda \(RQ\)
• Incorrect results when grouping in a query, Tammy
  • Re: Incorrect results when grouping in a query, John Spencer
    • Re: Incorrect results when grouping in a query, Tammy
• How to combine multiple lines by a sum function, cxw
  • RE: How to combine multiple lines by a sum function, KARL DEWEY
  • Re: How to combine multiple lines by a sum function, CJ
• how do i retrieve the last date for more than 1 field, jakkals
  • Re: how do i retrieve the last date for more than 1 field, John Spencer
• Subsetting by dollar amount, ChuckW
• Modifying my Date Select Query, Scuda
  • RE: Modifying my Date Select Query, KARL DEWEY
    • RE: Modifying my Date Select Query, Scuda
• Omitting certain returned values, EddieLampert
  • Re: Omitting certain returned values, John Spencer
    • Re: Omitting certain returned values, EddieLampert
      • Re: Omitting certain returned values, John Spencer
• Multiple Choice Parameter, acss
  • RE: Multiple Choice Parameter, Jerry Whittle
    • RE: Multiple Choice Parameter, acss
• LookUp a vaule in a array?, IT-1957
• query field help, ryan . fitzpatrick3
  • RE: query field help, KARL DEWEY
• Max value, Golfinray
  • Re: Max value, John Spencer
  • RE: Max value, remirocarleto@hotmail.com
• Deleting commas within quotes, RJF
  • RE: Deleting commas within quotes, KARL DEWEY
    • RE: Deleting commas within quotes, RJF
• Enter a property that is user defined, Leanne
  • Re: Enter a property that is user defined, John Spencer
    • Re: Enter a property that is user defined, Leanne
      • Re: Enter a property that is user defined, John Spencer
      • Re: Enter a property that is user defined, Leanne
      • Re: Enter a property that is user defined, John Spencer
      • Re: Enter a property that is user defined, Leanne
      • Re: Enter a property that is user defined, John Spencer
  • RE: Enter a property that is user defined, Leanne
• Search based on checkboxes, AlexG
  • Re: Search based on checkboxes, Evi
    • Re: Search based on checkboxes, AlexG
      • Re: Search based on checkboxes, Evi
• Select/Update Query with Command Button, ploddinggaltn
• Detect Idle Time & Exit Non Use routines in a mult-user environment, duncanjx
• Getting most recent date for multiple records, szag via AccessMonster.com
  • RE: Getting most recent date for multiple records, mike@work
  • Re: Getting most recent date for multiple records, John Spencer
    • Re: Getting most recent date for multiple records, szag via AccessMonster.com
      • Re: Getting most recent date for multiple records, John Spencer
      • Re: Getting most recent date for multiple records, szag via AccessMonster.com
      • Re: Getting most recent date for multiple records, John Spencer
      • Re: Getting most recent date for multiple records, szag via AccessMonster.com
      • Re: Getting most recent date for multiple records, szag via AccessMonster.com
      • Re: Getting most recent date for multiple records, John Spencer
• Append problem, mike@work
  • RE: Append problem, Dale Fye
• Parameter Query: Limit Parameter, Lkswrt54g
  • Re: Parameter Query: Limit Parameter, John Spencer
  • RE: Parameter Query: Limit Parameter, mike@work
    • RE: Parameter Query: Limit Parameter, lkswrt54g
      • RE: Parameter Query: Limit Parameter, Dale Fye
  • RE: Parameter Query: Limit Parameter, Dale Fye
  • RE: Parameter Query: Limit Parameter, lkswrt54g
    • Re: Parameter Query: Limit Parameter, Evi
• Casio Women's Beside watch #BEL101D7A - Replica Watch Fake, watches0572
• Wholesale AAA Ebel Brasilia Stainless Steel Mens Watch 9120M41/6235134 Replica, handbags017
• table not in append query list, lambertsm via AccessMonster.com
  • Re: table not in append query list, Jeanette Cunningham
    • Re: table not in append query list, lambertsm via AccessMonster.com
      • Re: table not in append query list, Jeanette Cunningham
      • Re: table not in append query list, John Spencer
      • Re: table not in append query list, Jeanette Cunningham
      • Re: table not in append query list, Jeanette Cunningham
• Please help with Query "dups", TotallyConfused
  • Re: Please help with Query "dups", Brendan Reynolds
  • Re: Please help with Query "dups", Evi
  • Re: Please help with Query "dups", John Spencer
    • Re: Please help with Query "dups", TotallyConfused
      • Re: Please help with Query "dups", John Spencer
      • Re: Please help with Query "dups", TotallyConfused
      • Re: Please help with Query "dups", John Spencer
• Using Or with an IIf Statement, dbad7
  • Re: Using Or with an IIf Statement, Marshall Barton
• flag (***) when the part number changes, Garry
  • Re: flag (***) when the part number changes, Jeff Boyce
    • Re: flag (***) when the part number changes, John Spencer
      • Re: flag (***) when the part number changes, Garry
      • Re: flag (***) when the part number changes, John Spencer
      • Re: flag (***) when the part number changes, Garry
      • Re: flag (***) when the part number changes, John Spencer
• Update query problem, senor_baub
  • RE: Update query problem, Duane Hookom
• Query Revision - Help Required, Paul W Smith
  • Re: Query Revision - Help Required, Al Campagna
    • Re: Query Revision - Help Required, Paul W Smith
      • Re: Query Revision - Help Required, John Spencer
      • Re: Query Revision - Help Required, Paul W Smith
      • Re: Query Revision - Help Required, John Spencer
      • Re: Query Revision - Help Required, Dale Fye
      • Re: Query Revision - Help Required, Steve Sanford
      • Re: Query Revision - Help Required, Paul W Smith
• Problem with Aliasing (AS), David Wetmore
  • RE: Problem with Aliasing (AS), Jerry Whittle
  • Re: Problem with Aliasing (AS), Jeff Boyce
  • Re: Problem with Aliasing (AS), David Wetmore
• data type for Make Table Query, Ted
  • Re: data type for Make Table Query, Jeff Boyce
• get max date from linked sql server table, ragtopcaddy via AccessMonster.com
  • <Possible follow-ups>
  • get max date from linked sql server table, ragtopcaddy via AccessMonster.com
    • Re: get max date from linked sql server table, John Spencer
      • Re: get max date from linked sql server table, ragtopcaddy via AccessMonster.com
      • Re: get max date from linked sql server table, John Spencer
      • Re: get max date from linked sql server table, ragtopcaddy via AccessMonster.com
      • Re: get max date from linked sql server table, ragtopcaddy via AccessMonster.com
• Grouping and adding columns, Jeffshex
  • RE: Grouping and adding columns, KARL DEWEY
    • RE: Grouping and adding columns, Jeffshex
      • RE: Grouping and adding columns, KARL DEWEY
• Someone Please Assist me with Expression ?, Gonzal
  • Re: Someone Please Assist me with Expression ?, Marshall Barton
    • Re: Someone Please Assist me with Expression ?, Gonzal
      • Re: Someone Please Assist me with Expression ?, Steve Sanford
• If then in Access SQL or macro, dksj67 via AccessMonster.com
  • Re: If then in Access SQL or macro, Marshall Barton
• Update field/table from a derived field in another query, Wendy
  • Re: Update field/table from a derived field in another query, Evi
• Group by with one field Unique Count, Jody
  • Re: Group by with one field Unique Count, John Spencer
• combind and rename, Pierre
  • Re: combind and rename, fredg
    • Re: combind and rename, Pierre
• how can i convert text to columns in access query, Lionel
  • Re: how can i convert text to columns in access query, fredg
• PivotChart woes.., Marcus
  • Re: PivotChart woes.., Marcus
• Compare fields against each other in a table, Dominick D.
  • Re: Compare fields against each other in a table, John Spencer
    • Re: Compare fields against each other in a table, Dominick D.
      • Re: Compare fields against each other in a table, John Spencer
  • Re: Compare fields against each other in a table, ANDY-N via AccessMonster.com
• query not working in 2007 access, jillm
  • RE: query not working in 2007 access, Jerry Whittle
    • RE: query not working in 2007 access, jillm
      • RE: query not working in 2007 access, Jerry Whittle
      • RE: query not working in 2007 access, jillm
      • RE: query not working in 2007 access, Jerry Whittle
      • RE: query not working in 2007 access, jmf
      • RE: query not working in 2007 access, Jerry Whittle
• Access Database bad structure, Queries...beginer, Sibo
  • RE: Access Database bad structure, Queries...beginer, Jerry Whittle
• Complex error in Query, Stockwell43
  • RE: Complex error in Query, Stockwell43
• Set Column Width, Leanne
  • Re: Set Column Width, Rick Brandt
    • Re: Set Column Width, Leanne
      • Re: Set Column Width, Rick Brandt
      • Re: Set Column Width, Leanne
      • Re: Set Column Width, Rick Brandt
      • Re: Set Column Width, Leanne
• Count of days, Linda RQ
  • RE: Count of days, Duane Hookom
  • Re: Count of days, Linda RQ
    • Re: Count of days, Rick Brandt
• Combine Tables without Duplicates, C. Bailey
  • RE: Combine Tables without Duplicates, Ken Sheridan
    • Re: Combine Tables without Duplicates, C. Bailey
• use calender to find dates, datahunter
  • Re: use calender to find dates, Jeff Boyce
• querying time, shirl
  • Re: querying time, John Spencer
    • Re: querying time, shirl
      • Re: querying time, John Spencer
      • Re: querying time, shirl
• Get all customers listed in a query, even with zero balance, magicdds-
  • Re: Get all customers listed in a query, even with zero balance, Marshall Barton
    • Re: Get all customers listed in a query, even with zero balance, magicdds-
      • Re: Get all customers listed in a query, even with zero balance, Marshall Barton
• Range of Records of update Query, ploddinggaltn
  • Re: Range of Records of update Query, Marshall Barton
• How to break a tie of fld A using fld B, Steve S
  • RE: How to break a tie of fld A using fld B, Duane Hookom
    • RE: How to break a tie of fld A using fld B, Steve S
  • Re: How to break a tie of fld A using fld B, John Spencer
    • Re: How to break a tie of fld A using fld B, Steve S
• Calculated or Entered Value, Bill
  • Re: Calculated or Entered Value, John Spencer
  • Re: Calculated or Entered Value, Rick Brandt
    • Re: Calculated or Entered Value, Bill
• QueryDef Help (Re-posted), NoodNutt
  • Re: QueryDef Help (Re-posted), Douglas J. Steele
    • Re: QueryDef Help (Re-posted), NoodNutt
    • Re: QueryDef Help (Re-posted), NoodNutt
    • Re: QueryDef Help (Re-posted), NoodNutt
      • Re: QueryDef Help (Re-posted), Douglas J. Steele
      • Re: QueryDef Help (Re-posted), NoodNutt
      • Re: QueryDef Help (Re-posted), Douglas J. Steele
      • Re: QueryDef Help (Re-posted), NoodNutt
      • Re: QueryDef Help (Re-posted), Douglas J. Steele
      • Re: QueryDef Help (Re-posted), NoodNutt
      • Re: QueryDef Help (Re-posted), Douglas J. Steele
      • Re: QueryDef Help (Re-posted), NoodNutt
• Query Problem, Debbie
  • Re: Query Problem, Debbie
    • Re: Query Problem, Debbie
• Query to capture AOL accounts, Glenn Dulmage
  • RE: Query to capture AOL accounts, Duane Hookom
    • Re: Query to capture AOL accounts, Glenn Dulmage
• Date issue in Access 2003 query, ShadrakUK
  • Re: Date issue in Access 2003 query, John W . Vinson
• Givenchy Apsaras Stainless Steel Ladies Watch AP.SM.S.3.2WHT - Replica Watch Fake, watches0112
• stored procedure query, smk23
  • Re: stored procedure query, Rick Brandt
    • Re: stored procedure query, smk23
      • Re: stored procedure query, Rick Brandt
      • Re: stored procedure query, smk23
• How to email differnet people in a query, MacrossHunter77
  • Re: How to email differnet people in a query, Rick Brandt
    • Re: How to email differnet people in a query, MacrossHunter77 via AccessMonster.com
    • Re: How to email differnet people in a query, MacrossHunter77 via AccessMonster.com
      • Re: How to email differnet people in a query, Rick Brandt
      • Re: How to email differnet people in a query, MacrossHunter77 via AccessMonster.com
      • Re: How to email differnet people in a query, Rick Brandt
    • Re: How to email differnet people in a query, MacrossHunter77 via AccessMonster.com
• Top 3, Louise
  • Re: Top 3, Jeff Boyce
    • Re: Top 3, Louise
      • Re: Top 3, raskew via AccessMonster.com
      • Re: Top 3, Jeff Boyce
      • Re: Top 3, raskew via AccessMonster.com
• My query doesn't display all data - records from tables! HELP, Ivan
  • Re: My query doesn't display all data - records from tables! HELP, John Spencer
• Updating Make Queries in File Server Set-up, Eugene
• ODBC Driver Manager not found Access 2007, JCIrish
• Query to calculate number of assemblies, DougW via AccessMonster.com
• Query Sum return incorrect total., idtjes3
  • RE: Query Sum return incorrect total., Jerry Whittle
    • RE: Query Sum return incorrect total., idtjes3
  • Re: Query Sum return incorrect total., NoodNutt
    • Re: Query Sum return incorrect total., idtjes3
• Count responses in report or Query, Clay
  • Re: Count responses in report or Query, John Spencer
    • Re: Count responses in report or Query, Clay
      • Re: Count responses in report or Query, John Spencer
  • RE: Count responses in report or Query, Clay
• Trying to check dates in a query, GaryP
  • RE: Trying to check dates in a query, Klatuu
    • RE: Trying to check dates in a query, GaryP
  • Re: Trying to check dates in a query, John Spencer
• between datetime value from date time picker, Souris
  • RE: between datetime value from date time picker, Klatuu
    • RE: between datetime value from date time picker, Souris
    • RE: between datetime value from date time picker, Dale Fye
• Alternative to domain functions?, BruceM
  • RE: Alternative to domain functions?, Jerry Whittle
    • Re: Alternative to domain functions?, BruceM
• Failed query, Oldjay
• union query returns floating point value, Souris
• Find missing Working Days, Evi
  • RE: Find missing Working Days, Dale Fye
    • Re: Find missing Working Days, Evi
• Queries not returing all results, timmycav
  • Re: Queries not returing all results, Ken Snell \(MVP\)
    • Re: Queries not returing all results, timmycav
      • Re: Queries not returing all results, Dale Fye
      • Re: Queries not returing all results, timmycav
• Query that returns entries of only the current week (or two), Mewmew
  • Re: Query that returns entries of only the current week (or two), Ken Snell \(MVP\)
  • Re: Query that returns entries of only the current week (or two), raskew via AccessMonster.com
• Invalid SQL Statement in VBA sub, JCIrish
  • Re: Invalid SQL Statement in VBA sub, Ken Snell \(MVP\)
    • Re: Invalid SQL Statement in VBA sub, Ken Snell \(MVP\)
      • Re: Invalid SQL Statement in VBA sub, JCIrish
      • Re: Invalid SQL Statement in VBA sub, Ken Snell \(MVP\)
      • Re: Invalid SQL Statement in VBA sub, JCIrish
      • Re: Invalid SQL Statement in VBA sub, Ken Snell \(MVP\)
      • Re: Invalid SQL Statement in VBA sub, JCIrish
• Qry not pulling bound column problem, AJ
  • Re: Qry not pulling bound column problem, Jeanette Cunningham
  • Re: Qry not pulling bound column problem, John W. Vinson/MVP
    • Re: Qry not pulling bound column problem, AJ
      • Re: Qry not pulling bound column problem, John W. Vinson/MVP
      • Re: Qry not pulling bound column problem, AJ
      • Re: Qry not pulling bound column problem, Jeanette Cunningham
• How to - Qry question, AJ
  • RE: How to - Qry question, Duane Hookom
    • RE: How to - Qry question, AJ
• Access Run really Slow, Grace
  • Re: Access Run really Slow, John W. Vinson/MVP
• group by and count null values, Todd
  • RE: group by and count null values, KARL DEWEY
    • RE: group by and count null values, Todd
  • RE: group by and count null values, Dale Fye
    • RE: group by and count null values, Todd
      • RE: group by and count null values, Dale Fye
      • RE: group by and count null values, Todd
• concatenation problem, Rich
  • RE: concatenation problem, Klatuu
    • Re: concatenation problem, John Spencer
      • Re: concatenation problem, Klatuu
  • Re: concatenation problem, John W. Vinson/MVP
    • Re: concatenation problem, John Spencer
    • Re: concatenation problem, Rich
• how do I combine Select and Update queries, David Powell
  • RE: how do I combine Select and Update queries, Klatuu
• Replace in 2007, Mapping
• Check for a value in the results of a query, magicdds-
  • Re: Check for a value in the results of a query, George Nicholson
    • Re: Check for a value in the results of a query, magicdds-
• criteria in query from form, 2Blessed4Stress
  • RE: criteria in query from form, KARL DEWEY
    • RE: criteria in query from form, 2Blessed4Stress
      • RE: criteria in query from form, KARL DEWEY
      • RE: criteria in query from form, 2Blessed4Stress
• Date question, ryan . fitzpatrick3
  • Re: Date question, raskew via AccessMonster.com
  • RE: Date question, Klatuu
    • Re: Date question, ryan . fitzpatrick3
• Move back a month, Lime
  • RE: Move back a month, akphidelt
    • RE: Move back a month, Klatuu
  • Re: Move back a month, John W. Vinson/MVP
    • Re: Move back a month, Lime
• Select min value, Rafi
  • RE: Select min value, akphidelt
• how do I count "is null" return "pending" in access, Todd
  • RE: how do I count "is null" return "pending" in access, Golfinray
    • RE: how do I count "is null" return "pending" in access, Todd
    • RE: how do I count "is null" return "pending" in access, Todd
    • RE: how do I count "is null" return "pending" in access, Todd
  • RE: how do I count "is null" return "pending" in access, Klatuu
    • RE: how do I count "is null" return "pending" in access, Todd
    • RE: how do I count "is null" return "pending" in access, Todd
    • RE: how do I count "is null" return "pending" in access, Todd
  • Re: how do I count "is null" return "pending" in access, John Spencer
    • Re: how do I count "is null" return "pending" in access, Todd
    • Re: how do I count "is null" return "pending" in access, Todd
• input box to update query, Carlee
• Refering to date fields in a form., Kjell Harnesk
  • RE: Refering to date fields in a form., akphidelt
    • RE: Refering to date fields in a form., KARL DEWEY
      • Re: Refering to date fields in a form., Ron2006
    • Re: Refering to date fields in a form., Kjell Harnesk
• Between and DateAdd Problem, JJ
  • RE: Between and DateAdd Problem, Klatuu
    • Re: Between and DateAdd Problem, Ron2006
      • Re: Between and DateAdd Problem, Klatuu
      • Re: Between and DateAdd Problem, JJ
• how do I get rid of "the expression you entered exceeds the 1,024-character limit for the query deisgn grid", annysjunkmail
  • RE: how do I get rid of "the expression you entered exceeds the 1,024-, KARL DEWEY
    • Re: how do I get rid of "the expression you entered exceeds the 1,024-, annysjunkmail
    • Re: how do I get rid of "the expression you entered exceeds the 1,024-, annysjunkmail
  • Re: how do I get rid of "the expression you entered exceeds the 1,024-character limit for the query deisgn grid", Chris O'C via AccessMonster.com
    • Re: how do I get rid of "the expression you entered exceeds the 1,024-character limit for the query deisgn grid", Chris O'C via AccessMonster.com
      • Re: how do I get rid of "the expression you entered exceeds the 1,024-character limit for the query deisgn grid", annysjunkmail
• Unlikely error msg from query, RandomTask
  • RE: Unlikely error msg from query, mscertified
    • RE: Unlikely error msg from query, RandomTask
• Help with Unmatch Query, Lori
  • Re: Help with Unmatch Query, John Spencer
    • Re: Help with Unmatch Query, Lori
      • Re: Help with Unmatch Query, Lori
• create query from option group, angie
  • RE: create query from option group, KARL DEWEY
    • RE: create query from option group, angie
• Query will run but error msg on Save, Matilda
  • Re: Query will run but error msg on Save, John W. Vinson/MVP
    • Re: Query will run but error msg on Save, Matilda
• Re: SQL QUERY PROBLEM : ORDER BY POPULARITY THEN DISTINCT, John Spencer
• Decision query, upsman via AccessMonster.com
  • RE: Decision query, KARL DEWEY
    • RE: Decision query, upsman via AccessMonster.com
• Calculation in Query, JennKriv
  • RE: Calculation in Query, akphidelt
  • RE: Calculation in Query, KARL DEWEY
  • Re: Calculation in Query, Evi
    • Re: Calculation in Query, JennKriv
      • Re: Calculation in Query, Evi
  • <Possible follow-ups>
  • Calculation in Query, Hardhit
• Union Query Group By, talibm
  • RE: Union Query Group By, Klatuu
  • RE: Union Query Group By, akphidelt
    • RE: Union Query Group By, talibm
  • RE: Union Query Group By, talibm
• “Division by zero”, Gonzalo
  • RE: “Division by zero”, Jerry Whittle
    • RE: “Division by zero”, Klatuu
      • RE: “Division by zero”, Gonzalo
• double check an update query, JRough
• union query precision issue, Souris
  • RE: union query precision issue, Jerry Whittle
    • RE: union query precision issue, Souris
    • RE: union query precision issue, Souris
      • Re: union query precision issue, John Spencer
      • Re: union query precision issue, Souris
      • Re: union query precision issue, Souris
• Query question involving AutoNumber data type, MichaelJohnson168
  • RE: Query question involving AutoNumber data type, akphidelt
• Pull field information only if it has information in it, ryan . fitzpatrick3
  • <Possible follow-ups>
  • Pull field information only if it has information in it, ryan . fitzpatrick3
    • RE: Pull field information only if it has information in it, Golfinray
      • Re: Pull field information only if it has information in it, ryan . fitzpatrick3
      • Re: Pull field information only if it has information in it, NetworkTrade
      • Re: Pull field information only if it has information in it, John Spencer
• Crosstab, Kou Vang
  • RE: Crosstab, KARL DEWEY
    • RE: Crosstab, Kou Vang
      • RE: Crosstab, KARL DEWEY
• select specific character from memo field, AlanO via AccessMonster.com
• How to do a left and right join together?, Grd
  • Re: How to do a left and right join together?, George Nicholson
    • Re: How to do a left and right join together?, Grd
  • RE: How to do a left and right join together?, Dale Fye
    • RE: How to do a left and right join together?, Grd
• Need to assign Column Header Alias in MS Access Query, Ray
• Using criteria on a calculated field in a query, jubu
  • RE: Using criteria on a calculated field in a query, Dale Fye
• How to I stop a running query in Access 2007, LCSO Carol
• Query totaling one field for unique values, Cathy C
  • RE: Query totaling one field for unique values, KARL DEWEY
    • Re: Query totaling one field for unique values, Cathy C
• multiple outcomes, Vadimbar
  • Re: multiple outcomes, George Nicholson
    • Re: multiple outcomes, Vadimbar
      • Re: multiple outcomes, George Nicholson
      • Re: multiple outcomes, Vadimbar
  • Re: multiple outcomes, NuBie via AccessMonster.com
    • Re: multiple outcomes, Vadimbar
  • Re: multiple outcomes, John Spencer
    • Re: multiple outcomes, Vadimbar
• Problem with Dupl Query, SITCFanTN
  • RE: Problem with Dupl Query, Jerry Whittle
    • RE: Problem with Dupl Query, SITCFanTN
      • RE: Problem with Dupl Query, Jerry Whittle
      • RE: Problem with Dupl Query, SITCFanTN
• Query modification, Anne
• Query not working, L Wilson
  • Re: Query not working, Jeff Boyce
    • Re: Query not working, L Wilson
• crosstab parameter, Souris
  • RE: crosstab parameter, Jerry Whittle
    • RE: crosstab parameter, Souris
• More than one claim, dbl
  • Re: More than one claim, Jeff Boyce
  • RE: More than one claim, Jerry Whittle
    • Re: More than one claim, Bob
      • Re: More than one claim, Jerry Whittle
      • Re: More than one claim, dbl
• Input Form, pepperj
  • RE: Input Form, Duane Hookom
• Payment Query, jkjmwilliams
  • Re: Payment Query, Evi
    • Re: Payment Query, jkjmwilliams
  • RE: Payment Query, jkjmwilliams
    • RE: Payment Query, jkjmwilliams
      • Re: Payment Query, Evi
      • Re: Payment Query, jkjmwilliams
      • Re: Payment Query, Evi
• Group by a multiple fields in query, Try Hard
  • Re: Group by a multiple fields in query, John W. Vinson/MVP
    • Re: Group by a multiple fields in query, Try Hard
      • Re: Group by a multiple fields in query, John W. Vinson/MVP
• optimize queries that refer to a calculated field in a source table, JRough
  • Re: optimize queries that refer to a calculated field in a source table, JRough
• Append table with If then else, MN
  • Re: Append table with If then else, Evi
    • Re: Append table with If then else, MN
• Nearly correct query needs checking PLZ, jonathan . cohen150887
  • Re: Nearly correct query needs checking PLZ, jonathan . cohen150887
    • Re: Nearly correct query needs checking PLZ, John Spencer
• Pass Thru Query Connection, Rickety107
  • Re: Pass Thru Query Connection, Gary Walter
• Refining query, SMT
  • RE: Refining query, Jerry Whittle
    • RE: Refining query, SMT
      • Re: Refining query, Gary Walter
      • Re: Refining query, SMT
      • Re: Refining query, Gary Walter
      • Re: Refining query, Gary Walter
      • Re: Refining query, SMT
      • Re: Refining query, Gary Walter
      • Message not available
      • Re: Refining query, Gary Walter
      • Re: Refining query, SMT
• JET Syntax problem, Harry V
  • Re: JET Syntax problem, fredg
    • Re: JET Syntax problem, Harry V
      • Re: JET Syntax problem, Harry V
• find the query that made a table., JH
  • RE: find the query that made a table., KARL DEWEY
    • RE: find the query that made a table., JH
      • RE: find the query that made a table., KARL DEWEY
      • RE: find the query that made a table., JH
      • RE: find the query that made a table., KARL DEWEY
      • RE: find the query that made a table., JH
      • Re: find the query that made a table., John Spencer
• Change format to results of Make table query, mcarter
  • RE: Change format to results of Make table query, Duane Hookom
  • Re: Change format to results of Make table query, John W. Vinson/MVP
• multi keyword search, don
  • RE: multi keyword search, Golfinray
    • multi keyword search, don
  • Re: multi keyword search, John W. Vinson/MVP
• Re: QUERY DESIGN PROBLEM, jonathan . cohen150887
• Update Query - Moving Data to Different Fields, Karen
  • RE: Update Query - Moving Data to Different Fields, Karen
• Date Criteria with Nz(), Question Boy
  • Re: Date Criteria with Nz(), Rick Brandt
• need percent based on DCount, CBeavers
  • Re: need percent based on DCount, Evi
  • Re: need percent based on DCount, John Spencer
    • Re: need percent based on DCount, CBeavers
• Distinct Count on a Report, ncm
  • Re: Distinct Count on a Report, Evi
• Ranking, RSon
  • Re: Ranking, Evi
    • Re: Ranking, RSon
      • Re: Ranking, John Spencer
• Creating a league table by multiple criteria, Tony Winter 77
• Make table qry - number format as Double, D
  • RE: Make table qry - number format as Double, Jerry Whittle
    • RE: Make table qry - number format as Double, D
• Form based on query opens slow, kjjames via AccessMonster.com
  • RE: Form based on query opens slow, Jerry Whittle
    • RE: Form based on query opens slow, kjjames via AccessMonster.com
      • RE: Form based on query opens slow, Jerry Whittle
  • RE: Form based on query opens slow, Jerry Whittle
• Weekend date, Johanna Gronlund
  • Re: Weekend date, NuBie via AccessMonster.com
  • Re: Weekend date, John W. Vinson/MVP
• Combining fields with similar initial characters, carl jordan
  • Re: Combining fields with similar initial characters, Evi
    • Re: Combining fields with similar initial characters, carl jordan
• add to group using macro, Loxsie
• Table not available for Append query, Mo
  • Re: Table not available for Append query, Evi
    • Re: Table not available for Append query, Mo
      • Re: Table not available for Append query, Evi
  • Re: Table not available for Append query, John Spencer
    • Re: Table not available for Append query, Mo
      • Re: Table not available for Append query, Mo
      • Re: Table not available for Append query, Jeanette Cunningham
      • Re: Table not available for Append query, Evi
      • Re: Table not available for Append query, Mo
      • Re: Table not available for Append query, Evi
      • Re: Table not available for Append query, Mo
      • Re: Table not available for Append query, Jeanette Cunningham
      • Re: Table not available for Append query, Jeanette Cunningham
      • Re: Table not available for Append query, Mo
      • Re: Table not available for Append query, Mo
• Disguising data, Angela 'Angel' Brown
  • RE: Disguising data, Dennis
    • RE: Disguising data, Angela 'Angel' Brown
• date string from form to query's criteria, Rafi
  • Re: date string from form to query's criteria, NuBie via AccessMonster.com
• ON ... AND statement problem, Olivier57
  • RE: ON ... AND statement problem, Olivier57
  • Re: ON ... AND statement problem, John W. Vinson/MVP
    • Re: ON ... AND statement problem, Olivier57
• Varying Number of Columns in Crosstab Query, Darrell
  • Re: Varying Number of Columns in Crosstab Query, Rob Parker
    • Re: Varying Number of Columns in Crosstab Query, Darrell
• How to create a rolling sum in a query, RSon
  • Re: How to create a rolling sum in a query, Ken Snell \(MVP\)
    • Re: How to create a rolling sum in a query, RSon
      • Re: How to create a rolling sum in a query, Ken Snell \(MVP\)
• Concatenating multiple records into one text field, Tomas C
  • RE: Concatenating multiple records into one text field, Duane Hookom
    • Re: Concatenating multiple records into one text field, Tomas C
      • Re: Concatenating multiple records into one text field, Tomas C
• query: record count discrepancies, saraua
  • RE: query: record count discrepancies, KARL DEWEY
• Duplicate Query but with small Time Variance, Chris
  • RE: Duplicate Query but with small Time Variance, KARL DEWEY
    • RE: Duplicate Query but with small Time Variance, Chris
      • RE: Duplicate Query but with small Time Variance, KARL DEWEY
• query or VBA, harleyken
  • RE: query or VBA, Ken Sheridan
• Invalid Argument Error, Cameron
  • Re: Invalid Argument Error, Ken Snell \(MVP\)
• Change values to negatives, Iram
  • Re: Change values to negatives, NuBie
• NZ, JimS
  • Re: NZ, fredg
    • Re: NZ, JimS
    • Re: NZ, George Nicholson
      • Re: NZ, JimS
      • Re: NZ, John Spencer
• Query to Linked Excel CSV by Multiple users, Brian Cook
  • RE: Query to Linked Excel CSV by Multiple users, JimS
    • RE: Query to Linked Excel CSV by Multiple users, Brian Cook
      • RE: Query to Linked Excel CSV by Multiple users, JimS
      • RE: Query to Linked Excel CSV by Multiple users, Brian Cook
• cross tab query fill with zero, Souris
  • RE: cross tab query fill with zero, KARL DEWEY
    • RE: cross tab query fill with zero, Souris
      • RE: cross tab query fill with zero, KARL DEWEY
• Creating a query with dynamic fields, GrantM
  • RE: Creating a query with dynamic fields, Ken Sheridan
    • RE: Creating a query with dynamic fields, GrantM
• Pass Through Query Help!!!, tkosel
  • RE: Pass Through Query Help!!!, JimS
  • RE: Pass Through Query Help!!!, JimS
    • RE: Pass Through Query Help!!!, tkosel
• Formatting Number in Query View, Tiz
  • RE: Formatting Number in Query View, KARL DEWEY
• Scheduling help, Abby
  • RE: Scheduling help, JimS
    • RE: Scheduling help, Abby
      • RE: Scheduling help, JimS
• Baffled by access report anomaly displaying data, Teri Welch
  • Re: Baffled by access report anomaly displaying data, Ken Snell \(MVP\)
• Expression clause in the Totals row in the QBE?, Ed Brancheau
  • Re: Expression clause in the Totals row in the QBE?, Ken Snell \(MVP\)
    • Re: Expression clause in the Totals row in the QBE?, Ed Brancheau
      • Re: Expression clause in the Totals row in the QBE?, JimS
      • Re: Expression clause in the Totals row in the QBE?, Ken Snell \(MVP\)
• Running Total, SAC
  • Re: Running Total, Evi
    • Re: Running Total, SAC
  • RE: Running Total, Ken Sheridan
    • RE: Running Total, Ken Sheridan
    • Re: Running Total, SAC
    • Re: Running Total, SAC
• The A-Z sort button in .mde files, ic_fish
  • Re: The A-Z sort button in .mde files, Rick Brandt
    • Re: The A-Z sort button in .mde files, ic_fish via AccessMonster.com
• Calculating monthly charges, Sean Bishop
  • Re: Calculating monthly charges, Ken Snell \(MVP\)
• column manipulation, Mano
  • Re: column manipulation, John W . Vinson
    • Re: column manipulation, Mano
• Not like, Charles via AccessMonster.com
  • RE: Not like, Duane Hookom
    • RE: Not like, quinto via AccessMonster.com
      • Re: Not like, Rick Brandt
      • Re: Not like (CORRECTION), Rick Brandt
      • Re: Not like, Charles via AccessMonster.com
      • Re: Not like, quinto via AccessMonster.com
      • Re: Not like, Duane Hookom
      • Re: Not like, quinto via AccessMonster.com
      • Re: Not like, Duane Hookom
      • Re: Not like, NewAccessDude
      • Re: Not like, Duane Hookom
• Query or a form required, subs
  • RE: Query or a form required, Duane Hookom
    • Re: Query or a form required, subs
      • Re: Query or a form required, Duane Hookom
      • Re: Query or a form required, subs
      • Re: Query or a form required, Duane Hookom
      • Re: Query or a form required, subs
      • Re: Query or a form required, Duane Hookom
      • Re: Query or a form required, subs
      • Re: Query or a form required, Duane Hookom
• Average Percent, Linda RQ
  • RE: Average Percent, Duane Hookom
    • Re: Average Percent, Linda RQ
      • Re: Average Percent, John Spencer
      • Re: Average Percent, Linda RQ
• Query to Merge 2 records in same table, sippyuconn
  • Re: Query to Merge 2 records in same table, Wolfgang Kais
    • Re: Query to Merge 2 records in same table, sippyuconn
      • Re: Query to Merge 2 records in same table, Wolfgang Kais
  • Re: Query to Merge 2 records in same table, John Spencer
• IIF & replace question, Choli
  • RE: IIF & replace question, Duane Hookom
    • RE: IIF & replace question, Choli
      • RE: IIF & replace question, Duane Hookom
      • RE: IIF & replace question, Choli
      • RE: IIF & replace question, Duane Hookom
      • Re: IIF & replace question, Marshall Barton
• Left Join Query Problem, Pat Coleman
  • RE: Left Join Query Problem, KARL DEWEY
    • Re: Left Join Query Problem, Pat Coleman
• A Challenge Query, aldunford
  • Re: A Challenge Query, Ken Snell \(MVP\)
    • Re: A Challenge Query, aldunford
    • Re: A Challenge Query, aldunford
• If statement, jenniferspnc
  • Re: If statement, Evi
    • Re: If statement, jenniferspnc
      • Re: If statement, Evi
  • Re: If statement, Jeff Boyce
• OutputTo File, Kris
  • RE: OutputTo File, Ken Sheridan
• Max Function, Dustin B
  • Re: Max Function, Wolfgang Kais
• Query to find duplicate records, Cam
  • Re: Query to find duplicate records, Jeff Boyce
• Joining Access table to SQL table with "Float" datatype, Ken Valenti
  • Re: Joining Access table to SQL table with "Float" datatype, Rick Brandt
  • Re: Joining Access table to SQL table with "Float" datatype, John W . Vinson
• Another Stumper, JimS
  • Re: Another Stumper, Jeff Boyce
  • Re: Another Stumper, Marshall Barton
• SQL for Post Obtaining "Current Balance" ..., Such a Beginner
  • RE: SQL for Post Obtaining "Current Balance" ..., KARL DEWEY
• Moving duplicate records to a separate table., Brad Granath
  • Re: Moving duplicate records to a separate table., John Spencer
    • Re: Moving duplicate records to a separate table., Brad Granath
• Obtaining "Current Balance" from multiple "Amount" entries, Such a Beginner
  • RE: Obtaining "Current Balance" from multiple "Amount" entries, KARL DEWEY
    • RE: Obtaining "Current Balance" from multiple "Amount" entries, Such a Beginner
      • RE: Obtaining "Current Balance" from multiple "Amount" entries, Klatuu
      • RE: Obtaining "Current Balance" from multiple "Amount" entries, Klatuu
• Formula Problems, Love Buzz
  • Re: Formula Problems, Marshall Barton
    • Re: Formula Problems, Love Buzz
      • Re: Formula Problems, KARL DEWEY
      • Re: Formula Problems, Marshall Barton
      • Re: Formula Problems, Love Buzz
      • Re: Formula Problems, KARL DEWEY
      • Re: Formula Problems, Love Buzz
      • Re: Formula Problems, Marshall Barton
  • RE: Formula Problems, KARL DEWEY
• Show only people who match multiple paramaters, Supe
  • RE: Show only people who match multiple paramaters, KARL DEWEY
    • RE: Show only people who match multiple paramaters, Supe
      • RE: Show only people who match multiple paramaters, KARL DEWEY
• Query not working in find a form Access 2007, L Wilson
• Update Query?, aldunford
  • RE: Update Query?, Bob Cutler
    • RE: Update Query?, aldunford
• Problems converting Text field to Date/Time, ChuckW
  • RE: Problems converting Text field to Date/Time, KARL DEWEY
    • RE: Problems converting Text field to Date/Time, KARL DEWEY
      • Re: Problems converting Text field to Date/Time, John W . Vinson
• What happened YESTERDAY - date/time, Annette
  • Re: What happened YESTERDAY - date/time, john . fuller
  • RE: What happened YESTERDAY - date/time, Klatuu
  • RE: What happened YESTERDAY - date/time, KARL DEWEY
  • Re: What happened YESTERDAY - date/time, Rick Brandt
• Date query in VBA Module, NoCanDo
  • RE: Date query in VBA Module, Duane Hookom
    • RE: Date query in VBA Module, NoCanDo via AccessMonster.com
      • RE: Date query in VBA Module, Duane Hookom
  • Re: Date query in VBA Module, John Spencer
    • Re: Date query in VBA Module, NoCanDo via AccessMonster.com
      • Re: Date query in VBA Module, John Spencer
      • Re: Date query in VBA Module, NoCanDo via AccessMonster.com
• SQL problem, database crashes., scubadiver
  • RE: SQL problem, database crashes., scubadiver
• format a time field in a query, Martyn
  • Re: format a time field in a query, Evi
  • RE: format a time field in a query, Dale Fye
• percentages problem: what am I doing wrong?, scubadiver
  • RE: percentages problem: what am I doing wrong?, scubadiver
• user entering the data, subs
  • RE: user entering the data, Duane Hookom
    • Re: user entering the data, subs
      • Re: user entering the data, scubadiver
      • Re: user entering the data, Duane Hookom
• RE: Null value in multi-parameter queries, GBAccess
• Selection of output, subs
  • Re: Selection of output, John Spencer
• find available IP, Song Su
  • RE: find available IP, KARL DEWEY
    • Re: find available IP, Song Su
      • Re: find available IP, Gary Walter
      • Re: find available IP, Gary Walter
      • Re: find available IP, KARL DEWEY
• Help with update query, using result of Max query, Jey
  • Re: Help with update query, using result of Max query, Gary Walter
    • Re: Help with update query, using result of Max query, Jey
• How do I split Names into 2 or more fields?, SlippDogg69
  • Re: How do I split Names into 2 or more fields?, John W . Vinson
• SQL WHERE statement, dksj67
  • Re: SQL WHERE statement, Douglas J. Steele
    • Re: SQL WHERE statement, dksj67
  • Re: SQL WHERE statement, John Spencer
    • Re: SQL WHERE statement, dksj67 via AccessMonster.com
• Calculate years from multiple records, Mariah
  • RE: Calculate years from multiple records, KARL DEWEY
    • RE: Calculate years from multiple records, Mariah
• Subtracting 2 "time" fields, carl
  • Re: Subtracting 2 "time" fields, Marshall Barton
    • Re: Subtracting 2 "time" fields, carl
      • Re: Subtracting 2 "time" fields, Marshall Barton
      • Re: Subtracting 2 "time" fields, John Spencer
• Access version of =Proper, Dan
  • Re: Access version of =Proper, fredg
• DMax, sturner333
  • RE: DMax, sturner333
  • Re: DMax, Marshall Barton
    • Re: DMax, sturner333
• Please Help Build an expression, lmyrfield
  • RE: Please Help Build an expression, KARL DEWEY
• counting the status types, JRough
  • Re: counting the status types, John Spencer
• How do I replace astricks * with 0 in a column?, Mitchell_Collen via AccessMonster.com
  • Re: How do I replace astricks * with 0 in a column?, Marshall Barton
    • Re: How do I replace astricks * with 0 in a column?, Mitchell_Collen via AccessMonster.com
• query brings in dups that i don't want, mcarter
  • Re: query brings in dups that i don't want, Marshall Barton
• how can i create a stored procedure, diaExcel
  • RE: how can i create a stored procedure, Golfinray
    • RE: how can i create a stored procedure, diaExcel
  • Re: how can i create a stored procedure, John W . Vinson
• SQL statement assistance, dksj67
  • Re: SQL statement assistance, fredg
  • Re: SQL statement assistance, Marshall Barton
    • Re: SQL statement assistance, dksj67
  • Re: SQL statement assistance, John Spencer
• Change/Save to aggregate query shuts down Access, BillC
  • RE: Change/Save to aggregate query shuts down Access, Golfinray
    • RE: Change/Save to aggregate query shuts down Access, BillC
  • RE: Change/Save to aggregate query shuts down Access, Jerry Whittle
    • RE: Change/Save to aggregate query shuts down Access, BillC
  • Re: Change/Save to aggregate query shuts down Access, Terry
• Compare Records in the same table, Ray magill
  • RE: Compare Records in the same table, Klatuu
    • RE: Compare Records in the same table, Ray magill
    • Re: Compare Records in the same table, John Spencer
  • Re: Compare Records in the same table, Marshall Barton
    • Re: Compare Records in the same table, Klatuu
• How do I search for a TAB in a field in a query?, DennisT
  • Re: How do I search for a TAB in a field in a query?, Marshall Barton
• Counting number of Mondays in a month, Jason
  • RE: Counting number of Mondays in a month, Klatuu
    • RE: Counting number of Mondays in a month, Jason
      • RE: Counting number of Mondays in a month, Klatuu
      • RE: Counting number of Mondays in a month, Jason
      • RE: Counting number of Mondays in a month, Klatuu
      • RE: Counting number of Mondays in a month, Klatuu
• Macro condition that i cannot find answer for anywhere, Accessghostrider via AccessMonster.com
  • Re: Macro condition that i cannot find answer for anywhere, John W . Vinson
  • RE: Macro condition that i cannot find answer for anywhere, Jerry Whittle
• Personnel leaving in 30 days and also 7 days, Cramer,Samuel USN
  • Re: Personnel leaving in 30 days and also 7 days, Jeff Boyce
    • Re: Personnel leaving in 30 days and also 7 days, Cramer,Samuel USN
• Absolutely Stumped on Query, JimS
  • Re: Absolutely Stumped on Query, Ken Snell \(MVP\)
    • Re: Absolutely Stumped on Query, JimS
      • Re: Absolutely Stumped on Query, Ken Snell \(MVP\)
      • Re: Absolutely Stumped on Query, JimS
• Crosstab help needed, scubadiver
  • RE: Crosstab help needed, KARL DEWEY
• Round up on .1?, Round up on .01
  • Re: Round up on .1?, John Spencer
    • Re: Round up on .1?, Round up on .01
      • Re: Round up on .1?, John Spencer
• SQL Help - Criteria Based On 2 Fields 1 Table, Cascot
  • Re: SQL Help - Criteria Based On 2 Fields 1 Table, John Spencer
• Send email to members, Tony
  • RE: Send email to members, Dennis
    • RE: Send email to members, Totte via AccessMonster.com
      • RE: Send email to members, Dennis
      • RE: Send email to members, Totte via AccessMonster.com
  • RE: Send email to members, Dennis
    • RE: Send email to members, Totte via AccessMonster.com
• InStrRev returns odd results, KARL DEWEY
  • Re: InStrRev returns odd results, John Spencer
• Looking for Help With Access - Writing a criteria that cross references 2 tables, mschneider25
  • RE: Looking for Help With Access - Writing a criteria that cross refer, KARL DEWEY
  • Re: Looking for Help With Access - Writing a criteria that cross references 2 tables, John Spencer
• Convert No Record to Zero, glnbnz
  • Re: Convert No Record to Zero, Evi
    • Re: Convert No Record to Zero, glnbnz
      • Re: Convert No Record to Zero, Evi
    • Re: Convert No Record to Zero, John W . Vinson
      • Re: Convert No Record to Zero, Evi
      • Re: Convert No Record to Zero, glnbnz
• Dependants, NeoFax
  • Re: Dependants, Jeff Boyce
    • Re: Dependants, NeoFax
      • Re: Dependants, Jeff Boyce
• shift key access to secure Db, Rich
  • RE: shift key access to secure Db, NetworkTrade
  • Re: shift key access to secure Db, Douglas J. Steele
  • Re: shift key access to secure Db, George Nicholson
  • Re: shift key access to secure Db, John W . Vinson
    • Re: shift key access to secure Db, Rich
• Numbers won't display in my address labels, Jen_ConfusedAboutAccess
  • RE: Numbers won't display in my address labels, KARL DEWEY
    • RE: Numbers won't display in my address labels, Jen_ConfusedAboutAccess
  • Re: Numbers won't display in my address labels, John Spencer
    • Re: Numbers won't display in my address labels, Jen_ConfusedAboutAccess
      • Re: Numbers won't display in my address labels, John W . Vinson
• conditional criteria, DawnTreader
  • RE: conditional criteria, KARL DEWEY
    • RE: conditional criteria, DawnTreader
      • RE: conditional criteria, KARL DEWEY
• Report Generator Question, Tim
  • Message not available
    • Re: Report Generator Question, Tim
      • Re: Report Generator Question, John W . Vinson
      • Re: Report Generator Question, Tim
      • Re: Report Generator Question, John W . Vinson
      • Re: Report Generator Question, Tim
  • Re: Report Generator Question, John Spencer
    • Re: Report Generator Question, Tim
• How do you pass parameters between queries in Microso, Nick 1136
  • Re: How do you pass parameters between queries in Microso, Jeff Boyce
  • RE: How do you pass parameters between queries in Microso, KARL DEWEY
• Crosstab for specific number of days, Molasses26
  • RE: Crosstab for specific number of days, KARL DEWEY
• Setting criteria for a query used several times, DougW via AccessMonster.com
  • Re: Setting criteria for a query used several times, Marshall Barton
    • Re: Setting criteria for a query used several times, DougW via AccessMonster.com
      • Re: Setting criteria for a query used several times, George Nicholson
      • Re: Setting criteria for a query used several times, DougW via AccessMonster.com
      • Re: Setting criteria for a query used several times, Marshall Barton
      • Re: Setting criteria for a query used several times, DougW via AccessMonster.com
      • Re: Setting criteria for a query used several times, DougW via AccessMonster.com
      • Re: Setting criteria for a query used several times, Marshall Barton
      • Re: Setting criteria for a query used several times, DougW via AccessMonster.com
      • Re: Setting criteria for a query used several times, Marshall Barton
      • Re: Setting criteria for a query used several times, DougW via AccessMonster.com
• total count, JRough
  • Re: total count, JRough
  • Re: total count, John Spencer
• Duane Hookom Query By Form Question, knowshowrosegrows
• Query, Ranges time group by concept, joffer
  • Re: Query, Ranges time group by concept, George Nicholson
• Update Query "IIf" and "Right" Function, Pepsi Girl & Petree
  • RE: Update Query "IIf" and "Right" Function, Dennis
  • Re: Update Query "IIf" and "Right" Function, raskew via AccessMonster.com
  • Re: Update Query "IIf" and "Right" Function, John Spencer
  • RE: Update Query "IIf" and "Right" Function, Klatuu
• Append Query Locks my Database!, Eka1618
  • RE: Append Query Locks my Database!, Jerry Whittle
• append memo fields together sequentially, AlanO
  • Re: append memo fields together sequentially, John Spencer
    • Re: append memo fields together sequentially, AlanO
      • Re: append memo fields together sequentially, John Spencer
      • Re: append memo fields together sequentially, AlanO
      • Re: append memo fields together sequentially, John Spencer
      • Re: append memo fields together sequentially, AlanO
      • Re: append memo fields together sequentially, John Spencer
      • Re: append memo fields together sequentially, AlanO via AccessMonster.com
• Help with query for linked tables, Rayo K
  • RE: Help with query for linked tables, Dale Fye
• Update Query, Melinda
  • RE: Update Query, Dale Fye
    • RE: Update Query, Melinda
  • <Possible follow-ups>
  • Update Query, SITCFanTN
    • Re: Update Query, Evi
• Union of several queries, sverre
  • RE: Union of several queries, KARL DEWEY
• show values that appear once only, Jas
  • RE: show values that appear once only, Dennis
    • RE: show values that appear once only, Jas
• Concatenating comments from consecutive rows together, Nick 1136
  • RE: Concatenating comments from consecutive rows together, Dale Fye
• Need Help Please w/IIF Statement, TotallyConfused
  • Re: Need Help Please w/IIF Statement, banem2
  • Re: Need Help Please w/IIF Statement, John Spencer
• Stock Market Robot, annihilatebuvo
  • Re: Stock Market Robot, John W . Vinson
• Union Query??, Ernst Guckel
  • Re: Union Query??, Ken Snell \(MVP\)
    • Re: Union Query??, Ken Snell \(MVP\)
    • Re: Union Query??, Ernst Guckel
      • Re: Union Query??, Ken Snell \(MVP\)
      • Re: Union Query??, Ernst Guckel
• Cascading Date Help, BernerOH
  • Re: Cascading Date Help, Ken Snell \(MVP\)
  • Re: Cascading Date Help, strive4peace
  • RE: Cascading Date Help, NetworkTrade
    • RE: Cascading Date Help, Dale Fye
• Query help, subs
  • Re: Query help, Jeff Boyce
    • Re: Query help, subs
      • Re: Query help, Jeff Boyce
  • <Possible follow-ups>
  • Query Help, NewAccessDude
    • Re: Query Help, Jeff Boyce
      • Re: Query Help, NewAccessDude
      • Re: Query Help, Jeff Boyce
      • Re: Query Help, NewAccessDude
      • Re: Query Help, Jeff Boyce
• Help with a query, aldunford
  • RE: Help with a query, Klatuu
• How to generate a auto number or increment number, MacrossHunter77 via AccessMonster.com
  • Re: How to generate a auto number or increment number, strive4peace
    • Re: How to generate a auto number or increment number, MacrossHunter77 via AccessMonster.com
      • Re: How to generate a auto number or increment number, strive4peace
• Partial Match query design, Amy E
  • Re: Partial Match query design, Jeff Boyce
    • Re: Partial Match query design, Amy
      • Re: Partial Match query design, Jeff Boyce
• Re: Duplicate Amounts don't show up in Union Query, Lythandra
• RE: Query Not a Valid Name, Denise
• Create a query to compute time, Brian T
  • Re: Create a query to compute time, John W . Vinson
  • Re: Create a query to compute time, Jeff Boyce
    • Re: Create a query to compute time, Brian T
      • Re: Create a query to compute time, Jeff Boyce
      • Re: Create a query to compute time, Brian T
      • Re: Create a query to compute time, John W . Vinson
      • Re: Create a query to compute time, Brian T
      • Re: Create a query to compute time, John W . Vinson
      • Re: Create a query to compute time, Brian T
• Parameter Prompt, DSmith
  • RE: Parameter Prompt, Golfinray
  • Re: Parameter Prompt, Lotto
    • Re: Parameter Prompt, DSmith
      • Re: Parameter Prompt, John W . Vinson
      • Re: Parameter Prompt, DSmith
• Text Field, Sean
  • RE: Text Field, KARL DEWEY
  • Re: Text Field, John W . Vinson
    • Re: Text Field, raskew via AccessMonster.com
      • Re: Text Field, John W . Vinson
• Avoid Parameter Prompt, D
  • Re: Avoid Parameter Prompt, Roger Carlson
  • RE: Avoid Parameter Prompt, KARL DEWEY
    • RE: Avoid Parameter Prompt, D
      • RE: Avoid Parameter Prompt, KARL DEWEY
      • RE: Avoid Parameter Prompt, D
      • RE: Avoid Parameter Prompt, KARL DEWEY
      • RE: Avoid Parameter Prompt, D
  • Re: Avoid Parameter Prompt, John W . Vinson
• append query, Professional_in_need_of help
  • RE: append query, Klatuu
• Dont want a calculation to round its result, twalsh
  • Re: Dont want a calculation to round its result, fredg
    • Re: Dont want a calculation to round its result, twalsh
• Problem with query when data removed, Robin9876
  • RE: Problem with query when data removed, Jerry Whittle
    • Re: Problem with query when data removed, Robin9876
      • Re: Problem with query when data removed, John W . Vinson
• Duplicates Question, TotallyConfused
  • RE: Duplicates Question, Jerry Whittle
  • RE: Duplicates Question, NetworkTrade
• update item code, Newbie
  • Re: update item code, John Spencer
• File Naming, Brig
  • Re: File Naming, John Spencer
• Conditionally make headers/footers visible, prairiewind via AccessMonster.com
  • Re: Conditionally make headers/footers visible, prairiewind via AccessMonster.com
  • Re: Conditionally make headers/footers visible, John Spencer
    • Re: Conditionally make headers/footers visible, prairiewind via AccessMonster.com
• Between Months, Karen
  • RE: Between Months, Jerry Whittle
• DateDiff Function, aldunford
• SQL if then, Kraig
  • RE: SQL if then, Klatuu
• Prevent repeting Join fields records from one table, Jahanzaib
• MS Query query-> Access, Gasperix
  • Re: MS Query query-> Access, John Spencer
    • Re: MS Query query-> Access, Gasperix
      • Re: MS Query query-> Access, John Spencer
      • Re: MS Query query-> Access, Gasperix
• Library Solutions, B1SL
• Query produce error field, Benjamins via AccessMonster.com
  • RE: Query produce error field, Jerry Whittle
    • RE: Query produce error field, Benjamins via AccessMonster.com
      • RE: Query produce error field, Jerry Whittle
      • RE: Query produce error field, Benjamins via AccessMonster.com
      • RE: Query produce error field, Benjamins via AccessMonster.com
      • Re: Query produce error field, John Spencer
• SQL query, subs
  • Re: SQL query, John Spencer
  • <Possible follow-ups>
  • Re: SQL query, subs
  • SQL Query, Gator
    • RE: SQL Query, smk23
    • Re: SQL Query, John Spencer
• Automatically run "something" when the system time match time in t, ali
  • Re: Automatically run "something" when the system time match time in t, John W . Vinson
• best way to write (recursive?) query, Duncan A. McRae
  • Re: best way to write (recursive?) query, Duncan A. McRae
    • Re: best way to write (recursive?) query, Michel Walsh
      • Re: best way to write (recursive?) query, Michel Walsh
• Find groups of records where a Boolean field is False, Ragnar Midtskogen
  • Re: Find groups of records where a Boolean field is False, John Spencer
    • Re: Find groups of records where a Boolean field is False, Ragnar Midtskogen
      • Re: Find groups of records where a Boolean field is False, John Spencer
      • Re: Find groups of records where a Boolean field is False, Ragnar Midtskogen
      • Re: Find groups of records where a Boolean field is False, Ragnar Midtskogen
• creating a custom date from two "between..and" dates, DubboPete
  • Re: creating a custom date from two "between..and" dates, John Spencer
• Re: How do I set up a parameter query in a cross tabs query?, Dmackcwby
  • Re: How do I set up a parameter query in a cross tabs query?, fredg
  • Re: How do I set up a parameter query in a cross tabs query?, John Spencer
    • Re: How do I set up a parameter query in a cross tabs query?, Dmackcwby
• moving entries in a table, ProCad Jen
  • RE: moving entries in a table, ProCad Jen
  • Re: moving entries in a table, Evi
    • Re: moving entries in a table, ProCad Jen
      • Re: moving entries in a table, John Spencer
• Display logged in users, auujxa2 via AccessMonster.com
  • Re: Display logged in users, Wolfgang Kais
• Creating an audit trail of changes, ChuckW
  • Re: Creating an audit trail of changes, Allen Browne
• Sorting records from a select query ?, TonyB
  • Re: Sorting records from a select query ?, John W . Vinson
• Trouble getting date value from field, RussCRM
  • Re: Trouble getting date value from field, John W . Vinson
    • Re: Trouble getting date value from field, RussCRM
      • Re: Trouble getting date value from field, RussCRM
• pulling the a record by greatest value of a field, Ted
  • Re: pulling the a record by greatest value of a field, strive4peace
    • Re: pulling the a record by greatest value of a field, Ted
      • Re: pulling the a record by greatest value of a field, strive4peace
• Pulling a Parameter from a Form in a Query, PowerPoint Jedi
  • Re: Pulling a Parameter from a Form in a Query, Jeff Boyce
    • Re: Pulling a Parameter from a Form in a Query, PowerPoint Jedi
      • Re: Pulling a Parameter from a Form in a Query, Jeff Boyce
      • Re: Pulling a Parameter from a Form in a Query, Ragnar Midtskogen
      • Re: Pulling a Parameter from a Form in a Query, PowerPoint Jedi
• Convert text string to number in a query, twalsh
  • Re: Convert text string to number in a query, Jeff Boyce
  • Re: Convert text string to number in a query, strive4peace
  • Re: Convert text string to number in a query, raskew via AccessMonster.com
    • Re: Convert text string to number in a query, twalsh
      • Re: Convert text string to number in a query, raskew via AccessMonster.com
• Limit query results to 1 item, Valix
  • Re: Limit query results to 1 item, Jeff Boyce
  • Re: Limit query results to 1 item, Armen Stein
    • Re: Limit query results to 1 item, Valix
      • Re: Limit query results to 1 item, John Spencer
      • Re: Limit query results to 1 item, Valix
• Re: Queries Access 2003 use a Drop down box for selection of querycrit, Marshall Barton
  • Re: Queries Access 2003 use a Drop down box for selection of query, FrankSpokane
    • Re: Queries Access 2003 use a Drop down box for selection of query, Marshall Barton
• double check on a make table, JRough
  • Re: double check on a make table, Evi
    • Re: double check on a make table, JRough
      • Re: double check on a make table, fredg
      • Re: double check on a make table, Evi
• Don't show null columns, jenniferspnc
  • RE: Don't show null columns, Golfinray
    • RE: Don't show null columns, jenniferspnc
      • Re: Don't show null columns, Jeff Boyce
      • RE: Don't show null columns, Golfinray
      • Re: Don't show null columns, John Spencer
• Goup Data by a Custom Week, zaps via AccessMonster.com
  • Re: Goup Data by a Custom Week, John Spencer
  • Re: Goup Data by a Custom Week, Marshall Barton
    • Re: Goup Data by a Custom Week, Ron2006
• Scheduled Tasks and password protected databases?, S Davis
• Update query that changes the format of a field to currency, ChuckW
  • Re: Update query that changes the format of a field to currency, Marshall Barton
• help, simorris
  • RE: help, Dennis
  • Re: help, John W . Vinson
• Prevent Duplication when ruunning Append query, Jahanzaib
  • Re: Prevent Duplication when ruunning Append query, Brendan Reynolds
  • Re: Prevent Duplication when ruunning Append query, John Spencer
• vaccation sate, Faisal
  • Re: vaccation sate, John Spencer
• Pick up values by parameter, Matti Koski
  • RE: Pick up values by parameter, Dale Fye
• Using a control field in a form with a subform., quinto via AccessMonster.com
  • Re: Using a control field in a form with a subform., John W . Vinson
    • Re: Using a control field in a form with a subform., quinto via AccessMonster.com
      • Re: Using a control field in a form with a subform., John W . Vinson
      • Re: Using a control field in a form with a subform., quinto via AccessMonster.com
      • Re: Using a control field in a form with a subform., quinto via AccessMonster.com
• Re: Adding data in a 2nd query, Ken Snell \(MVP\)
• Need help adding additional criteria, SMT
• Append matching records, nicomak
  • Re: Append matching records, Evi
    • Re: Append matching records, nicomak via AccessMonster.com
      • Re: Append matching records, John Spencer
      • Re: Append matching records, nicomak via AccessMonster.com
• Appending a table with an autonumber field, jflash
  • Re: Appending a table with an autonumber field, Evi
• HELP!!!, mac
  • Re: HELP!!!, strive4peace
    • Re: HELP!!!, strive4peace
• word document to vista, martinmccann10
  • RE: word document to vista, Duane Hookom
• Please Help, teelee
  • Re: Please Help, Evi
    • Re: Please Help, teelee
      • Re: Please Help, Evi
      • Re: Please Help, teelee
  • RE: Please Help, Duane Hookom
  • <Possible follow-ups>
  • please help, chandimichele
    • Re: please help, Rick Brandt
      • Re: please help, chandimichele
• If Blank Select All, daveyboy300
  • Re: If Blank Select All, Evi
  • RE: If Blank Select All, Duane Hookom
    • RE: If Blank Select All, daveyboy300
• Query based on two option group selections, jonfromdon
  • Re: Query based on two option group selections, strive4peace
    • Re: Query based on two option group selections, jonfromdon
      • Re: Query based on two option group selections, strive4peace
  • RE: Query based on two option group selections, NetworkTrade
• Access 2003 Query, Fesada
  • RE: Access 2003 Query, Duane Hookom
    • RE: Access 2003 Query, Fesada
      • Re: Access 2003 Query, John Spencer
• sqlQuery for daily plans and tasks, Mario Krsnic
  • Re: sqlQuery for daily plans and tasks, strive4peace
• Need Help with a query, georgia
  • Re: Need Help with a query, Allen Browne
• Selecting records above and below target value, Mike C
  • Re: Selecting records above and below target value, Rob Parker
    • Re: Selecting records above and below target value, Rob Parker
  • Re: Selecting records above and below target value, Allen Browne
    • Re: Selecting records above and below target value, Mike C
  • Re: Selecting records above and below target value, John Spencer
• Query Based on Three Yes/No Checkboxes, Brian
  • Re: Query Based on Three Yes/No Checkboxes, Rob Parker
  • Re: Query Based on Three Yes/No Checkboxes, Allen Browne
    • Re: Query Based on Three Yes/No Checkboxes, Brian
• MASTER -> DETAIL {the last row entered ordered by Date then PrimaryKey}, Gary B
  • Re: MASTER -> DETAIL {the last row entered ordered by Date then PrimaryKey}, Allen Browne
    • Re: MASTER -> DETAIL {the last row entered ordered by Date then PrimaryKey}, Gary B
      • Re: MASTER -> DETAIL {the last row entered ordered by Date then PrimaryKey}, Allen Browne
      • Re: MASTER -> DETAIL {the last row entered ordered by Date then PrimaryKey}, Gary B
      • Re: MASTER -> DETAIL {the last row entered ordered by Date then PrimaryKey}, Allen Browne
  • Re: MASTER -> DETAIL {the last row entered ordered by Date then PrimaryKey}, John Spencer
• IIF question, Jeff
  • Re: IIF question, Rob Parker
    • Re: IIF question, Jeff
      • Re: IIF question, Rob Parker
      • Re: IIF question, Jeff
      • Re: IIF question, Rob Parker
      • Re: IIF question, Jeff
      • Re: IIF question, Rob Parker
      • Re: IIF question, Jeff
• Help with SUM expression, Brad Granath
  • RE: Help with SUM expression, Klatuu
• Undefined table query, Sean
  • Re: Undefined table query, John W . Vinson
    • Re: Undefined table query, sean_schodowski
      • Re: Undefined table query, John W . Vinson
      • Re: Undefined table query, Sean
• MS Access 2008 Help, sbas
  • Re: MS Access 2008 Help, John W . Vinson
• Adding Columns Between Two Different Tables, Vylent Fyre
  • Re: Adding Columns Between Two Different Tables, Marshall Barton
• Query to Extract Portion of Text between 2 defined parameters, Cydney
  • Re: Query to Extract Portion of Text between 2 defined parameters, John Spencer
• SQL to query columns that are in seconds since 1/1/1970, Jim in Arizona
  • RE: SQL to query columns that are in seconds since 1/1/1970, Klatuu
    • Re: SQL to query columns that are in seconds since 1/1/1970, Jim in Arizona
      • Re: SQL to query columns that are in seconds since 1/1/1970, Klatuu
      • Re: SQL to query columns that are in seconds since 1/1/1970, Jim in Arizona
      • Re: SQL to query columns that are in seconds since 1/1/1970, John Spencer
      • Re: SQL to query columns that are in seconds since 1/1/1970 [RESOLVED], Jim in Arizona
• Need to account for weekends on some SQL, RobertM
  • RE: Need to account for weekends on some SQL, KARL DEWEY
    • RE: Need to account for weekends on some SQL, KARL DEWEY
• optional paramter query, Souris
  • RE: optional paramter query, KARL DEWEY
    • RE: optional paramter query, Souris
  • RE: optional paramter query, Souris
• IIf Nz, jlute
  • Re: IIf Nz, John Spencer
    • Re: IIf Nz, jlute
  • RE: IIf Nz, KARL DEWEY
    • Re: IIf Nz, jlute
• Records not deleted. Data read only, Mario
  • Re: Records not deleted. Data read only, Allen Browne
    • Re: Records not deleted. Data read only, Mario
  • RE: Records not deleted. Data read only, Jerry Whittle
• Query coding, Pwyd
  • RE: Query coding, Duane Hookom
    • RE: Query coding, Pwyd
      • RE: Query coding, Duane Hookom
      • RE: Query coding, Pwyd
      • RE: Query coding, Duane Hookom
      • RE: Query coding, Pwyd
      • Re: Query coding, jlute
      • Re: Query coding, Pwyd
      • Re: Query coding, Duane Hookom
      • Re: Query coding, Pwyd
      • Re: Query coding, Duane Hookom
      • Re: Query coding, Pwyd
• append query key violations, Jacquie
  • RE: append query key violations, Jerry Whittle
• Date(), Jennifer Gose
  • RE: Date(), Jerry Whittle
• MS ACCESS 2003 Report, A64+
• MS ACCESS 2003 Report + SQL, A64+
  • Re: MS ACCESS 2003 Report + SQL, NoodNutt
• ACCESS 2003 Report & SQL Query, A64+
  • Re: ACCESS 2003 Report & SQL Query, strive4peace
• find and display specific piece of text in a memo field, J Kai
  • RE: find and display specific piece of text in a memo field, Jerry Whittle
    • RE: find and display specific piece of text in a memo field, J Kai
• Cumulative total in a query, Gary F Shelton
  • RE: Cumulative total in a query, Rob Ward
• Queries try to the most current, Michaelc
  • Re: Queries try to the most current, strive4peace
• Sending emails in Outlook, emails in Access table, jacobe2008
  • Re: Sending emails in Outlook, emails in Access table, Carl Rapson
    • Re: Sending emails in Outlook, emails in Access table, jacobe2008 via AccessMonster.com
      • Re: Sending emails in Outlook, emails in Access table, Carl Rapson
• Question on one to many query, Shanin
  • RE: Question on one to many query, Shanin
• Query on two databases, JaneM
  • RE: Query on two databases, Jerry Whittle
• find duplicates query, lance
  • Re: find duplicates query, John W . Vinson
• passthrough query referencing a saved table, joemeshuggah
  • Re: passthrough query referencing a saved table, John W . Vinson
• Query a Crosstab Query, Jacinda
  • RE: Query a Crosstab Query, Jerry Whittle
  • RE: Query a Crosstab Query, Jacinda
• 2 left joins in access 2003, Casper Page
  • Re: 2 left joins in access 2003, bcap
    • Re: 2 left joins in access 2003, Casper Page
• divide by 100, SITCFanTN
  • RE: divide by 100, Jerry Whittle
  • Re: divide by 100, John W . Vinson
    • Re: divide by 100, SITCFanTN
      • Re: divide by 100, John W . Vinson
      • Re: divide by 100, SITCFanTN
      • Re: divide by 100, John W . Vinson
• Cannot export Query to Excel, Ken Valenti
  • Re: Cannot export Query to Excel, Jeanette Cunningham
    • Re: Cannot export Query to Excel, Ken Valenti
      • Re: Cannot export Query to Excel, Jeanette Cunningham
      • Re: Cannot export Query to Excel, Ken Valenti
• sub query count, Souris
  • RE: sub query count, Dale Fye
    • RE: sub query count, Souris
      • Re: sub query count, Dale Fye
      • Re: sub query count, Souris
      • Re: sub query count, Souris
      • Re: sub query count, Dale Fye
      • Re: sub query count, Souris
      • Re: sub query count, Souris
• Using GetBusinessDay with DateAdd, PeteyP
  • RE: Using GetBusinessDay with DateAdd, KARL DEWEY
    • RE: Using GetBusinessDay with DateAdd, PeteyP
      • RE: Using GetBusinessDay with DateAdd, KARL DEWEY
• Delete Queries, macrobater
  • Re: Delete Queries, fredg
  • RE: Delete Queries, Dale Fye
    • RE: Delete Queries, macrobater
  • RE: Delete Queries, macrobater
• Updating Access Tables from SQL, GUIDMonster
  • RE: Updating Access Tables from SQL, Dale Fye
• display code based on a name, Lila
  • Re: display code based on a name, John Spencer
    • Re: display code based on a name, Lila
      • Re: display code based on a name, Lila
      • Re: display code based on a name, Dale Fye
      • Re: display code based on a name, Lila
      • Re: display code based on a name, John Spencer
      • Re: display code based on a name, Lila
• crosstab query error, Patricia Lynch
  • Re: crosstab query error, John Spencer
• Time Difference, John Foster
  • Re: Time Difference, Allen Browne
• Executing multiple queries, DSmith
  • Re: Executing multiple queries, Allen Browne
• Email updated information?, twalsh
  • Re: Email updated information?, Tony Toews [MVP]
• Switch, IIf or ?, Mykas_Robi
  • Re: Switch, IIf or ?, Allen Browne
    • Re: Switch, IIf or ?, Mykas_Robi
      • Re: Switch, IIf or ?, Allen Browne
• data type mismatch, scubadiver
  • RE: data type mismatch, Duane Hookom
    • RE: data type mismatch, scubadiver
      • RE: data type mismatch, Duane Hookom
      • RE: data type mismatch, scubadiver
• Re: How do I limit records to current month, Hong
  • Re: How do I limit records to current month, John Spencer
• Parse Field Alphabetically, Pincus
  • Re: Parse Field Alphabetically, John Spencer
    • Re: Parse Field Alphabetically, Pincus
      • Re: Parse Field Alphabetically, John Spencer
• Extracting Dates from Text String, Florida Analyst
  • RE: Extracting Dates from Text String, Jerry Whittle
  • Re: Extracting Dates from Text String, John Spencer
    • Re: Extracting Dates from Text String, Florida Analyst
• change yes or true to positive number, Frank Bavis
  • Re: change yes or true to positive number, Marshall Barton
• select top 5, Souris
  • RE: select top 5, Dale Fye
  • RE: select top 5, Dale Fye
    • RE: select top 5, Souris
  • Re: select top 5, John Spencer
• Update text field field, darees1
  • Re: Update text field field, Allen Browne
  • Re: Update text field field, John Spencer
• subquery prob (repost), scubadiver
  • Re: subquery prob (repost), John Spencer
    • Re: subquery prob (repost), scubadiver
      • Re: subquery prob (repost), John Spencer
      • Re: subquery prob (repost), scubadiver
• how to check if date is correct?, troubleD
  • Re: how to check if date is correct?, John W . Vinson
    • Re: how to check if date is correct?, troubleD
  • Re: how to check if date is correct?, Rob Parker
    • Re: how to check if date is correct?, troubleD
  • RE: how to check if date is correct?, scubadiver
• Sum Query, Ernst Guckel
  • Re: Sum Query, Allen Browne
• Un-Concatenate text before and after a hyphen symbol ..... -, Gary Shelton
  • Re: Un-Concatenate text before and after a hyphen symbol ..... -, Douglas J. Steele
• manipulating queries, Patricia Lynch
  • RE: manipulating queries, akphidelt
• Query Efficiency, Jahlu
  • Re: Query Efficiency, John W . Vinson
• RE: Query Help Possible IIF Statement, Lisa
  • RE: Query Help Possible IIF Statement, Dale Fye
    • RE: Query Help Possible IIF Statement, Lisa
      • RE: Query Help Possible IIF Statement, Dale Fye
• Random Selection, FrankM
  • RE: Random Selection, FrankM
    • RE: Random Selection, KARL DEWEY
      • RE: Random Selection, FrankM
    • RE: Random Selection, raskew via AccessMonster.com
      • RE: Random Selection, FrankM
      • RE: Random Selection, Dale Fye
      • RE: Random Selection, FrankM
      • RE: Random Selection, KARL DEWEY
      • RE: Random Selection, FrankM
      • RE: Random Selection, Dale Fye
      • RE: Random Selection, FrankM
      • RE: Random Selection, FrankM
      • RE: Random Selection, KARL DEWEY
      • RE: Random Selection, FrankM
      • RE: Random Selection, KARL DEWEY
      • Re: Random Selection, Dale Fye
      • Re: Random Selection, FrankM
      • RE: Random Selection, FrankM
• Pass Through Query Make Table, Kevin
  • Re: Pass Through Query Make Table, Jeff Boyce
    • Re: Pass Through Query Make Table, Kevin
      • Re: Pass Through Query Make Table, Jeff Boyce
• Deleting a join in Query design view?, DougW via AccessMonster.com
  • RE: Deleting a join in Query design view?, Jerry Whittle
    • RE: Deleting a join in Query design view?, DougW via AccessMonster.com
• Date query, snappl3
  • RE: Date query, KARL DEWEY
  • RE: Date query, Golfinray
  • Re: Date query, fredg
• Union pass through query returns null records, ragtopcaddy via AccessMonster.com
  • Re: Union pass through query returns null records, ragtopcaddy via AccessMonster.com
  • Re: Union pass through query returns null records, John Spencer
• Checkbox in query, complex
  • RE: Checkbox in query, akphidelt
  • RE: Checkbox in query, sam
    • RE: Checkbox in query, complex
• Help ASAP Pleeaasssee!!!, Arichmond
  • RE: Help ASAP Pleeaasssee!!!, KARL DEWEY
• Please help! Trying to use one query in a report and another query in subrpt, floyd33 via AccessMonster.com
• Sub query problem, scubadiver
  • RE: Sub query problem, scubadiver
• Make table warning, Crazyhorse
  • RE: Make table warning, Jerry Whittle
    • Re: Make table warning, John W . Vinson
  • Re: Make table warning, John W . Vinson
• Multi List Values, auujxa2 via AccessMonster.com
  • RE: Multi List Values, Steve Sanford
• Pass Through Query Code, Kevin
  • RE: Pass Through Query Code, Jerry Whittle
    • RE: Pass Through Query Code, Kevin
      • RE: Pass Through Query Code, Ofer Cohen
      • RE: Pass Through Query Code, Kevin
      • Re: Pass Through Query Code, John Spencer
      • Re: Pass Through Query Code, Stefan Hoffmann
      • Re: Pass Through Query Code, Kevin
      • Re: Pass Through Query Code, Stefan Hoffmann
      • Re: Pass Through Query Code, Kevin
      • Re: Pass Through Query Code, Kevin
      • Re: Pass Through Query Code, Stefan Hoffmann
      • Re: Pass Through Query Code, Kevin
      • Re: Pass Through Query Code, John Spencer
      • Re: Pass Through Query Code, Kevin
      • Re: Pass Through Query Code, Stefan Hoffmann
• Query Help?, Peakey via AccessMonster.com
  • Re: Query Help?, Allen Browne
• UPDATE QUERY - DECIMAL PLACES, ANDY-N via AccessMonster.com
  • RE: UPDATE QUERY - DECIMAL PLACES, Jerry Whittle
  • Re: UPDATE QUERY - DECIMAL PLACES, J_Goddard via AccessMonster.com
    • Re: UPDATE QUERY - DECIMAL PLACES, ANDY-N via AccessMonster.com
      • Re: UPDATE QUERY - DECIMAL PLACES, J_Goddard via AccessMonster.com
• Update Query Type conversion, Bongard
  • RE: Update Query Type conversion, KARL DEWEY
  • Re: Update Query Type conversion, John Spencer
• Problem saving query, Grey Donkey
  • RE: Problem saving query, KARL DEWEY
• Query help please!, Golfinray
  • Re: Query help please!, Stefan Hoffmann
    • Re: Query help please!, Golfinray
• Qry Design, Jason
  • RE: Qry Design, "Peter Yang[MSFT]"
  • Re: Qry Design, John W . Vinson
• Adding data from a new table, Jeff
• Re: Create table from text strings within field, mralmackay
  • Re: Create table from text strings within field, John Spencer
• Calculate elapsed time, bob1
  • Re: Calculate elapsed time, Allen Browne
• Inserting records while incrementing an ID field., jeff
  • Re: Inserting records while incrementing an ID field., John W . Vinson
• nested AND loop query, aaaagc
  • RE: nested AND loop query, KARL DEWEY
    • Re: nested AND loop query, aaaagc
• Is it possible to use a function to set query criteria, Dale
  • Re: Is it possible to use a function to set query criteria, John W . Vinson
• Re: Create query with table columns as rows, Nan Hauser
  • <Possible follow-ups>
  • Re: Create query with table columns as rows, ANDY-N via AccessMonster.com
    • Re: Create query with table columns as rows, ANDY-N via AccessMonster.com
• Re: Export query from a switchboard, dab1477
  • Re: Export query from a switchboard, Ken Snell \(MVP\)
    • Re: Export query from a switchboard, dab1477
      • Re: Export query from a switchboard, Ken Snell \(MVP\)
• Update Query Using Multi List Box, auujxa2 via AccessMonster.com
  • Re: Update Query Using Multi List Box, auujxa2 via AccessMonster.com
• Query w/ 1 parameter - 16 different fields, same possible answer, Tboartz
  • Re: Query w/ 1 parameter - 16 different fields, same possible answer, Amy Blankenship
    • Re: Query w/ 1 parameter - 16 different fields, same possible answ, Tboartz
      • Re: Query w/ 1 parameter - 16 different fields, same possible answ, Pete D.
      • Re: Query w/ 1 parameter - 16 different fields, same possible answ, Pete D.
  • Re: Query w/ 1 parameter - 16 different fields, same possible answer, John Spencer
• Re: find/replace characters like quotes, RJF
  • Re: find/replace characters like quotes, Douglas J. Steele
    • Re: find/replace characters like quotes, RJF
      • Re: find/replace characters like quotes, RJF
      • Re: find/replace characters like quotes, RJF
• Make query ask for input, user selects item from drop down list., Rob F
  • Re: Make query ask for input, user selects item from drop down list., Armen Stein
• percentages in various groups, feh
  • Re: percentages in various groups, John Spencer
• Query to Update Date, KLock
  • RE: Query to Update Date, Jerry Whittle
  • Re: Query to Update Date, fredg
• Update a table from summary query, Fredrated
• Re: Query Table1 to only return results based on 'criteria' within a 2nd table, mralmackay
• nested AND loop Qery Question, aaaagc
  • RE: nested AND loop Qery Question, akphidelt
• pass paramter to crosstab query report, Souris
  • RE: pass paramter to crosstab query report, KARL DEWEY
• distinct and yet duplicates, patti
  • Re: distinct and yet duplicates, Jeff Boyce
    • Re: distinct and yet duplicates, patti
      • Re: distinct and yet duplicates, Rick Brandt
      • Re: distinct and yet duplicates, patti
      • Re: distinct and yet duplicates, Rick Brandt
      • Re: distinct and yet duplicates, patti
• List Box, auujxa2 via AccessMonster.com
  • RE: List Box, Golfinray
  • Re: List Box, John Spencer
    • Re: List Box, auujxa2 via AccessMonster.com
    • Re: List Box, auujxa2 via AccessMonster.com
      • Re: List Box, auujxa2 via AccessMonster.com
  • Re: List Box, John W . Vinson
• LIST with subqueries -->Problem, jonathan . cohen150887
  • RE: LIST with subqueries -->Problem, KARL DEWEY
    • Re: LIST with subqueries -->Problem, jonathan . cohen150887
• Calculate difference between readings, PD
  • Re: Calculate difference between readings, Marshall Barton
    • Re: Calculate difference between readings, PD
• Re: Reference to next record within a group, Simon L
  • Re: Reference to next record within a group, Michel Walsh
    • Re: Reference to next record within a group, Simon L
      • Re: Reference to next record within a group, Simon L
      • Message not available
      • Re: Reference to next record within a group, Simon L
      • Re: Reference to next record within a group, Michel Walsh
      • Re: Reference to next record within a group, Michel Walsh
• Concantenate - another level, Griff
  • Re: Concantenate - another level, Jeff Boyce
    • Re: Concantenate - another level, Griff
  • Re: Concantenate - another level, John Spencer
• Parameter from form, PowerPoint Jedi
  • RE: Parameter from form, KARL DEWEY
    • RE: Parameter from form, PowerPoint Jedi
      • RE: Parameter from form, KARL DEWEY
      • RE: Parameter from form, PowerPoint Jedi
      • RE: Parameter from form, KARL DEWEY
• Problem running query from web using asterick, rmcompute
  • Re: Problem running query from web using asterick, Jeff Boyce
    • Re: Problem running query from web using asterick, rmcompute
      • Re: Problem running query from web using asterick, Jeff Boyce
      • Re: Problem running query from web using asterick, rmcompute
• Advanced Sort, Cath
  • RE: Advanced Sort, Jerry Whittle
  • Re: Advanced Sort, fredg
  • <Possible follow-ups>
  • Advanced sort, Cath
    • RE: Advanced sort, Cath
    • RE: Advanced sort, KARL DEWEY
      • RE: Advanced sort, Cath
      • RE: Advanced sort, KARL DEWEY
      • RE: Advanced sort, Cath
      • RE: Advanced sort, KARL DEWEY
    • Re: Advanced sort, fredg
    • Re: Advanced sort, John W . Vinson
• apply a filter on date-column in a query, sverre
  • RE: apply a filter on date-column in a query, Jerry Whittle
    • RE: apply a filter on date-column in a query, sverre
      • RE: apply a filter on date-column in a query, Jerry Whittle
      • RE: apply a filter on date-column in a query, sverre
      • Re: apply a filter on date-column in a query, John Spencer
      • Re: apply a filter on date-column in a query, Jerry Whittle
  • Re: apply a filter on date-column in a query, Marshall Barton
• RE: Append Query Unable To Display Link List Tables, Jerry Whittle
  • RE: Append Query Unable To Display Link List Tables, hspgapsemc
    • RE: Append Query Unable To Display Link List Tables, Jerry Whittle
      • RE: Append Query Unable To Display Link List Tables, hspgapsemc
• using start time and end time to calculate durations by hour, tthomas via AccessMonster.com
• RE: Similar / Fuzzy "Match" Logic, FBxiii
  • RE: Similar / Fuzzy "Match" Logic, Dale Fye
    • RE: Similar / Fuzzy "Match" Logic, FBxiii
      • Re: Similar / Fuzzy "Match" Logic, John Spencer
      • Re: Similar / Fuzzy "Match" Logic, FBxiii
      • Re: Similar / Fuzzy "Match" Logic, John Spencer
      • Re: Similar / Fuzzy "Match" Logic, FBxiii
      • Re: Similar / Fuzzy "Match" Logic, John Spencer
• Allen browns Popup Calendar, Totte
  • Re: Allen browns Popup Calendar, Allen Browne
• Re: Timestamp query, durtywhytboy via AccessMonster.com
• query outcomes, sheena
  • RE: query outcomes, Jerry Whittle
    • RE: query outcomes, sheena
      • RE: query outcomes, Jerry Whittle
  • RE: query outcomes, sheena
• wildcard, sam
  • RE: wildcard, Duane Hookom
    • RE: wildcard, sam
    • RE: wildcard, sam
  • Re: wildcard, Marshall Barton
• Calculate the travel time hours, abu_saleh
  • RE: Calculate the travel time hours, Duane Hookom
  • Re: Calculate the travel time hours, Marshall Barton
    • Re: Calculate the travel time hours, abu_saleh via AccessMonster.com
  • Re: Calculate the travel time hours, abu_saleh via AccessMonster.com
• Re: Query to Return: Field Names, Data Type and Description, Jorge Ramos
• Re: MS Access Join Query, Allen Browne
  • <Possible follow-ups>
  • RE: MS Access Join Query, KARL DEWEY
• Re: Is this possible in a Query, Allen Browne
  • Re: Is this possible in a Query, NAHolmes
    • Re: Is this possible in a Query, Allen Browne
      • Re: Is this possible in a Query, NAHolmes
• I was wrong --, Colleen
• NEVER MIND, Colleen
  • <Possible follow-ups>
  • NEVER MIND, Colleen
• RE: How do I get resuts between two tables that has two relationsh, Colleen
  • Re: How do I get resuts between two tables that has two relationsh, John W . Vinson
• Re: date range for every change in value, jversiz via AccessMonster.com
  • Re: date range for every change in value, joemeshuggah
• Re: combo box queries, jversiz via AccessMonster.com
• AVG and IIF expressions, Kaylen
• Multiple Critera in Running Total Query (DSum I think), jversiz via AccessMonster.com
  • Re: Multiple Critera in Running Total Query (DSum I think), Dale Fye
    • Re: Multiple Critera in Running Total Query (DSum I think), jversiz via AccessMonster.com
      • Re: Multiple Critera in Running Total Query (DSum I think), jversiz via AccessMonster.com
• Need To Find Last Date W/Info, pcm1977
  • Re: Need To Find Last Date W/Info, Marshall Barton
    • Re: Need To Find Last Date W/Info, pcm1977
      • Re: Need To Find Last Date W/Info, Marshall Barton
      • Re: Need To Find Last Date W/Info, pcm1977
      • Re: Need To Find Last Date W/Info, Marshall Barton
      • Re: Need To Find Last Date W/Info, pcm1977
• Re: Crosstab query for gantt report, NeoFax
• Re: Update Query Question, mcl
  • <Possible follow-ups>
  • update query question, Stephen
    • RE: update query question, KARL DEWEY
      • Re: update query question, Stephen
• Re: Checkbox with query to select records to enter, Jeff Boyce
• Re: form lists, Jeff Boyce
  • <Possible follow-ups>
  • Re: form lists, John W . Vinson
    • Re: form lists, Dale Fye
      • Re: form lists, auujxa2 via AccessMonster.com
      • Re: form lists, John W . Vinson
  • Re: form lists, auujxa2 via AccessMonster.com