microsoft.public.access.queries

• Thread Index

---

• Re: Comparing next in a sequence
  • From: Marshall Barton
• Re: Trouble subtracting dates??
  • From: Douglas J. Steele
• Re: Crosstab query error 3104
  • From: Douglas J. Steele
• Re: Crosstab query error 3104
  • From: ridders
• Re: Crosstab query error 3104
  • From: ridders
• RE: Trouble subtracting dates??
  • From: tcek
• Re: Comparing next in a sequence
  • From: Bibi
• Re: Urgent - Calendar - Need 7 days for week selected
  • From: John W . Vinson
• Re: Help needed re: parameter query
  • From: s.f.
• RE: Sum of Qty
  • From: Ken Sheridan
• Re: Count records in update query
  • From: Baz
• Re: Count records in update query
  • From: Baz
• Re: Count records in update query
  • From: Robert
• Re: Count records in update query
  • From: Robert
• Re: SQL
  • From: d
• Re: Comparing next in a sequence
  • From: Marshall Barton
• Re: Cannot Update
  • From: Baz
• Re: Cannot Update
  • From: SHIPP
• Re: Last of Date Query
  • From: Scottie
• Re: Cannot Update
  • From: Baz
• Re: Crosstab query error 3104
  • From: Douglas J. Steele
• Re: Crosstab query error 3104
  • From: Gary Walter
• Re: Crosstab query error 3104
  • From: ridders
• Re: Crosstab query error 3104
  • From: Gary Walter
• RE: Query leaving out some data
  • From: natira
• RE: Query leaving out some data
  • From: Jerry Whittle
• Query leaving out some data
  • From: natira
• Re: Count records in update query
  • From: Baz
• Re: Expression query
  • From: Jeff Boyce
• Re: Comparing next in a sequence
  • From: Bibi
• Re: Count records in update query
  • From: Nick Godfrey
• Re: Sum of Qty
  • From: Ron2006
• Count records in update query
  • From: Robert
• Re: Query just beeps when updating
  • From: Ron2006
• Re: Crosstab query error 3104
  • From: Gary Walter
• Re: Select/Append Query Malfunction
  • From: Baz
• Re: Sub-query, Union, Nested or what?
  • From: Baz
• Passing an expression from a table field to a query
  • From: mallettdj
• Select/Append Query Malfunction
  • From: tbrogdon
• Re: Comparing next in a sequence
  • From: Marshall Barton
• Re: Sub-query, Union, Nested or what?
  • From: Lee Hunter
• Re: Expression query
  • From: Adrian1962
• Re: make table query
  • From: John W . Vinson
• Re: Help needed re: parameter query
  • From: Allen Browne
• Re: Comparing next in a sequence
  • From: Bibi
• Re: can you reassign week numbers
  • From: Pat
• Re: SQL
  • From: John W . Vinson
• Re: Comparing next in a sequence
  • From: Marshall Barton
• Re: Last of Date Query
  • From: John Spencer
• Re: Sorting results Query
  • From: Steve
• Re: Sub-query, Union, Nested or what?
  • From: Baz
• Re: Query just beeps when updating
  • From: Jeanette Cunningham
• Re: Last of Date Query
  • From: Jeanette Cunningham
• Re: Query just beeps when updating
  • From: SHIPP
• Re: Query just beeps when updating
  • From: Jeanette Cunningham
• Re: Query just beeps when updating
  • From: SHIPP
• Re: Sorting results Query
  • From: Jeanette Cunningham
• RE: Sorting results Query
  • From: Steve
• Re: Query just beeps when updating
  • From: Jeanette Cunningham
• Re: Sub-query, Union, Nested or what?
  • From: Lee Hunter
• Re: Comparing next in a sequence
  • From: Bibi
• Re: Comparing next in a sequence
  • From: Marshall Barton
• Re: Sorting Crosstab Query Values
  • From: Allen Browne
• SQL
  • From: d
• Re: Comparing next in a sequence
  • From: Bibi
• Re: Comparing next in a sequence
  • From: Marshall Barton
• RE: pass parameter value to query
  • From: harleyken
• Re: Sorting Crosstab Query Values
  • From: Chad
• pass parameter value to query
  • From: harleyken
• Re: Query using Like
  • From: Jerry Whittle
• Re: Changing commission rate at a future date
  • From: ChuckW
• Re: Count with a condition
  • From: Jeff Boyce
• Re: Count with a condition
  • From: Douglas J. Steele
• Re: Sorting Crosstab Query Values
  • From: Allen Browne
• Re: Sub-query, Union, Nested or what?
  • From: Baz
• Re: query criteria
  • From: JamesDeckert
• Re: can you reassign week numbers
  • From: John W . Vinson
• Re: query not correct: between dates ?
  • From: Rick Stahl
• Re: query criteria
  • From: Allen Browne
• Re: can you reassign week numbers
  • From: Pat
• Re: Query using Like
  • From: mattc66 via AccessMonster.com
• Re: can you reassign week numbers
  • From: Jeff Boyce
• Re: can you reassign week numbers
  • From: Pat
• Re: Changing commission rate at a future date
  • From: Jeff Boyce
• Re: Query using Like
  • From: John W . Vinson
• RE: Subquery Parameters
  • From: Klatuu
• RE: Subquery Parameters
  • From: Erin Searfoss
• Re: Old Records
  • From: Douglas J. Steele
• RE: Subquery Parameters
  • From: Klatuu
• Re: column headings of days
  • From: Jeanette Cunningham
• RE: Subquery Parameters
  • From: Erin Searfoss
• Query using Like
  • From: mattc66 via AccessMonster.com
• Re: separate columns by numeric and letter values
  • From: Marshall Barton
• RE: Cross Tab
  • From: KARL DEWEY
• Re: separate columns by numeric and letter values
  • From: Mitchell_Collen via AccessMonster.com
• Re: separate columns by numeric and letter values
  • From: Marshall Barton
• can you reassign week numbers
  • From: Pat
• RE: Cross Tab
  • From: solsen via AccessMonster.com
• Re: Changing commission rate at a future date
  • From: ChuckW
• separate columns by numeric and letter values
  • From: Mitchell_Collen via AccessMonster.com
• RE: Newbie question, looking for earliest test record for each s/n
  • From: Jerry Whittle
• Re: Changing commission rate at a future date
  • From: Jeff Boyce
• RE: Newbie question, looking for earliest test record for each s/n
  • From: dan b in st. louis
• Re: Query works, query based on it fails.
  • From: Baz
• RE: Query works, query based on it fails.
  • From: KARL DEWEY
• RE: Cross Tab
  • From: KARL DEWEY
• Re: Combo Box to open report
  • From: Douglas J. Steele
• Re: Combo Box to open report
  • From: Douglas J. Steele
• Query works, query based on it fails.
  • From: Phil Smith
• Re: query not correct: between dates ?
  • From: George Nicholson
• Re: setting criteria for time values in select queries
  • From: RobV
• RE: if.. then.. else.. in a query
  • From: KARL DEWEY
• RE: if.. then.. else.. in a query
  • From: Kim K
• Re: setting criteria for time values in select queries
  • From: RobV
• Re: Runs Ok, EXPORT fails with:Cannot define Field more than once
  • From: Phil Smith
• RE: if.. then.. else.. in a query
  • From: Kim K
• Re: setting criteria for time values in select queries
  • From: Dale Fye
• RE: Cross Tab
  • From: solsen via AccessMonster.com
• RE: Urgent! Need CrossTab help...
  • From: Dale Fye
• RE: Newbie question, looking for earliest test record for each s/n
  • From: Dale Fye
• Re: Query Help Needed!
  • From: Dale Fye
• RE: if.. then.. else.. in a query
  • From: Kim K
• RE: if.. then.. else.. in a query
  • From: Dale Fye
• RE: Cross Tab
  • From: KARL DEWEY
• Re: Query Help Needed!
  • From: Golfinray
• Re: Query Help Needed!
  • From: Jeff Boyce
• Re: Combo Box to open report
  • From: Bhupinder Rayat
• RE: Urgent! Need CrossTab help...
  • From: KARL DEWEY
• RE: Newbie question, looking for earliest test record for each s/n
  • From: dan b in st. louis
• RE: Newbie question, looking for earliest test record for each s/n
  • From: Klatuu
• Re: setting criteria for time values in select queries
  • From: Marshall Barton
• Test3
  • From: DS
• RE: Newbie question, looking for earliest test record for each s/n
  • From: dan b in st. louis
• Test 3
  • From: DS
• Test2
  • From: DS
• Test
  • From: DS
• RE: Cross Tab
  • From: solsen via AccessMonster.com
• Re: Sub-query, Union, Nested or what?
  • From: John Spencer
• Re: Combo Box to open report
  • From: Douglas J. Steele
• Re: Expression query
  • From: Jeff Boyce
• Re: Sub-query, Union, Nested or what?
  • From: Jeff Boyce
• Re: Sub-query, Union, Nested or what?
  • From: Baz
• Re: compare two tables
  • From: John W . Vinson
• Re: Update Query with Yes/No
  • From: John Spencer
• Re: Expression query
  • From: John Spencer
• Re: query not correct: between dates ?
  • From: Rick Stahl
• Re: Adding totals in Query
  • From: Gonzalo
• RE: Assigning a number to a date range
  • From: KARL DEWEY
• Re: Running sum by contract nbr and Date
  • From: Jeff Boyce
• Re: query not correct: between dates ?
  • From: John W . Vinson
• Cross Tab
  • From: solsen
• Re: highlighting text box if...
  • From: Minton M
• Re: Adding totals in Query
  • From: Minton M
• Re: highlighting text box if...
  • From: Rick Brandt
• Re: highlighting text box if...
  • From: spcscooter via AccessMonster.com
• highlighting text box if...
  • From: spcscooter via AccessMonster.com
• RE: Assigning a number to a date range
  • From: ChuckW
• Re: column headings of days
  • From: Jeanette Cunningham
• query not correct: between dates ?
  • From: Rick Stahl
• Re: Sort/Odering on field in a UNION Qruery
  • From: John W . Vinson
• Re: Sort/Odering on field in a UNION Qruery
  • From: Steve Stad
• Re: Collating text files
  • From: John W . Vinson
• Re: Check boxes in forms to call a query
  • From: John W . Vinson
• Re: How do I disable 'Enter Parameter Value' prompt on an existing Que
  • From: Marshall Barton
• Re: Sort/Odering on field in a UNION Qruery
  • From: Marshall Barton
• Re: Sort/Odering on field in a UNION Qruery
  • From: Douglas J. Steele
• Re: How do I disable 'Enter Parameter Value' prompt on an existing Que
  • From: Jeff Boyce
• Re: Count records utilizing Where clause
  • From: REGREGL
• Re: Sort/Odering on field in a UNION Qruery
  • From: John W . Vinson
• Re: Query
  • From: John W . Vinson
• Re: Sort/Odering on field in a UNION Qruery
  • From: Steve Stad
• Re: Check boxes in forms to call a query
  • From: Senthil
• Re: Collating text files
  • From: Senthil
• Re: Sort/Odering on field in a UNION Qruery
  • From: Marshall Barton
• Re: Count records utilizing Where clause
  • From: Marshall Barton
• Re: Summing daily values by calendar month
  • From: Adrian1962
• Re: Count records utilizing Where clause
  • From: REGREGL
• RE: "invalid operation" in query
  • From: Jerry Whittle
• RE: Multiple records showing when Multiples do not exist
  • From: Jerry Whittle
• Re: Convert "Date Format" and into "Text"
  • From: Douglas J. Steele
• Re: qry return no results in given field
  • From: Rick Stahl
• Re: Summing daily values by calendar month
  • From: Adrian1962
• Re: Summing daily values by calendar month
  • From: John W . Vinson
• Re: Unintended field "expression 1006" in the query grids
  • From: John W . Vinson
• Re: Query
  • From: Jeanette Cunningham
• Re: qry return no results in given field
  • From: John W . Vinson
• Re: Unintended field "expression 1006" in the query grids
  • From: Jeanette Cunningham
• Re: Summing multiple checkboxes
  • From: Robbie Doo
• qry return no results in given field
  • From: Rick Stahl
