microsoft.public.access.queries

Date Index

Re: How do I calculate workdays in access using date diff in a query?, PC Datasheet
Re: Empty Text Field Problem, OfficeDev18 via AccessMonster.com
Re: Dlookup, Jeff Boyce
Not In Query, Dave - MS Newsgroups
- Message not available
  - Re: Not In Query, Dave - MS Newsgroups
date from form, Dale and Sandi Brown
- Re: date from form, Baz
  - Re: date from form, dale@xxxxxxxxxxxxxxxx
    - Message not available
    - Re: date from form, dale@xxxxxxxxxxxxxxxx
Re: syntax error at or near "{" at character 86(#-1), David Lloyd
Re: Goofy Query behavior, Michel Walsh
Re: Organize queries into folders., Rick B
- <Possible follow-ups>
- Re: Organize queries into folders., Michel Walsh
Re: count how many records are true, Chaim
- Re: count how many records are true, Michel Walsh
Formatting Phone Numbers, Dale
Re: query with many criteria, Tom Ellison
- Re: query with many criteria, lynn atkinson
  - Re: query with many criteria, Tom Ellison
Re: Query databased Result, Van T. Dinh
Re: dlookup syntax problem, Van T. Dinh
RE: Problem with a query that concatenates field values, '69 Camaro
Re: How do I query the same field from different tables, Tom Ellison
UPPER CASE to Proper Case, Dale
- Message not available
  - Re: UPPER CASE to Proper Case, Dale
Duplicates Query... Help Wanted, Dale
- Re: Duplicates Query... Help Wanted, Tom Ellison
  - Re: Duplicates Query... Help Wanted, Dale
Re: Formatting Phone Number, Dale
- Re: Formatting Phone Number, SusanV
Time Stamp Records, Dale
- Re: Time Stamp Records, Dale
- Re: Time Stamp Records, tina
  - Re: Time Stamp Records, Dale
  - Re: Time Stamp Records, Tom Ellison
    - Re: Time Stamp Records, peregenem
    - Re: Time Stamp Records, Tom Ellison
    - Re: Time Stamp Records, peregenem
    - Re: Time Stamp Records, tina
Query not returning all the records I need., upsman via AccessMonster.com
- Re: Query not returning all the records I need., Tom Ellison
Re: Sort error in query - record is deleted, MGFoster
Re: Need a query to find all records with ONE keyword, Phil
- Re: Need a query to find all records with ONE keyword, Randall Arnold
Update and insert a increment number, gv
- Message not available
  - Re: Update and insert a increment number, gv
Append Query to Create Repeated Records in Table, bmsc
- Message not available
  - Re: Append Query to Create Repeated Records in Table, bmsc
getdate conversion, gv
- Message not available
  - Message not available
    - Re: getdate conversion, Roger Carlson
    - Re: getdate conversion, gv
Re: How CDate() determines century, MGFoster
- Re: How CDate() determines century, kdbarrett
Re: Updating Table, MGFoster
Another variation, Chris Smith
- Re: Another variation, Michel Walsh
Parameter default value, peregenem
- Re: Parameter default value, MGFoster
  - Re: Parameter default value, peregenem
  - Re: Parameter default value, peregenem
  - Re: Parameter default value, peregenem
    - Re: Parameter default value, MGFoster
    - Re: Parameter default value, peregenem
    - Re: Parameter default value, MGFoster
    - Re: Parameter default value, peregenem
    - Message not available
    - Re: Parameter default value, peregenem
    - Re: Parameter default value, Michel Walsh
Re: Using an AND for the same record, John W. Vinson/MVP
- Message not available
  - Re: Using an AND for the same record, John W. Vinson/MVP
backdoor, val via AccessMonster.com
- Message not available
  - Re: backdoor, val via AccessMonster.com
- Message not available
  - Re: backdoor, val via AccessMonster.com
Re: Delete duplicate values, Rick B
- <Possible follow-ups>
- Re: Delete duplicate values, Jeff Boyce
Cancelling long query?, Bill
- Re: Cancelling long query?, peregenem
Query very slow with UNION, Alfred Malleier
Re: Desperately need help with a Query, PC Datasheet
- Re: Desperately need help with a Query, Stephane Pelletier
- <Possible follow-ups>
- RE: Desperately need help with a Query, '69 Camaro
  - Message not available
    - Message not available
    - RE: Desperately need help with a Query, Stephane Pelletier
Re: Nesting IIf Statements, Duane Hookom
- <Possible follow-ups>
- Re: Nesting IIf Statements, david epsom dot com dot au
Need help designing a query, dorr
- Re: Need help designing a query, Dale Fye
Re: Adding times past midnight, Marshall Barton
Re: Problem with Pass Through query and subform, [MVP] S.Clark
- Message not available
  - Re: Problem with Pass Through query and subform, Rick Brandt
Re: Averaging Time, [MVP] S.Clark
Re: Criteria, John Spencer (MVP)
- Message not available
  - Re: Criteria, Tom Ellison
Re: Append Quary tables, [MVP] S.Clark
Re: "Best Fit" table windows?, [MVP] S.Clark
Re: Add 3 months for next quarterly statement, Tom Ellison
- <Possible follow-ups>
- Re: Add 3 months for next quarterly statement, MGFoster
  - Message not available
    - Re: Add 3 months for next quarterly statement, MGFoster
- Re: Add 3 months for next quarterly statement, Van T. Dinh
Re: Varible in query, John Vinson
format result of an update query, Helen
Summary totals in query, FJB
- Re: Summary totals in query, Tom Ellison
Re: TRANSFORM and Avg(), Gwen H
new to msaccess, trinity13
Re: Dynamic subdatasheets?, John Vinson
Re: Format this as fixed with a decimal space of 0 - 3, Chaim
Parameter Query, Alec Green
- Re: Parameter Query, John Vinson
- Message not available
  - Re: Parameter Query, John Vinson
Query Popup, Wanda via AccessMonster.com
- Re: Query Popup, Rick B
- Re: Query Popup, Bob M via AccessMonster.com
new to access, trinity13
- Re: new to access, Baz
- Re: new to access, Chaim
Re: help me plzzz, Chaim
- Re: help me plzzz, mike via AccessMonster.com
  - Re: help me plzzz, Chaim
    - Re: help me plzzz, mike via AccessMonster.com
    - Re: help me plzzz, mike via AccessMonster.com
    - Re: help me plzzz, mike via AccessMonster.com
RE: removal of spaces, stuart
- Re: removal of spaces, '69 Camaro
- <Possible follow-ups>
- Re: removal of spaces, Chaim
Re: Skew and other statistics in Access, Douglas J. Steele
- <Possible follow-ups>
- Re: Skew and other statistics in Access, Michel Walsh
Re: Passing SQL to MSDE/SQL server, Bill Sturdevant
Extract records with a specific field appearing more than once in the DB, markx
- Message not available
  - Re: Extract records with a specific field appearing more than once in the DB, Chaim
    - Message not available
    - Re: Extract records with a specific field appearing more than once in the DB, Michel Walsh
select case function on date/time, Lindsey M
- Re: select case function on date/time, Chaim
Re: need random number routine, John Vinson
Re: Not equal, mike via AccessMonster.com
- <Possible follow-ups>
- Re: Not equal, mike via AccessMonster.com
- Re: Not equal, mike via AccessMonster.com
- Re: Not equal, mike via AccessMonster.com
Re: Archive Acess Report Data, John Vinson
Re: Creating an Access query that searches multiple tables, John Vinson
Re: How do I save an access query to a floppy?, Dave Patrick
- <Possible follow-ups>
- Re: How do I save an access query to a floppy?, John Vinson
Query to send e-mail, Glenn
- Message not available
  - Re: Query to send e-mail, Glenn
    - Message not available
    - Message not available
    - Re: Query to send e-mail, Michel Walsh
Re: Change attributes from "read-only on CD-RW, PC Datasheet
- <Possible follow-ups>
- Re: Change attributes from "read-only on CD-RW, fredg
Re: My parameter queries fail, whereas my select queries work fine, Jeff Boyce
- <Possible follow-ups>
- Re: My parameter queries fail, whereas my select queries work fine, John Spencer (MVP)
  - Re: My parameter queries fail, whereas my select queries work fine, peregenem
    - Re: My parameter queries fail, whereas my select queries work fine, peregenem
Append query with different field names, FJB
- Re: Append query with different field names, John Vinson
Re: Averages, John Spencer (MVP)
- <Possible follow-ups>
- Re: Averages, Jeff Boyce
- Re: Averages, Michel Walsh
RE: How to get count of unique records in one-to-many query, Randall Arnold
- <Possible follow-ups>
- RE: How to get count of unique records in one-to-many query, Randall Arnold
Select query driving me mad (using *), TheSingingCat
- Message not available
  - Re: Select query driving me mad (using *), John Spencer (MVP)
    - Re: Select query driving me mad (using *), TheSingingCat
Re: Text To Columns in Access, Rick B
- Message not available
  - Re: Text To Columns in Access, Douglas J. Steele
    - Re: Text To Columns in Access, Randall Arnold
- <Possible follow-ups>
- Re: Text To Columns in Access, Marshall Barton
RE: Interesting Question, MChrist
- RE: Interesting Question, Blaze
Re: Using Select Distinct with *, Michel Walsh
Re: Query with more than one table, Chaim
Re: Displaying a Zip Code (5 or more digits), Chaim
Re: format a NZ field in a query to 0 decimal places, Jeff Boyce
Re: Vague match/match partial information, John Vinson
Re: Use of global variables in Queries, Amy Blankenship
- <Possible follow-ups>
- Re: Use of global variables in Queries, Amy Blankenship
Re: help with sql, John
- <Possible follow-ups>
- Re: help with sql, John Spencer (MVP)
Using Access to try SQL codes, J_J
- Re: Using Access to try SQL codes, Rick Brandt
  - Re: Using Access to try SQL codes, J_J
    - Re: Using Access to try SQL codes, Rick Brandt
    - Re: Using Access to try SQL codes, Albert D.Kallal
    - Re: Using Access to try SQL codes, J_J
- Re: Using Access to try SQL codes, Randy Harris
  - Re: Using Access to try SQL codes, J_J
Re: IF THEN query in SQL, Douglas J. Steele
Re: keyboard letters, Allen Browne
RE: Properties change in VBA, '69 Camaro
- Message not available
  - Re: Properties change in VBA, '69 Camaro
RE: filtering a query, '69 Camaro
Re: #Error in date field, Duane Hookom
Adding Records in a query, ijakings
- Re: Adding Records in a query, Marshall Barton
- Re: Adding Records in a query, ijakings@xxxxxxxxx
RE: Data Entry on condition basis, '69 Camaro
Re: Reusing a subquery, John Spencer (MVP)
- Re: Reusing a subquery, TipTop
Re: Append Query & Linked Tables, Jeff Boyce
- Re: Append Query & Linked Tables, Karl Burrows
  - Re: Append Query & Linked Tables, Jeff Boyce
    - Re: Append Query & Linked Tables, Karl Burrows
    - Re: Append Query & Linked Tables, Jeff Boyce
    - Re: Append Query & Linked Tables, Karl Burrows
    - Re: Append Query & Linked Tables, Karl Burrows
    - Re: Append Query & Linked Tables, Jeff Boyce
    - Re: Append Query & Linked Tables, Karl Burrows
Re: how to query a street in an address, Marshall Barton
Re: Adopting and developing an existing popular and efficient PIM, Marshall Barton
Re: Select latest recorded record in Access crosstab query, MGFoster
- Re: Select latest recorded record in Access crosstab query, mgidron
Re: Date/Time Fields criteria, Simon
- Re: Date/Time Fields criteria, Simon
  - Re: Date/Time Fields criteria, Jeff Boyce
- Re: Date/Time Fields criteria, Douglas J. Steele
Re: numeric data, John Spencer (MVP)
- Message not available
  - Re: numeric data, AccessAddict
Re: SQL For Next, Brendan Reynolds
Find a record AND the one immediately above it for bad GL postings, M.M.
- Re: Find a record AND the one immediately above it for bad GL postings, david
Counting ONE field with date parameters, FJB
- Re: Counting ONE field with date parameters, John Spencer (MVP)
Re: Updating a memo field, John Vinson
- Message not available
  - Message not available
    - Message not available
    - Re: Updating a memo field, John Vinson
Re: Fromdate todate syntax error, Kevin W. via AccessMonster.com
- Re: Fromdate todate syntax error, Kevin W. via AccessMonster.com
Re: pull first record, Amy Blankenship
- <Possible follow-ups>
- Re: pull first record, Marshall Barton
Re: how can I have access total the number of yes's in a yes/no col.?, Amy Blankenship
- <Possible follow-ups>
- Re: how can I have access total the number of yes's in a yes/no col.?, Marshall Barton
find if the coumn exists in a number of tables, dtonse via AccessMonster.com
Re: Query Pulling from 3 Tables, oozyscab via AccessMonster.com
top values, newgroup
- Re: top values, JohnFol
- Message not available
  - Message not available
    - Re: top values, Duane Hookom
    - Re: top values, newgroup
    - Re: top values, Duane Hookom
Re: Crosstab queries and SQL problems, Duane Hookom
Counting in a query, MyVi
- Message not available
  - Re: Counting in a query, MyVi
    - Re: Counting in a query, Baz
    - Re: Counting in a query, MyVi
    - Message not available
    - Message not available
    - Re: Counting in a query, MyVi
    - Re: Counting in a query, Baz
    - Re: Counting in a query, MyVi
    - Re: Counting in a query, Baz
Re: Force Binary String Comparison, david epsom dot com dot au
Re: Update Query Counting occurrences in a field and Sequential numbering the occurs, Duane Hookom
- Re: Update Query Counting occurrences in a field and Sequential numbering the occurs, Marshall Barton
DSUM problem, SF
Re: Pull down menus for queries., Duane Hookom
Re: join fields containing null values, John B via AccessMonster.com
- Re: join fields containing null values, peregenem
  - Re: join fields containing null values, John B via AccessMonster.com
Ordering using Max?, Mike
- Errata, Mike
Re: Query with field in a form, Lasse T
Re: Query Problem, Show only records from previous Qtr, Amy Blankenship
- <Possible follow-ups>
- Re: Query Problem, Show only records from previous Qtr, OfficeDev18 via AccessMonster.com
  - Message not available
    - Re: Query Problem, Show only records from previous Qtr, Amy Blankenship
    - Message not available
    - Re: Query Problem, Show only records from previous Qtr, Amy Blankenship
Re: Those two 'Testing' posts, Ken Snell [MVP]
- Re: Those two 'Testing' posts, Chaim
Re: Creating a counter, Chaim
RE: using memory variables in a query criteria, '69 Camaro
- Message not available
  - RE: using memory variables in a query criteria, '69 Camaro
Re: Updating Multiple Fields in a Query, Chaim
Help! Calculate Average using Queries, Alex_Firenze
- Message not available
  - Re: Help! Calculate Average using Queries, Alex_Firenze
Re: How to group and count results of calculation, shep
- Message not available
  - Re: How to group and count results of calculation, shep
- Message not available
  - Re: How to group and count results of calculation, shep
    - Re: How to group and count results of calculation, Duane Hookom
Re: Names query, Duane Hookom
Re: Query using > and dates, Duane Hookom
- <Possible follow-ups>
- Re: Query using > and dates, Chaim
- Re: Query using > and dates, Chaim
  - Message not available
    - Re: Query using > and dates, Chaim
    - Re: Query using > and dates, Amy Blankenship
Re: Converting a Date Rage into a simple format, Allen Browne
- Re: Converting a Date Rage into a simple format, Secret Squirrel
  - Re: Converting a Date Rage into a simple format, Allen Browne
    - Re: Converting a Date Rage into a simple format, Secret Squirrel
    - Re: Converting a Date Rage into a simple format, Allen Browne
Re: execute a query from VBA, Darryl
- Re: execute a query from VBA, Allen Browne
  - Re: execute a query from VBA, Darryl
    - Message not available
    - Re: execute a query from VBA, Darryl
    - Re: execute a query from VBA, Allen Browne
Re: Query in a loop, JohnFol
How to arrange names to create pairs of names, aeronav
- Message not available
  - Re: How to arrange names to create pairs of names, aeronav
- Re: How to arrange names to create pairs of names, Baz
Re: splitting data from one column into multiple columns, peregenem
Re: Include only first part of a field in a query, David S via AccessMonster.com
- Re: Include only first part of a field in a query, David S via AccessMonster.com
Re: Update Quarterly Statement Sent Date, David S via AccessMonster.com
Re: Merging 2 Tables, Doug Fete
Make count = 0 where no row is returned., Roger Hembury
- Re: Make count = 0 where no row is returned., Roger Hembury
  - Message not available
    - Re: Make count = 0 where no row is returned., peregenem
    - Re: Make count = 0 where no row is returned., peregenem
    - Re: Make count = 0 where no row is returned., Michel Walsh
    - Re: Make count = 0 where no row is returned., peregenem
Re: Update Several records, John Spencer (MVP)
- <Possible follow-ups>
- Re: Update Several records, John Vinson
Re: Testing 2, Douglas J. Steele
- <Possible follow-ups>
- Re: Testing 2, Wayne Morgan
Re: Dlookup function, John Spencer (MVP)
- Message not available
  - Re: Dlookup function, John Spencer (MVP)
Re: Summary Report, John Spencer (MVP)
Re: all columns not always present in query - report won't run, Duane Hookom
- <Possible follow-ups>
- Re: all columns not always present in query - report won't run, Duane Hookom
Combination of Field not empty, YDN
- Re: Combination of Field not empty, John Vinson
  - Re: Combination of Field not empty, YDN
Re: how to write an expression, OfficeDev18 via AccessMonster.com
Re: Time Format, Duane Hookom
Re: Count does not give me 0, OfficeDev18 via AccessMonster.com
- <Possible follow-ups>
- Re: Count does not give me 0, Duane Hookom
Re: Query getting stuck, ChrisBat via AccessMonster.com
Re: postcode search, lookup, finder, agnieuwe
Trim Spaces, Garry
Cross table Query, Paramasivan
Change data name, Alex Martinez
- Re: Change data name, John Vinson
Re: Populate one table with values from another, Amy Blankenship
- Message not available
  - Message not available
    - Message not available
    - Message not available
    - Re: Populate one table with values from another, Sean
Re: Microsoft DA0 3.x Object Library - sql, vba, PC Datasheet
- Re: Microsoft DA0 3.x Object Library - sql, vba, david epsom dot com dot au
  - Message not available
    - Re: Microsoft DA0 3.x Object Library - sql, vba, david epsom dot com dot au
Re: Dup Entry Query, John Spencer (MVP)
- Re: Dup Entry Query, Peter Carlson
Combo Box Query, Oopesh
- Re: Combo Box Query, Duane Hookom
- Message not available
  - Re: re:Combo Box Query, Duane Hookom
- re:Combo Box Query, Oopesh
- re:Combo Box Query, Oopesh
- re:Combo Box Query, Oopesh
  - Re: re:Combo Box Query, Duane Hookom
- re:Combo Box Query, Oopesh
- re:Combo Box Query, Oopesh
- re:Combo Box Query, Oopesh
  - Re: re:Combo Box Query, Sassy Baskets
- re:Combo Box Query, Oopesh
- re:Combo Box Query, Oopesh
Re: Minimum Date, John Spencer (MVP)
- <Possible follow-ups>
- Re: Minimum Date, Brent
  - Re: Minimum Date, John Vinson
- Re: Minimum Date, Brent
Query producing 522 copies of same record, FJB
- Re: Query producing 522 copies of same record, Jeff Boyce
  - Re: Query producing 522 copies of same record, FJB
    - Re: Query producing 522 copies of same record, Duane Hookom
    - Re: Query producing 522 copies of same record, John Vinson
    - Message not available
    - Re: Query producing 522 copies of same record, Duane Hookom
    - Message not available
    - Message not available
    - Message not available
    - Message not available
    - Re: Query producing 522 copies of same record, Duane Hookom
    - Re: Query producing 522 copies of same record, FJB
Re: Running a query against it's own base table, David S via AccessMonster.com
Re: Problem with Nested IIF, David S via AccessMonster.com
Re: How do I fix Access Error undefined function "CStr$" in expressio, Douglas J. Steele
generate a temporary table, Darryl
- Re: generate a temporary table, MGFoster
- Re: generate a temporary table, PC Datasheet
  - Re: generate a temporary table, Darryl
Re: Return Latest Quarterly and Monthly info., spartanmba
Text to Int, Peter Carlson
- Message not available
  - Re: Text to Int, Peter Carlson
    - Re: Text to Int, John Spencer (MVP)
Re: date parameter, Chaim
Re: Searching for records that do not exist yet, Chaim
Re: name query, Chaim
Re: How to add just one field, Rick B
Re: Date restrictor for this week, John Vinson
Re: Make table query with derived fields, Marshall Barton
Re: What does RWOP stand for?, Rick B
- <Possible follow-ups>
- Re: What does RWOP stand for?, Rick Brandt
- Re: What does RWOP stand for?, SusanV
Re: Format Yes/No fields after Union, Marshall Barton
Re: Variable Table name, Rick B
Payroll Dates, johnnya@xxxxxxxxxxxxxxxxxxx
- Re: Payroll Dates, Chaim
  - Message not available
    - Re: Payroll Dates, Chaim
Re: Simple Expression Question, Rick B
Re: Keep Count of Query Output Records, JohnFol
- <Possible follow-ups>
- Re: Keep Count of Query Output Records, Marshall Barton
  - Message not available
    - Re: Keep Count of Query Output Records, Marshall Barton
Re: Query with a twist %%, Roger Carlson
RE: query to display only most recent version., R.Douthwaite
Concatenating not working with primary key as text field, annysjunkmail
- Message not available
  - Re: Concatenating not working with primary key as text field, annysjunkmail
delete records help, Bob
- Re: delete records help, John Vinson
Re: Time/Date, Marshall Barton
- Re: Time/Date, peregenem
Re: How do I number the entries in a query?, [MVP] S.Clark
- <Possible follow-ups>
- Re: How do I number the entries in a query?, Duane Hookom
Re: help with an update query from form data..., [MVP] S.Clark
Re: Regular Expressions in Access, Douglas J. Steele
- Re: Regular Expressions in Access, Mel_la_Bel
Re: Does Access Not Support INSERT ... SET Syntax?, Douglas J. Steele
Cannot Delete From Specified Tables, Dave
- Re: Cannot Delete From Specified Tables, [MVP] S.Clark
Re: Access almost freeses aftera pass-through query, [MVP] S.Clark
Re: Records not displaying, Chaim
- <Possible follow-ups>
- Re: Records not displaying, SteveS
  - Re: Records not displaying, Teri
    - Re: Records not displaying, SteveS
    - Re: Records not displaying, Teri
    - Re: Records not displaying, SteveS
Re: Subtracting a fixed date from a date field, Chaim
- <Possible follow-ups>
- Re: Subtracting a fixed date from a date field, SteveS
RE: Date Summary Report, Rod
Re: Excluding row based on trailing text, Marshall Barton
Re: Simple Query or not?, Marshall Barton
- Message not available
  - Message not available
    - Re: Simple Query or not?, Marshall Barton
- Message not available
  - Message not available
    - Re: Simple Query or not?, Barry
Re: Update query using Sum function, John Vinson
- Re: Update query using Sum function, peregenem
  - Message not available
    - Re: Update query using Sum function, peregenem
Re: Doesn't work Like "*" [Forms]![SearchCriteria]![StrAddress] "*", John Vinson
Update Query, Brianna W
- Re: Update Query, SteveS
- <Possible follow-ups>
- Update Query, Mary M
  - Re: Update Query, Brendan Reynolds
- Update Query, Joy M
Re: Switch and IIF both give me an extra data Line., rhoisy
- Re: Switch and IIF both give me an extra data Line., Ken Snell [MVP]
  - Message not available
    - Re: Switch and IIF both give me an extra data Line., Ken Snell [MVP]
    - Re: Switch and IIF both give me an extra data Line., rhoisy
    - Re: Switch and IIF both give me an extra data Line., Ken Snell [MVP]
    - Message not available
    - Re: Switch and IIF both give me an extra data Line., Ken Snell [MVP]
    - Re: Switch and IIF both give me an extra data Line., rhoisy
    - Message not available
    - Re: Switch and IIF both give me an extra data Line., rhoisy
Re: HEEEELP!! Less Hair then B4!, SusanV
- <Possible follow-ups>
- Re: HEEEELP!! Less Hair then B4!, A. Smart
  - Re: HEEEELP!! Less Hair then B4!, Ken Snell [MVP]
More Help withthe WHERE Clause, tamxwell
- Message not available
  - Re: More Help withthe WHERE Clause, tamxwell
Crosstab query - odd field, SusanV
- Re: Crosstab query - odd field, Duane Hookom
  - Re: Crosstab query - odd field, SusanV
Re: attetching a Macro to a action Queries, Allen Browne
Re: Please Help!!!? Select * From, Jeff Boyce
Append Query from Unbound Textbox to subform, Denis Bisson via AccessMonster.com
- Re: Append Query from Unbound Textbox to subform, [MVP] S.Clark
Rows to columns - can it be done?, annysjunkmail
- Re: Rows to columns - can it be done?, Nikos Yannacopoulos
  - Re: Rows to columns - can it be done?, annysjunkmail
Concatinating query results of one field, Kathy Webster
- Re: Concatinating query results of one field, JohnFol
  - Re: Concatinating query results of one field, Duane Hookom
- Any suggestions, anyone??, Kathy Webster
  - Re: Any suggestions, anyone??, John Vinson
RE: Sync Columns, '69 Camaro
Re: Query with minimum field value, Duane Hookom
Re: New Totals Query, Duane Hookom
Re: How do I combine data from two fields into one using a query?, Marshall Barton
Using SQL format function in Access 2003, smashing_austin
Apostrephes Make Query Upset, mcwhirt3
- Re: Apostrephes Make Query Upset, Douglas J. Steele
Re: Select Data, Duane Hookom
- Re: Select Data, John Spencer (MVP)
Query showing Inspections not performed, Chris
- Message not available
  - Re: Query showing Inspections not performed, Chris
Re: Days, Weeks, And Months, Duane Hookom
- <Possible follow-ups>
- RE: Days, Weeks, And Months, '69 Camaro
How to combine multiple row values into one column, Bill Murphy
- Re: How to combine multiple row values into one column, Douglas J. Steele
Re: Multiple Criteria to run Parameter Query for a report, questionnaire database analyst
Re: Access query, Vincent Johns
Re: Return records where field duplicates, Allen Browne
Programs alphabetized, how?, cilorentson
- Re: Programs alphabetized, how?, Duane Hookom
Re: Names in an Expression, Duane Hookom
- Re: Names in an Expression, Elizabeth Reynolds
  - Re: Names in an Expression, PC Datasheet
  - Message not available
    - Message not available
    - Re: Names in an Expression, Ofer
    - Re: Names in an Expression, Duane Hookom
Can't find last order with data fields in a query, Rolf Rosenquist
- Re: Can't find last order with data fields in a query, Douglas J. Steele
  - Re: Can't find last order with data fields in a query, Rolf Rosenquist
    - Re: Can't find last order with data fields in a query, Douglas J. Steele
- Re: Can't find last order with data fields in a query, PC Datasheet
Adding missing records to a table, Petterq
- Re: Adding missing records to a table, Steve Schapel
Re: Running a query from a form, Rick Brandt
Re: Having trouble joining a table and query, Jeff Boyce
- Re: Having trouble joining a table and query, Mel
  - Re: Having trouble joining a table and query, Jeff Boyce
Query fails, Petterq
- Re: Query fails, Jeff Boyce
duplicate query within an If statement, Alan
- Re: duplicate query within an If statement, peregenem
Please Help ! Queries for Dates, if statement..., Bill
- Re: Please Help ! Queries for Dates, if statement..., Jeff Boyce
- Re: Please Help ! Queries for Dates, if statement..., Duane Hookom
- Re: Please Help ! Queries for Dates, if statement..., Amy Blankenship
MORE THEN ONE QUERIES-- HELP--, TYE
- Re: MORE THEN ONE QUERIES-- HELP--, Duane Hookom
Re: How do I join data from 2 fields in same query?, Allen Browne
Re: Help with append query for one-to-many relationship tables, SteveS
Re: Formatting for a Weekly Report, Duane Hookom
- Re: Formatting for a Weekly Report, iholder
  - Re: Formatting for a Weekly Report, Duane Hookom
Re: how do i create multiple tables from a master table automatically?, John Vinson
Re: Using Calculated Fields to Calculate other fields, [MVP] S.Clark
import flat file into a table, gv
Add records if do not exist?, SusanV
- Re: Add records if do not exist?, Dale Fye
  - Re: Add records if do not exist?, SusanV
  - Re: Add records if do not exist?, SusanV
    - Re: Add records if do not exist?, Dale Fye
    - Re: Add records if do not exist?, SusanV
- Message not available
  - Re: Add records if do not exist?, SusanV
Re: Please Help!? Multiple Check Boxes in Query!, [MVP] S.Clark
- Re: Please Help!? Multiple Check Boxes in Query!, A. Smart
  - OT: Posting style, was: Re: Please Help!? Multiple Check Boxes in Query!, John Vinson
Help to append flat file table to two tables, Victoriya F via AccessMonster.com
- re:Help to append flat file table to two tables, Vika
  - Re: Help to append flat file table to two tables, SteveS
- Thank you so much!!!, Vika
- re:Help to append flat file table to two tables, Vika
  - Re: Help to append flat file table to two tables, SteveS
- re:Help to append flat file table to two tables, Vika
- re:Help to append flat file table to two tables, Vika
Re: SQL Aggregate AVG function and GROUP BY Clause, Chaim
Re: Breaking down a weekly rolling total in a sales table, Chaim
- Re: Breaking down a weekly rolling total in a sales table, Tim Zych
  - Re: Breaking down a weekly rolling total in a sales table, Dale Fye
    - Re: Breaking down a weekly rolling total in a sales table, Tim Zych
Report from Query - Select Max value, Gil Lopes via AccessMonster.com
- Re: Report from Query - Select Max value, Allen Browne
  - Message not available
    - Message not available
    - Message not available
    - Message not available
    - Re: Report from Query - Select Max value, Allen Browne
    - Message not available
    - Re: Report from Query - Select Max value, Allen Browne
    - Re: Report from Query - Select Max value, Gil Lopes via AccessMonster.com
Re: Translating values from a form into a JET query, Ogelema
Help: create query, Angelo
- RE: Help: create query, A. Smart
Re: SELECT from two tables (not same number of fields), Allen Browne
Prompting for the same parameter three times when opening a report., Lee B via AccessMonster.com
- Re: Prompting for the same parameter three times when opening a report., Allen Browne
Re: Doing an 'AND' query on the same field, Amy Blankenship
show jobs not completed within a time frame, GMan
Re: Datatype conversion, Randy Harris
- <Possible follow-ups>
- Re: Datatype conversion, John Vinson
Re: Primary Key re-setting to "0", John Vinson
Re: Imported query from another access db has strange syntax error., David S via AccessMonster.com
How to Query Overdue Dates, jchollo
- Re: How to Query Overdue Dates, Duane Hookom
Re: Why can't I do an Append Update Query, tina
- <Possible follow-ups>
- Re: Why can't I do an Append Update Query, Van T. Dinh
  - Message not available
    - Re: Why can't I do an Append Update Query, Van T. Dinh
Queries in Access - Overdue Dates, jchollo
- Re: Queries in Access - Overdue Dates, John Vinson
Re: Need help with updating with value from another database, MGFoster
- Re: Need help with updating with value from another database, Alpha
  - Message not available
    - Message not available
    - Re: Need help with updating with value from another database, MGFoster
    - Re: Need help with updating with value from another database, Alpha
    - Message not available
    - Re: Need help with updating with value from another database, MGFoster
    - Re: Need help with updating with value from another database, Alpha
Re: How to get rid of characters in a string, PC Datasheet
- <Possible follow-ups>
- Re: How to get rid of characters in a string, Tom Lake
Re: Union query for different fields, Duane Hookom
- <Possible follow-ups>
- Re: Union query for different fields, John Vinson
Re: Concatenate the records with same ID, Michel Walsh
- Re: Concatenate the records with same ID, Duane Hookom
  - Re: Concatenate the records with same ID, Tim
Full OUter Join Help Needed, walemly
- RE: Full OUter Join Help Needed, TomHinkle
  - Re: Full OUter Join Help Needed, walemly
    - Re: Full OUter Join Help Needed, John Vinson
    - Re: Full OUter Join Help Needed, walemly
    - Re: Full OUter Join Help Needed, John Vinson
Re: A query that joins 2 tables, John Vinson
- Message not available
  - Re: A query that joins 2 tables, John Vinson
- <Possible follow-ups>
- Re: A query that joins 2 tables, Ian Chappel
- Re: A query that joins 2 tables, John Vinson
Re: Duplicated records, Jeff Boyce
Re: Don't Display queries with Zero Results, Graham R Seach
Re: Join Properties Problem, Baz
Count on a yes/no field, Alex Martinez
- Re: Count on a yes/no field, John Vinson
- Re: Count on a yes/no field, oozyscab via AccessMonster.com
Re: Copying a record, Marshall Barton
- Message not available
  - Re: Copying a record, Marshall Barton
Re: Append new record, Douglas J. Steele
Re: duplicate records, John Spencer (MVP)
Re: tables, John Spencer (MVP)
Re: Count Query not showing all records, MGFoster
Re: How to query or SP to insert/upate a table from another DB's table, MGFoster
- Re: How to query or SP to insert/upate a table from another DB's table, peregenem
Re: Add autonumber key while creating a new table thru MakeTable Query, MGFoster
- <Possible follow-ups>
- Re: Add autonumber key while creating a new table thru MakeTable Query, peregenem
  - Message not available
    - Re: Add autonumber key while creating a new table thru MakeTable Q, peregenem
Re: HELP WITH "WHERE" clause, MGFoster
Re: Make a table query with no duplicates, John Spencer (MVP)
Re: Records missing in a query, Teri
Re: Query to add Foreign Key constraint to existing tables?, peregenem
- Re: Query to add Foreign Key constraint to existing tables?, Francisco Garcia
  - Re: Query to add Foreign Key constraint to existing tables?, peregenem
    - Re: Query to add Foreign Key constraint to existing tables?, Francisco Garcia
    - Re: Query to add Foreign Key constraint to existing tables?, Brendan Reynolds
    - Re: Query to add Foreign Key constraint to existing tables?, peregenem
    - Message not available
    - Message not available
    - Re: Query to add Foreign Key constraint to existing tables?, Francisco Garcia
CHOOSE function not behaving as expected, mikes
Re: Comparing 2 tables, Duane Hookom
- Message not available
  - Re: Comparing 2 tables, John Vinson
Last Record, Keith
Re: Force Row Headings in Crosstab?, Duane Hookom
Re: Non-cents query, John Vinson
- Message not available
  - Re: Non-cents query, John Vinson
Re: Last, Group By, unique results, Marshall Barton
IIf and parameter query, Amy Blankenship
Re: SQL Join statement, Amy Blankenship
Re: Adding data in fields together, Amy Blankenship
Re: Removing common fields, Baz
- <Possible follow-ups>
- Re: Removing common fields, John Spencer (MVP)
Re: ADD MONTH -1, Michel Walsh
unique values, wimsan
- Re: unique values, peregenem
Re: Why does a database close when I open design of a make table q, tdcarm
Select field name, Gil Lopes via AccessMonster.com
- Message not available
  - Message not available
    - Re: Select field name, John Vinson
Re: Select Count Random, JohnFol
Crosstab Query?, bassplayer
Re: Sort Order of Queries, Allen Browne
Not able to edit / update query, purushotham k via AccessMonster.com
Re: can you specifie criteria for a parameter query in an Auto Num, Van T. Dinh
Re: Date/Time, Van T. Dinh
- <Possible follow-ups>
- Re: Date/Time, John Vinson
Re: ODBC call failed, Van T. Dinh
Re: Sorting records in a form, John Vinson
- Re: Sorting records in a form, Jeff S via AccessMonster.com
  - Re: Sorting records in a form, John Vinson
Runs on Theirs, Not on Mine, Christopher Weaver
- Message not available
  - Re: Runs on Theirs, Not on Mine, Christopher Weaver
Re: Why is the "copy" command disabled when viewing a query in Access?, John Vinson
- <Possible follow-ups>
- Re: Why is the "copy" command disabled when viewing a query in Access?, Van T. Dinh
Re: can you specifie criteria for a parameter query in an Auto Number., John Vinson
Query Puzzle, Bradley
- Re: Query Puzzle, Chaim
- Re: Query Puzzle, Marshall Barton
criteria and dates, kryszystof via AccessMonster.com
- Re: criteria and dates, kryszystof via AccessMonster.com
  - Re: criteria and dates, kryszystof via AccessMonster.com
    - Re: criteria and dates, kryszystof via AccessMonster.com
    - Re: criteria and dates, Chaim
  - Re: criteria and dates, Marshall Barton
    - Re: criteria and dates, kryszystof via AccessMonster.com
    - Re: criteria and dates, Van T. Dinh
Expr1002, aak
- Re: Expr1002, Marshall Barton
HELP With DATA and Make Table Query, Doc
- Re: HELP With DATA and Make Table Query, Chaim
  - Re: HELP With DATA and Make Table Query, Doc
Re: how to feed result from P_T query to combo box?, Duane Hookom
Re: Query performance, MGFoster
- <Possible follow-ups>
- Re: Query performance, Van T. Dinh
Re: Computing Median, mcl
Expressions, Pompey_Boy
Previous Results, Bakr Z via AccessMonster.com
- Re: Previous Results, Vincent Johns
Re: a Query that collected parameters from a form just stopped working, JohnFol
- Re: a Query that collected parameters from a form just stopped wor, WebDude
  - Re: a Query that collected parameters from a form just stopped wor, WebDude
Invalid operation - error 3219 - iterative select query, Mark Wickett
Why is access filling in fields in query results, Robbie via AccessMonster.com
- Re: Why is access filling in fields in query results, John Vinson
too few parameters - Sub Query, Dianna
- Re: too few parameters - Sub Query, Vincent Johns
Group by, neeraj
- Re: Group by, Eric D via AccessMonster.com
  - Re: Group by, Michel Walsh
- Re: Group by, John Spencer (MVP)
help w/ access 2k3 query criteria -user prompt for last name &/or, sj
- Re: help w/ access 2k3 query criteria -user prompt for last name &/or, John Vinson
select records on yes/no fields, Bob Brannon
- Re: select records on yes/no fields, Eric D via AccessMonster.com
  - Re: select records on yes/no fields, peregenem
- Re: select records on yes/no fields, Bob Brannon
calculation help, Carlee
- Re: calculation help, SteveS
Using Unbound Form to Enter Query Criteria, cainentm
- RE: Using Unbound Form to Enter Query Criteria, Ofer
- RE: Using Unbound Form to Enter Query Criteria, Ken Sheridan
Create records using defaults, Alex
- Re: Create records using defaults, Lynn Trapp
  - Message not available
    - Re: Create records using defaults, Lynn Trapp
Creating a Pivot table or Crosstab query with specific data., Andy
- Re: Creating a Pivot table or Crosstab query with specific data., David S via AccessMonster.com
Queries with Expressions cause a Compile Error, Dr Rubick
- Re: Queries with Expressions cause a Compile Error, John Vinson
Parameter from Form, Melinda
- RE: Parameter from Form, Ofer
  - RE: Parameter from Form, Melinda
  - RE: Parameter from Form, Melinda
    - RE: Parameter from Form, Ofer
Working with linked (MySQL) data, Mike
- Re: Working with linked (MySQL) data, John Spencer (MVP)
  - Re: Working with linked (MySQL) data, Mike
UNION returns unique values?, Stef
- Re: UNION returns unique values?, George Nicholson
How to create an expression, Jenn Civello
- RE: How to create an expression, Ofer
  - Message not available
    - Message not available
    - Message not available
    - Message not available
    - Message not available
    - Message not available
    - RE: How to create an expression, Jenn Civello
DISTINCT vs GROUPBY ?, Stef
- Re: DISTINCT vs GROUPBY ?, BabyATX13 via AccessMonster.com
- Re: DISTINCT vs GROUPBY ?, Michel Walsh
  - Re: DISTINCT vs GROUPBY ?, peregenem
    - Message not available
    - Re: DISTINCT vs GROUPBY ?, peregenem
Removing Nulls and displaying data together, Bradley
- Re: Removing Nulls and displaying data together, Bradley
  - Re: Removing Nulls and displaying data together, John Vinson
Order by rownum or order that data was entered into table, Cindy H
- Re: Order by rownum or order that data was entered into table, BabyATX13 via AccessMonster.com
  - Re: Order by rownum or order that data was entered into table, Will Lastname
    - Re: Order by rownum or order that data was entered into table, peregenem
criteria, checkboxes, and/or, bicyclops
- Re: criteria, checkboxes, and/or, John Vinson
  - Message not available
    - Re: criteria, checkboxes, and/or, John Vinson
Need a date query hero, John G
- RE: Need a date query hero, John G
  - RE: Need a date query hero, John G
- Re: Need a date query hero, Michel Walsh
  - Re: Need a date query hero, John G
    - Re: Need a date query hero, Michel Walsh
    - Re: Need a date query hero, John G
    - Re: Need a date query hero, Michel Walsh
    - Message not available
    - Re: Need a date query hero, Douglas J. Steele
    - Message not available
    - Re: Need a date query hero, Michel Walsh
    - Message not available
    - Message not available
    - Re: Need a date query hero, John G
    - Message not available
    - Re: Need a date query hero, Michel Walsh
    - Message not available
    - Re: Need a date query hero, John G
    - Message not available
    - Re: Need a date query hero, John G
    - Re: Need a date query hero, John G
Selecting records with email addresses, Melih
- Re: Selecting records with email addresses, John Spencer (MVP)
Calculation for tiered discounting, Carlee
- Re: Calculation for tiered discounting, Michel Walsh
  - Re: Calculation for tiered discounting, Carlee
Subtract days from Left(Date(),5), consjoe
- RE: Subtract days from Left(Date(),5), KARL DEWEY
  - RE: Subtract days from Left(Date(),5), consjoe
    - RE: Subtract days from Left(Date(),5), KARL DEWEY
- Re: Subtract days from Left(Date(),5), John Vinson
Re: How do I change the default year setting from Jan-Dec to Oct-S, Cyberwolf
Query to find list of persons whose age is below/above input age, leo pradeep
- RE: Query to find list of persons whose age is below/above input age, Ofer
- Re: Query to find list of persons whose age is below/above input age, Rick B
- Re: Query to find list of persons whose age is below/above input age, John Vinson
Trouble with "*" wildcard, Leroy
- Re: Trouble with "*" wildcard, Eric D via AccessMonster.com
Query rolling dates?, pvdalen
- Re: Query rolling dates?, John Vinson
- Re: Query rolling dates?, Olli Kinnunen
Change date format in Query, Rhonda
- Re: Change date format in Query, David Lloyd
- RE: Change date format in Query, Ofer
Working with Dates in Access, Nora
- Re: Working with Dates in Access, John Vinson
  - Re: Working with Dates in Access, Nora
Store Procedure, Arne
- RE: Store Procedure, Ofer
How to compare fields, Luther
- RE: How to compare fields, Ofer
  - RE: How to compare fields, Luther
    - RE: How to compare fields, Ofer
- RE: How to compare fields, Ofer
  - RE: How to compare fields, Luther
    - RE: How to compare fields, Ofer
    - RE: How to compare fields, Luther
    - RE: How to compare fields, Ofer
    - RE: How to compare fields, Luther
- Re: How to compare fields, John Vinson
- Re: How to compare fields, John Spencer (MVP)
Syntax ^'(ctrl + '), michael
- Re: Syntax ^'(ctrl + '), John Vinson
  - Re: Syntax ^'(ctrl + '), Mike Gill