• Re: Summing multiple checkboxes
  • From: Allen Browne
• Re: sum of union queries
  • From: Rick Stahl
• RE: Sorting results Query
  • From: Steve
• Re: setting criteria for time value search in select queries
  • From: Allen Browne
• Re: Adding totals by group
  • From: John W . Vinson
• Re: Reusing Union Query with different variable values
  • From: John W . Vinson
• RE: No duplicates in 2 columns
  • From: KARL DEWEY
• Re: No duplicates in 2 columns
  • From: Tom Lake
• No duplicates in 2 columns
  • From: Weezie1383
• Re: FromDate - ToDate
  • From: John W . Vinson
• Re: Count records utilizing Where clause
  • From: Marshall Barton
• Re: presence/absense matrix
  • From: E.Hobson
• Re: FromDate - ToDate
  • From: Chad
• Re: Help in removing information from description
  • From: John W . Vinson
• Re: Count records utilizing Where clause
  • From: REGREGL
• Re: Reusing Union Query with different variable values
  • From: John W . Vinson
• Help in removing information from description
  • From: mattc66 via AccessMonster.com
• Re: Count records utilizing Where clause
  • From: Marshall Barton
• Re: Sintaxis of CONVERT function in MS ACCESS
  • From: John W . Vinson
• Re: FromDate - ToDate
  • From: John W . Vinson
• Re: Reusing Union Query with different variable values
  • From: John W . Vinson
• RE: Query Problem Help!
  • From: Jerry Whittle
• Count records utilizing Where clause
  • From: REGREGL
• RE: Reusing Union Query with different variable values
  • From: Steve Stad
• RE: Viewing data based on criteria
  • From: brownti via AccessMonster.com
• RE: Query Problem Help!
  • From: Golfinray
• RE: Query Problem Help!
  • From: KARL DEWEY
• RE: Multiple records showing when Multiples do not exist
  • From: Nick
• RE: Reusing Union Query with different variable values
  • From: KARL DEWEY
• Query Problem Help!
  • From: Golfinray
• Sub Total
  • From: vikram_singh
• RE: Viewing data based on criteria
  • From: brownti via AccessMonster.com
• RE: Sorting results Query
  • From: KARL DEWEY
• RE: "invalid operation" in query
  • From: JoanneB
• Re: Disappearing SQL Code
  • From: Jerry Whittle
• Re: Late Binding
  • From: tmort
• Re: delete only 1 instance of each record that has more than 1 exa
  • From: efandango
• Re: syntax error with multiple inner join query - Access 2003
  • From: pgcn
• Re: Disappearing SQL Code
  • From: bgetson
• RE: Disappearing SQL Code
  • From: Steve Sanford
• Disappearing SQL Code
  • From: bgetson
• Re: Simple calculated field problem
  • From: Allen Browne
• Re: Date Count Help
  • From: Allen Browne
• Simple calculated field problem
  • From: Caroline Brown
• Re: Date Count Help
  • From: Cy
• Re: Date Count Help
  • From: Allen Browne
• Date Count Help
  • From: Cy
• Re: table not getting updated
  • From: KKruz
• Re: Remove Redundancy in joined tables
  • From: Ken Sheridan
• Re: Collating text files
  • From: John W . Vinson
• Re: Message of the day pop-up?
  • From: A Paid Observer
• Collating text files
  • From: Senthil
• Re: Export text with current date
  • From: Jeanette Cunningham
• RE: Check boxes in forms to call a query
  • From: Senthil
• Re: Check boxes in forms to call a query
  • From: Senthil
• Re: calcluating a value if the original value meets a condition
  • From: Allen Browne
• Re: delete only 1 instance of each record that has more than 1 example
  • From: tina
• Re: Check boxes in forms to call a query
  • From: John W . Vinson
• RE: Check boxes in forms to call a query
  • From: Klatuu
• Re: Check boxes in forms to call a query
  • From: tina
• delete only 1 instance of each record that has more than 1 example
  • From: efandango
• Execute As
  • From: Matt Vandermolen
• RE: Multiple records showing when Multiples do not exist
  • From: Jerry Whittle
• Re: Query not displaying correct column from a field
  • From: thorpk@xxxxxxxxx
• Re: Delete table values automatically
  • From: John Spencer
• Re: Simple Select Query
  • From: THINKINGWAY
• Re: Remove Redundancy in joined tables
  • From: AccBeginner
• Re: Changing the search field
  • From: Nick Heath
• Re: Remove Redundancy in joined tables
  • From: Rick Brandt
• Re: Changing the search field
  • From: Rick Brandt
• Re: Remove Redundancy in joined tables
  • From: AccBeginner
• Re: Remove Redundancy in joined tables
  • From: Baz
• Re: Remove Redundancy in joined tables
  • From: Rick Brandt
• Re: sum of union queries
  • From: Douglas J. Steele
• Re: syntax error with multiple inner join query - Access 2003
  • From: Douglas J. Steele
• Re: Delete table values automatically
  • From: Jeanette Cunningham
• Re: How do I count the number of "yes" boxes?
  • From: Jeanette Cunningham
• Re: Delete table values automatically
  • From: Lp12
• Re: Delete table values automatically
  • From: Jeanette Cunningham
• Re: Delete table values automatically
  • From: Lp12
• Re: Updating info from a form with query
  • From: Jeanette Cunningham
• Re: Delete table values automatically
  • From: Jeanette Cunningham
• returning only a selected number of records
  • From: Anthony
• Re: parameter quesy
  • From: Allen Browne
• Re: sum of union queries
  • From: Rick Stahl
• Re: presence/absense matrix
  • From: John Spencer
• Re: parameter query
  • From: Allen Browne
• Re: syntax error with multiple inner join query - Access 2003
  • From: pgcn
• Re: multiply a certain field in all query by same value
  • From: Ken Snell \(MVP\)
• Re: Select TOP 4 Records For Each Group
  • From: David W. Fenton
• Re: table not getting updated
  • From: Rick Brandt
• Re: table not getting updated
  • From: Rick Brandt
• Re: multiply a certain field in all query by same value
  • From: Ken Snell \(MVP\)
• Re: presence/absense matrix
  • From: E.Hobson
• Re: syntax error with multiple inner join query - Access 2003
  • From: Douglas J. Steele
• Re: Select TOP 4 Records For Each Group
  • From: Allen Browne
• Re: SELECT query as subquery to APPEND
  • From: tbrogdon
• Re: New Question
  • From: David W. Fenton
• Re: Select TOP 4 Records For Each Group
  • From: David W. Fenton
• Re: first record query
  • From: John W . Vinson
• Re: How do I count the number of "yes" boxes?
  • From: Jeanette Cunningham
• Re: How do I count the number of "yes" boxes?
  • From: tina
• Re: Runs Ok, EXPORT fails with:Cannot define Field more than once
  • From: Gary Walter
• Re: Count how many days ?
  • From: Dale Fye
• Re: Numbering Raws
  • From: Dale Fye
• RE: Ranking Scores in a Query
  • From: Steve S
• Re: sum of union queries
  • From: John Spencer
• RE: Access Append Query to update Sequence Generator in Oracle
  • From: Jim
• Re: first record query
  • From: jon
• Re: Runs Ok, EXPORT fails with:Cannot define Field more than once
  • From: John Spencer
• Re: presence/absense matrix
  • From: John Spencer
• Re: Count how many days ?
  • From: SpookiePower
• Re: Select TOP 4 Records For Each Group
  • From: Tirelle
• sum of union queries
  • From: Rick Stahl
• Re: Select TOP 4 Records For Each Group
  • From: Allen Browne
• Re: New Question
  • From: Allen Browne
• Re: Expression Problem in Form
  • From: Jeanette Cunningham
• Re: first record query
  • From: John W . Vinson
• Expression Problem in Form
  • From: legal_eagle_01
• Re: Select TOP 4 Records For Each Group
  • From: Tirelle
• New Question
  • From: Tirelle
• Thank Allen!!!
  • From: Tirelle
• Re: Select TOP 4 Records For Each Group
  • From: Tirelle
• Re: Select TOP 4 Records For Each Group
  • From: Allen Browne
• Re: Select TOP 4 Records For Each Group
  • From: Tirelle
• Re: Select TOP 4 Records For Each Group
  • From: Allen Browne
• Re: Runs Ok, EXPORT fails with:Cannot define Field more than once
  • From: Jeanette Cunningham
• RE: Access Append Query to update Sequence Generator in Oracle
  • From: Jerry Whittle
• Re: Runs Ok, EXPORT fails with:Cannot define Field more than once
  • From: Jeanette Cunningham
• Re: Query not displaying correct column from a field
  • From: Jerry Whittle
• Re: Runs Ok, EXPORT fails with:Cannot define Field more than once
  • From: Phil Smith
• Re: Runs Ok, EXPORT fails with:Cannot define Field more than once
  • From: Jeanette Cunningham
• Runs Ok, EXPORT fails with:Cannot define Field more than once
  • From: Phil Smith
• presence/absense matrix
  • From: E.Hobson
• Re: Simple Select Query
  • From: Jeff Boyce
• Re: Simple Select Query
  • From: John Spencer
• Re: date mismatch in query..do not know how to solve
  • From: Marshall Barton
• Re: even or odd records
  • From: Marshall Barton
• Re: Count how many days ?
  • From: John Spencer
• Re: date mismatch in query..do not know how to solve
  • From: John W . Vinson
• Re: even or odd records
  • From: fredg
• Viewing data based on criteria
  • From: brownti via AccessMonster.com
• even or odd records
  • From: Jeff Klein
• Re: Simple Select Query
  • From: THINKINGWAY
• RE: Access Append Query to update Sequence Generator in Oracle
  • From: Jim
• Re: first record query
  • From: jon
• Re: Query not displaying correct column from a field
  • From: thorpk@xxxxxxxxx
• Re: Changing Numbers to Text in a query
  • From: Jeff Boyce
• RE: Access Append Query to update Sequence Generator in Oracle
  • From: Jim
• RE: Access Append Query to update Sequence Generator in Oracle
  • From: Jerry Whittle
• Re: Changing Numbers to Text in a query
  • From: MacNut2004
• RE: Access Append Query to update Sequence Generator in Oracle
  • From: Jim
• Re: Simple Select Query
  • From: Jeff Boyce
• Re: Changing Numbers to Text in a query
  • From: Jeff Boyce
• RE: Access Append Query to update Sequence Generator in Oracle
  • From: Jerry Whittle
• Re: Changing Numbers to Text in a query
  • From: MacNut2004
• Re: Changing Numbers to Text in a query
  • From: KARL DEWEY
• Re: Changing Numbers to Text in a query
  • From: John W . Vinson
• RE: Access Append Query to update Sequence Generator in Oracle
  • From: Jim
• Re: Late Binding
  • From: tmort
• Re: Changing Numbers to Text in a query
  • From: Jeff Boyce
• Re: Changing Numbers to Text in a query
  • From: MacNut2004
• Re: Changing Numbers to Text in a query
  • From: Jeff Boyce
• Re: Late Binding
  • From: Tom Wickerath
• Re: Query not dislaying correct column of a field
  • From: John W . Vinson
• Re: first record query
  • From: John W . Vinson
• Re: max autonum multi-user environment
  • From: NJS
• RE: Count how many days ?
  • From: Dale Fye
• Re: Late Binding
  • From: tmort
• RE: SELECT query as subquery to APPEND
  • From: Dale Fye
• Re: Changing Numbers to Text in a query
  • From: Jeff Boyce
• Re: Late Binding
  • From: tmort
• Re: Query not displaying correct column from a field
  • From: thorpk@xxxxxxxxx
• Re: Query, between, Null, IF, And .........UGH
  • From: Allen Browne
• RE: Help with update query UDF
  • From: KARL DEWEY
• Query not displaying correct column from a field
  • From: thorpk@xxxxxxxxx
• Query not dislaying correct column of a field
  • From: thorpk@xxxxxxxxx
• Re: Query, between, Null, IF, And .........UGH
  • From: scubadiver
• Re: Query, between, Null, IF, And .........UGH
  • From: Allen Browne
• Re: Count how many days ?
  • From: SpookiePower
• SELECT query as subquery to APPEND
  • From: tbrogdon
• Count how many days ?
  • From: SpookiePower
• Re: Sorting hell
  • From: Gary Walter
• Re: max autonum multi-user environment
  • From: Jamie Collins
• Re: Sorting hell
  • From: Gary Walter
• RE: Numbering Raws
  • From: doughnut
• Re: Numbering Raws
  • From: doughnut
• Re: first record query
  • From: jon
• Re: first record query
  • From: John W . Vinson
• Re: New table from 2 existing tables
  • From: John W . Vinson
• Re: New table from 2 existing tables
  • From: Jeanette Cunningham
• Re: New table from 2 existing tables
  • From: Paul Wilson
• Re: calculate null text field
  • From: Allen Browne
• Re: calculate null text field
  • From: HL
• first record query
  • From: jon
• Re: New table from 2 existing tables
  • From: Jeanette Cunningham
• Help with update query UDF
  • From: Craigbob
• Re: New table from 2 existing tables
  • From: John W . Vinson
• Re: To Record in Form View from Query
  • From: John W . Vinson
• Re: To Record in Form View from Query
  • From: Jeanette Cunningham
• Re: To Record in Form View from Query
  • From: Jeanette Cunningham
• Re: To Record in Form View from Query
  • From: Jeanette Cunningham
• Re: Count Question
  • From: John Spencer
• Re: Nz function not working!
  • From: Rick Brandt
• Re: Count Question
  • From: Jeff Boyce
• Re: Count Question
  • From: NeonSky via AccessMonster.com
• Re: Count Question
  • From: NeonSky via AccessMonster.com
• Re: Number fields being converted to text
  • From: Dale Fye
• Re: Count Question
  • From: Marshall Barton
• Re: Count Question
  • From: NeonSky via AccessMonster.com
• Re: Nz function not working!
  • From: gregatvrm
• Re: Count Question
  • From: Jeff Boyce
• Re: Count Question
  • From: NeonSky via AccessMonster.com
• Re: Count Question
  • From: Jeff Boyce
• Sorting hell
  • From: Phil Hellmuth
• Count Question
  • From: NeonSky via AccessMonster.com
• RE: Complex Query question - using distant related criteria
  • From: KARL DEWEY
• Re: Late Binding
  • From: Douglas J. Steele
• Re: Nz function not working!
  • From: Klatuu
• Re: Nz function not working!
  • From: gregatvrm
• Re: Nz function not working!
  • From: Klatuu
• Re: Nz function not working!
  • From: gregatvrm
• RE: Number fields being converted to text
  • From: PatrickM
• Re: Nz function not working!
  • From: Klatuu
• RE: Number fields being converted to text
  • From: KARL DEWEY
• Re: Nz function not working!
  • From: Jeanette Cunningham
• Re: Late Binding
  • From: tmort
• RE: Number fields being converted to text
  • From: PatrickM
• Re: Late Binding
  • From: Douglas J. Steele
• Re: Late Binding
  • From: Douglas J. Steele
• Re: returning dates in a query
  • From: Stan
• Re: Numbering Raws
  • From: John W . Vinson
• RE: Assigning a number to a date range
  • From: KARL DEWEY
• Re: max autonum multi-user environment
  • From: NJS
• RE: Late Binding
  • From: Tom Wickerath
• Annoying Access 2003 Query bug. Fix available?
  • From: OceanView
• RE: Subtracting values in a query
  • From: KARL DEWEY
• RE: Setting a Parameter for multiple fields
  • From: Duane Hookom
• Re: Using Code to build criteria
  • From: FBxiii
• RE: Option Menu for queries
  • From: Klatuu
• RE: Late Binding
  • From: tmort
• Odd issue linking to View
  • From: Matt Williamson
• Re: Using Code to build criteria
  • From: Klatuu
• Re: Using Code to build criteria
  • From: FBxiii
• Option Menu for queries
  • From: misschanda via AccessMonster.com
• RE: Setting a Parameter for multiple fields
  • From: erica573583
• Re: Consecutive Date Query
  • From: NeonSky via AccessMonster.com
• Re: Data From oracle stored procedure
  • From: Peter Doering
• Re: Using Code to build criteria
  • From: Klatuu
• Re: Using Code to build criteria
  • From: FBxiii
• Re: Selected Criteria or All
  • From: FBxiii
• RE: Late Binding
  • From: Klatuu
• Re: Undefined function “Right” in expression
  • From: Allen Browne
• Re: returning dates in a query
  • From: John Spencer
• RE: Late Binding
  • From: tmort
• Re: Can an update query be used to update/produce a query?
  • From: Pat
• Re: Calculation query, how to avoid extreme values?
  • From: John Spencer
• Re: Using Code to build criteria
  • From: Ofer Cohen
• Re: Find Missing Numbers in a Sequence
  • From: John Spencer
• Re: Can an update query be used to update/produce a query?
  • From: John Spencer
• Re: Selected Criteria or All
  • From: John Spencer
• Re: calculate null text field
  • From: John Spencer
• Re: Unwanted info in query
  • From: John Spencer
• Re: Unwanted info in query
  • From: Rhianne
• Re: Late Binding
  • From: Douglas J. Steele
• Re: Using Code to build criteria
  • From: Jeanette Cunningham
• Re: Using Code to build criteria
  • From: FBxiii
• Re: Using Code to build criteria
  • From: Jeanette Cunningham
• Re: Selected Criteria or All
  • From: FBxiii
• Re: calculate null text field
  • From: Allen Browne
• Re: Calculation query, how to avoid extreme values?
  • From: Stefan Hoffmann
• Re: calculate null text field
  • From: HL
• RE: Late Binding
  • From: Tom Wickerath
• Re: Append query with "if" on possible missing field.
  • From: Jeanette Cunningham
• Re: Append query with "if" on possible missing field.
  • From: Jeanette Cunningham
• Re: Show "Form1" everytime i open MS Access automatically.
  • From: fredg
• RE: Joined table: Returns duplicated record
  • From: ali
• Re: Grouping and counting
  • From: Joe Parsons
• RE: Joined table: Returns duplicated record
  • From: Duane Hookom
• Re: Grouping and counting
  • From: Allen Browne
• Re: Sum of Descriptions Query
  • From: Jeanette Cunningham
• RE: Joined table: Returns duplicated record
  • From: ali
• Grouping and counting
  • From: joe
• Re: Consecutive Date Query
  • From: Michel Walsh
• Re: How to set up relationship query for minerals database - continued
  • From: Jeanette Cunningham
• Re: Find Missing Numbers in a Sequence
  • From: Allen Browne
• Follow up to earlier Select Query Question
  • From: jndickin
• Re: Consecutive Date Query
  • From: NeonSky via AccessMonster.com
• Re: Consecutive Date Query
  • From: Michel Walsh
• Re: Consecutive Date Query
  • From: NeonSky via AccessMonster.com
• Re: Remove Specific Text/Character in Specific Place
  • From: Gary Dolliver
• Select, Modify, and Append Question
  • From: tbrogdon
• RE: Breaking out sales data
  • From: KARL DEWEY
• Re: Queries won't save in landscape
  • From: CW
• Re: Total count of multiple fields?... Is that possible?
  • From: TomP
• Re: Complex Query ?
  • From: Michel Walsh
• Re: Can field names be changed with a query?
  • From: John W . Vinson
• How to set up relationship query for minerals database - continued
  • From: Neville MADDEN
• Re: Complex Query ?
  • From: Sean
• Re: Consecutive Date Query
  • From: Michel Walsh
• Re: Complex Query ?
  • From: Michel Walsh
• Re: Can an update query be used to update/produce a query?
  • From: Pat
• Re: Complex Query ?
  • From: Sean
• Re: query counting issue
  • From: den1jxt via AccessMonster.com
• RE: query counting issue
  • From: den1jxt via AccessMonster.com
• Re: Consecutive Date Query
  • From: NeonSky via AccessMonster.com
• Re: Complex Query ?
  • From: Michel Walsh
• Re: Can an update query be used to update/produce a query?
  • From: John Spencer
• Re: Can an update query be used to update/produce a query?
  • From: Pat
• Re: create a query that provides a drop down list to choose from
  • From: Dabears70
• Re: Can an update query be used to update/produce a query?
  • From: Pat
• Re: Crosstab - Null to Zero
  • From: Michel Walsh
• Re: Queries won't save in landscape
  • From: fredg
• Re: Help creating updateable query
  • From: John W . Vinson
• RE: Crosstab - Null to Zero
  • From: KARL DEWEY
• Crosstab - Null to Zero
  • From: learning_codes@xxxxxxxxxxx
• Re: Total count of multiple fields?... Is that possible?
  • From: Michel Walsh
• Re: Consecutive Date Query
  • From: Michel Walsh
• Re: Queries won't save in landscape
  • From: Roger Carlson
• Re: Between [start date] and [end date]
  • From: Jeff Boyce
• Re: Show <> Records Between 2 Tables ?? (ANTI-Join)
  • From: John Spencer
• Re: Show <> Records Between 2 Tables ?? (ANTI-Join)
  • From: Roger Carlson
• Re: Can an update query be used to update/produce a query?
  • From: John Spencer
• Re: Selected Criteria or All
  • From: John Spencer
• Show <> Records Between 2 Tables ?? (ANTI-Join)
  • From: kev100 via AccessMonster.com
• Re: Consecutive Date Query
  • From: NeonSky via AccessMonster.com
• RE: Massive Summary of data
  • From: DawnTreader
• Re: Total count of multiple fields?... Is that possible?
  • From: TomP
• Re: date format conversion
  • From: Michel Walsh
• Re: Query and auto fill
  • From: Esaw
• RE: Breaking out sales data
  • From: KARL DEWEY
• Re: Help creating updateable query
  • From: John Spencer
• Re: USING (LIKE) IN A QUERY
  • From: Michel Walsh
• Re: Total count of multiple fields?... Is that possible?
  • From: KARL DEWEY
• Re: Delete record if a matching record is present in another table
  • From: Kiwi_731
• Re: Group By Query - Sum
  • From: Michel Walsh
• Re: Unwanted info in query
  • From: John Spencer
• RE: Joined table: Returns duplicated record
  • From: Duane Hookom
• Re: Help creating updateable query
  • From: jsccorps
• Re: Consecutive Date Query
  • From: Michel Walsh
• Re: Unwanted info in query
  • From: Rhianne
• Re: Lost decimal precision for single and double number format-Acc
  • From: Pat
• RE: Breaking out sales data
  • From: Fanew3
• Re: Cross Tab Line Numbers
  • From: John Spencer
• Re: Delete record if a matching record is present in another table
  • From: John Spencer
• Re: Wildcard code for a query
  • From: Allen Browne
• Re: Total count of multiple fields?... Is that possible?
  • From: Michel Walsh
• Wildcard code for a query
  • From: nybaseball22@xxxxxxxxx
• Re: Unwanted info in query
  • From: John Spencer
• Re: Question regarding IIf
  • From: John Spencer
• Re: Query - auto fill "between values"?
  • From: John Spencer
• Re: Query - auto fill "between values"?
  • From: Mikael Lindqvist
• Re: Unwanted info in query
  • From: Rhianne
• Re: Query - auto fill "between values"?
  • From: John Spencer
• Re: Subject: How to set up relationship query for minerals database - continued
  • From: John Spencer
• Re: Total count of multiple fields?... Is that possible?
  • From: TomP
• Re: Between [start date] and [end date]
  • From: John Spencer
• Re: Cross Tab Line Numbers
  • From: John Spencer
• Re: Question regarding IIf
  • From: Allen Browne
• Re: max autonum multi-user environment
  • From: Jamie Collins
• Re: Stop all macros - not stopping all macros!
  • From: Allen Browne
• Re: Checked box as Criteria
  • From: Allen Browne
• Re: calculate null text field
  • From: Allen Browne
• Subject: How to set up relationship query for minerals database - continued
  • From: Neville MADDEN
• Re: IsError not working
  • From: david
• IsError not working
  • From: vikram_singh
• Re: Query and auto fill
  • From: Jeanette Cunningham
• Re: Query and auto fill
  • From: Jeanette Cunningham
• Re: UNION query changes results after close and reopen
  • From: Jeanette Cunningham