Count distinct in pivot table, Kanga
Repeating an empty query, EliotF
- Re: Repeating an empty query, Duane Hookom
what does 'inconsistent updates' really mean?, bicyclops
- Re: what does 'inconsistent updates' really mean?, Michel Walsh
Why is this not an updatable query?, cvegas
- Re: Why is this not an updatable query?, JohnFol
how do i get help with querying a database, lloyd8156
- Re: how do i get help with querying a database, JohnFol
- Re: how do i get help with querying a database, PC Datasheet
Lookup field abilities, Rich
- Re: Lookup field abilities, Allen Browne
  - Re: Lookup field abilities, Rich
    - Re: Lookup field abilities, Allen Browne
    - Re: Lookup field abilities, Rich
    - Re: Lookup field abilities, John Vinson
Time Schedule Query, Debbie D.
- Re: Time Schedule Query, Eric D via AccessMonster.com
  - Re: Time Schedule Query - Eric D, Debbie D.
    - Re: Time Schedule Query - Eric D, Eric D via AccessMonster.com
    - Re: Time Schedule Query - Eric D, Debbie D.
    - Re: Time Schedule Query - Eric D, Eric D via AccessMonster.com
    - Re: Time Schedule Query - Eric D, Debbie D.
Put a total at the bottom a column, edward keith
- Re: Put a total at the bottom a column, Rick Brandt
Challenging?, Jay
- Re: Challenging?, David S via AccessMonster.com
Challenging Thinking, Jay
- Re: Challenging Thinking, David S via AccessMonster.com
Date format in crosstab query, Matt
- Re: Date format in crosstab query, Duane Hookom
  - Re: Date format in crosstab query, Matt
    - Re: Date format in crosstab query, Duane Hookom