• Re: Group By Query - Sum
  • From: raskew via AccessMonster.com
• Re: Date diff excluding weekends
  • From: raskew via AccessMonster.com
• timestamp grouped as time interval
  • From: buattis
• Re: Help creating updateable query
  • From: John W . Vinson
• Re: Lost decimal precision for single and double number format-Access2
  • From: John W . Vinson
• Re: Cross Tab Query
  • From: Rey
• Re: Consecutive Date Query
  • From: NeonSky via AccessMonster.com
• Re: Cross Tab Query
  • From: KARL DEWEY
• Re: Between [start date] and [end date]
  • From: spcscooter via AccessMonster.com
• RE: Between [start date] and [end date]
  • From: spcscooter via AccessMonster.com
• Re: Cross Tab Query
  • From: Rey
• Re: Between [start date] and [end date]
  • From: Jeff Boyce
• Re: Change Date Format
  • From: Jeff Boyce
• Between [start date] and [end date]
  • From: spcscooter via AccessMonster.com
• Cross Tab Query
  • From: Rey
• RE: Breaking out sales data
  • From: KARL DEWEY
• Re: Select Query Question Continued
  • From: jndickin
• Re: Ranking Scores in a Query
  • From: Michel Walsh
• Re: Remove Specific Text/Character in Specific Place
  • From: John Nurick
• Re: Total count of multiple fields?... Is that possible?
  • From: Michel Walsh
• Re: query counting issue
  • From: Jeanette Cunningham
• Re: Blank fields
  • From: Jeff Boyce
• Re: Remove Specific Text/Character in Specific Place
  • From: Marshall Barton
• Re: How do I number records in an Access Query?
  • From: Hile
• Re: How do I number records in an Access Query?
  • From: John Spencer
• Re: Due date query
  • From: Melissa
• Breaking out sales data
  • From: Fanew3
• query counting issue
  • From: den1jxt
• RE: Late Binding
  • From: Klatuu
• RE: Help creating updateable query
  • From: Klatuu
• RE: Ranking Scores in a Query
  • From: Dale Fye
• Re: Ranking Scores in a Query
  • From: Marshall Barton
• Re: Lost decimal precision for single and double number format-Access2
  • From: John Spencer
• Re: How do I number records in an Access Query?
  • From: Hile
• Re: Concatenate only if there is something to concatenate
  • From: David W. Fenton
• Re: Total count of multiple fields?... Is that possible?
  • From: TomP
• Re: Blank fields
  • From: Martin
• Re: Blank fields
  • From: Jeff Boyce
• Re: Parameter Using InStr Function
  • From: croy
• Late Binding
  • From: tmort
• Re: Parameter Using InStr Function
  • From: John W . Vinson
• Re: Unwanted info in query
  • From: John Spencer
• Re: Subquery Help?
  • From: Dale Fye
• Re: Total count of multiple fields?... Is that possible?
  • From: Michel Walsh
• Re: Matching fields between 3 tables
  • From: Michel Walsh
• Re: Query and Count no records Want a Zero
  • From: Michel Walsh
• Re: Can I use a Report expression for queries?
  • From: Robbie Doo
• Re: max autonum multi-user environment
  • From: Michel Walsh
• Re: How to select distinct combinations of 2 fields that can be th
  • From: KARL DEWEY
• Re: max autonum multi-user environment
  • From: Michel Walsh
• Re: Parameter Using InStr Function
  • From: croy
• Re: Parameter Using InStr Function
  • From: croy
• Re: Unwanted info in query
  • From: Rhianne
• Re: Unwanted info in query
  • From: John Spencer
• Re: Combining Queries
  • From: Ron2006
• RE: If Statement Pay rate based on efficiency
  • From: Dale Fye
• Re: Subquery Help?
  • From: Jay
• RE: How to make a query like this ?
  • From: Dale Fye
• Re: Append to Table with Auto Number
  • From: Jeff Boyce
• RE: Subquery Help?
  • From: Dale Fye
• Re: Append to Table with Auto Number
  • From: Bill
• Append to Table with Auto Number
  • From: Bill
• Re: Can I use a Report expression for queries?
  • From: John Spencer
• Re: Unwanted info in query
  • From: Rhianne
• Subquery Help?
  • From: Jay
• Re: How to select distinct combinations of 2 fields that can be th
  • From: John Spencer
• Re: Unwanted info in query
  • From: John Spencer
• Re: Datepart function is it the right solution???
  • From: Moon Walker
• Re: How to make a query like this ?
  • From: Allen Browne
• Re: multiply a certain field in all query by same value
  • From: Pedro
• Re: substracting in query
  • From: Stefan Hoffmann
• Weekly Overtime into Months
  • From: neil_val
• Re: Unwanted info in query
  • From: Rhianne
• Re: Parameter Using InStr Function
  • From: Jamie Collins
• Re: max autonum multi-user environment
  • From: Jamie Collins
• substracting in query
  • From: peljo via AccessMonster.com
• Re: Invalid use of Null
  • From: vikram_singh
• Re: Combining Queries
  • From: John W . Vinson
• Re: Combining Queries
  • From: Rem
• Re: Combining Queries
  • From: Ken Snell \(MVP\)
• Re: select query
  • From: G venkatesh
• Re: Can I use a Report expression for queries?
  • From: Allen Browne
• Re: If Statement Pay rate based on efficiency
  • From: John W . Vinson
• Re: Select Query Question
  • From: John W . Vinson
• Re: If Statement Pay rate based on efficiency
  • From: Marshall Barton
• Re: Concatenate only if there is something to concatenate
  • From: bhrosey via AccessMonster.com
• Re: Concatenate only if there is something to concatenate
  • From: bhrosey via AccessMonster.com
• Re: If Statement Pay rate based on efficiency
  • From: Ken Snell \(MVP\)
• RE: Select Query Question
  • From: KARL DEWEY
• RE: How to select distinct combinations of 2 fields that can be th
  • From: KARL DEWEY
• RE: Use query results to copy files?
  • From: Gary
• Re: multiply a certain field in all query by same value
  • From: Ken Snell \(MVP\)
• Re: Parameter Using InStr Function
  • From: John W . Vinson
• RE: Date Expressions & Calculations
  • From: Vylent Fyre
• Re: Due date query
  • From: John Spencer
• RE: How to select distinct combinations of 2 fields that can be th
  • From: agarten
• Select Query Question
  • From: jndickin
• RE: Date Expressions & Calculations
  • From: Vylent Fyre
• Re: Parameter Using InStr Function
  • From: croy
• Re: Parameter Using InStr Function
  • From: croy
• Re: Counting records with Values
  • From: Douglas J. Steele
• RE: Parameter Using InStr Function
  • From: Dale Fye
• Re: Invalid use of Null
  • From: Michel Walsh
• RE: Date Expressions & Calculations
  • From: Dale Fye
• Re: max autonum multi-user environment
  • From: Michel Walsh
• Re: Due date query
  • From: Melissa
• Re: Parameter Using InStr Function
  • From: John W . Vinson
• How to set up relationship query for minerals database
  • From: Neville MADDEN
• Re: How to set up relationship query for minerals database
  • From: John Spencer
• RE: How to set up relationship query for minerals database
  • From: Jerry Whittle
• Re: Macro to grab email address and open Outlook
  • From: duncanjx
• Re: max autonum multi-user environment
  • From: NJS
• Re: count number
  • From: Jeff Boyce
• Re: max autonum multi-user environment
  • From: Michel Walsh
• RE: Multiple word search Parameter Query
  • From: Iram
• count number
  • From: Jeff Klein
• RE: Multiple word search Parameter Query
  • From: KARL DEWEY
• RE: How to add multiples records from a querie
  • From: KARL DEWEY
• RE: Multiple word search Parameter Query
  • From: Iram
• Re: Need to sort several different fields together - Alphabeticall
  • From: Jannette
• Re: select query
  • From: John Spencer
• Re: Select Query acting like an Update Query
  • From: John Spencer
• Date Expressions & Calculations
  • From: Vylent Fyre
• Re: Select Query acting like an Update Query
  • From: John W . Vinson
• Re: Need to sort several different fields together - Alphabetically
  • From: John Spencer
• Parameter Using InStr Function
  • From: croy
• Re: Select Query acting like an Update Query
  • From: Ron2006
• Re: Unwanted info in query
  • From: John Spencer
• RE: If statement not displaying text if conditions not met
  • From: Ofer Cohen
• Re: Append/Update
  • From: Ron2006
• RE: Macro to grab email address and open Outlook
  • From: Dale Fye
• Re: multiply a certain field in all query by same value
  • From: Pedro
• Re: Ordering results, not as simple as it sounds
  • From: Joe
• Re: Counting records with Values
  • From: Michel Walsh
• Re: Append/Update
  • From: chamlyn
• Re: max autonum multi-user environment
  • From: Michel Walsh
• Re: Ordering results, not as simple as it sounds
  • From: KARL DEWEY
• Re: Need to sort several different fields together - Alphabetically
  • From: Ken Snell \(MVP\)
• Re: multiply a certain field in all query by same value
  • From: Ken Snell \(MVP\)
• Re: Append/Update
  • From: Ron2006
• Re: If statement not displaying text if conditions not met
  • From: Ron2006
• RE: Use query results to copy files?
  • From: Klatuu
• Re: Unwanted info in query
  • From: Mika Oukka
• Re: Query: date is null
  • From: barrynichols
• Re: Datepart function is it the right solution???
  • From: Michel Walsh
• Re: Unwanted info in query
  • From: Rhianne
• Append/Update
  • From: chamlyn
• Re: Unwanted info in query
  • From: Rhianne
• Re: date manipulation
  • From: John Spencer
• Re: Unwanted info in query
  • From: John Spencer
• Re: Query: date is null
  • From: John Spencer
• Invalid use of Null
  • From: vikram_singh
• Re: Unwanted info in query
  • From: Mika Oukka
• Re: Query: date is null
  • From: barrynichols
• Re: Unwanted info in query
  • From: Rhianne
• Re: Unwanted info in query
  • From: John Spencer
• Re: Query: date is null
  • From: John Spencer
• Re: Concatenate only if there is something to concatenate
  • From: John Spencer
• Re: Counting records with Values
  • From: John Spencer
• Re: IsError In Query - Handle #Error
  • From: gumby
• Re: Ordering results, not as simple as it sounds
  • From: Joe
• Query: date is null
  • From: barrynichols
• Re: Datepart function is it the right solution???
  • From: John Spencer
• Re: multiply a certain field in all query by same value
  • From: Pedro
• Re: Parameter Query Problem
  • From: John Spencer
• Re: IsError In Query - Handle #Error
  • From: Allen Browne
• IsError In Query - Handle #Error
  • From: gumby
• Macro to grab email address and open Outlook
  • From: duncanjx
• Re: Concatenate only if there is something to concatenate
  • From: Rick Brandt
• Concatenate only if there is something to concatenate
  • From: bhrosey via AccessMonster.com
• help with 2 queries to compare and delete from same source table
  • From: efandango
• Re: Counting records with Values
  • From: Douglas J. Steele
• Re: Datepart function is it the right solution???
  • From: Rick Brandt
• mike lalonde
  • From: Mike
• Macro to send grab email address and open Outlook
  • From: duncanjx
• Re: Still showing numbers not text in display
  • From: John W . Vinson
• Re: Field showing number instead of linked table info
  • From: John W . Vinson
• Re: Field showing number instead of linked table info
  • From: Douglas J. Steele
• Re: Use Pass through with another Access database
  • From: ScottS
• Re: Invalid syntax
  • From: John Spencer
• Re: multiply a certain field in all query by same value
  • From: Ken Snell \(MVP\)
• Re: Consecutive Date Query
  • From: Michel Walsh
• Re: Opening Bal and closing Balance
  • From: Michel Walsh
• Re: sum a field value in all querys
  • From: Jeanette Cunningham
• mike lalonde
  • From: delfox
• Re: how to concat from another table field w/in my select?
  • From: Duane Hookom
• Re: anyone else seen problem using LEN() function in Runtime?
  • From: Allen Browne
• Re: how to concat from another table field w/in my select?
  • From: Marshall Barton
• RE: Use query results to copy files?
  • From: Gary
• RE: Use query results to copy files?
  • From: Gary
• Re: Ordering results, not as simple as it sounds
  • From: KARL DEWEY
• RE: Use query results to copy files?
  • From: Klatuu
• Re: Ordering results, not as simple as it sounds
  • From: Joe
• Re: Consecutive Date Query
  • From: NeonSky via AccessMonster.com
• Re: Apparently Bogus "could refer to more than one.
  • From: David W. Fenton
• Re: Consecutive Date Query
  • From: NeonSky via AccessMonster.com
• RE: Counting queries
  • From: Papa Jonah
• Re: Invalid syntax
  • From: Phil Smith
• Re: Ordering results, not as simple as it sounds
  • From: Phil Smith
• Re: Last full week
  • From: Mike
• Invalid syntax
  • From: peljo via AccessMonster.com
• Re: Last full week
  • From: John Spencer
• Re: Last full week
  • From: Jeff Boyce
• Re: Counting queries
  • From: Jeff Boyce
• Re: Apparently Bogus "could refer to more than one.
  • From: George Nicholson
• RE: Counting queries
  • From: KARL DEWEY
• Re: Opening Bal and closing Balance
  • From: Michel Walsh
• Re: SQL - take out the day+month
  • From: SpookiePower
• Re: Consecutive Date Query
  • From: Michel Walsh
• Re: Add years between two dates
  • From: Robbin
• Re: Add years between two dates
  • From: Robbin
• Re: Numbers in a text field-can I add them up?
  • From: fredg
• Re: Add years between two dates
  • From: John Spencer
• Re: Add years between two dates
  • From: Douglas J. Steele
• Re: null data not showing up if "is null" query criteria
  • From: Duane Hookom
• Re: null data not showing up if "is null" query criteria
  • From: tcek
• Re: Numbers in a text field-can I add them up?
  • From: John Spencer
• Re: null data not showing up if "is null" query criteria
  • From: John Spencer
• RE: Numbers are text-need to add them
  • From: Bonnie A
• Re: Table name as a parameter
  • From: Ron2006
• Re: Consecutive Date Query
  • From: NeonSky via AccessMonster.com
• Re: Consecutive Date Query
  • From: NeonSky via AccessMonster.com
• Re: Use Pass through with another Access database
  • From: John Spencer
• Re: Parsing Problem
  • From: robboll
• RE: Table name as a parameter
  • From: JB
• Re: IIf statement, wildcard to return all records
  • From: adam . vogg
• Re: Update Field Names
  • From: Jeff Boyce
• Re: Sum A String
  • From: NeonSky via AccessMonster.com
• Re: Update Field Names
  • From: Craig
• RE: Most Recent
  • From: tryn2learn
• Re: Table name as a parameter
  • From: Michel Walsh
• Re: Time Question filtering out weekends and mondays
  • From: Ron2006
• Re: using compute by
  • From: Michel Walsh
• Re: Lost data in Union Query
  • From: John Spencer
• RE: check for data
  • From: Klatuu
• Re: Running sum that restarts on each group
  • From: Michel Walsh
• Re: Lost data in Union Query
  • From: Allen Browne
• Re: SQL - take out the day+month
  • From: John Spencer
• Re: Parsing Problem
  • From: John Spencer
• Re: query from a form Date as number YYYYMMDD
  • From: John Spencer
• Lost data in Union Query
  • From: DZ
• Re: How to determine if field is all uppercase?
  • From: John Spencer
• Re: Due date query
  • From: John Spencer
• Re: Union Queries - Results showing as text & not numbers
  • From: Clive
• Re: anyone else seen problem using LEN() function in Runtime?
  • From: Allen Browne
• Re: Union Queries - Results showing as text & not numbers
  • From: Allen Browne
• SQL - take out the day+month
  • From: SpookiePower
• Re: anyone else seen problem using LEN() function in Runtime?
  • From: Stefan Hoffmann
• using compute by
  • From: vikram_singh
• Re: Union Queries - Results showing as text & not numbers
  • From: Clive
• Re: Union Queries - Results showing as text & not numbers
  • From: Allen Browne
• Re: Apparently Bogus "could refer to more than one.
  • From: Allen Browne
• Re: Running sum that restarts on each group
  • From: doughnut
• RE: Adding fields to table like LTP1.......LTPn after query execution
  • From: ppc via AccessMonster.com
• RE: Adding fields to table like LTP1.......LTPn after query execution
  • From: Duane Hookom
• RE: Due date query
  • From: Melissa
• RE: Run series of query -- I don't want any pop-up
  • From: ali
• Adding fields to table like LTP1.......LTPn after query execution
  • From: ppc via AccessMonster.com
• RE: Union Query
  • From: Duane Hookom
• Re: Sub-query no results
  • From: Opal
• RE: Query using expression for criteria retunring no results for o
  • From: Sue Compelling
• Parsing Problem
  • From: robboll
• Re: Apparently Bogus "could refer to more than one.
  • From: Phil Smith
• Re: Consecutive Date Query
  • From: NeonSky via AccessMonster.com
• Re: query from a form Date as number YYYYMMDD
  • From: George Nicholson
• Re: How to determine if field is all uppercase?
  • From: Allen Browne
• RE: query from a form Date as number YYYYMMDD
  • From: AngieSD
• RE: check for data
  • From: Gary Dolliver
• RE: query from a form Date as number YYYYMMDD
  • From: Duane Hookom
• Re: Apparently Bogus "could refer to more than one.
  • From: Allen Browne
• Re: Query with Combo Box
  • From: Skip
• Re: Modifying a Query To Reflect Business days
  • From: Ron2006
• RE: Query with Combo Box
  • From: KARL DEWEY
• RE: Most Recent
  • From: Jerry Whittle
• Re: Operation must use an updateable query
  • From: Skip
• RE: Query with Combo Box
  • From: Ron
• Re: Consecutive Date Query
  • From: Michel Walsh
• Query on a set of optional M2M relationships
  • From: David Wetmore
• RE: Most Recent
  • From: tryn2learn
• Re: Too many duplicate records
  • From: Ricoy-Chicago
• Re: Too many duplicate records
  • From: Ricoy-Chicago
• Re: Combine Data from the same Table
  • From: brownti via AccessMonster.com
• Re: How do I number each row in a query result?
  • From: Jeff Boyce
• Re: field based on field
  • From: Kou Vang
• Re: Combine Data from the same Table
  • From: Michel Walsh
• RE: field display in pivot table
  • From: Sherry
• Re: Apparently Bogus "could refer to more than one.
  • From: Phil Smith
• RE: Combine Data from the same Table
  • From: brownti via AccessMonster.com
• Re: Consecutive Date Query
  • From: NeonSky via AccessMonster.com
• Consecutive Date Query
  • From: NeonSky via AccessMonster.com
• Re: field based on field
  • From: fredg
• Re: Too many duplicate records
  • From: John Spencer
• RE: field display in pivot table
  • From: Duane Hookom
• Combine Data from the same Table
  • From: brownti via AccessMonster.com
• Re: Too many duplicate records
  • From: Ricoy-Chicago
• Re: Too many duplicate records
  • From: Ricoy-Chicago
• union query
  • From: peljo via AccessMonster.com
• Re: Moving data from one table to another
  • From: Michel Walsh
• Re: Running sum that restarts on each group
  • From: Michel Walsh
• Moving data from one table to another
  • From: brownti via AccessMonster.com
• RE: Most Recent
  • From: tryn2learn
• RE: Most Recent
  • From: Jerry Whittle
• Re: Deleting Anything Duplicate
  • From: Allen Browne
• Re: query multiple non-consecutive dates
  • From: Michel Walsh
• Re: Deleting Anything Duplicate
  • From: Mike
• Re: Sub-query no results
  • From: John Spencer
• Re: QUERY DESIGN
  • From: John Spencer
• Re: Too many duplicate records
  • From: John Spencer
• Re: from froms to queries
  • From: Al Campagna
• Re: Operation must use an updateable query
  • From: RL
• Re: Operation must use an updateable query
  • From: RL
• Sub-query no results
  • From: Opal
• Re: Deleting Anything Duplicate
  • From: Allen Browne
• Re: Like Operator in the Criteria in a Query
  • From: Ken Snell \(MVP\)
• Re: Apparently Bogus "could refer to more than one.
  • From: Allen Browne
• Re: Like Operator in the Criteria in a Query
  • From: Ken Snell \(MVP\)
• Re: make field with sql or iif
  • From: Ken Snell \(MVP\)
• Re: Apparently Bogus "could refer to more than one.
  • From: Phil Smith
• Re: easy way around "not updateable query" for sums?
  • From: Phil Smith
• RE: Apparently Bogus "could refer to more than one.
  • From: mscertified
• Re: Parameter Query For Selected Dates or All Dates
  • From: Michael
• Re: query multiple non-consecutive dates
  • From: Todd
• Re: easy way around "not updateable query" for sums?
  • From: Rick Brandt
• Re: easy way around "not updateable query" for sums?
  • From: John Spencer
• Re: Parameter Query For Selected Dates or All Dates
  • From: fredg
• Re: Field Concatenation Question
  • From: Marshall Barton
• Apparently Bogus "could refer to more than one.
  • From: Phil Smith
• RE: To be or not to be: Unique
  • From: Eric
• RE: Due date query
  • From: KARL DEWEY
• Re: How do I number each row in a query result?
  • From: Jeff Boyce
• Re: Operation must use an updateable query
  • From: Skip
• Parameter Query For Selected Dates or All Dates
  • From: Michael
• Re: IIf statement, wildcard to return all records
  • From: fredg
• RE: Too many duplicate records
  • From: Ricoy-Chicago
• easy way around "not updateable query" for sums?
  • From: Phil Smith
• Re: IIf statement, wildcard to return all records
  • From: adam . vogg
• RE: Latest Record
  • From: Jerry Whittle
• Re: IIf statement, wildcard to return all records
  • From: fredg
• RE: Too many duplicate records
  • From: KARL DEWEY
• RE: Too many duplicate records
  • From: Ricoy-Chicago
• Re: Commissions/Receipts query
  • From: BMoroneso
• Re: Field Concatenation Question
  • From: NeonSky via AccessMonster.com
• Re: IIf statement, wildcard to return all records
  • From: adam . vogg
• Re: How to delete "non-identical" duplicate records in an Access table
  • From: Michael Gramelspacher
• Re: Sum A String
  • From: fredg
• RE: Sum A String
  • From: Klatuu
• RE: Too many duplicate records
  • From: KARL DEWEY
• Re: Sum A String
  • From: Michel Walsh
• Re: IIf statement, wildcard to return all records
  • From: fredg
• Re: Commissions/Receipts query
  • From: Michel Walsh
• Re: IIf statement, wildcard to return all records
  • From: Michel Walsh
• Re: wrapping text in a query field
  • From: fredg
• RE: Quarterly Restriction
  • From: Leviathan via AccessMonster.com
• RE: Quarterly Restriction
  • From: KARL DEWEY
• Sum A String
  • From: NeonSky via AccessMonster.com
• RE: Quarterly Restriction
  • From: Leviathan via AccessMonster.com
• Re: Field Concatenation Question
  • From: NeonSky via AccessMonster.com
• RE: How to delete "non-identical" duplicate records in an Access table
  • From: Jerry Whittle
• Re: wrapping text in a query field
  • From: adam . vogg
• IIf statement, wildcard to return all records
  • From: adam . vogg
• Re: Field Concatenation Question
  • From: NeonSky via AccessMonster.com
• Re: Field Concatenation Question
  • From: Michel Walsh
• RE: Select Records that Start at a Break in the Date
  • From: KARL DEWEY
• Re: Select Records that Start at a Break in the Date
  • From: Michel Walsh
• RE: passing criteria from form to query
  • From: Duane Hookom
• Re: Field Concatenation Question
  • From: NeonSky via AccessMonster.com
• Re: Variable (select) TABLE name in query
  • From: Michel Walsh
• Creating a registration table list based on an existing table
  • From: ChuckW
• Re: Memo field gets cut short in a query.
  • From: KimPotter
• Re: Field Concatenation Question
  • From: Michel Walsh
• update or layered query on count
  • From: JustALittleHelp
• Re: Memo field gets cut short in a query.
  • From: Allen Browne