vba Query for column name, ismail
- Re: vba Query for column name, JohnFol
  - Re: vba Query for column name, ismail
date and time, Jay
- RE: date and time, Ofer
- Re: date and time, John Spencer (MVP)
- <Possible follow-ups>
- Date and Time, Jay
  - Re: Date and Time, Duane Hookom
How to usa ALTER COLUMN to change a column name, Robson_Brasil
- RE: How to usa ALTER COLUMN to change a column name, Ofer
- Re: How to usa ALTER COLUMN to change a column name, peregenem
Count Unique Records, BBTMAMA
- RE: Count Unique Records, Ken Sheridan
- Re: Count Unique Records, John Spencer (MVP)
Multiple phone numbers (home, business, mobile) in one list, Russ via AccessMonster.com
- Re: Multiple phone numbers (home, business, mobile) in one list, Russ via AccessMonster.com
  - Re: Multiple phone numbers (home, business, mobile) in one list, Russ via AccessMonster.com
    - Re: Multiple phone numbers (home, business, mobile) in one list, Jeff Boyce
    - Re: Multiple phone numbers (home, business, mobile) in one list, Russ via AccessMonster.com
    - Re: Multiple phone numbers (home, business, mobile) in one list, Jeff Boyce
    - Re: Multiple phone numbers (home, business, mobile) in one list, Russ via AccessMonster.com
    - Re: Multiple phone numbers (home, business, mobile) in one list, Jeff Boyce
    - Re: Multiple phone numbers (home, business, mobile) in one list, Russ via AccessMonster.com
    - Re: Multiple phone numbers (home, business, mobile) in one list, Jeff Boyce
    - Re: Multiple phone numbers (home, business, mobile) in one list, Russ via AccessMonster.com