• Re: query multiple non-consecutive dates
  • From: Michel Walsh
• RE: Memo field gets cut short in a query.
  • From: KimPotter
• Variable (select) TABLE name in query
  • From: Eric Waldheim
• Re: Field Concatenation Question
  • From: NeonSky via AccessMonster.com
• RE: How to delete "non-identical" duplicate records in an Access table
  • From: mscertified
• Re: Trimming SSN to last 4 digits
  • From: Roger Carlson
• Create summary tab of last entry/row on all tabs in workbook
  • From: Lisa
• How to delete "non-identical" duplicate records in an Access table
  • From: Ernest Monterrosa
• Maximum number of fields in a Union query
  • From: mrelam
• Re: parameter
  • From: Allen Browne
• Re: update query updates 0 records
  • From: John Spencer
• Re: Need help to find Values after from
  • From: John Spencer
• Re: Operation must use an updateable query
  • From: RL
• Re: monthly stats query
  • From: John Spencer
• Re: Operation must use an updateable query
  • From: John Spencer
• Re: Operation must use an updateable query
  • From: RL
• update query updates 0 records
  • From: peljo via AccessMonster.com
• Select Records that Start at a Break in the Date
  • From: 58djoker via AccessMonster.com
• RE: A2003 - Getting records between two dates
  • From: drunkjunkie via AccessMonster.com
• RE: Right Truncation warning
  • From: Charles Wang[MSFT]
• Re: Simple Question?
  • From: tbrogdon
• Re: Simple Question?
  • From: AbhijitDDeveloper via AccessMonster.com
• Re: Simple Question?
  • From: tbrogdon
• Re: Simple Question?
  • From: AbhijitDDeveloper via AccessMonster.com
• Simple Question?
  • From: tbrogdon
• RE: query for importing table form the net
  • From: ppc via AccessMonster.com
• Re: make field with sql or iif
  • From: NetworkTrade
• Re: make field with sql or iif
  • From: Ken Snell \(MVP\)
• Re: Pass through query speed
  • From: Rick Brandt
• RE: IIF Statement
  • From: KARL DEWEY
• Re: Field Concatenation Question
  • From: Marshall Barton
• Re: make field with sql or iif
  • From: NetworkTrade
• Field Concatenation Question
  • From: NeonSky via AccessMonster.com
• Massive Summary of data
  • From: DawnTreader
• Re: Operation must use an updateable query
  • From: Skip
• Re: Operation must use an updateable query
  • From: Skip
• Re: Operation must use an updateable query
  • From: Skip
• RE: IIF Statement
  • From: T Miller
• Re: Query that updates automatically on screen
  • From: Marshall Barton
• RE: Quarterly Restriction
  • From: Leviathan via AccessMonster.com
• RE: IIF Statement
  • From: KARL DEWEY
• RE: Expression to enter data from one column 2 multiple columns in
  • From: KARL DEWEY
• Re: Find most recent record by date and time
  • From: Scott Whetsell, A.S. - WVSP
• Re: Update Query Problem
  • From: Michel Walsh
• Re: Query that updates automatically on screen
  • From: Michel Walsh
• Re: Date selection from form VBA
  • From: Michel Walsh
• RE: If "Other" Selected
  • From: hulksdgt
• Update Query Problem
  • From: Jonas
• Re: Does an UPDATE create a record???
  • From: Michel Walsh
• Re: create 1 field from multiple records
  • From: Marshall Barton
• Re: Using one table to populate multiple columns in a query
  • From: Marshall Barton
• RE: Quarterly Restriction
  • From: KARL DEWEY
• Re: Does an UPDATE create a record???
  • From: fredg
• update question yes/no field
  • From: angelinarose via AccessMonster.com
• RE: Quarterly Restriction
  • From: Leviathan via AccessMonster.com
• Re: Operation must use an updateable query
  • From: John Spencer
• RE: how to populate a listboc with the result of two combobox
  • From: Jazz57
• RE: how to populate a listboc with the result of two combobox
  • From: Jazz57
• Expression to enter data from one column 2 multiple columns in a q
  • From: Rose
• RE: Quarterly Restriction
  • From: Leviathan via AccessMonster.com
• Re: Operation must use an updateable query
  • From: RL
• RE: how to populate a listboc with the result of two combobox
  • From: Duane Hookom
• switch function or sumif?
  • From: jaydywan
• RE: filter for values in another table
  • From: Qaspec
• RE: how to populate a listboc with the result of two combobox
  • From: Jazz57
• RE: filter for values in another table
  • From: Qaspec
• Re: Delete query problem
  • From: Keith Wilby
• Re: Query sort not working after NULL column
  • From: Michel Walsh
• Re: Delete query problem
  • From: John Spencer
• Re: How to convert 2007-001 this year and day to a normal date?
  • From: John Spencer
• Re: Operation must use an updateable query
  • From: John Spencer
• Re: Find most recent record by date and time
  • From: John Spencer
• A2003 - Getting records between two dates
  • From: drunkjunkie via AccessMonster.com
• Re: cannot sum null; not zero
  • From: Rick Stahl
• Re: SQL String
  • From: clk
• Re: cannot sum null; not zero
  • From: fredg
• Re: Using one table to populate multiple columns in a query
  • From: Frank
• Re: Date Intervals from dates
  • From: c8tz
• RE: Inventory Location
  • From: Daryl Au
• Re: cannot sum null; not zero
  • From: Rick Stahl
• Re: cannot sum null; not zero
  • From: Ken Snell \(MVP\)
• cannot sum null; not zero
  • From: Rick Stahl
• Re: Query sort not working after NULL column
  • From: mscertified
• RE: Iif, And Expressions in a Query (Working with Dates)
  • From: Vylent Fyre
• RE: Quarterly Restriction
  • From: Leviathan via AccessMonster.com
• RE: filter for values in another table
  • From: Dale Fye
• Quarterly Restriction
  • From: Leviathan via AccessMonster.com
• Re: Query sort not working after NULL column
  • From: Michel Walsh
• RE: Iif, And Expressions in a Query (Working with Dates)
  • From: Dale Fye
• Re: Query sort not working after NULL column
  • From: Michel Walsh
• Re: Query sort not working after NULL column
  • From: mscertified
• Re: Message of the day pop-up?
  • From: A Paid Observer
• Re: Query sort not working after NULL column
  • From: Michel Walsh
• Re: Message of the day pop-up?
  • From: John Spencer
• Convert value to OLE Object
  • From: Tony
• Re: Query not totaling correctly
  • From: Tara
• Re: Query not totaling correctly
  • From: Jeff Boyce
• RE: Query sort not working after NULL column
  • From: mscertified
• RE: Query sort not working after NULL column
  • From: mscertified
• Re: Query sort not working after NULL column
  • From: mscertified
• RE: how to populate a listboc with the result of two combobox
  • From: Duane Hookom
• RE: filter for values in another table
  • From: Qaspec
• Re: adding a toolbar to a specific query
  • From: Rick Brandt
• Re: Query sort not working after NULL column
  • From: mscertified
• Re: Using one table to populate multiple columns in a query
  • From: Marshall Barton
• Re: Message of the day pop-up?
  • From: A Paid Observer
• Re: Query that calls value from one table field to another table f
  • From: Jeff Boyce
• Re: Query sort not working after NULL column
  • From: John Spencer
• RE: Iif, And Expressions in a Query (Working with Dates)
  • From: Vylent Fyre
• Re: Query sort not working after NULL column
  • From: mscertified
• Re: Do I need a Crosstab Query (html)
  • From: Gary Walter
• RE: how to populate a listboc with the result of two combobox
  • From: Jazz57
• Re: Query sort not working after NULL column
  • From: Michel Walsh
• Re: Do I need a Crosstab Query (html)
  • From: Steve S
• RE: how to populate a listboc with the result of two combobox
  • From: Duane Hookom
• RE: filter for values in another table
  • From: Dale Fye
• RE: Updateable Query
  • From: Duane Hookom
• Re: Maximum Salary
  • From: Gary Walter
• Re: I am in need of a query in Mysql
  • From: Michel Walsh
• Creating update query to update non primary key.
  • From: george . greiner
• Re: Query that calls value from one table field to another table f
  • From: Lisa W.
• Re: Do I need a Crosstab Query (html)
  • From: Gary Walter
• RE: Iif, And Expressions in a Query (Working with Dates)
  • From: Dale Fye
• query for importing table form the net
  • From: ppc via AccessMonster.com
• RE: Self Join Query / Second highest value in query
  • From: Ken Sheridan
• RE: how to populate a listboc with the result of two combobox
  • From: Jazz57
• Re: Date Intervals from dates
  • From: Allen Browne
• RE: Updateable Query
  • From: FBxiii
• I am in need of a query in Mysql
  • From: rajsmashr
• RE: Updateable Query
  • From: FBxiii
• RE: how to populate a listboc with the result of two combobox
  • From: Jazz57
• RE: how to populate a listboc with the result of two combobox
  • From: Jazz57
• RE: how to populate a listboc with the result of two combobox
  • From: Jazz57
• Re: Using one table to populate multiple columns in a query
  • From: Frank
• Re: Make Table Query hits 2GB Limit
  • From: Grd
• Re: Need assistance with SUM and MAX
  • From: Tony
• Re: Need assistance with SUM and MAX
  • From: John Spencer
• Re: Need assistance with SUM and MAX
  • From: John Spencer
• Re: Do I need a Crosstab Query (html)
  • From: Steve S
• Date Intervals from dates
  • From: c8tz
• Re: Do I need a Crosstab Query (html)
  • From: Steve S
• Re: Need assistance with SUM and MAX
  • From: Tony
• Re: Need assistance with SUM and MAX
  • From: Tony
• Re: Need assistance with SUM and MAX
  • From: Tony
• RE: how to populate a listboc with the result of two combobox
  • From: Duane Hookom
• RE: how to populate a listboc with the result of two combobox
  • From: Jazz57
• Re: Message of the day pop-up?
  • From: John Spencer
• Re: Need assistance with SUM and MAX
  • From: John Spencer
• Re: Need assistance with SUM and MAX
  • From: Tony
• RE: Need assistance with SUM and MAX
  • From: Ken Sheridan
• Re: Select N rows and get Minimum
  • From: small brother
• Re: Using one table to populate multiple columns in a query
  • From: Marshall Barton
• RE: expression typed incorretly or too complex to be evaluated
  • From: Duane Hookom
• Re: Two table in one query
  • From: Rick Brandt
• Using one table to populate multiple columns in a query
  • From: Frank
• Two table in one query
  • From: New_Access
• RE: expression typed incorretly or too complex to be evaluated
  • From: DOMIRICAN via AccessMonster.com
• Need assistance with SUM and MAX
  • From: Tony
• Re: make field with sql or iif
  • From: Ken Snell \(MVP\)
• make field with sql or iif
  • From: NetworkTrade
• Re: queries to look up multiply and add
  • From: gbpg
• Re: queries to look up multiply and add
  • From: Smartin
• queries to look up multiply and add
  • From: gbpg
• Re: Select N rows and get Minimum
  • From: Gary Walter
• Re: Select N rows and get Minimum
  • From: giorgio rancati
• Re: Birthday
  • From: John Spencer
• Re: Distilling a Query?
  • From: Craig
• Re: Select N rows and get Minimum
  • From: Marshall Barton
• RE: Group By Record Limit in Query?
  • From: Rick Lewis
• Re: Birthday
  • From: EllenM
• Re: Why doesn't this work: =DateAdd("m",36,[Initial QNFT Date])
  • From: Wenzell
• Re: Why doesn't this work: =DateAdd("m",36,[Initial QNFT Date])
  • From: John Spencer
• Re: Problem with an Updating query
  • From: John Spencer
• Re: Birthday
  • From: Douglas J. Steele
• Re: Birthday
  • From: John Spencer
• Re: Find Duplicates & wildcards?
  • From: Mika Oukka
• Re: Why doesn't this work: =DateAdd("m",36,[Initial QNFT Date])
  • From: Allen Browne
• Re: Maximum Salary
  • From: Gary Walter
• Problem with an Updating query
  • From: Dennis Snelgrove
• Re: Multi Table Queries
  • From: Duane Hookom