calculating data from multiple fields, David
- Re: calculating data from multiple fields, Allen Browne
  - Re: calculating data from multiple fields, David
    - Re: calculating data from multiple fields, Allen Browne
    - Re: calculating data from multiple fields, David
    - Re: calculating data from multiple fields, Allen Browne
    - Re: calculating data from multiple fields, David
    - Re: calculating data from multiple fields, John Spencer (MVP)
    - Re: calculating data from multiple fields, David
on line help regarding individual record's calculation not to fie., Quadeer Ahmed
- Re: on line help regarding individual record's calculation not to fie., David S via AccessMonster.com
Dealing with "almost" duplicate records, Cheese
- Re: Dealing with "almost" duplicate records, Jeff Boyce
  - Re: Dealing with "almost" duplicate records, Cheese
    - Re: Dealing with "almost" duplicate records, Jeff Boyce
SQL Union Query - include table name as field?, Titian
- Re: SQL Union Query - include table name as field?, Duane Hookom
  - Re: SQL Union Query - include table name as field?, Titian
Problem with displaying all records in a query, ukpicker
- RE: Problem with displaying all records in a query, KARL DEWEY
  - RE: Problem with displaying all records in a query, ukpicker
extract digits from addresses, shank
- Re: extract digits from addresses, Debra Farnham
  - Re: extract digits from addresses, shank
    - Re: extract digits from addresses, Debra Farnham
    - Re: extract digits from addresses, shank
    - Re: extract digits from addresses, Debra Farnham
    - Re: extract digits from addresses, John Spencer (MVP)
Accessing functions from an external library, dp
- RE: Accessing functions from an external library, '69 Camaro
  - RE: Accessing functions from an external library, dp
    - RE: Accessing functions from an external library, '69 Camaro
Current Expenditure, Alylia
- Re: Current Expenditure, Duane Hookom
  - Re: Current Expenditure, Alylia
    - Re: Current Expenditure, Duane Hookom
    - Re: Current Expenditure, Alylia
    - Re: Current Expenditure, Duane Hookom
    - Re: Current Expenditure, Alylia
    - Re: Current Expenditure, Duane Hookom
    - Re: Current Expenditure, Alylia
    - Re: Current Expenditure, Duane Hookom
"Find Unmatched Query" help for Football pool, Lucky Louie
- Re: "Find Unmatched Query" help for Football pool, Michel Walsh
Read me, casey
Find anniversary of a date, Rli
- Re: Find anniversary of a date, Allan Murphy
  - Re: Find anniversary of a date, Rli
    - Re: Find anniversary of a date, Rli
    - Re: Find anniversary of a date, Douglas J. Steele
    - Re: Find anniversary of a date, Rli
    - Re: Find anniversary of a date, Douglas J. Steele
    - Re: Find anniversary of a date, Rli
    - Re: Find anniversary of a date, Debra Farnham
    - Re: Find anniversary of a date, Rli
    - Message not available
    - Re: Find anniversary of a date, Rli
- Re: Find anniversary of a date, Dale Fye
field not equal, neeraj
- Re: field not equal, Dale Fye
  - Re: field not equal, neeraj
Just the month please, KAnoe
- Re: Just the month please, PC Datasheet
  - Re: Just the month please, KAnoe
concatenate records, db
- RE: concatenate records, KARL DEWEY
  - Re: concatenate records, db
Two Columns of same fields in query, Randy
- RE: Two Columns of same fields in query, KARL DEWEY
Append query problem, BabyATX13 via AccessMonster.com
- RE: Append query problem, S Panja
  - RE: Append query problem, BabyATX13 via AccessMonster.com
- Re: Append query problem, BabyATX13 via AccessMonster.com
  - Re: Append query problem, John Spencer (MVP)
    - Message not available
    - Message not available
    - Re: Append query problem, BabyATX13 via AccessMonster.com
Spliting one field into three, Snake
- RE: Spliting one field into three, SteveD
  - Re: Spliting one field into three, Steve Schapel
Fiscal Year query, Cyberwolf
- RE: Fiscal Year query, KARL DEWEY
  - RE: Fiscal Year query, Cyberwolf
Union query- count records, Stephanie
- RE: Union query- count records, KARL DEWEY
  - RE: Union query- count records, Stephanie
Validation Rule Problem, Martin
- Re: Validation Rule Problem, Jeff Boyce
  - Re: Validation Rule Problem, Martin
    - Re: Validation Rule Problem, Jeff Boyce
Counting Records, Rick Deemer
- RE: Counting Records, Hafeez Esmail
Delete Multiple Items in one Table, Sparky Arbuckle
- Re: Delete Multiple Items in one Table, Allen Browne
  - Re: Delete Multiple Items in one Table, Sparky Arbuckle
    - Re: Delete Multiple Items in one Table, Will Lastname
returning all records, Jason
- Re: returning all records, David S via AccessMonster.com
- RE: returning all records, Jason
- RE: returning all records, Jason
  - RE: returning all records, David S via AccessMonster.com
    - RE: returning all records, David S via AccessMonster.com
    - RE: returning all records, Jason via AccessMonster.com
how do I query values in a single column, Rashar Sharro via AccessMonster.com
- RE: how do I query values in a single column, Hafeez Esmail
Null Value in Table, mcgj
- Re: Null Value in Table, Duane Hookom
Complex queries & reports, Darryl
- Re: Complex queries & reports, Duane Hookom
Modify Format of Date Query, Leroy
- Re: Modify Format of Date Query, Rick B
  - Re: Modify Format of Date Query, Leroy
    - Re: Modify Format of Date Query, Rick B
    - Re: Modify Format of Date Query, Leroy
    - Re: Modify Format of Date Query, Rick B
    - Re: Modify Format of Date Query, John Spencer (MVP)
- RE: Modify Format of Date Query, KARL DEWEY
multiple sortings, dlb1228
- RE: multiple sortings, Dennis
How to setup an expression, Jenn Civello
- Re: How to setup an expression, Chaim
RE: moving data, Ofer
How do I count the values in a column?, Rashar Sharro via AccessMonster.com
- Re: How do I count the values in a column?, Jeff Boyce
  - Re: How do I count the values in a column?, Rashar Sharro via AccessMonster.com
    - Re: How do I count the values in a column?, Jeff Boyce
    - Re: How do I count the values in a column?, Rashar Sharro via AccessMonster.com
    - Re: How do I count the values in a column?, Jeff Boyce
    - Re: How do I count the values in a column?, John Spencer (MVP)
Date and Time format, Alan
- Re: Date and Time format, Duane Hookom
update query count, Edrick larkin
- Re: update query count, Chaim
Please help with extracting records, Al
- Re: Please help with extracting records, Eric D via AccessMonster.com
  - Re: Please help with extracting records, Al
Test for unpopulated Date field, Glynn Taylor
- RE: Test for unpopulated Date field, Ofer
- Re: Test for unpopulated Date field, Erik
UNION of two queries gives Overflow, Erik
Update Query to search for " and replace with something else, Bingo
- RE: Update Query to search for " and replace with something else, Dennis
Query Criteria based off Form, Jack W via AccessMonster.com
- Re: Query Criteria based off Form, Jack W via AccessMonster.com
- RE: Query Criteria based off Form, Ofer
Return Top records not Top values?, Val
- RE: Return Top records not Top values?, Ofer
- Re: Return Top records not Top values?, John Spencer (MVP)
  - Re: Return Top records not Top values?, Val
    - Re: Return Top records not Top values?, Val
Use wildcard or value from form, axle
- RE: Use wildcard or value from form, Ofer
  - RE: Use wildcard or value from form, axle
Returning an answer based upon a range.., apmeehan
- Re: Returning an answer based upon a range.., John Vinson
  - Re: Returning an answer based upon a range.., andymqld
    - Re: Returning an answer based upon a range.., John Vinson
full name from first and last name, again, Jay
- RE: full name from first and last name, again, TerryC
Need HELP to limit number of records per individual, John
- Re: Need HELP to limit number of records per individual, John Vinson
  - Re: Need HELP to limit number of records per individual, John
    - Re: Need HELP to limit number of records per individual, John Vinson
Make an updateable query, TerryC
- Re: Make an updateable query, John Vinson
  - Re: Make an updateable query, TerryC
Query size of memo field, Janna
- RE: Query size of memo field, TerryC
full name vs first and last name, Jay
- Re: full name vs first and last name, David S via AccessMonster.com
- <Possible follow-ups>
- full name vs first and last name, Jay
  - Re: full name vs first and last name, PC Datasheet
  - RE: full name vs first and last name, TerryC
Query from Multiple tables, Ed
- Re: Query from Multiple tables, Duane Hookom
  - Re: Query from Multiple tables, Ed
    - Re: Query from Multiple tables, Duane Hookom
    - Re: Query from Multiple tables, Ed
    - Re: Query from Multiple tables, Duane Hookom
Re: Quiz Test Maker, Tony Dondero
Merge two or more tables into new table, yourokay
- Re: Merge two or more tables into new table, John Spencer (MVP)
  - Re: Merge two or more tables into new table, yourokay
    - Re: Merge two or more tables into new table, John Spencer (MVP)
#name?/ deleted record error, Pogue Mahone
- RE: #name?/ deleted record error, Ofer
  - RE: #name?/ deleted record error, Pogue Mahone
    - RE: #name?/ deleted record error, Ofer
How can I set up a query inside a query?, jaybear
- RE: How can I set up a query inside a query?, Ofer
- Re: How can I set up a query inside a query?, PC Datasheet
Query to extract data in a specified format, sattaluri
- RE: Query to extract data in a specified format, KARL DEWEY
Time lapsed between two records with same value, danka
- RE: Time lapsed between two records with same value, jmonty
- RE: Time lapsed between two records with same value, danka
- Re: Time lapsed between two records with same value, Jeff Boyce
  - Re: Time lapsed between two records with same value, danka
    - Re: Time lapsed between two records with same value, Jeff Boyce
    - Re: Time lapsed between two records with same value, danka
How do I calculate an Average Daily Balance in Access?, JOhnDragt
- Re: How do I calculate an Average Daily Balance in Access?, Rick B
  - Re: How do I calculate an Average Daily Balance in Access?, JOhnDragt
Can a field in a table get its value by referencing another table?, kelly d via AccessMonster.com
- Re: Can a field in a table get its value by referencing another table?, kelly d via AccessMonster.com
Pivot Table and Crosstab Query Limitions, amkazen
- RE: Pivot Table and Crosstab Query Limitions, amkazen
- Re: Pivot Table and Crosstab Query Limitions, John Spencer (MVP)
  - Re: Pivot Table and Crosstab Query Limitions, Andy
    - Re: Pivot Table and Crosstab Query Limitions, John Spencer (MVP)
Scoping Report Output using Parameterized Query, DBG
- Re: Scoping Report Output using Parameterized Query, MGFoster
Prompt in query, Cissy
- Re: Prompt in query, Rick B
  - Re: Prompt in query, Cissy
    - Re: Prompt in query, Rick B
    - Re: Prompt in query, Cissy
Re: How do I do a random sample query of data in an Access databas, Joe Chioda
sorting columns in crosstab, monia13
- RE: sorting columns in crosstab, KARL DEWEY
- Re: sorting columns in crosstab, Eric D via AccessMonster.com
- Re: sorting columns in crosstab, Michel Walsh
- Re: sorting columns in crosstab, MGFoster
  - Re: sorting columns in crosstab, MGFoster
    - Re: sorting columns in crosstab, Duane Hookom
SQL Query to Combine Records, Clint Marshall
- Re: SQL Query to Combine Records, Michel Walsh
- Re: SQL Query to Combine Records, MGFoster
Adding records to a table, Petterq
- RE: Adding records to a table, KARL DEWEY
- Re: Adding records to a table, Michel Walsh
  - Re: Adding records to a table, Petterq
    - Re: Adding records to a table, Michel Walsh
    - Re: Adding records to a table, Michel Walsh
Q: show value if another field is yes, dianne
- Re: show value if another field is yes, Michel Walsh
Distinct and Concatenate, Gwen H
- Re: Distinct and Concatenate, Michel Walsh
  - Re: Distinct and Concatenate, Gwen H
- Re: Distinct and Concatenate, MGFoster
Finding Unmatched records from two tables, Tia
- RE: Finding Unmatched records from two tables, Stephanie
  - RE: Finding Unmatched records from two tables, Tia
    - RE: Finding Unmatched records from two tables, Stephanie
    - Re: Finding Unmatched records from two tables, John Spencer (MVP)
How do I import data from one table into another?, Mo Man
- RE: How do I import data from one table into another?, KARL DEWEY
  - Re: How do I import data from one table into another?, Mo Man
- Re: How do I import data from one table into another?, Michel Walsh
  - Re: How do I import data from one table into another?, Mo Man
Queries with partial matches between tables, Lostshakerofsalt
- RE: Queries with partial matches between tables, KARL DEWEY
  - RE: Queries with partial matches between tables, Lostshakerofsalt
    - RE: Queries with partial matches between tables, KARL DEWEY
- Re: Queries with partial matches between tables, John Spencer (MVP)
parameterized in clause, Daniel Fisherman
- Re: parameterized in clause, Michel Walsh
  - Re: parameterized in clause, Daniel Fisherman
    - Re: parameterized in clause, Michel Walsh
    - Re: parameterized in clause, Daniel Fisherman
    - Re: parameterized in clause, Michel Walsh
    - Re: parameterized in clause, peregenem
Joining two queries...Please Help, Carlee
- RE: Joining two queries...Please Help, KARL DEWEY
- Re: Joining two queries...Please Help, Michel Walsh
- Re: Joining two queries...Please Help, David Lloyd
Query is not updating table, melwester
- Re: Query is not updating table, Michel Walsh
Field Calculation in query error, kontra
- Re: Field Calculation in query error, Duane Hookom
  - Re: Field Calculation in query error, kontra
  - Re: Field Calculation in query error, kontra
- RE: Field Calculation in query error, kontra
Calculating weekdays in Access, tjmp007
- Re: Calculating weekdays in Access, Michel Walsh
  - Re: Calculating weekdays in Access, tjmp007
    - Re: Calculating weekdays in Access, Michel Walsh
  - Re: Calculating weekdays in Access, peregenem
    - Re: Calculating weekdays in Access, Michel Walsh
How can I make a query for a key word in a column?, jaybear
- RE: How can I make a query for a key word in a column?, KARL DEWEY
  - RE: How can I make a query for a key word in a column?, jaybear
- Re: How can I make a query for a key word in a column?, Michel Walsh
  - Re: How can I make a query for a key word in a column?, jaybear
    - Re: How can I make a query for a key word in a column?, Michel Walsh
Vacant Time Slots Query, Debbie D.
- Re: Vacant Time Slots Query, Eric D via AccessMonster.com
  - Re: Vacant Time Slots Query, Debbie D.
Show is data is missing, Carlee
- RE: Show is data is missing, KARL DEWEY
- Re: Show is data is missing, David Lloyd
Adding records from a table and a query, Kimbly
- Re: Adding records from a table and a query, Vincent Johns
  - Re: Adding records from a table and a query, Kimbly
    - Re: Adding records from a table and a query, Vincent Johns
How do i get database table of addys to sort by particular states, vr
- Re: How do i get database table of addys to sort by particular states, Rick B
- Re: How do i get database table of addys to sort by particular states, John Vinson
Inconsistent Behaviour of Union Select Query, Doug Robbins
- Re: Inconsistent Behaviour of Union Select Query, Allen Browne
  - Re: Inconsistent Behaviour of Union Select Query, Doug Robbins
- Re: Inconsistent Behaviour of Union Select Query, Olli Kinnunen
  - Re: Inconsistent Behaviour of Union Select Query, Doug Robbins
Calcolo delle ore, Giuseppe
After compacting my database, my queries are taking much more time, Billou
- Re: After compacting my database, my queries are taking much more time, Allen Browne
  - Re: After compacting my database, my queries are taking much more, Billou
    - Re: After compacting my database, my queries are taking much more, Vincent Johns
    - Re: After compacting my database, my queries are taking much more, Billou
    - Re: After compacting my database, my queries are taking much more, Vincent Johns
    - Re: After compacting my database, my queries are taking much more, Allen Browne
    - Re: After compacting my database, my queries are taking much more, Billou
    - Re: After compacting my database, my queries are taking much more, Allen Browne
'No Current Record' error in Group By query with outer joins - SOLUTION, Allen Browne
Design view (select query with link table issues), Kim
- Re: Design view (select query with link table issues), Allen Browne
  - Re: Design view (select query with link table issues), Kim
    - Re: Design view (select query with link table issues), Allen Browne
Update query on (sub)form exit, Kanga
- Re: Update query on (sub)form exit, MGFoster
Still can't get query to work, me
- Re: Still can't get query to work, Ken Snell [MVP]
- Re: Still can't get query to work, me
  - Re: Still can't get query to work, Ken Snell [MVP]
- Re: Still can't get query to work, George Nicholson
  - Re: Still can't get query to work, me
    - Re: Still can't get query to work, Vincent Johns
    - Re: Still can't get query to work, George Nicholson
    - Re: Still can't get query to work, Vincent Johns
    - Re: Still can't get query to work, David S via AccessMonster.com
    - Re: Still can't get query to work, Jason via AccessMonster.com
  - Message not available
    - Message not available
    - Message not available
    - Re: Still can't get query to work, George Nicholson
Still can't make it work, me
- Re: Still can't make it work, David S via AccessMonster.com
Form open full size, Steve via AccessMonster.com
- RE: Form open full size, Ofer
  - RE: Form open full size, Steve via AccessMonster.com
    - Re: Form open full size, John Spencer (MVP)
    - Re: Form open full size, Steve via AccessMonster.com
Trying to get a query to return certain records, jbirchal
- RE: Trying to get a query to return certain records, Ofer
  - RE: Trying to get a query to return certain records, jbirchal
  - RE: Trying to get a query to return certain records, jbirchal
    - RE: Trying to get a query to return certain records, Ofer
Re: to group like items with total and number associated in the group., MGFoster
Re: Albert D. Kallal -WordMerge20, Albert D.Kallal
- Re: Albert D. Kallal -WordMerge20, Stephanie
  - Re: Albert D. Kallal -WordMerge20, Albert D.Kallal
    - Re: Albert D. Kallal -WordMerge20, Albert D.Kallal
    - Re: Albert D. Kallal -WordMerge20, Stephanie
    - Re: Albert D. Kallal -WordMerge20, Albert D.Kallal
    - Re: Albert D. Kallal -WordMerge20, Stephanie
    - Re: Albert D. Kallal -WordMerge20, Albert D.Kallal
    - Re: Albert D. Kallal -WordMerge20, Stephanie
    - Re: Albert D. Kallal -WordMerge20, Albert D.Kallal
Sum of sums, MilesMonkMingus
- Re: Sum of sums, Duane Hookom
- RE: Sum of sums, Ofer
  - Re: Sum of sums, MilesMonkMingus
  - Re: Sum of sums, MilesMonkMingus
Where used?, Stephanie
- Re: Where used?, RuralGuy
  - Re: Where used?, Stephanie
- Re: Where used?, Wayne Morgan
  - Re: Where used?, RuralGuy
    - Re: Where used?, Wayne Morgan
Add comments?, MilesMonkMingus
- RE: Add comments?, Ofer
- Re: Add comments?, MGFoster
  - Re: Add comments?, Vincent Johns
Extracting certain information from a column, Rita D via AccessMonster.com
- RE: Extracting certain information from a column, jbirchal
  - RE: Extracting certain information from a column, Rita D via AccessMonster.com
    - Re: Extracting certain information from a column, Gary Walter
    - Re: Extracting certain information from a column, Gary Walter
    - Re: Extracting certain information from a column, Rita D via AccessMonster.com
    - Re: Extracting certain information from a column, Gary Walter
Help with recursive statement, Net
- RE: Help with recursive statement, Net
- Re: Help with recursive statement, RuralGuy
Re: Query "N" previous records starting with this record, WR@hotmail.com(donotspam)
- Re: Query "N" previous records starting with this record, John Vinson
Form field for criterea problems, Bdavis
- RE: Form field for criterea problems, Ofer
  - RE: Form field for criterea problems, Bdavis
    - Re: Form field for criterea problems, John Spencer (MVP)
could not delete from specified tables, LutherMom
- Re: could not delete from specified tables, Lynn Trapp
Sort by largest sub-total, Steve via AccessMonster.com
- Re: Sort by largest sub-total, Duane Hookom
  - Re: Sort by largest sub-total, Steve via AccessMonster.com