• Re: How do I select a specific amount of random values for individuals
  • From: pietlinden@xxxxxxxxxxx
• RE: expression typed incorretly or too complex to be evaluated
  • From: Duane Hookom
• Re: Distilling a Query?
  • From: John W . Vinson
• Re: Distilling a Query?
  • From: Smartin
• Distilling a Query?
  • From: Craig
• RE: Help with sum of max values for a specific date field
  • From: Hafeez Esmail
• Re: Calculated Conditional Expressions
  • From: Allen Browne
• Re: Criteria wildcard
  • From: Marshall Barton
• Re: Multi Table Queries
  • From: Marshall Barton
• Re: Query that calls value from one table field to another table field
  • From: Jeff Boyce
• Calculated Conditional Expressions
  • From: Caburky
• RE: expression typed incorretly or too complex to be evaluated
  • From: DOMIRICAN via AccessMonster.com
• RE: expression typed incorretly or too complex to be evaluated
  • From: DOMIRICAN via AccessMonster.com
• Re: Birthday
  • From: Douglas J. Steele
• RE: Re Monthly Invoices
  • From: Joseph
• Re: Multi Table Queries
  • From: Duane Hookom
• Help with sum of max values for a specific date field
  • From: PKT
• Re: Criteria wildcard
  • From: Gavelle
• Re: Criteria wildcard
  • From: Marshall Barton
• Re: Maximum Salary
  • From: Tom Lake
• Re: Multi Table Queries
  • From: Marshall Barton
• Re: Weekend and holiday dates only
  • From: Douglas J. Steele
• Re: Replace
  • From: fredg
• Re: Criteria Problem
  • From: D
• Re: Sort in an IIf statement
  • From: Marshall Barton
• Re: Criteria Problem
  • From: John Spencer
• Need help with unusual dedupe query
  • From: ebecker
• Re: Maximum Salary
  • From: Tom Lake
• RE: Maximum Salary
  • From: Robert T
• RE: Maximum Salary
  • From: Jerry Whittle
• Re: Weekend and holiday dates only
  • From: Douglas J. Steele
• Re: Filter by sum of counts
  • From: Dale Fye
• Re: Criteria Problem
  • From: D
• Re: Replace
  • From: John Spencer
• Re: Criteria Problem
  • From: John Spencer
• Re: Subquery help?
  • From: John Spencer
• Re: Criteria Problem
  • From: D
• RE: Updateable Query
  • From: Duane Hookom
• Re: Criteria Problem
  • From: fredg
• Re: Multi Table Queries
  • From: Marshall Barton
• Re: Criteria Problem
  • From: Marshall Barton
• Re: Sort in an IIf statement
  • From: Huber57
• Re: Find duplicates one one field, unmatching on another
  • From: tmwilkin
• Re: Sort in an IIf statement
  • From: Marshall Barton
• Re: corrupted vba
  • From: Marshall Barton
• Re: Sort in an IIf statement
  • From: Michel Walsh
• Re: Sort in an IIf statement
  • From: Michel Walsh
• RE: Sort in an IIf statement
  • From: Huber57
• Re: query results not showing up in report
  • From: megbowlstrike
• RE: Updateable Query
  • From: FBxiii
• Sort in an IIf statement
  • From: Huber57
• Re: Select record External Source
  • From: pietlinden@xxxxxxxxxxx
• Re: query results not showing up in report
  • From: Duane Hookom
• Re: Join not working right?
  • From: Michel Walsh
• Re: Customer Sales Data
  • From: Michel Walsh
• Re: query results not showing up in report
  • From: megbowlstrike
• Re: Subquery help?
  • From: Jay
• Re: View columns as rows
  • From: Stefan Hoffmann
• Re: Subquery help?
  • From: Jay
• Re: Subquery help?
  • From: John Spencer
• Re: Unmatched Query
  • From: John Spencer
• Re: Filter by sum of counts
  • From: runnik
• Subquery help?
  • From: Jay
• Re: how to put in sql code
  • From: John Spencer
• Re: Find duplicates one one field, unmatching on another
  • From: John Spencer
• Re: how to put in sql code
  • From: HENDRY_del_FUEGO via AccessMonster.com
• Re: Date Query
  • From: John Spencer
• RE: Duplicate Records
  • From: Mike
• Re: View columns as rows
  • From: Marco
• how to put in sql code
  • From: HENDRY_del_FUEGO via AccessMonster.com
• Re: View columns as rows
  • From: Stefan Hoffmann
• RE: Option Button to Restrict Qry
  • From: Wei Lu [MSFT]
• Re: Error 3420 Object invalid or no longer set under Vista
  • From: Allen Browne
• Re: Make Table Query hits 2GB Limit
  • From: John W . Vinson
• Re: Select record External Source
  • From: Dale Fye
• Re: Exceptions in Query
  • From: Marshall Barton
• Re: Select record External Source
  • From: pietlinden@xxxxxxxxxxx
• RE: query to make a list of products based on delivery history
  • From: tsison7
• Re: Exceptions in Query
  • From: Gonzalo
• Re: Exceptions in Query
  • From: Marshall Barton
• Re: Filter by sum of counts
  • From: Dale Fye
• Re: Duplicate date prompts when using Macro to run Crosstab Query
  • From: Allen Browne
• Re: Formatting the month of a date
  • From: fredg
• Re: TOP 3 in row source
  • From: Robert
• Re: Join not working right?
  • From: Phil Smith
• Re: Customer Sales Data
  • From: Jeff G.
• Re: Join not working right?
  • From: Michel Walsh
• Re: Crosstab Month Sort
  • From: MGFoster
• query results not showing up in report
  • From: megbowlstrike
• Re: pulling matching names from 2 queries
  • From: Michel Walsh
• Re: Help needed with query for weekly totals
  • From: Michel Walsh
• Re: Join not working right?
  • From: Phil Smith
• Re: Formula in Query to produce Balance field
  • From: Michel Walsh
• Re: Filter by sum of counts
  • From: runnik
• RE: select record before and after, then calculate average.
  • From: brhall
• RE: mutiple -query
  • From: M.
• Re: Using not equal to with wildcard
  • From: John Spencer
• Re: Help needed with query for weekly totals
  • From: Terry
• Re: pulling matching names from 2 queries
  • From: Jeff Boyce
• RE: Help needed with query for weekly totals
  • From: Jerry Whittle
• RE: select record before and after, then calculate average.
  • From: Dale Fye
• Re: Filter by sum of counts
  • From: runnik
• Re: Convert DAY IN YEAR to date
  • From: Klatuu
• Re: Formula in Query to produce Balance field
  • From: KimTong via AccessMonster.com
• Re: Convert DAY IN YEAR to date
  • From: John W . Vinson
• RE: select record before and after, then calculate average.
  • From: brhall
• RE: select record before and after, then calculate average.
  • From: brhall
• Help needed with query for weekly totals
  • From: Terry
• Crosstab twist.
  • From: pietlinden@xxxxxxxxxxx
• Re: Query Design Questions
  • From: Marshall Barton
• RE: select record before and after, then calculate average.
  • From: Dale Fye
• Re: Update Field Names
  • From: Michel Walsh
• Update Field Names
  • From: Craig
• Duplicate date prompts when using Macro to run Crosstab Query
  • From: VMR via AccessMonster.com
• Re Monthly Invoices
  • From: Joseph
• Re: two tables one query.
  • From: Michel Walsh
• Re: Formula in Query to produce Balance field
  • From: Michel Walsh
• Re: delete spaces between last name and first name
  • From: fredg
• Re: Filter by sum of counts
  • From: Dale Fye
• Re: Not Like
  • From: DS
• RE: Convert DAY IN YEAR to date
  • From: fdnyfish via AccessMonster.com
• RE: Convert DAY IN YEAR to date
  • From: Klatuu
• Re: Filter by sum of counts
  • From: runnik
• Re: Variable Created For a Query Not Working
  • From: SHIPP
• RE: getsavedquery
  • From: Klatuu
• Re: Filter by sum of counts
  • From: runnik
• Convert DAY IN YEAR to date
  • From: fdnyfish via AccessMonster.com
• Re: Filter by sum of counts
  • From: John Spencer
• Re: Filter by sum of counts
  • From: Michel Walsh
• Re: Is null
  • From: John Spencer
• Re: Duplicate query
  • From: John Spencer
• Re: Variable Created For a Query Not Working
  • From: SHIPP
• Re: Unique Value's in Query Issue
  • From: John Spencer
• RE: Filter by sum of counts
  • From: Dale Fye
• Re: Update query result to table
  • From: John Spencer
• Filter by sum of counts
  • From: runnik
• Re: Separating strings in a field to separate fields
  • From: jseger22
• Re: Transposing Data from Query
  • From: Gary Walter
• Re: IIF Query for Numeric Values in Text Field - #ERROR
  • From: CFJOHN1
• Re: Transposing Data from Query
  • From: Gary Walter
• Re: Problem with code
  • From: Jeff Boyce
• Re: Transposing Data from Query
  • From: Gary Walter
• Re: Transposing Data from Query
  • From: Gary Walter
• Re: Transposing Data from Query
  • From: Stefan Hoffmann
• RE: getsavedquery
  • From: HENDRY_del_FUEGO via AccessMonster.com
• RE: getsavedquery
  • From: HENDRY_del_FUEGO via AccessMonster.com
• Re: Using Prompt with a "like" query parameter
  • From: rpm
• Re: Not Like
  • From: John W . Vinson
• Re: Using Prompt with a "like" query parameter
  • From: fredg
• Re: Sorting by Last Name and then First Name in the Same Field
  • From: fredg
• Using Prompt with a "like" query parameter
  • From: rpm
• Re: Not Like
  • From: DS
• Re: Not Like
  • From: DS
• Unique Value's in Query Issue
  • From: tekari
• Re: Isolating a PO number in a text field
  • From: John Spencer
• Re: Querying multiple records in two tables
  • From: rmorrison
• Re: IIF and formatting
  • From: Allen Browne
• Re: Not Like
  • From: John W . Vinson
• Re: Separating strings in a field to separate fields
  • From: John W . Vinson
• mutiple -query
  • From: Fuzuy
• Re: Join not working right?
  • From: Michel Walsh
• Re: Join not working right?
  • From: Phil Smith
• Re: Predefined date range
  • From: raskew via AccessMonster.com
• Formula in Query to produce Balance field
  • From: KimTong via AccessMonster.com
• RE: Running "Balance Available" in Query
  • From: RaShae
• Re: wildcard number used in iif statement
  • From: pat c
• RE: A report with many values
  • From: MN
• Re: wildcard number used in iif statement
  • From: John Spencer
• Re: Variable Created For a Query Not Working
  • From: Michel Walsh
• Re: Not Like
  • From: John Spencer
• RE: A report with many values
  • From: Jerry Whittle
• Re: wildcard number used in iif statement
  • From: John Spencer
• Re: query question
  • From: John Spencer
• Re: Update using specified field
  • From: Michel Walsh
• Not Like
  • From: DS
• RE: A report with many values
  • From: MN
• Separating strings in a field to separate fields
  • From: jseger22
• Re: Update using specified field
  • From: Marshall Barton
• query question
  • From: angelinarose via AccessMonster.com
• Subqueries within queries
  • From: Conan Kelly
• Re: Query Options
  • From: Jeff Boyce
• Query Options
  • From: Douglas @ Helpdesk
• sum certain columns of a query
  • From: JEA via AccessMonster.com
• Re: IIF and formatting
  • From: John Spencer
• Re: IIF and formatting
  • From: Marshall Barton
• Re: IIF and formatting
  • From: Huber57
• Re: IIF and formatting
  • From: Keith Wilby
• RE: merge two tables in one queie
  • From: joebogey
• Re: Access Linked to Excel Producing Wrong Month
  • From: PatK
• Re: IIF and formatting
  • From: Huber57
• Re: IIF Query for Numeric Values in Text Field - #ERROR
  • From: Allen Browne
• Re: IIF and formatting
  • From: Allen Browne
• RE: Limit record count in query
  • From: Duane Hookom
• Re: combo box columns
  • From: Michel Walsh
• IIF and formatting
  • From: Huber57