simple query count, arran1180
- Re: simple query count, Duane Hookom
  - Re: simple query count, arran1180
    - Re: simple query count, Duane Hookom
Delete Query to SQL Database Times Out, John Piotrowski
- RE: Delete Query to SQL Database Times Out, Ofer
  - RE: Delete Query to SQL Database Times Out, John Piotrowski
    - RE: Delete Query to SQL Database Times Out, Ofer
    - RE: Delete Query to SQL Database Times Out, John Piotrowski
ADO to mdb joins, jmonty
- Re: ADO to mdb joins, MGFoster
  - Re: ADO to mdb joins, jmonty
    - Re: ADO to mdb joins, peregenem
Running Sum Error, Lori
- Re: Running Sum Error, MGFoster
HOWTO: Use conditions in FROM clause in Access sintax., NKN
- Re: HOWTO: Use conditions in FROM clause in Access sintax., MGFoster
  - Re: HOWTO: Use conditions in FROM clause in Access sintax., NKN
    - Re: HOWTO: Use conditions in FROM clause in Access sintax., Vincent Johns
    - Re: HOWTO: Use conditions in FROM clause in Access sintax., MGFoster
    - Re: HOWTO: Use conditions in FROM clause in Access sintax., John Spencer (MVP)
Roll-Up and Aggregate query, Tom
- Re: Roll-Up and Aggregate query, David S via AccessMonster.com
Updating Multiple fields with the same number, Rich S.
- Re: Updating Multiple fields with the same number, John Spencer (MVP)
  - Re: Updating Multiple fields with the same number, Rich S.
Listing birthdays - best method?, Aaron G
- Re: Listing birthdays - best method?, Rick B
  - Re: Listing birthdays - best method?, Aaron G
Re: Displaying empty cells as zero in report, Duane Hookom
show all records in a join, Kenyon
- Re: show all records in a join, MGFoster
Need to write a query, tamxwell
- Re: Need to write a query, Chaim
  - Re: Need to write a query, tamxwell
    - Re: Need to write a query, Chaim
- Re: Need to write a query, Eric D via AccessMonster.com
  - Re: Need to write a query, tamxwell
Crosstab Query / Column Headers, Jeff Schneider
- Re: Crosstab Query / Column Headers, Duane Hookom
  - Re: Crosstab Query / Column Headers, Jeff Schneider
major query issues, Jason
- Re: major query issues, JohnFol
  - Re: major query issues, Jason
- RE: major query issues, Jason
How do I restrict a query to give only one name&date per name?, Aileen Hewat
- RE: How do I restrict a query to give only one name&date per name?, Dennis
- Re: How do I restrict a query to give only one name&date per name?, John Spencer (MVP)
The Recordset is Not Updateable, Paul
Query->db changes, Zurn
- Re: Query->db changes, JohnFol
  - Re: Query->db changes, Zurn
pro-rata figures don't equal original total, Dave
- Re: pro-rata figures don't equal original total, John Vinson
Re: Literal Columnheaders in crosstable query, Allen Browne
- Message not available
  - Re: Literal Columnheaders in crosstable query, Allen Browne
How to set up default number format in a make-table query?, Frances
- Re: How to set up default number format in a make-table query?, Duane Hookom
- Re: How to set up default number format in a make-table query?, John Vinson
  - Re: How to set up default number format in a make-table query?, Frances
    - Re: How to set up default number format in a make-table query?, John Vinson
Sum Query - how to??, Flemming
- Re: Sum Query - how to??, David S via AccessMonster.com
Crosstab query with missing data, Orlando
Most current JET provider string, XP
- Re: Most current JET provider string, Douglas J. Steele
DMax and more!!, David#
- Re: DMax and more!!, David S via AccessMonster.com
Use of Distinct?, wgoldfarb
- Re: Use of Distinct?, David S via AccessMonster.com
  - Re: Use of Distinct?, David S via AccessMonster.com
  - Re: Use of Distinct?, wgoldfarb
How do I not carry over parameters from query to query?, Karin S
- Re: How do I not carry over parameters from query to query?, John Vinson
  - Re: How do I not carry over parameters from query to query?, Karin S
- <Possible follow-ups>
- How do I NOT carry over parameters from query to query?, Karin S
  - Re: How do I NOT carry over parameters from query to query?, JohnFol
  - RE: How do I NOT carry over parameters from query to query?, Karin S
  - Re: How do I NOT carry over parameters from query to query?, Rick B
undefined function 'replace', kaw
- Re: undefined function 'replace', Douglas J. Steele
Query of records with various criteria incl. Null Values, ETC
- Re: Query of records with various criteria incl. Null Values, Allen Browne
  - Re: Query of records with various criteria incl. Null Values, ETC
    - Re: Query of records with various criteria incl. Null Values, Allen Browne
Finding Unmatched values, Carlee
- RE: Finding Unmatched values, Ofer
  - RE: Finding Unmatched values, Ofer
- RE: Finding Unmatched values, Ofer
Datatype error, XP
- Re: Datatype error, Duane Hookom
  - Re: Datatype error, XP
IIF "Add-On", Sparky Arbuckle
- Re: IIF "Add-On", Douglas J. Steele
  - Re: IIF "Add-On", Sparky Arbuckle
    - Re: IIF "Add-On", George Nicholson
    - Re: IIF "Add-On", Sparky Arbuckle
    - Re: IIF "Add-On", Sparky Arbuckle
Re: Multi-Level BOM (Bill of Materials), chuck . streb
update query from command button on form, Mike
- Re: update query from command button on form, Chaim
  - Re: update query from command button on form, Mike
    - Re: update query from command button on form, John Vinson
    - Re: update query from command button on form, Mike
    - Re: update query from command button on form, John Vinson
    - Re: update query from command button on form, Mike
- Re: update query from command button on form, John Vinson
Return Earliest Date, Alex
- Re: Return Earliest Date, [MVP] S.Clark
- Re: Return Earliest Date, Chaim
Help - Query must have at least one destination field, Suraj
- Re: Help - Query must have at least one destination field, John Vinson
  - Re: Help - Query must have at least one destination field, Suraj
Returning NULL Values, Sparky Arbuckle
- Re: Returning NULL Values, Brendan Reynolds
  - Re: Returning NULL Values, Sparky Arbuckle
    - Re: Returning NULL Values, Sparky Arbuckle
    - Re: Returning NULL Values, Brendan Reynolds
    - Re: Returning NULL Values, Sparky Arbuckle
    - Re: Returning NULL Values, Brendan Reynolds
  - Re: Returning NULL Values, Sparky Arbuckle
Number of fields within a table, John Palm
- Re: Number of fields within a table, Allen Browne
Total in a Crosstab Query, bbishop222
- Re: Total in a Crosstab Query, Duane Hookom
RE: FREE New Indian oil for men!, rKp
Use Transaction property, rKp
- Re: Use Transaction property, [MVP] S.Clark
  - Re: Use Transaction property, rKp
Help with Update statement, Net
- Re: Help with Update statement, George Nicholson
Date Query, Dennis A.
- Re: Date Query, Eric D via AccessMonster.com
  - Re: Date Query, Dennis A.
Criteria?, Angel_1
- Re: Criteria?, John Vinson
- RE: Criteria?, KARL DEWEY
Access 2003 and ADO 2.81, Ivan Debono
Access DDL/DMO??, Ivan Debono
- Re: Access DDL/DMO??, Brendan Reynolds
  - Re: Access DDL/DMO??, Ivan Debono
How to make empty columns in query, Johanna
- RE: How to make empty columns in query, Dennis
How a multiparameter query returns all records if all r null?, INM
- Re: How a multiparameter query returns all records if all r null?, Brendan Reynolds
Remove Duplicate Records....Pawan, Pawan
- Re: Remove Duplicate Records....Pawan, Nikos Yannacopoulos
using function to get multi values in query, dominic
- Re: using function to get multi values in query, Brendan Reynolds
- Re: using function to get multi values in query, peregenem
sum fields and then average them, Tailwag
- Re: sum fields and then average them, Brendan Reynolds
  - Re: sum fields and then average them, Tailwag
    - Re: sum fields and then average them, Brendan Reynolds
    - Re: sum fields and then average them, Brendan Reynolds
    - Re: sum fields and then average them, Tailwag
    - Re: sum fields and then average them, Brendan Reynolds
    - Re: sum fields and then average them, Tailwag
Insert Into Where account numbers are inequal, XP
- Re: Insert Into Where account numbers are inequal, Douglas J. Steele
  - Re: Insert Into Where account numbers are inequal, XP
- Re: Insert Into Where account numbers are inequal, John Vinson
  - Re: Insert Into Where account numbers are inequal, XP
- RE: Insert Into Where account numbers are inequal, XP
Count groups, Bonnie
- Re: Count groups, [MVP] S.Clark
- Re: Count groups, John Spencer (MVP)
extract portion of a string using SQL, pedro
- Re: extract portion of a string using SQL, david epsom dot com dot au
- Re: extract portion of a string using SQL, Duane Hookom
  - Re: extract portion of a string using SQL, John Vinson
    - Re: extract portion of a string using SQL, Duane Hookom
- Re: extract portion of a string using SQL, John Spencer (MVP)
- Re: extract portion of a string using SQL, John Vinson
Changing Data format in a field, Nigel
- Re: Changing Data format in a field, John Vinson
How do I get the reading for last month, Minnow
- Re: How do I get the reading for last month, John Vinson
  - Re: How do I get the reading for last month, Minnow
    - Re: How do I get the reading for last month, John Vinson
    - Re: How do I get the reading for last month, Douglas J. Steele
    - Re: How do I get the reading for last month, John Vinson
How to pass a value to a variable, sjw
- Re: How to pass a value to a variable, John Vinson
  - Re: How to pass a value to a variable, sjw
Help needed w/Crosstab Query and Column Values, John Moore
- Re: Help needed w/Crosstab Query and Column Values, Duane Hookom
Updating a Query, BigG
- Re: Updating a Query, Duane Hookom
  - Re: Updating a Query, BigG
    - Re: Updating a Query, Duane Hookom
- Re: Updating a Query, John Vinson
Can somebody help me with this query?, Wim Verschaeve
- Re: Can somebody help me with this query?, Duane Hookom
- Re: Can somebody help me with this query?, John Vinson
Query and count, Minnow
- Re: Query and count, Jeff Boyce
  - Re: Query and count, Minnow
    - Re: Query and count, Jeff Boyce
    - Re: Query and count, Sparky Arbuckle
- RE: Query and count, Minnow
  - Re: Query and count, Jeff Boyce
Help with query criteria. 2nd posting, Randy
- Re: Help with query criteria. 2nd posting, Ken Snell [MVP]
  - Re: Help with query criteria. 2nd posting, Randy
    - Re: Help with query criteria. 2nd posting, Ken Snell [MVP]
    - Re: Help with query criteria. 2nd posting, Randy
    - Re: Help with query criteria. 2nd posting, Ken Snell [MVP]
    - Re: Help with query criteria. 2nd posting, Randy
    - Re: Help with query criteria. 2nd posting, Ken Snell [MVP]
    - Re: Help with query criteria. 2nd posting, Randy
Adding data to a query, Johanna
- Re: Adding data to a query, Duane Hookom
  - Re: Adding data to a query, Johanna
    - Re: Adding data to a query, Duane Hookom
query - sum up and assign records to category, Flemming
- Re: query - sum up and assign records to category, [MVP] S.Clark
Dates, tpkt
- Re: Dates, Allen Browne
  - Re: Dates, tpkt
Last day of month, TUNSTAD
- RE: Last day of month, Ofer
Using a text box on a form to set the criteria, Chase
- Re: Using a text box on a form to set the criteria, Allen Browne
- Re: Using a text box on a form to set the criteria, Rick Brandt
Email Help!!!, Jack W via AccessMonster.com
- Re: Email Help!!!, David Lloyd
soccer competion schema, Richard
- RE: soccer competion schema, tpkt
  - Re: soccer competion schema, Duane Hookom
Problem with automatic SQL lookup, Charles E Finkenbiner
- Re: Problem with automatic SQL lookup, Jeff Boyce
- Re: Problem with automatic SQL lookup, John Vinson
  - Re: Problem with automatic SQL lookup, Charles E Finkenbiner
    - Re: Problem with automatic SQL lookup, Charles E Finkenbiner
    - Re: Problem with automatic SQL lookup, John Vinson
    - Re: Problem with automatic SQL lookup, Charles E Finkenbiner
    - Re: Problem with automatic SQL lookup, John Vinson
Like Query, Lynne
- Re: Like Query, JohnFol
  - Re: Like Query, Lynne
  - Re: Like Query, Lynne
- Re: Like Query, SteveS
Automated Table, mylove
- Re: Automated Table, JohnFol
- Re: Automated Table, John Vinson
Re: How to calculate a square root in a query, D Stretton
joining 2 tables, Rashesh$H$
- Re: joining 2 tables, John Spencer (MVP)
Help with a query to yield the most recent event grouped by client, Steve
- Re: Help with a query to yield the most recent event grouped by client, SteveS
  - Re: Help with a query to yield the most recent event grouped by cl, Steve
    - Re: Help with a query to yield the most recent event grouped by cl, SteveS
Filetring Date Fields by Month Name, Daren Hawes
- Re: Filetring Date Fields by Month Name, Allen Browne
  - Re: Filetring Date Fields by Month Name, Daren Hawes
  - Re: Filetring Date Fields by Month Name, Daren Hawes
    - Re: Filetring Date Fields by Month Name, Allen Browne
    - Re: Filetring Date Fields by Month Name, Daren Hawes
    - Re: Filetring Date Fields by Month Name, Allen Browne
Search & replace SQL string, Brian
- RE: Search & replace SQL string, Brian
Picking up Week Ending data, Alex Martinez
- Re: Picking up Week Ending data, Eric D via AccessMonster.com
decimal point problem, Andre C
- RE: decimal point problem, Ofer
  - Re: decimal point problem, peregenem
    - Re: decimal point problem, Andre C
    - Re: decimal point problem, peregenem
analysising ages in database., Andre C
- Re: analysising ages in database., Douglas J. Steele
  - Re: analysising ages in database., Andre C
    - Re: analysising ages in database., Douglas J. Steele
    - Re: analysising ages in database., Andre C
    - Re: analysising ages in database., Douglas J. Steele
    - Re: analysising ages in database., Andre C
    - Re: analysising ages in database., John Vinson
    - Re: analysising ages in database., Douglas J. Steele
    - Re: analysising ages in database., Andre C
    - Re: analysising ages in database., Duane Hookom
    - Re: analysising ages in database., Andre C
Building a SQL expression in VBA, Garry Douglas
trying to make a relitively diecent search, Mario Cirillo via AccessMonster.com
- Re: trying to make a relitively diecent search, Duane Hookom
  - Re: trying to make a relitively diecent search, Mario Cirillo via AccessMonster.com
    - Re: trying to make a relitively diecent search, Duane Hookom
Null & Is Not Null Query Question, Randy
- Re: Null & Is Not Null Query Question, Douglas J. Steele
  - Re: Null & Is Not Null Query Question, Randy
Need help with Access SQL Query, Charles E Finkenbiner
- Re: Need help with Access SQL Query, John Spencer (MVP)
  - Re: Need help with Access SQL Query, Charles E Finkenbiner
    - Re: Need help with Access SQL Query, John Spencer (MVP)
    - Re: Need help with Access SQL Query, Charles E Finkenbiner
    - Re: Need help with Access SQL Query, Charles E Finkenbiner
    - Re: Need help with Access SQL Query, John Spencer (MVP)
    - Re: Need help with Access SQL Query, John Spencer (MVP)
    - Re: Need help with Access SQL Query, Charles E Finkenbiner
Retrieve only the most recent event and event date, Steve
- RE: Retrieve only the most recent event and event date, Ofer
- Re: Retrieve only the most recent event and event date, John Spencer (MVP)
Show Table Window too small, adrian
- Re: Show Table Window too small, Rick Brandt
- Re: Show Table Window too small, Jack MacDonald
Updating Query SQL Text, Babar Rahim
- Re: Updating Query SQL Text, Duane Hookom
  - Re: Updating Query SQL Text, Babar Rahim
    - Re: Updating Query SQL Text, Duane Hookom
wild search, jervin via AccessMonster.com
- Re: wild search, Douglas J. Steele
  - Re: wild search, jervin via AccessMonster.com
Queries when the "one" table is used several times, Rich
- Re: Queries when the "one" table is used several times, Allen Browne
  - Re: Queries when the "one" table is used several times, Rich
    - Re: Queries when the "one" table is used several times, John Vinson
How Populate empty fields with zeros.., adrian
- RE: How Populate empty fields with zeros.., Ofer
- Re: How Populate empty fields with zeros.., Dale
Can Someone Help Me Fix My Querry, Aamer
- Re: Can Someone Help Me Fix My Querry, Michel Walsh
Select Distinct, smk23
- Re: Select Distinct, Ken Snell [MVP]
  - Re: Select Distinct, smk23
Non-Duplicates, Gary B
- Re: Non-Duplicates, John Spencer (MVP)
- Re: Non-Duplicates, PC Datasheet
  - Re: Non-Duplicates, Douglas J. Steele
Subtracting dates to equal months-access 2000, harvey
- Re: Subtracting dates to equal months-access 2000, PC Datasheet
why do other computers read and print my cd incorrectly?, dustykat
- Re: why do other computers read and print my cd incorrectly?, Gary Walter
  - Re: why do other computers read and print my cd incorrectly?, Gary Walter
RE: select into table (temporary or not), Alur
Re: "Square boxes", Blaze
Date Format, Jologs
- Re: Date Format, Allen Browne
  - Re: Date Format, Jologs
Infopath integration with Access Reports, Blaze
Update query giving blank results - Access 2003, Ann Scharpf
- Re: Update query giving blank results - Access 2003, SteveS
  - Re: Update query giving blank results - Access 2003, SteveS
query question, Bob Matthews
- <Possible follow-ups>
- QUERY QUESTION, anill
  - Re: QUERY QUESTION, John Spencer (MVP)
  - Re: QUERY QUESTION, John Vinson
Parameter Query and Date calculations...., Julie Wardlow
- Re: Parameter Query and Date calculations...., John Spencer (MVP)
  - Re: Parameter Query and Date calculations...., Julie Wardlow
More help with Paramter Query with Mathamatical Expressions, prismlight
- Re: More help with Paramter Query with Mathamatical Expressions, Duane Hookom
  - Re: More help with Paramter Query with Mathamatical Expressions, prismlight
    - Re: More help with Paramter Query with Mathamatical Expressions, Duane Hookom
    - Re: More help with Paramter Query with Mathamatical Expressions, prismlight
    - Re: More help with Paramter Query with Mathamatical Expressions, Duane Hookom
    - Re: More help with Paramter Query with Mathamatical Expressions, prismlight
    - Re: More help with Paramter Query with Mathamatical Expressions, Duane Hookom
relating one table to three fields in another table, bumpmobile
- Re: relating one table to three fields in another table, Duane Hookom
- RE: relating one table to three fields in another table, bumpmobile
Limitation using IN in WHERE, XP
- RE: Limitation using IN in WHERE, XP
- Re: Limitation using IN in WHERE, Michel Walsh
  - Re: Limitation using IN in WHERE, GPO
IN (Select ... ) in Query criteria, Cydney
- Re: IN (Select ... ) in Query criteria, Jack MacDonald
  - Re: IN (Select ... ) in Query criteria, Cydney
Best method to join six queries, Chuck
- Re: Best method to join six queries, Rick B
- RE: Best method to join six queries, tope12
- Re: Best method to join six queries, Rick B
Union query, tope12
- Re: Union query, John Vinson
  - Re: Union query, tope12
    - Re: Union query, John Vinson
    - Re: Union query, tope12
    - Re: Union query, John Vinson
    - Re: Union query, tope12
    - Re: Union query, John Vinson
- <Possible follow-ups>
- Union Query, Don S.
  - Re: Union Query, Duane Hookom
Returning all fields, me
- Re: Returning all fields, Rick B
Compile Error - SQL View, P B via AccessMonster.com
- Re: Compile Error - SQL View, Brendan Reynolds
WHERE statement, Stephanie
- Re: WHERE statement, MGFoster
  - Re: WHERE statement, Stephanie
    - Re: WHERE statement, MGFoster
    - Re: WHERE statement, Stephanie
    - Re: WHERE statement, MGFoster
    - Re: WHERE statement, Stephanie
    - Re: WHERE statement, MGFoster
    - Re: WHERE statement, Stephanie
    - Re: WHERE statement, MGFoster
    - Re: WHERE statement, Stephanie
Missing Queries when copying MDB from 2003 to 2000, Steve Happ
- Re: Missing Queries when copying MDB from 2003 to 2000, Allen Browne
Query joining 2 seperate tables, Jeffshex
- Re: Query joining 2 seperate tables, Duane Hookom
  - Re: Query joining 2 seperate tables, Jeffshex
    - Re: Query joining 2 seperate tables, Duane Hookom
    - Re: Query joining 2 seperate tables, Jeffshex
- Re: Query joining 2 seperate tables, Rick Brandt
SubQuery Help, William Horton
Re: Combining Voters from the same household., Mo Man
- Re: Combining Voters from the same household., Rick B
  - Re: Combining Voters from the same household., Mo Man
Union without duplicates?, Stephanie
- Re: Union without duplicates?, Sylvain Lafontaine
access field that contains first name space last into separate fie, Sheila
- Re: access field that contains first name space last into separate fie, Chaim
- Re: access field that contains first name space last into separate fie, Eric D via AccessMonster.com
- Re: access field that contains first name space last into separate fie, Eric D via AccessMonster.com
- Re: access field that contains first name space last into separate fie, Eric D via AccessMonster.com
Query last date by item, FA
- Re: Query last date by item, Chaim
  - Re: Query last date by item, FA
    - Re: Query last date by item, Michel Walsh
    - Re: Query last date by item, FA
    - Re: Query last date by item, Michel Walsh
    - Re: Query last date by item, FA
Compare table Records and Count New Records, Matt B. via AccessMonster.com
- Re: Compare table Records and Count New Records, MGFoster
  - Re: Compare table Records and Count New Records, Matt B via AccessMonster.com
Double Frustrated Outer Join?, Debra Farnham
- Re: Double Frustrated Outer Join?, peregenem
  - Re: Double Frustrated Outer Join?, Debra Farnham
- Re: Double Frustrated Outer Join?, JoelH
Number of 1st's between two dates, TUNSTAD
- Re: Number of 1st's between two dates, MGFoster
  - Re: Number of 1st's between two dates, PC Datasheet
Counts and Dates, Kelly H
- Re: Counts and Dates, John Vinson
MANIPULATE FIELD VALUES, angie
- Re: MANIPULATE FIELD VALUES, Gijs Beukenoot
please explain query (how it works), Akshay Harsulkar
- Re: please explain query (how it works), Jeff Boyce
- Re: please explain query (how it works), peregenem
select, Rli
- Re: select, Gary Walter
How to best send Emails, Jack W via AccessMonster.com
- Re: How to best send Emails, Jack W via AccessMonster.com
filelen in a query, TTL
- Re: filelen in a query, Brendan Reynolds
Compile Error, P B via AccessMonster.com
- Re: Compile Error, Gijs Beukenoot
  - Re: Compile Error, P B via AccessMonster.com
Any idea why a working query now produces "Compile Error", SherryT
- Re: Any idea why a working query now produces "Compile Error", Gary Walter
  - Re: Any idea why a working query now produces "Compile Error", SherryT
    - Re: Any idea why a working query now produces "Compile Error", Gary Walter
Queries with sorting vs. Orderby, Thomas Kroljic
- Re: Queries with sorting vs. Orderby, peregenem
Duplicates Recordset?, P B via AccessMonster.com
- Re: Duplicates Recordset?, Allen Browne
  - Re: Duplicates Recordset?, P B via AccessMonster.com
    - Re: Duplicates Recordset?, Allen Browne
    - Re: Duplicates Recordset?, John Spencer (MVP)
RE: Summing a sum2:David S, David S via AccessMonster.com
- RE: Summing a sum2:David S, Stephanie
  - RE: Summing a sum2:David S, David S via AccessMonster.com
    - RE: Summing a sum2:David S, Stephanie
    - RE: Summing a sum2:David S, Stephanie
    - RE: Summing a sum2:David S, Stephanie
Counting data?, jmuirman
- Re: Counting data?, Duane Hookom
  - Re: Counting data?, jmuirman
    - Re: Counting data?, Duane Hookom
    - Re: Counting data?, jmuirman
    - Re: Counting data?, Duane Hookom
    - Re: Counting data?, jmuirman
    - Re: Counting data?, Duane Hookom
    - Re: Counting data?, jmuirman
    - Re: Counting data?, Duane Hookom
- Re: Counting data?, John Vinson
Re: query on one to many that returns only specific records, ahzryn
Records mimicking each other, Jen
- Re: Records mimicking each other, John Vinson
  - Re: Records mimicking each other, Jen
    - Re: Records mimicking each other, John Vinson
    - Re: Records mimicking each other, BradJones
    - Re: Records mimicking each other, Jen
Error message assistance needed!, kblanding
- Re: Error message assistance needed!, '69 Camaro
Exclude zero-length strings in calculating average of a field, Kathy Franklin
- RE: Exclude zero-length strings in calculating average of a field, Ofer
joining two tables question, Frank
- Re: joining two tables question, John Vinson
Re: Make - Append Table Query Question, G DelVecchio
Loading Date Values into Access, Naveen
- Re: Loading Date Values into Access, Chaim
  - Re: Loading Date Values into Access, Naveen
Query results show records w/diff License # when finds matching Last/First names, jack R via AccessMonster.com
- Re: Query results show records w/diff License # when finds matching Last/First names, David Lloyd
editing a crosstab query, radioheadbutt
- Re: editing a crosstab query, Roger Carlson
  - Re: editing a crosstab query, Duane Hookom
#Error Results in Query, Sherry N.
- Re: #Error Results in Query, Ken Snell [MVP]
- RE: #Error Results in Query, Ofer
Like Join Query, Query Curious
- Re: Like Join Query, Roger Carlson
  - Re: Like Join Query, Query Curious
    - Re: Like Join Query, Roger Carlson
    - Re: Like Join Query, Michel Walsh
Using Operators in a query, Philly
- RE: Using Operators in a query, Ofer
- Re: Using Operators in a query, MGFoster
Color Coding Lines, Sondra
- Re: Color Coding Lines, Rick B
Optional Criteria in Query, b dubbin
- Re: Optional Criteria in Query, Chaim
Inexact Duplicates, RayRay
- RE: Inexact Duplicates, Ofer
  - RE: Inexact Duplicates, RayRay
- Re: Inexact Duplicates, John Vinson
HELP-can't open query recordset, Alan Baker
- Re: HELP-can't open query recordset, John Vinson
Query: If Statement Format, Chuck
- Re: Query: If Statement Format, Chaim
  - Re: Query: If Statement Format, Chuck
Difference between two dates, Carlee
- Re: Difference between two dates, Chaim
  - Re: Difference between two dates, John Spencer (MVP)