• Re: IIF function with variables
  • From: Michel Walsh
• IIF Query for Numeric Values in Text Field - #ERROR
  • From: CFJOHN1
• Re: Access Linked to Excel Producing Wrong Month
  • From: Michel Walsh
• Re: Join not working right?
  • From: Michel Walsh
• how to do a where query
  • From: Rivers
• Re: Query formulas (dates in formulas to be changed only once)
  • From: John Spencer
• RE: hierarchy in one table
  • From: Dale Fye
• Re: IIF with condition
  • From: Dave
• Re: Update query result to table
  • From: John Spencer
• Re: Problem with code
  • From: Johnkl via AccessMonster.com
• Re: IIF with condition
  • From: John Spencer
• Re: Problem with code
  • From: Jeff Boyce
• Re: SQL String
  • From: John Spencer
• Problem with code
  • From: Johnkl via AccessMonster.com
• RE: getsavedquery
  • From: HENDRY_del_FUEGO via AccessMonster.com
• Re: every query throws "invalid use of null"
  • From: John W . Vinson
• Re: Extracting common ids across 12 tables and assoc data
  • From: Max
• Re: Extracting common ids across 12 tables and assoc data
  • From: Max
• every query throws "invalid use of null"
  • From: jsyeldezian
• Re: Labels not duplicated
  • From: Chuck
• Re: Labels not duplicated
  • From: Chuck
• Re: Restrict number of records returned by query on form
  • From: Robert
• Re: IIF with condition
  • From: Phil Smith
• Join not working right?
  • From: Phil Smith
• Re: IIF function with variables
  • From: Jeff Boyce
• Re: Restrict number of records returned by query on form
  • From: Marshall Barton
• Restrict number of records returned by query on form
  • From: Robert
• Re: Viewing Data by Weeks
  • From: Marshall Barton
• Re: Access: Getting the beginning date of the current week
  • From: Marshall Barton
• Re: Query based on combo box response
  • From: Gabriella777_2
• Re: Query based on combo box response
  • From: John W . Vinson
• Re: Query based on combo box response
  • From: Gabriella777_2
• Re: Query based on combo box response
  • From: John W . Vinson
• Access: Getting the beginning date of the current week
  • From: Barry
• Re: How do I create a table with data selected via a pass through
  • From: John W . Vinson
• Re: simple update query
  • From: Dale Fye
• RE: DateFunction in Query
  • From: Curtis Stevens
• RE: Query based on combo box response
  • From: Gabriella777_2
• Re: simple update query
  • From: tschaeffer
• RE: DateFunction in Query
  • From: Klatuu
• RE: DateFunction in Query
  • From: Curtis Stevens
• Re: SQL String
  • From: clk
• RE: DateFunction in Query
  • From: Klatuu
• RE: DateFunction in Query
  • From: Curtis Stevens
• RE: DateFunction in Query
  • From: Klatuu
• RE: DateFunction in Query
  • From: Curtis Stevens
• Re: Issue when combining fields
  • From: Roger Carlson
• Re: Access 2003 VB Code Export Query Failing with Access 2007 user
  • From: Dale Fye
• Re: Issue when combining fields
  • From: Michel Walsh
• RE: query for Dates between today and 30 days back
  • From: Mitchell_Collen via AccessMonster.com
• RE: query for Dates between today and 30 days back
  • From: Mitchell_Collen via AccessMonster.com
• Re: Monthly Invoice
  • From: Joseph
• query for Dates between today and 30 days back
  • From: Mitchell_Collen via AccessMonster.com
• RE: DateFunction in Query
  • From: Klatuu
• Query based on combo box response
  • From: Gabriella777_2
• RE: DateFunction in Query
  • From: Curtis Stevens
• RE: Data Type Mismatch in Criteria Expression
  • From: Vylent Fyre
• RE: DateFunction in Query
  • From: Klatuu
• Re: How do I create a table with data selected via a pass through
  • From: kandamj
• Re: table designing ms access
  • From: Michel Walsh
• Re: Extracting common ids across 12 tables and assoc data
  • From: John Spencer
• Re: Extracting common ids across 12 tables and assoc data
  • From: Michel Walsh
• Re: TOP 3 in row source
  • From: Michel Walsh
• Re: Grouping data
  • From: Dave
• Re: Grouping data
  • From: Dave
• Re: Format Function
  • From: John Spencer
• Re: Grouping data
  • From: Allen Browne
• Re: Format Function
  • From: Martin
• Re: Insert Commas
  • From: jseger22
• Re: Format Function
  • From: Gary Walter
• Re: Extracting common ids across 12 tables and assoc data
  • From: Max
• Re: Format Function
  • From: Gary Walter
• Re: Append data
  • From: John Spencer
• Re: Monthly Invoice
  • From: John Spencer
• Re: TOP 3 in row source
  • From: Robert
• Re: Append data
  • From: Gary Walter
• Re: Query to select from one table where no record in another table
  • From: John Spencer
• Re: Insert Commas
  • From: John Spencer
• Re: Find Last Yaer's Value
  • From: John Spencer
• query problem
  • From: peljo via AccessMonster.com
• Access, how to base a query field criteria in a macro
  • From: x_gollumn_x
• Re: Calculate a field in Access, using a formula from a text string
  • From: Dale Fye
• Re: Monthly Invoice
  • From: John W . Vinson
• Re: Populate empty fields with a number
  • From: John W . Vinson
• Re: Labels not duplicated
  • From: John W . Vinson
• Re: Access 2003 VB Code Export Query Failing with Access 2007 user
  • From: Dale Fye
• Re: Populate empty fields with a number
  • From: Dale Fye
• Re: simple update query
  • From: Dale Fye
• Re: Extracting common ids across 12 tables and assoc data
  • From: Dale Fye
• Re: simple update query
  • From: tschaeffer
• Re: TOP 3 in row source
  • From: Dale Fye
• simple update query
  • From: tschaeffer
• Extracting common ids across 12 tables and assoc data
  • From: Max
• TOP 3 in row source
  • From: Robert
• Re: Retrieving query result in code
  • From: Robert
• Re: Query Problem - field name has ampersand (&) - Access XL 2002
  • From: Rob Parker
• Re: Query Problem - can't use field with ampersand (&) in its name
  • From: Douglas J. Steele
• RE: DateFunction in Query
  • From: Curtis Stevens
• RE: Query Problem - field name has ampersand (&) - Access XL 2002
  • From: VC
• RE: need to show blank values
  • From: mscertified
• RE: Find Last Yaer's Value
  • From: Dale Fye
• Re: Recording the date and time when a record is modified in Access
  • From: duncanjx
• Access 2003 VB Code Export Query Failing with Access 2007 user
  • From: PatK
• Re: Insert Commas
  • From: jseger22
• Re: Insert Commas
  • From: fredg
• RE: DateFunction in Query
  • From: Klatuu
• Re: Insert Commas
  • From: John Spencer
• Re: Update Table
  • From: small brother
• Re: Update Table
  • From: small brother
• RE: DateFunction in Query
  • From: Curtis Stevens
• Re: Update Table
  • From: Michel Walsh
• RE: DateFunction in Query
  • From: Klatuu
• RE: DateFunction in Query
  • From: Curtis Stevens
• RE: Query Totals
  • From: KARL DEWEY
• RE: Query Totals
  • From: Klatuu
• RE: DateFunction in Query
  • From: Klatuu
• RE: DateFunction in Query
  • From: Curtis Stevens
• RE: need to show blank values
  • From: instereo911 via AccessMonster.com
• RE: need to show blank values
  • From: KARL DEWEY
• Update Table
  • From: small brother
• RE: getsavedquery
  • From: HENDRY_del_FUEGO via AccessMonster.com
• RE: need to show blank values
  • From: mscertified
• RE: getsavedquery
  • From: Klatuu
• Insert Commas
  • From: jseger22
• Re: How do I return the table structure using an SQL command in a quer
  • From: John Spencer
• Re: Customer Sales Data
  • From: Michel Walsh
• Re: How do I return the table structure using an SQL command in a quer
  • From: Michel Walsh
• Re: Calculate a field in Access, using a formula from a text string
  • From: Jeff Boyce
• Re: How do I return the table structure using an SQL command in a quer
  • From: Jeff Boyce
• RE: getsavedquery
  • From: HENDRY_del_FUEGO via AccessMonster.com
• Re: Cross tab for a fiscal year starting in Oct
  • From: Michel Walsh
• RE: getsavedquery
  • From: HENDRY_del_FUEGO via AccessMonster.com
• RE: DateFunction in Query
  • From: Klatuu
• Calculate a field in Access, using a formula from a text string
  • From: ALF
• RE: getsavedquery
  • From: HENDRY_del_FUEGO via AccessMonster.com
• Re: Cross tab for a fiscal year starting in Oct
  • From: KARL DEWEY
• need to show blank values
  • From: instereo911 via AccessMonster.com
• Re: I cannot open my query in SQL view
  • From: MN
• RE: getsavedquery
  • From: Klatuu
• getsavedquery
  • From: HENDRY_del_FUEGO via AccessMonster.com
• Re: I cannot open my query in SQL view
  • From: MN
• Re: Cross tab for a fiscal year starting in Oct
  • From: Michel Walsh
• Re: union query
  • From: Michel Walsh
• RE: Recording the date and time when a record is modified in Access
  • From: Jerry Whittle
• Re: union query
  • From: Michel Walsh
• Re: to query for proper case text
  • From: John Spencer
• Re: Find Last Yaer's Value
  • From: John Spencer
• Recording the date and time when a record is modified in Access
  • From: duncanjx
• Re: Compare Multiple Fields in Two Tables and Show Whats Different
  • From: KIMA06
• RE: Find Last Yaer's Value
  • From: Jahanzaib
• RE: Another undefined function problem
  • From: frankerin
• Re: Another undefined function problem
  • From: frankerin
• Re: Retrieving query result in code
  • From: Rick Brandt
• Re: Another undefined function problem
  • From: John W . Vinson
• Retrieving query result in code
  • From: Robert
• Re: find records in one table not in another table
  • From: John W . Vinson
• Re: Do I need a Crosstab Query (html)
  • From: Gary Walter
• RE: Selecting unique records from a join query
  • From: Mark E
• RE: Selecting unique records from a join query
  • From: Ken Sheridan
• Re: find records in one table not in another table
  • From: Sharon V
• Selecting unique records from a join query
  • From: Mark E
• Re: Running Month to date query
  • From: DIH
• Re: Running Month to date query
  • From: Ken Sheridan
• Re: Basic Update Query
  • From: John Spencer
• Re: Running Month to date query
  • From: DIH
• SPAM
  • From: Ed Metcalfe
• Re: Compare Multiple Fields in Two Tables and Show Whats Different
  • From: Douglas J. Steele
• Re: Comments in a query
  • From: RoyVidar
• Re: struggling with my left join
  • From: ArielZusya
• Re: Basic Update Query
  • From: Hyder
• SPAM
  • From: Ed Metcalfe
• Re: Comments in a query
  • From: Ed Metcalfe
• Comments in a query
  • From: Daryl
• Re: struggling with my left join
  • From: Ken Snell \(MVP\)
• Re: find records in one table not in another table
  • From: Douglas J. Steele
• 3 day 2 night Travel Certificates. Only 0.35 cents each
  • From: Travelcerts
• RE: Date Help Request
  • From: Ken Sheridan
• Re: NOT operator
  • From: Marshall Barton
• Re: Running Month to date query
  • From: Ken Sheridan
• Re: Running Month to date query
  • From: DIH
• Re: Running Month to date query
  • From: Jeff Boyce
• Running Month to date query
  • From: DIH
• Re: NOT operator
  • From: Allen Browne
• Re: union query
  • From: New_Access
• Re: union query
  • From: New_Access
• Re: Basic Update Query
  • From: Ken Snell \(MVP\)
• Re: Basic Update Query
  • From: John W . Vinson
• Re: concatenate while grouping
  • From: John W . Vinson
• Re: concatenate while grouping
  • From: Marshall Barton
• Re: Basic Update Query
  • From: Hyder
• Re: How do I create a table with data selected via a pass through que.
  • From: John W . Vinson
• Re: Basic Update Query
  • From: Ken Snell \(MVP\)