Help with query criteria, Randy
- Re: Help with query criteria, David S via AccessMonster.com
  - Re: Help with query criteria, Randy
    - Re: Help with query criteria, David S via AccessMonster.com
Passing Active Form Name to Report Input Parameter (ADP), Aad v via AccessMonster.com
- Re: Passing Active Form Name to Report Input Parameter (ADP), MGFoster
  - Re: Passing Active Form Name to Report Input Parameter (ADP), Aad v via AccessMonster.com
    - Re: Passing Active Form Name to Report Input Parameter (ADP), Aad v via AccessMonster.com
Not Between not working!, Todd W
- Re: Not Between not working!, Michel Walsh
  - Re: Not Between not working!, Todd W
    - Re: Not Between not working!, Michel Walsh
    - Re: Not Between not working!, Todd W
    - Re: Not Between not working!, Michel Walsh
    - Re: Not Between not working!, Todd W
Bitwise, Hermione
- Re: Bitwise, Allen Browne
  - Re: Bitwise, peregenem
Table to exclude in Critieria, Jack W via AccessMonster.com
- RE: Table to exclude in Critieria, Dennis
  - RE: Table to exclude in Critieria, Jack W via AccessMonster.com
Update Query based on criteria (joins), kmhnhsuk
- RE: Update Query based on criteria (joins), '69 Camaro
- Re: Update Query based on criteria (joins), John Vinson
Appending new rows only..., googlegroups
- Re: Appending new rows only..., Gijs Beukenoot
  - Re: Appending new rows only..., jacko3
    - Re: Appending new rows only..., Gijs Beukenoot
    - Re: Appending new rows only..., John Spencer (MVP)
    - Re: Appending new rows only..., jacko3
    - Re: Appending new rows only..., Gijs Beukenoot
    - Re: Appending new rows only..., jacko3
Re: Vacation database, two timelines, still working on switch quer, eb1mom
Query Sort Order, Gibson
- Re: Query Sort Order, Jeff Boyce
- Re: Query Sort Order, John Vinson
Query: Recordset is not updateable, Mus' via AccessMonster.com
- Re: Query: Recordset is not updateable, Duane Hookom
  - Re: Query: Recordset is not updateable, Mus' via AccessMonster.com
Additional column in select query, :uno:
RE: Date Last Changed, FA
- <Possible follow-ups>
- RE: Date Last Changed, FA
  - Re: Date Last Changed, John Spencer (MVP)
    - Re: Date Last Changed, FA
    - Re: Date Last Changed, John Spencer (MVP)
    - Re: Date Last Changed, FA
Summary Total of Two Date Fields, Karl Burrows
- Re: Summary Total of Two Date Fields, John Vinson
  - Re: Summary Total of Two Date Fields, Karl Burrows
    - Re: Summary Total of Two Date Fields, John Vinson
    - Re: Summary Total of Two Date Fields, Karl Burrows
    - Re: Summary Total of Two Date Fields, John Vinson
    - Re: Summary Total of Two Date Fields, Karl Burrows
    - Re: Summary Total of Two Date Fields, Karl Burrows
    - Re: Summary Total of Two Date Fields, John Vinson
    - Re: Summary Total of Two Date Fields, Karl Burrows
    - Re: Summary Total of Two Date Fields, John Vinson
    - Re: Summary Total of Two Date Fields, Karl Burrows
    - Re: Summary Total of Two Date Fields, John Vinson
    - Re: Summary Total of Two Date Fields, Karl Burrows
Query, Module or How find records in Table that match NAME but hav, UtahJack
- Re: Query, Module or How find records in Table that match NAME but hav, Eric D via AccessMonster.com
  - Re: Query, Module or How find records in Table that match NAME but, UtahJack
    - Re: Query, Module or How find records in Table that match NAME but, Eric D via AccessMonster.com
Query, Ransom
- Re: Query, John Vinson
- <Possible follow-ups>
- query, Alex
  - Re: query, David S via AccessMonster.com
    - Re: query, Duane Hookom
- Re: Query, Duane Hookom
  - Re: Query, gambler844
    - Re: Query, Duane Hookom
Re: "You canceled the previous operation.", Steven L via AccessMonster.com
- Re: "You canceled the previous operation.", Steven L via AccessMonster.com
  - Re: "You canceled the previous operation.", Steven L via AccessMonster.com
Re: A 'how did they do that' question about the Northwind DB, kelly d via AccessMonster.com
- Re: A 'how did they do that' question about the Northwind DB, Ken Snell [MVP]
  - Re: A 'how did they do that' question about the Northwind DB, kelly d via AccessMonster.com
Append Query, Ed
- RE: Append Query, madison1974
Re: can the new record icon be changed from the asterisk to something else?, kelly d via AccessMonster.com
- Re: can the new record icon be changed from the asterisk to something else?, Ken Snell [MVP]
  - Re: can the new record icon be changed from the asterisk to something else?, kelly d via AccessMonster.com
    - Re: can the new record icon be changed from the asterisk to something else?, kelly d via AccessMonster.com
    - Re: can the new record icon be changed from the asterisk to something else?, kelly d via AccessMonster.com
    - Re: can the new record icon be changed from the asterisk to something else?, Ken Snell [MVP]
Re: Error when running Query, but not Report, Ken Snell [MVP]
- Re: Error when running Query, but not Report, Blaze
  - Re: Error when running Query, but not Report, Ken Snell [MVP]
    - Re: Error when running Query, but not Report, Blaze
    - Re: Error when running Query, but not Report, Ken Snell [MVP]
    - Re: Error when running Query, but not Report, Blaze
    - Re: Error when running Query, but not Report, Ken Snell [MVP]
    - Re: Error when running Query, but not Report, Blaze
    - Re: Error when running Query, but not Report, Ken Snell [MVP]
    - Re: Error when running Query, but not Report, Blaze
    - Re: Error when running Query, but not Report, Ken Snell [MVP]
    - Re: Error when running Query, but not Report, Blaze
    - Re: Error when running Query, but not Report, Blaze
- <Possible follow-ups>
- Re: Error when running Query, but not Report, Blaze
  - Re: Error when running Query, but not Report, Ken Snell [MVP]
    - Re: Error when running Query, but not Report, Blaze
    - Re: Error when running Query, but not Report, Ken Snell [MVP]
    - Re: Error when running Query, but not Report, Blaze
    - Re: Error when running Query, but not Report, Ken Snell [MVP]
    - Re: Error when running Query, but not Report, Blaze
    - Re: Error when running Query, but not Report, Ken Snell [MVP]
    - Re: Error when running Query, but not Report, Blaze
    - Re: Error when running Query, but not Report, Ken Snell [MVP]
    - Re: Error when running Query, but not Report, Blaze
    - Re: Error when running Query, but not Report, Ken Snell [MVP]
Duplicates Query Question, P B via AccessMonster.com
- RE: Duplicates Query Question, KARL DEWEY
Update query with data from another table, WayneM
- Re: Update query with data from another table, John Vinson
Help with Parameter Query using MathamaticalExpressions, prismlight
- Re: Help with Parameter Query using MathamaticalExpressions, Van T. Dinh
Decimal/Rounding problem??, chrissy2391
- Re: Decimal/Rounding problem??, RuralGuy
  - Re: Decimal/Rounding problem??, chrissy2391
    - Re: Decimal/Rounding problem??, RuralGuy
Works great - How about selecting last two records in the child?, headly
- Re: Works great - How about selecting last two records in the child?, Michel Walsh
  - Not Entirely Working, headly
    - Re: Not Entirely Working, Michel Walsh
Re: I have a query that I need help on please, John Vinson
How to query the different format of the same name, JoJo S via AccessMonster.com
- Re: How to query the different format of the same name, John Vinson
  - Re: How to query the different format of the same name, JoJo S via AccessMonster.com
    - Re: How to query the different format of the same name, John Spencer (MVP)
    - Re: How to query the different format of the same name, John Vinson
    - Re: How to query the different format of the same name, JoJo S via AccessMonster.com
    - Re: How to query the different format of the same name, John Vinson
Re: Pivot Query Non-Numeric reporting, J Shrimps, Jr.
- Re: Pivot Query Non-Numeric reporting, KARL DEWEY
  - Re: Pivot Query Non-Numeric reporting, J Shrimps, Jr.
Query dilemma, BabyATX13 via AccessMonster.com
- Re: Query dilemma, John Vinson
  - Re: Query dilemma, BabyATX13 via AccessMonster.com
Like Month year Q, KAnoe
- Re: Like Month year Q, John Vinson
- RE: Like Month year Q, '69 Camaro
  - Re: Like Month year Q, John Vinson
    - Re: Like Month year Q, '69 Camaro
Help with Dynamic Queries/Report, THANX LW
- Re: Help with Dynamic Queries/Report, David Lloyd
  - Re: Help with Dynamic Queries/Report, THANX LW
- Re: Help with Dynamic Queries/Report, Duane Hookom
Queries that affect reports, Kelly H
- Re: Queries that affect reports, Chaim
  - Re: Queries that affect reports, Kelly H
RE: Help with update query, KARL DEWEY
Re: Am I on the right track with taking data from one db and putting it into another, MGFoster
how do i just read a .pps message from somebody?, JIMBO44
- Re: how do i just read a .pps message from somebody?, Chaim
user entered data in a query, Darryl
- RE: user entered data in a query, KARL DEWEY
RE: Query that doesn't show all records from multiple tables/queri, KARL DEWEY
- RE: Query that doesn't show all records from multiple tables/queri, GaryDennis
Using a query to add new records to tables, duwardb
- Re: Using a query to add new records to tables, Chaim
  - Re: Using a query to add new records to tables, duwardb
Passing Variables from VBA to Access Queries, Drayton
Re: Insert a table form one database into another, John Vinson
Re: How can i get maximum number of QTY from Stock and Vendors Table?, Chaim
access 2003 zero fill field, NC Beach Bum
- Re: access 2003 zero fill field, Chaim
  - Re: access 2003 zero fill field, NC Beach Bum
EASY - Select from multiple tables, Vacation's Over
- Re: EASY - Select from multiple tables, John Vinson
  - Re: EASY - Select from multiple tables, Vacation's Over
  - Re: EASY - Select from multiple tables, Vacation's Over
Select Distinct Query that is editable, David
- Re: Select Distinct Query that is editable, MGFoster
  - Re: Select Distinct Query that is editable, David
Re: DATE() Prompts ME for date!, MsHlyl
Error Msg. External Table is not in the expected format, JD
RE: Importing query loses the table relationships, '69 Camaro
- RE: Importing query loses the table relationships, Doug F.
Simple Query Help, P B via AccessMonster.com
- Re: Simple Query Help, Chaim
  - Re: Simple Query Help, P B via AccessMonster.com
    - Re: Simple Query Help, Rich S.
    - Re: Simple Query Help, Chaim
delete query, Jose E via AccessMonster.com
- Re: delete query, John Spencer (MVP)
- <Possible follow-ups>
- Delete query, Nick
  - Re: Delete query, John Vinson
    - Re: Delete query, Nick
    - Re: Delete query, John Vinson
- Delete Query, neeraj
  - RE: Delete Query, S Panja
  - Re: Delete Query, Steve Schapel
    - Re: Delete Query, neeraj
- Delete query, Bob
- Re: Delete Query, Steve Schapel
  - Message not available
    - Message not available
    - Message not available
    - Re: Delete Query, SusanV
    - Message not available
    - Re: Delete Query, Steve Schapel
Not In statement, James K via AccessMonster.com
- Re: Not In statement, Duane Hookom
  - Re: Not In statement, Chaim
    - Re: Not In statement, James K via AccessMonster.com
    - Re: Not In statement, Chaim
How can I remove non-letters from words in Access?, Cainman
- Re: How can I remove non-letters from words in Access?, Matt Williamson
  - Re: How can I remove non-letters from words in Access?, Cainman
Re: pivot table, Duane Hookom
- <Possible follow-ups>
- Re: pivot table, AccessAddict
  - Re: pivot table, Duane Hookom
    - Re: pivot table, AccessAddict
    - Re: pivot table, Duane Hookom
    - Re: pivot table, AccessAddict
    - Re: pivot table, Duane Hookom
    - Re: pivot table, AccessAddict
    - Re: pivot table, AccessAddict
    - Re: pivot table, Duane Hookom
    - Re: pivot table, AccessAddict
    - Re: pivot table, AccessAddict
    - Re: pivot table, Duane Hookom
    - Re: pivot table, AccessAddict
    - Message not available
    - Re: pivot table, Duane Hookom
    - Message not available
    - Message not available
    - Re: pivot table, AccessAddict
How do I combine all datarecords in one field into another field, Mariana
- RE: How do I combine all datarecords in one field into another field, KARL DEWEY
  - RE: How do I combine all datarecords in one field into another fi, Mariana
    - Re: How do I combine all datarecords in one field into another fi, Duane Hookom
- Re: How do I combine all datarecords in one field into another field, John Vinson
  - Re: How do I combine all datarecords in one field into another fi, Lisa
    - Re: How do I combine all datarecords in one field into another fi, John Vinson
Accum & count selected fields in a record, Chuck
- Re: Accum & count selected fields in a record, MGFoster
- Re: Accum & count selected fields in a record, John Spencer (MVP)
Query help, Darryl
- Re: Query help, Chaim
Re: I am getting the error message "Query is too complex", Mardou
get rid of duplicate records, dlb1228
- Re: get rid of duplicate records, Nikos Yannacopoulos
Query Problem, Martin
- Re: Query Problem, Duane Hookom
RE: Take month from date field, JLS04
Re: QBE Column Name loses spaces, T Kirtley
- Re: QBE Column Name loses spaces, RuralGuy