microsoft.public.access.queries

• Thread Index

---

• Status update query
  • From: rama
• Re: "Record Deleted"
  • From: Gary Walter
• Re: Fikter outrepeated values - IN JUST ONE FIELD
  • From: John Spencer
• Re: Parameter searching all like numbers
  • From: John Spencer
• Re: Calculating Avg with null values
  • From: John Spencer
• Re: Calculating Avg with null values
  • From: John W . Vinson
• Update using Select where fields match
  • From: j.t.w
• Re: how to name field to include a date range...
  • From: John W . Vinson
• Re: Showing Blank fields in Query
  • From: Beginner
• Access freezing as I scroll down queried results
  • From: JJEWELL
• Re: Calculating Avg with null values
  • From: Maggie
• Re: Calculating Avg with null values
  • From: Maggie
• Re: Calculating Avg with null values
  • From: John Spencer
• Re: Microsoft Jet database engine does not recognize...
  • From: Douglas J. Steele
• RE: Using partial dates in a query expression
  • From: KARL DEWEY
• RE: Query Dates by Week Num then String as Date Range
  • From: KARL DEWEY
• Re: Calculating Avg with null values
  • From: Maggie
• Re: Using partial dates in a query expression
  • From: John Spencer
• Re: A rookie needs a patient teacher
  • From: Denise
• Re: Calculating Avg with null values
  • From: John Spencer
• RE: Query Dates by Week Num then String as Date Range
  • From: laknight
• Re: Using partial dates in a query expression
  • From: LaurenM
• RE: Query Dates by Week Num then String as Date Range
  • From: S.Clark
• Re: Finding Average of Time.
  • From: Jeff Boyce
• RE: Record with multiple lines
  • From: S.Clark
• RE: Using OR in a query
  • From: deeds
• Re: Calculating Avg with null values
  • From: Maggie
• Re: Calculating Avg with null values
  • From: Maggie
• Re: Calculating Avg with null values
  • From: John Spencer
• Re: how to name field to include a date range...
  • From: John Spencer
• Re: Using OR in a query
  • From: John Spencer
• Re: Calculating Avg with null values
  • From: John Spencer
• Re: how to name field to include a date range...
  • From: John Spencer
• Re: Concatenate with ORDER BY clause
  • From: John Spencer
• Re: Help with Date Range
  • From: John Spencer
• Re: Need help with my query for comparing two tables?!
  • From: John Spencer
• Re: Help with Date Range
  • From: eoluke
• Re: query construct question
  • From: Michel Walsh
• Re: query construct question
  • From: George Applegate
• Re: Showing Blank fields in Query
  • From: Michel Walsh
• Re: Help with Date Range
  • From: Michel Walsh
• Obtaining a filter from a form
  • From: Leslie Isaacs
• Re: conditional dedupe in Access 2000
  • From: Michel Walsh
• Re: query construct question
  • From: Michel Walsh
• Re: query construct question
  • From: Michel Walsh
• RE: "Record Deleted"
  • From: Pwyd
• Re: Query for weeks, getting aggregate func. error
  • From: Michel Walsh
• Re: Show any activity falling between 2 time points.
  • From: John Spencer
• conditional dedupe in Access 2000
  • From: not_an_exit
• Re: Repeat the value from the previous record in a query
  • From: Allen Browne
• Re: Automatically assigning specimens to queries/tables?
  • From: John W . Vinson
• Trouble with a query
  • From: schongresh
• Re: Compare date to previous date to see if 6 weeks have past
  • From: John Spencer
• Re: Can't access table Error Message from Microsoft Query
  • From: Tony Toews [MVP]
• Re: Using partial dates in a query expression
  • From: John Spencer
• RE: Using partial dates in a query expression
  • From: KARL DEWEY
• Re: parameter query for greater than date
  • From: John Spencer
• Re: Current month IIf statement.
  • From: John Spencer
• RE: parameter query for greater than date
  • From: KARL DEWEY
• Re: Order/identity/row number help needed
  • From: KARL DEWEY
• Re: Update Queries
  • From: John Spencer
• Repeat the value from the previous record in a query
  • From: Roger
• Re: On Time/Late Response
  • From: John Spencer
• Re: DLookUp in a Query
  • From: DS
• Re: "Record Deleted"
  • From: Gary Walter
• Re: Compare date to previous date to see if 6 weeks have past
  • From: raskew via AccessMonster.com
• Record with multiple lines
  • From: jenniferspnc
• Re: "Record Deleted"
  • From: Gary Walter
• Re: query construct question
  • From: George Applegate
• Re: query construct question
  • From: George Applegate
• Re: Sum Total of Numeric Field
  • From: Jeff Boyce
• Re: Query for weeks, getting aggregate func. error
  • From: MartyO
• RE: parameter query for greater than date
  • From: tjb
• RE: Updatable Table filtered by Query
  • From: Ripper
• Re: #Error
  • From: S.Clark
• RE: parameter query for greater than date
  • From: KARL DEWEY
• RE: Order/identity/row number help needed
  • From: zizi2007 via AccessMonster.com
• Re: #Error
  • From: SJW_OST
• Re: Order/identity/row number help needed
  • From: zizi2007 via AccessMonster.com
• Re: Order/identity/row number help needed
  • From: zizi2007 via AccessMonster.com
• Re: #Error
  • From: SJW_OST
• Re: #Error
  • From: KARL DEWEY
• Query tables where string of data is other table
  • From: mralmackay
• Re: Order/identity/row number help needed
  • From: Michel Walsh
• Re: Query for weeks, getting aggregate func. error
  • From: Michel Walsh
• RE: parameter query for greater than date
  • From: KARL DEWEY
• Order/identity/row number help needed
  • From: zizi2007 via AccessMonster.com
• RE: Convert Excel formula to Access Query formula
  • From: SJW_OST
• Re: #Error
  • From: Michel Walsh
• RE: Convert Excel formula to Access Query formula
  • From: S.Clark
• Re: Query for weeks, getting aggregate func. error
  • From: Michel Walsh
• Re: Two Data Series in CrossTab Query
  • From: Michel Walsh
• Re: Update a field based upon the content of another field in other ta
  • From: Michel Walsh
• Re: Current month IIf statement.
  • From: Michel Walsh
• Re: A rookie needs a patient teacher
  • From: Jerry Whittle
• Query is blank if one subquery has no records
  • From: RussCRM
• RE: Convert Excel formula to Access Query formula
  • From: SJW_OST
• Re: Duplicate Query - How to Remove Duplicates from Original Table
  • From: Dorothy
• Re: A rookie needs a patient teacher
  • From: Denise
• Re: A rookie needs a patient teacher
  • From: raskew via AccessMonster.com
• RE: Convert GPS Date and Time
  • From: Scott
• Re: Query will not populate with data
  • From: Jeff Boyce
• RE: Cross Tab Query and a Date Form
  • From: KARL DEWEY
• RE: A rookie needs a patient teacher
  • From: Denise
• Re: A rookie needs a patient teacher
  • From: raskew via AccessMonster.com
• RE: A rookie needs a patient teacher
  • From: Jerry Whittle
• Re: Aggregate function error
  • From: Michel Walsh
• Re: query construct question
  • From: Michel Walsh
• RE: Aggregate function error
  • From: Jerry Whittle
• RE: FORMAT THE DATA TO ONE FEILD???????
  • From: Lanny
• Re: "Record Deleted"
  • From: Pwyd
• DLookUp in a Query
  • From: DS
• Re: "Record Deleted"
  • From: Gary Walter
• Aggregate function error
  • From: Yam84
• Update a field based upon the content of another field in other ta
  • From: Wendy
• query construct question
  • From: George Applegate
• Re: Query will not populate with data
  • From: Amy Schmid
• Re: Cross Tab Query and Date Part
  • From: Gary Walter
• Re: Automatically assigning specimens to queries/tables?
  • From: park . walter
• RE: Error with Append Query
  • From: S.Clark
• Re: Query will not populate with data
  • From: Amy Schmid
• RE: Convert Excel formula to Access Query formula
  • From: S.Clark
• RE: Cross Tab Query and a Date Form
  • From: T Kelley
• RE: Cross Tab Query and a Date Form
  • From: T Kelley
• Re: How do I write an SQL statement to return the 2nd highest valu
  • From: Michel Walsh
• RE: Subform Querie
  • From: KevinPreston via AccessMonster.com
• RE: Convert Excel formula to Access Query formula
  • From: SJW_OST
• Re: Count Problem
  • From: Douglas J. Steele
• Re: Compare table for changed data
  • From: Jeff Boyce
• Re: Find Missing data
  • From: Jeff Boyce
• Re: Query will not populate with data
  • From: Jeff Boyce
• Re: On Time/Late Response
  • From: Jeff Boyce
• Re: How do I create a query which is only a snapshot - no updating
  • From: Jeff Boyce
• Re: Count Problem
  • From: TommoUK
• Re: Automatically assigning specimens to queries/tables?
  • From: John W . Vinson
• Re: Grouping Into 1/2 Hour Time Buckets
  • From: junior33
• Re: running sum in query
  • From: Michel Walsh
• Re: Access Query
  • From: Michel Walsh
• Re: How do I write an SQL statement to return the 2nd highest valu
  • From: Michel Walsh
• RE: Access Query
  • From: KARL DEWEY
• Re: How do I write an SQL statement to return the 2nd highest valu
  • From: Michel Walsh
• Re: Grouping Into 1/2 Hour Time Buckets
  • From: raskew via AccessMonster.com
• Re: Electronic TimePro Timeclock Database Question
  • From: Ron2006
• Grouping Into 1/2 Hour Time Buckets
  • From: junior33
• Re: Group By dates
  • From: Laura1 via AccessMonster.com
• Re: CONCATENATE multiple rows
  • From: Laurie
• Re: query does not display all records
  • From: Chris O'C via AccessMonster.com
• running sum in query
  • From: RobD
• Mileage Query
  • From: schongresh
• Re: query does not display all records
  • From: MStadnik
• Re: How do I write an SQL statement to return the 2nd highest valu
  • From: CMA
• RE: error "Type mismatch in expression" when trying to run a query
  • From: KARL DEWEY
• RE: Subform Querie
  • From: Ken Sheridan
• RE: How can I count the number of individuals?
  • From: Ken Sheridan
• RE: help with a query
  • From: Ken Sheridan
• Re: query does not display all records
  • From: Chris O'C via AccessMonster.com
• Re: query does not display all records
  • From: MStadnik
• RE: error "Type mismatch in expression" when trying to run a query
  • From: Amy Schmid
• RE: error "Type mismatch in expression" when trying to run a query
  • From: KARL DEWEY
• Re: query does not display all records
  • From: Chris O'C via AccessMonster.com
• Re: How do I write an SQL statement to return the 2nd highest valu
  • From: Michel Walsh
• Re: True, False, or All
  • From: Michel Walsh
• RE: Duplicate Query - How to Remove Duplicates from Original Table
  • From: digitalmuse
• RE: Count Weeks Between Start and End Date
  • From: KARL DEWEY
• RE: error "Type mismatch in expression" when trying to run a query
  • From: Amy Schmid
• Re: How do I write an SQL statement to return the 2nd highest valu
  • From: CMA
• Re: True, False, or All
  • From: ProteanBeing via AccessMonster.com
• Re: You are persistant
  • From: Michel Walsh
• Re: Using Switch function properly
  • From: Michel Walsh
• RE: error "Type mismatch in expression" when trying to run a query
  • From: KARL DEWEY
• Re: How do I write an SQL statement to return the 2nd highest valu
  • From: Michel Walsh
• Re: How can I count the number of individuals?
  • From: Michel Walsh
• RE: Cross Tab Query and Date Part
  • From: T Kelley
• Re: the SUM function.. please help, assignment due
  • From: Chris O'C via AccessMonster.com
• Re: the SUM function.. please help, assignment due
  • From: Chris O'C via AccessMonster.com
• Re: the SUM function.. please help, assignment due
  • From: Chris O'C via AccessMonster.com
• Re: the SUM function.. please help, assignment due
  • From: Chris O'C via AccessMonster.com
• Re: Using Switch function properly
  • From: Student Databaser
• Re: Using Switch function properly
  • From: Ken Snell \(MVP\)
• Re: How do I get totals of rows values in query?
  • From: Jeff Boyce
• Re: Using * as a literal in query criteria
  • From: Michel Walsh
• Cross Tab Query and a Date Form
  • From: T Kelley
• Re: Automatically assigning specimens to queries/tables?
  • From: park . walter
• Subform Querie
  • From: KevinPreston via AccessMonster.com
• Re: Difference in Date/Time
  • From: John Spencer
• Re: Group By dates
  • From: John Spencer
• Re: Can't access table Error Message from Microsoft Query
  • From: lack32
• A query with a dialog box
  • From: kerenshor
• RE: Can't access table Error Message from Microsoft Query
  • From: Vish
• Re: How do I get Totals of rows values in query?
  • From: John W . Vinson
• You are persistant
  • From: griz
• Re: Find top 2 by group
  • From: Grizy
• Group By dates
  • From: Laura1 via AccessMonster.com
• Re: CONCATENATE multiple rows
  • From: John Spencer
• RE: Link Query
  • From: Irene
• Re: Dmin
  • From: John Spencer
• Re: Automatically assigning specimens to queries/tables?
  • From: John W . Vinson
• Re: Dmin
  • From: John W . Vinson
• Re: How do I calculate totals in a query
  • From: John W . Vinson
• Re: Count Problem
  • From: TommoUK
• RE: CONCATENATE multiple rows
  • From: Laurie
• CONCATENATE multiple rows
  • From: Laurie
• Re: True, False, or All
  • From: ProteanBeing
• Re: Using * as a literal in query criteria
  • From: DanR
• Re: SELECT string with table name of two words problem
  • From: Chris O'C via AccessMonster.com
• Re: SELECT string with table name of two words problem
  • From: Jeff Boyce
• Re: SELECT string with table name of two words problem
  • From: Chris O'C via AccessMonster.com
• Re: SELECT string with table name of two words problem
  • From: Michel Walsh
• Re: grouping by 100's
  • From: norm
• Re: SELECT string with table name of two words problem
  • From: Dave F.
• Re: Top Values Not Working
  • From: Alex
• Re: Ranking
  • From: Michel Walsh
• Re: Top Values Not Working
  • From: Michel Walsh
• Re: Using * as a literal in query criteria
  • From: Michel Walsh
• Re: SELECT string with table name of two words problem
  • From: Dave F.
• Re: find and replace situation
  • From: John W . Vinson
• Re: Top Values Not Working
  • From: Alex
• Re: Ranking
  • From: Alex
• Re: Count Weeks Between Start and End Date
  • From: John W . Vinson
• Re: Calculate the difference for a record over time
  • From: Michel Walsh
• Re: SELECT string with table name of two words problem
  • From: Chris O'C via AccessMonster.com
• Re: Using * as a literal in query criteria
  • From: DanR
• Re: SELECT string with table name of two words problem
  • From: Michel Walsh
• SELECT string with table name of two words problem
  • From: Dave F.
• Re: Top Values Not Working
  • From: Michel Walsh
• Re: Ranking
  • From: Michel Walsh
• Re: True, False, or All
  • From: Michel Walsh
• RE: How do I calculate totals in a query
  • From: Golfinray
• Re: Using * as a literal in query criteria
  • From: Michel Walsh
• Automatically assigning specimens to queries/tables?
  • From: park . walter
• True, False, or All
  • From: ProteanBeing
• Re: Query to find most recent date
  • From: Klatuu
• Re: Query to find most recent date
  • From: LadyIlsebet
• How do I calculate totals in a query
  • From: cna48
• Re: I need an expert - link not displaying correct data
  • From: Chris O'C via AccessMonster.com
• Re: Query Criteria: How to handle >9 "or" conditions?
  • From: Chris O'C via AccessMonster.com
• RE: find and replace situation
  • From: JWCrosby
• RE: Link Query
  • From: Ranjit kurian
• Re: Query Criteria: How to handle >9 "or" conditions?
  • From: Jimbo213
• Re: I need an expert - link not displaying correct data
  • From: mcarter
• Re: Query Criteria: How to handle >9 "or" conditions?
  • From: Chris O'C via AccessMonster.com
• Re: NZ function
  • From: John Spencer
• Re: Query Criteria: How to handle >9 "or" conditions?
  • From: John Spencer
• Re: I need an expert - link not displaying correct data
  • From: Chris O'C via AccessMonster.com
• Count Weeks Between Start and End Date
  • From: Intui_Sol
• RE: Differentiate same name columns in different tables
  • From: S.Clark
• Re: Crosstab query for chart
  • From: Alex
• Re: Rounding Up
  • From: RedHeadedMonster via AccessMonster.com
• Re: Need Sum of Weeks Between 2 Dates
  • From: Intui_Sol
• Re: Query to find most recent date
  • From: Klatuu
• Re: Select Case - SQL
  • From: auujxa2 via AccessMonster.com
• Re: Query to find most recent date
  • From: LadyIlsebet
• Re: Select Case - SQL
  • From: Michel Walsh
• Re: Compare this month to last month
  • From: Michel Walsh
• Re: Count Problem
  • From: John Spencer
• Re: Highest and Lowest Numbner
  • From: Rick Brandt
• Re: Query: Create column that is equal to two other columns multiplica
  • From: raskew via AccessMonster.com
• Re: Highest and Lowest Numbner
  • From: Nur Muhammad
• Re: Find Minimum value for each change in part number
  • From: John W . Vinson
• Re: linearize data
  • From: John W . Vinson
• Re: grouping by 100's
  • From: John W . Vinson
• Re: grouping by 100's
  • From: raskew via AccessMonster.com
• Re: Expression Formula
  • From: raskew via AccessMonster.com
• Re: Access 2007 Query - "Do I wnat to Save"?
  • From: John W . Vinson
• grouping by 100's
  • From: norm
• Re: Compare this month to last month
  • From: acss
• Re: VBA query help - I've never done this before...
  • From: Opal
• Select Case - SQL
  • From: auujxa2 via AccessMonster.com
• Re: VBA query help - I've never done this before...
  • From: Michel Walsh
• VBA query help - I've never done this before...
  • From: Opal
• Re: Compare this month to last month
  • From: Michel Walsh
• Re: Append query (insert into) changes with Union query
  • From: hannes
• Re: Append query (insert into) changes with Union query
  • From: John Spencer
• Re: Compare this month to last month
  • From: acss
• Append query (insert into) changes with Union query
  • From: hannes
• Re: Compare this month to last month
  • From: Michel Walsh
• Re: Rounding Up
  • From: Michel Walsh
• Re: Rounding Up
  • From: RedHeadedMonster via AccessMonster.com
• Re: Split database
  • From: Michel Walsh
• Re: Crosstab query for chart
  • From: Michel Walsh
• Re: How to convert this to an Access query?
  • From: Michel Walsh
• Re: Rounding Up
  • From: RedHeadedMonster via AccessMonster.com
• RE: address book from excel to access
  • From: mhmaid
• Re: Highest and Lowest Numbner
  • From: Rick Brandt
• Re: Find top 2 by group
  • From: raskew via AccessMonster.com
• Re: Opening Wizards
  • From: Qury
• RE: Link Query
  • From: Irene
• Split database
  • From: kuria
• RE: Dynamic Query, Using ListBox
  • From: ryguy7272
• Re: Multiple queries based off of the same criteria (input)
  • From: John W . Vinson
• Multiple queries based off of the same criteria (input)
  • From: Brett
• Re: Multiple Table Query
  • From: dazoloko via AccessMonster.com
• Re: number not in both the query
  • From: Evi
• Re: Finding Closest Match To A Number Then Returning Field Value Linked To Number
  • From: Ken Snell \(MVP\)
• Re: number not in both the query
  • From: Ken Snell \(MVP\)
• Re: number not in both the query
  • From: Chris O'C via AccessMonster.com
• Re: How to convert this to an Access query?
  • From: Chris O'C via AccessMonster.com
• Re: Compare records in same table
  • From: John Spencer
• Re: How to convert this to an Access query?
  • From: Rick Brandt
• Re: Help with append query
  • From: John Spencer
• Re: How to convert this to an Access query?
  • From: OK
• Re: Date format to display month name
  • From: Chris O'C via AccessMonster.com
• Re: Date format to display month name
  • From: Evi
• Date format to display month name
  • From: reji
• Re: Opening Wizards
  • From: Chris O'C via AccessMonster.com
• Re: Help with append query
  • From: Rick Brandt
• Re: Help with append query
  • From: magicdds
• Re: Help with append query
  • From: Rick Brandt
• Re: Compare records in same table
  • From: Douglas J. Steele
• Its Still Building
  • From: Timithy Reid
• Re: SQL and design mode are different
  • From: Rick Brandt
• Re: SQL and design mode are different
  • From: Chris O'C via AccessMonster.com
• Re: SQL and design mode are different
  • From: John Spencer
• Re: SQL and design mode are different
  • From: Jean-Paul
• Re: How to convert this to an Access query?
  • From: Chris O'C via AccessMonster.com
• Re: SQL and design mode are different
  • From: Chris O'C via AccessMonster.com
• SQL and design mode are different
  • From: Jean-Paul
• Re: How to convert this to an Access query?
  • From: Jeff Boyce
• Re: Iff Statements
  • From: JezLisle via AccessMonster.com
• Re: DateDiff vs a minus sum
  • From: Douglas J. Steele
• Finding Closest Match To A Number Then Returning Field Value Linked To Number
  • From: tbg
• Re: Check if record exists
  • From: Jeanette Cunningham
• Re: Inserting Rows in another table automatically
  • From: Evi
• Re: Query Quandry
  • From: Evi
• Re: DateDiff vs a minus sum
  • From: Evi
• Need Sum of Weeks Between 2 Dates
  • From: Intui_Sol
• Re: Subqueries and Outer Joins
  • From: Kirk P.
• Re: Crosstab query for chart
  • From: Alex
• Re: Rounding Up
  • From: John Spencer
• Re: Subqueries and Outer Joins
  • From: John Spencer
• Re: Convert text date to date/time
  • From: Michel Walsh
• Re: datediff
  • From: Ron2006
• Re: Crosstab query for chart
  • From: Michel Walsh
• Re: What's Wrong With This Query?
  • From: Chris O'C via AccessMonster.com
• Re: Len Function
  • From: John W . Vinson
• RE: Dynamic Query, Using ListBox
  • From: ryguy7272
• Re: What's Wrong With This Query?
  • From: Robert T
• Re: Crosstab query for chart
  • From: Alex
• Re: Rounding Up
  • From: RedHeadedMonster via AccessMonster.com
• Rounding Up
  • From: RedHeadedMonster via AccessMonster.com
• Re: How to use a parameter query with multiple values?
  • From: Michel Walsh
• Re: What's Wrong With This Query?
  • From: Chris O'C via AccessMonster.com
• Re: Crosstab query for chart
  • From: Michel Walsh
• Re: How to use a parameter query with multiple values?
  • From: AJ
• Re: What's Wrong With This Query?
  • From: Robert T
• Re: What's Wrong With This Query?
  • From: Robert T
• Re: Crosstab query for chart
  • From: Alex
• Re: What's Wrong With This Query?
  • From: John Spencer
• Re: Union query?
  • From: John Spencer
• Re: What's Wrong With This Query?
  • From: Robert T
• Re: Query Quandry
  • From: Matt Winberry
• Re: Union query?
  • From: Leslie Isaacs
• Re: Crosstab query for chart
  • From: Michel Walsh
• Re: How to convert this to an Access query?
  • From: John Spencer
• Re: How to convert this to an Access query?
  • From: Jeff Boyce
• Re: How to convert this to an Access query?
  • From: carlos
• Re: Union query?
  • From: John Spencer
• Re: Multiple Table Query
  • From: Michel Walsh
• Re: Use single SQL statement instead of 2 saved queries?
  • From: John Spencer
• RE: merge data in a query
  • From: Jerry Whittle
• Re: Sequence numbers
  • From: Michel Walsh
• RE: What's Wrong With This Query?
  • From: scubadiver
• Multiple Table Query
  • From: dazoloko via AccessMonster.com
• Re: What's Wrong With This Query?
  • From: Chris O'C via AccessMonster.com
• Re: Union query?
  • From: Leslie Isaacs
• Re: How to convert this to an Access query?
  • From: OK
• Re: Sequence numbers
  • From: Ryan
• How to convert this to an Access query?
  • From: OK
• Re: Criteria - show records in text field1 based on a yes/no field
  • From: jriccardi
• Re: datediff
  • From: Ron2006
• Re: Split a Table
  • From: John Spencer
• Re: Criteria - show records in text field1 based on a yes/no field
  • From: John Spencer
• Re: Iff Statements
  • From: John Spencer
• Re: Union query?
  • From: John Spencer
• Re: DateDiff vs a minus sum
  • From: Michel Walsh
• RE: PLEASE HELP. Reposting
  • From: scubadiver
• Re: How to use a parameter query with multiple values?
  • From: Michel Walsh
• RE: Iff Statements
  • From: JezLisle via AccessMonster.com
• RE: using identical variables from two different tables in a query
  • From: sarahphonics
• Re: Union query?
  • From: Leslie Isaacs
• RE: Len Function
  • From: Max
• RE: Criteria does not work on a calculated expression
  • From: CDG via AccessMonster.com
• Len Function
  • From: mohsin via AccessMonster.com
• Re: Split a Table
  • From: Ken Snell \(MVP\)
• Re: Not Like Operator
  • From: John W . Vinson
• Re: Criteria - show records in text field1 based on a yes/no field
  • From: jriccardi
• Dynamic Query, Using ListBox
  • From: ryguy7272
• Re: Criteria - show records in text field1 based on a yes/no field2
  • From: John Spencer
• Re: counting random numbers in a field.
  • From: Jeff Boyce
• Re: Use single SQL statement instead of 2 saved queries?
  • From: John Spencer
• Re: How to use a parameter query with multiple values?
  • From: AJ
• Re: Syntax Error
  • From: Douglas J. Steele
• Re: duplicate rows returned in query with inner join and where cla
  • From: Michel Walsh
• Re: DateDiff vs a minus sum
  • From: Douglas J. Steele
• Re: DateDiff vs a minus sum
  • From: Michel Walsh
• Criteria does not work on a calculated expression
  • From: CDG via AccessMonster.com
• Re: Using IIf and DateDiff #Error
  • From: Opal
• DateDiff vs a minus sum
  • From: Evi
• Re: Using IIf and DateDiff #Error
  • From: Evi
• Re: Using IIf and DateDiff #Error
  • From: Michel Walsh
• Re: duplicate rows returned in query with inner join and where clause
  • From: Michel Walsh
• Using IIf and DateDiff #Error
  • From: Opal
• Re: How to use a parameter query with multiple values?
  • From: Michel Walsh
• Re: Sequence numbers
  • From: Michel Walsh
• Re: Need help with query
  • From: Michel Walsh
• Re: How do I embed hyper text formatting within a text field?
  • From: Michel Walsh
• Re: Query to find most recent date
  • From: Klatuu
• Re: How to use a parameter query with multiple values?
  • From: AJ
• Re: Query to find most recent date
  • From: LadyIlsebet
• Re: Query to find most recent date
  • From: Klatuu
• RE: Query Guru's, Please help Sequence Numbers in Query
  • From: KARL DEWEY
• RE: Iff Statements
  • From: Klatuu
• Re: Query to find most recent date
  • From: LadyIlsebet
• RE: Iff Statements
  • From: JezLisle via AccessMonster.com
• RE: using identical variables from two different tables in a query
  • From: KARL DEWEY
• Re: Input
  • From: fredg
• RE: Urgent - Create column on query depending on another column text
  • From: Jerry Whittle
• RE: Merge 2 different tables
  • From: Jerry Whittle
• RE: Query to find most recent date
  • From: Klatuu
• Re: pagebreak in queries
  • From: PhilT via AccessMonster.com
• Re: Union query?
  • From: Chris O'C via AccessMonster.com
• Re: Simple Select Query - To Complicated?
  • From: Love Buzz
• RE: unique records
  • From: KARL DEWEY
• Iff Statements
  • From: JezLisle via AccessMonster.com
• Re: Union query?
  • From: Leslie Isaacs
• Re: Changing date fotmats & calculating date - HELP
  • From: Robs
• Query to find most recent date
  • From: LadyIlsebet
• RE: unique records
  • From: tina
• Re: Simple Select Query - To Complicated?
  • From: John Spencer
• Re: similar situation
  • From: strive4peace
• Re: Changing date fotmats & calculating date - HELP
  • From: John Spencer
• Re: similar situation
  • From: Julie
• Re: Results multiplied by 3??
  • From: Love Buzz
• Re: Showig differences in Month to Month data from data in the sam
  • From: strive4peace
• Re: Showig differences in Month to Month data from data in the sam
  • From: strive4peace
• Re: IIf statement with multiple Else conditions?
  • From: Colleen
• Re: Showig differences in Month to Month data from data in the sam
  • From: John
• Re: Duplicate query acrros 4 fields
  • From: Jeff Boyce
• Re: Showig differences in Month to Month data from data in the sam
  • From: strive4peace
• Re: Update query question
  • From: Jeff Boyce
• Re: Union query?
  • From: Chris O'C via AccessMonster.com
• Re: Showig differences in Month to Month data from data in the sam
  • From: John
• Union query?
  • From: Leslie Isaacs
• Re: Changing date fotmats & calculating date - HELP
  • From: Robs
• using identical variables from two different tables in a query
  • From: sarahphonics
• Re: Changing date fotmats & calculating date - HELP
  • From: John Spencer
• Re: Changing date fotmats & calculating date - HELP
  • From: John Spencer
• Re: Insert Query to a Table
  • From: John Spencer
• Re: Not Like Operator
  • From: John Spencer
• Some answers 3 [TIC]
  • From: Jamie Collins
• Re: similar situation
  • From: strive4peace
• Re: calculate day from date
  • From: littleskinny83
• RE: Insert Query to a Table
  • From: Wayne-I-M
• Re: Query Quandry
  • From: Evi
• RE: Insert Query to a Table
  • From: Wayne-I-M
• graphs
  • From: Hope
• RE: Hyperlink to a report from a record in a table
  • From: Rob M.
• Re: Group by Weeks of the Month
  • From: Dale Fye
• Re: Results multiplied by 3??
  • From: Jeff Boyce
• Re: Not Like Operator
  • From: Jeff Boyce
• Re: comparing tables
  • From: Jeff Boyce
• Re: similar situation
  • From: strive4peace
• Re: Query Quandry
  • From: Matt Winberry
• Re: selecting groups of records
  • From: John Spencer
• Re: Query Quandry
  • From: Evi
• Re: similar situation
  • From: Julie
• Re: Row fix-up/updatable join on linked tables broken in Access 2007?
  • From: Sir Lawrence
• Re: Append Query - How?
  • From: Evi
• Re: pagebreak in queries
  • From: Lupe
• Re: pagebreak in queries
  • From: PhilT via AccessMonster.com
• Re: Expression Formula
  • From: rciolkosz
• Re: Expression Formula
  • From: fredg
• Re: Expression Formula
  • From: raskew via AccessMonster.com
• Re: IIf statement with multiple Else conditions?
  • From: fredg
• Re: IIf statement with multiple Else conditions?
  • From: PhilT via AccessMonster.com
• Re: Expression Formula
  • From: Rick Brandt
• RE: selecting groups of records
  • From: Dale Fye
• IIf statement with multiple Else conditions?
  • From: Bill C
• Summarize Data
  • From: mikebres
• RE: SQL for changing number into text without UPDATE
  • From: Student Databaser
• Re: SQL for changing number into text without UPDATE
  • From: John Spencer
• Re: Comparing Dates
  • From: John Spencer
• Re: Unique Records
  • From: John Spencer
• Re: Can you use the Like statement in a crosstab query criteria ?
  • From: John Spencer
• Re: Sorting on an expression
  • From: John Spencer
• Re: calculate day from date
  • From: Tom Lake
• Re: Comparing Dates
  • From: Dale Fye
• Re: Comparing Dates
  • From: Jeff Boyce
• Re: Crosstab Query??
  • From: Michel Walsh
• Re: Sorting on an expression
  • From: KARL DEWEY
• Re: Crosstab Query??
  • From: smith_gw
• Re: Comparing Dates
  • From: Jeff Boyce
• Comparing Dates
  • From: Public
• Re: Crosstab Query??
  • From: Michel Walsh
• Re: Blank result, want a zero
  • From: Michel Walsh
• Re: Update query question
  • From: OldEnough
• Re: Update query question
  • From: Jeff Boyce
• Re: Duplicate query acrros 4 fields
  • From: Jeff Boyce
• Re: DSUM Error
  • From: NeoFax
• Re: Multiple Aggregate Functions
  • From: Michel Walsh
• Re: Duplicate query acrros 4 fields
  • From: Nogger-01
• Re: Syntax Error
  • From: auujxa2 via AccessMonster.com
• Re: Sorting on an expression
  • From: Mr-Re Man
• Re: workingdays in Acess
  • From: Ron2006
• Re: workingdays in Acess
  • From: Ron2006
• workingdays in Acess
  • From: Johannes
• Re: Sorting on an expression
  • From: John Spencer
• Re: Left Outer Join - With Two conditions
  • From: John Spencer
• Re: Multiple Aggregate Functions
  • From: John Spencer
• Re: Count Distinct displayed on subform
  • From: John Spencer
• RE: Merge 2 different tables
  • From: JezLisle via AccessMonster.com
• Re: Multiple Aggregate Functions
  • From: Michel Walsh
• Multiple Aggregate Functions
  • From: Public
• Update query question
  • From: OldEnough
• Re: calculate day from date
  • From: John W . Vinson
• calculate day from date
  • From: littleskinny83
• RE: In an access Query how do you get data for the current month
  • From: KARL DEWEY
• Re: In an access Query how do you get data for the current month
  • From: raskew via AccessMonster.com
• In an access Query how do you get data for the current month
  • From: Dram
• Re: Date()-14
  • From: John Spencer
• Re: Syntax Error
  • From: Douglas J. Steele
• Syntax Error
  • From: auujxa2 via AccessMonster.com
• Date()-14
  • From: Jacinda
• Concatenate WHERE Criteria Question
  • From: Ray Todd Jr
• Count Distinct displayed on subform
  • From: gmazza via AccessMonster.com
• RE: Group by week
  • From: Jerry Whittle
• RE: Group by week
  • From: Alex
• RE: Getting Multiple Owners Names for Single Pieces of Property
  • From: Ray Todd Jr
• RE: Query Resulting in Duplicate Records
  • From: NetworkTrade
• RE: Query Resulting in Duplicate Records
  • From: Singinbeauty
• RE: Query Resulting in Duplicate Records
  • From: NetworkTrade
• RE: Run a Query from a Form
  • From: Ed Cones
• RE: subreport problems with multivalued fields
  • From: NetworkTrade
• RE: finding duplicated id in a query
  • From: Klatuu
• RE: Getting Multiple Owners Names for Single Pieces of Property
  • From: Ray Todd Jr
• RE: Group by week
  • From: Jerry Whittle
• RE: Query Help?
  • From: Lisa
• OT: implicit cast
  • From: Gary Walter
• Group by week
  • From: Alex
• RE: Query Help?
  • From: Klatuu
• RE: Query Help?
  • From: Lisa
• RE: DSUM Error
  • From: Klatuu
• RE: DSUM Error
  • From: Dennis
• RE: Formatting a text file
  • From: Mark
• Re: Query does not include specified expression
  • From: Love Buzz
• Query Resulting in Duplicate Records
  • From: Singinbeauty
• Re: If Statement In Query
  • From: strive4peace
• Re: Finding First Alphabetical Character in a String
  • From: meangene
• DSUM Error
  • From: NeoFax
• Re: Update Query to Update Info from One Table to Another
  • From: Michel Walsh
• Re: Displaying query results in a form
  • From: Michel Walsh
• Re: Invalid use of null
  • From: Michel Walsh
• Re: Update or Append query
  • From: Michel Walsh
• RE: Update Query to Update Info from One Table to Another
  • From: Mytara
• RE: Update Query to Update Info from One Table to Another
  • From: Duane Hookom
• RE: Update Query to Update Info from One Table to Another
  • From: Duane Hookom
• Re: Matching a product field to another field that are not the sam
  • From: Michel Walsh
• Re: Group by Weeks of the Month
  • From: MartyO
• RE: Query Help?
  • From: Klatuu
• Re: Update Query
  • From: Michel Walsh
• RE: Query Help?
  • From: Lisa
• Update Query to Update Info from One Table to Another
  • From: Mytara
• Re: Run a Query from a Form
  • From: Evi
• Re: ms outlook arrives with wrong date and time
  • From: John Spencer
• Re: Left function query error
  • From: John Spencer
• Re: Query
  • From: John Spencer
• Re: Invalid use of null
  • From: John Spencer
• subreport problems with multivalued fields
  • From: Intouch
• Re: count selected fields in a query
  • From: Ra
• Re: Formatting a text file
  • From: John Spencer
• Re: Add function to a query
  • From: John Spencer
• Re: Query does not include specified expression
  • From: John Spencer
• Re: Group by Weeks of the Month
  • From: John Spencer
• ms outlook arrives with wrong date and time
  • From: scream
• Displaying query results in a form
  • From: Andy Wall
• RE: Left function query error
  • From: bkwilliams
• Left function query error
  • From: bkwilliams
• Re: Formatting a text file
  • From: Vsn
• Re: Run a Query from a Form
  • From: JBad
• Re: Group by Weeks of the Month
  • From: John W . Vinson
• Re: Group by Weeks of the Month
  • From: MartyO
• RE: Two Different Tables one Query
  • From: Steve Sanford
• RE: Two Different Tables one Query
  • From: Duane Hookom
• RE: Getting Multiple Owners Names for Single Pieces of Property
  • From: Duane Hookom
• RE: use an expression as a field
  • From: Duane Hookom
• Two Different Tables one Query
  • From: Love Buzz
• Re: Invalid use of null
  • From: Vsn
• RE: use an expression as a field
  • From: Joseph
• Re: Query
  • From: raskew via AccessMonster.com
• RE: Query
  • From: ScubaDee
• RE: Getting Multiple Owners Names for Single Pieces of Property
  • From: Ray Todd Jr
• Query
  • From: ScubaDee
• Invalid use of null
  • From: RobertG
• Re: If Statement In Query
  • From: DS
• Re: Query to lookup from external wordlist for match
  • From: Jeff Boyce
• Re: Group by Weeks of the Month
  • From: Dale Fye
• Re: Urgen Query Help Needed
  • From: Evi
• Re: Query does not include specified expression
  • From: Love Buzz
• Formatting a text file
  • From: Mark
• Urgen Query Help Needed
  • From: tmdrake
• RE: Add function to a query
  • From: Duane Hookom
• RE: Getting Multiple Owners Names for Single Pieces of Property
  • From: Duane Hookom
• RE: finding duplicated id in a query
  • From: Hlarkin
• RE: address book from excel to access
  • From: KARL DEWEY
• RE: Date fields break GROUP By or ORDER By clauses
  • From: KARL DEWEY
• RE: Getting Multiple Owners Names for Single Pieces of Property
  • From: Ray Todd Jr
• Re: DB Query - search
  • From: Evi
• RE: address book from excel to access
  • From: KARL DEWEY
• Re: Show last date
  • From: instereo911 via AccessMonster.com
• Re: Run a Query from a Form
  • From: Evi
• Add function to a query
  • From: Radhika
• Re: Query does not include specified expression
  • From: John Spencer
• Re: count selected fields in a query
  • From: John Spencer
• RE: Query Help?
  • From: Klatuu
• Re: Query to lookup from external wordlist for match
  • From: John Spencer
• Date fields break GROUP By or ORDER By clauses
  • From: colin_e
• RE: Query Help?
  • From: Lisa
• Re: Show last date
  • From: John Spencer
• address book from excel to access
  • From: mhmaid
• Re: Query does not include specified expression
  • From: Love Buzz
• RE: Query Help?
  • From: Klatuu
• RE: Query Help?
  • From: Lisa
• RE: finding duplicated id in a query
  • From: Klatuu
• RE: Query to lookup from external wordlist for match
  • From: Klatuu
• RE: Query Help?
  • From: Klatuu
• count selected fields in a query
  • From: Ra
• RE: Query Help?
  • From: Lisa
• Query to lookup from external wordlist for match
  • From: elementdesign
• Re: Show last date
  • From: Jeff Boyce
• Show last date
  • From: instereo911 via AccessMonster.com
• Re: Replace on PART of the Text in a COMMENT field ???
  • From: kev100 via AccessMonster.com
• RE: Problem with a query in Access 2007
  • From: KARL DEWEY
• RE: Query/Function/Parameter Troubles...
  • From: RobertG
• Re: If Statement In Query
  • From: strive4peace
• Problem with a query in Access 2007
  • From: Lilian
• finding duplicated id in a query
  • From: Hlarkin
• Re: Query does not include specified expression
  • From: John Spencer
• Query does not include specified expression
  • From: Love Buzz
• Re: If Statement In Query
  • From: DS
• Re: Bug in ODBC?
  • From: Knox
• RE: mail merge
  • From: Franklin Smith
• Re: IN-Predicate means OR - I need AND
  • From: candide_sh
• RE: Code
  • From: Khartoum
• Update or Append query
  • From: ChuckW
• Update Query
  • From: Craig
• RE: Code
  • From: Khartoum
• Re: How to make more text fields in queries in Access 2007
  • From: Lilian
• Re: Run a Query from a Form
  • From: JBad
• RE: How to make more text fields in queries in Access 2007
  • From: Jerry Whittle
• RE: Code
  • From: Jerry Whittle
• Re: How to make more text fields in queries in Access 2007
  • From: Brendan Reynolds
• How to make more text fields in queries in Access 2007
  • From: Lilian
• Code
  • From: Khartoum
• Re: Classified by segment
  • From: John Spencer
• Re: If Statement In Query
  • From: John Spencer
• Re: Lpad in Access
  • From: John Spencer
• Re: Classified by segment
  • From: John Spencer
• RE: use an expression as a field
  • From: Duane Hookom
• Re: SUM-Function for strings, to concatenate strings
  • From: Duane Hookom
• Re: SUM-Function for strings, to concatenate strings
  • From: Douglas J. Steele
• SUM-Function for strings, to concatenate strings
  • From: Liz Helmecke
• Re: Find a number and return corresponding fields in that record
  • From: Evi
• Re: Run a Query from a Form
  • From: Evi
• Find a number and return corresponding fields in that record
  • From: JBad
• Re: How do I remove leading zeros?
  • From: Vsn
• Re: How do I remove leading zeros?
  • From: Frank Martin
• Run a Query from a Form
  • From: JBad
• use an expression as a field
  • From: Joseph
• Re: Classified by segment
  • From: Dawn
• Re: Add a column to a query (the value of the column needs calcula
  • From: Dawn
• Re: If Statement In Query
  • From: DS
• Re: If Statement In Query
  • From: DS
• Re: Lpad in Access
  • From: DonnaA
• RE: Getting Multiple Owners Names for Single Pieces of Property
  • From: Duane Hookom
• Re: Lpad in Access
  • From: raskew via AccessMonster.com
• Re: If Statement In Query
  • From: strive4peace
• Re: If Statement In Query
  • From: DS
• Re: If Statement In Query
  • From: DS
• Re: If Statement In Query
  • From: DS
• Re: If Statement In Query
  • From: Evi
• Re: If Statement In Query
  • From: strive4peace
• Re: If Statement In Query
  • From: John Spencer
• Re: If Statement In Query
  • From: DS
• Re: If Statement In Query
  • From: strive4peace
• Re: Lpad in Access
  • From: John Spencer
• If Statement In Query
  • From: DS
• Re: Showig differences in Month to Month data from data in the sam
  • From: strive4peace
• Re: One-liner causes "Object invalid or no longer set"
  • From: raskew via AccessMonster.com
• Re: One-liner causes "Object invalid or no longer set"
  • From: colin_e
• Re: Showig differences in Month to Month data from data in the sam
  • From: John
• Re: Lpad in Access
  • From: raskew via AccessMonster.com
• Re: Can I use 'exists' in the ORDER BY clause?
  • From: Douglas J. Steele
• Re: Lpad in Access
  • From: Douglas J. Steele
• Re: Lpad in Access
  • From: DonnaA
• Re: Lpad in Access
  • From: raskew via AccessMonster.com
• Re: Can I use 'exists' in the ORDER BY clause?
  • From: markmarko
• Re: Lpad in Access
  • From: DonnaA
• Re: Showig differences in Month to Month data from data in the same ta
  • From: strive4peace
• RE: Group by Weeks of the Month
  • From: MartyO
• RE: Date range Query
  • From: JBad
• DB Query - search
  • From: JBad
• Re: Date() Problem in Query
  • From: JBad
• Date range Query
  • From: jchambone
• Re: Date() Problem in Query
  • From: Rick Brandt
• Date() Problem in Query
  • From: JBad
• Re: Wild Card in a Querie
  • From: John Spencer
• Re: One-liner causes "Object invalid or no longer set"
  • From: John Spencer
• Re: Wild Card in a Querie
  • From: Jeff Boyce
• RE: Getting Multiple Owners Names for Single Pieces of Property
  • From: colin_e
• Wild Card in a Querie
  • From: Chris Gorham
• Re: Can I use 'exists' in the ORDER BY clause?
  • From: Vsn
• Re: Crosstab query with notes
  • From: Evi
• Re: How do I remove leading zeros?
  • From: Vsn
• How do I remove leading zeros?
  • From: Frank Martin
• RE: Combine the Unique data
  • From: colin_e
• One-liner causes "Object invalid or no longer set"
  • From: colin_e
• Crosstab query with notes
  • From: David Marks
• Re: Moving data from one table to another
  • From: John Spencer
• Showig differences in Month to Month data from data in the same ta
  • From: John
• Combine the Unique data
  • From: Ranjit kurian
• Getting Multiple Owners Names for Single Pieces of Property
  • From: Ray Todd Jr
• Re: Finding a ?
  • From: John Spencer
• Finding a ?
  • From: David W. Owens
• Re: Bizarre subquery syntax problem
  • From: Sylvain Lafontaine
• Re: Bizarre subquery syntax problem
  • From: Douglas J. Steele
• Re: Lpad in Access
  • From: Douglas J. Steele
• Lpad in Access
  • From: DonnaA
• Re: Bizarre subquery syntax problem
  • From: colin_e
• Re: Bizarre subquery syntax problem
  • From: colin_e
• Re: Bug in ODBC?
  • From: Knox
• Re: Bizarre subquery syntax problem
  • From: John Spencer
• Re: Bug in ODBC?
  • From: Stefan Hoffmann
• Re: Can I use 'exists' in the ORDER BY clause?
  • From: Douglas J. Steele
• Re: Get subtotal in a Query
  • From: Douglas J. Steele
• Bug in ODBC?
  • From: Knox
• Get subtotal in a Query
  • From: JPIN2008
• Can I use 'exists' in the ORDER BY clause?
  • From: markmarko
• Re: Moving data from one table to another
  • From: Rob Parker
• Re: Bizarre subquery syntax problem
  • From: Sylvain Lafontaine
• Re: Excluding certain items
  • From: John W . Vinson
• Re: Excluding certain items
  • From: raskew via AccessMonster.com
• Excluding certain items
  • From: ChuckW
• RE: Extracting Different Parts of Our SKU
  • From: meangene
• RE: Extracting Different Parts of Our SKU
  • From: KARL DEWEY
• Re: Matching a product field to another field that are not the sam
  • From: ChuckW
• Bizarre subquery syntax problem
  • From: colin_e
• Re: Unique ID and Latest Date
  • From: KerryF
• RE: Query/Function/Parameter Troubles...
  • From: KARL DEWEY
• Re: Syntax Error in From Clause
  • From: CR
• Query/Function/Parameter Troubles...
  • From: RobertG
• Re: Finding First Alphabetical Character in a String
  • From: John Spencer
• RE: Combining CrossTab Qry
  • From: Golfinray
• RE: Queries changed from column names to AS Exprn !?!
  • From: Golfinray
• Finding First Alphabetical Character in a String
  • From: meangene
• Queries changed from column names to AS Exprn !?!
  • From: mscertified
• Re: Access Messages
  • From: fredg
• Combining CrossTab Qry
  • From: Pedro
• RE: Query How To?
  • From: KARL DEWEY
• Re: Update Query to Search for Blanks in Certain Column
  • From: ryguy7272
• RE: Wild Card a Field in a Table
  • From: Dale Fye
• RE: email query
  • From: KARL DEWEY
• RE: Queries - criteria show list of values to pick from
  • From: KARL DEWEY
• RE: Moving data from one table to another
  • From: David Marks
• Access Messages
  • From: Nuno Gomes
• RE: Moving data from one table to another
  • From: Jerry Whittle
• RE: Returning multiple values within a single recordset
  • From: Jerry Whittle
• RE: Syntax Error in From Clause
  • From: Jerry Whittle
• RE: Update Query to Search for Blanks in Certain Column
  • From: Jerry Whittle
• Re: Update Query to Search for Blanks in Certain Column
  • From: John Spencer
• RE: Update Query to Search for Blanks in Certain Column
  • From: Golfinray
• Re: Access help needed! Over my head!
  • From: Michel Walsh
• RE: Wild Card a Field in a Table
  • From: Neil
• RE: Queries - criteria show list of values to pick from
  • From: Mary
• RE: Wild Card a Field in a Table
  • From: Golfinray
• Re: Classified by segment
  • From: John Spencer
• email query
  • From: Harvey
• Re: Top 25 brokers query help
  • From: Michel Walsh
• Re: Unique ID and Latest Date
  • From: Jeff Boyce
• Re: how do I compare text with embedded spaces
  • From: Michel Walsh
• Re: Problem deleting records
  • From: Michel Walsh
• Wild Card a Field in a Table
  • From: Neil
• Update Query to Search for Blanks in Certain Column
  • From: ryguy7272
• RE: Queries - criteria show list of values to pick from
  • From: KARL DEWEY
• RE: Query How To?
  • From: Ray Todd Jr
• RE: Query Help
  • From: Mary
• Queries - criteria show list of values to pick from
  • From: Mary
• Moving data from one table to another
  • From: David Marks
• Re: Moving data from one table to another
  • From: David Marks
• how do I compare text with embedded spaces
  • From: doc ian john hutch
• Query How To?
  • From: Ray Todd Jr
• Re: dsum
  • From: ScottR3
• RE: Two fields combined
  • From: deb
• Access help needed! Over my head!
  • From: daveallston
• Top 25 brokers query help
  • From: Pat Dools
• RE: Extracting Different Parts of Our SKU
  • From: meangene
• Re: Weird issue
  • From: Alan
• Re: change default numbering in access all versions
  • From: Jeff Boyce
• Re: Need your Help - Average
  • From: Jeff Boyce
• RE: Extracting Different Parts of Our SKU
  • From: Golfinray
• Re: Add a column to a query (the value of the column needs calculation
  • From: John Spencer
• Extracting Different Parts of Our SKU
  • From: meangene
• RE: Update Query - Consecutive Numbers
  • From: Dale Fye
• Re: change default numbering in access all versions
  • From: John Spencer
• Re: Unique ID and Latest Date
  • From: John Spencer
• RE: Collecting records from different tables
  • From: Duane Hookom
• Collecting records from different tables
  • From: danfryp
• RE: Update Query - Consecutive Numbers
  • From: James Frater
• Add a column to a query (the value of the column needs calculation
  • From: Dawn
• Re: Moving data from one table to another
  • From: Rob Parker
• Re: Problem deleting records
  • From: MarcVS
• Moving data from one table to another
  • From: David Marks
• Moving data from one table to another
  • From: David Marks
• RE: Using word distinct in Count function.
  • From: Dawn
• Query Help
  • From: Filo
• Re: Classified by segment
  • From: Dawn
• RE: How to combine two queries into one?
  • From: Dawn
• Need your Help - Average
  • From: learning_codes@xxxxxxxxxxx
• RE: Find and return zip codes
  • From: Jeff
• change default numbering in access all versions
  • From: questions
• RE: Remove Ties from a Top 5 query
  • From: Grd
• RE: Remove Ties from a Top 5 query
  • From: Grd
• Re: Remove Ties from a Top 5 query
  • From: Grd
• Re: Remove Ties from a Top 5 query
  • From: Grd
• Re: dsum
  • From: John Spencer
• Re: vertical dates
  • From: John Spencer
• RE: Find and return zip codes
  • From: KARL DEWEY
• Re: Unique ID and Latest Date
  • From: KerryF
• Returning multiple values within a single recordset
  • From: Tomas Eklund
• RE: Find and return zip codes
  • From: Jeff
• Re: Unique ID and Latest Date
  • From: Jeff Boyce
• Unique ID and Latest Date
  • From: KerryF
• RE: Show those who do not satisfy a condition
  • From: KARL DEWEY
• Re: dsum
  • From: ScottR3
• RE: concatenate records
  • From: Jen
• RE: Show those who do not satisfy a condition
  • From: Sandy
• Re: Combo Box lists
  • From: fredg
• dsum
  • From: ScottR3
• Syntax Error in From Clause
  • From: CR
• RE: Summing the fields in a Query
  • From: Duane Hookom
• vertical dates
  • From: Matt
• RE: concatenate records
  • From: Duane Hookom
• Combo Box lists
  • From: Tom
• RE: SQL Demand
  • From: Jerry Whittle
• RE: Find and return zip codes
  • From: KARL DEWEY
• Summing the fields in a Query
  • From: Lin
• concatenate records
  • From: Jen
• Find and return zip codes
  • From: Jeff
• Re: Passing Parameters from one query to another
  • From: norm
• How do I set up a 'combo box' control in a Query By Form
  • From: PVic
• Re: Matching a product field to another field that are not the same
  • From: Michel Walsh
• questions database and randomizing questions
  • From: Jeramie.proctor
• Re: Two fields combined
  • From: John Spencer
• Re: Delete more that one customer at a time ?
  • From: John Spencer
• RE: Update Query - Consecutive Numbers
  • From: Dale Fye
• RE: Update Query - Consecutive Numbers
  • From: James Frater
• Re: ODBC error with SQL Server
  • From: Dale Fye
• Two fields combined
  • From: deb
• Matching a product field to another field that are not the same
  • From: ChuckW
• Delete more that one customer at a time ?
  • From: SpookiePower
• Use Query to Filter Table
  • From: Ripper
• RE: Joning on null value
  • From: Marcie
• Re: Criteria Question
  • From: John Spencer
• SQL Demand
  • From: rloader
• Re: Help with Query
  • From: John Spencer
• Re: Joning on null value
  • From: John Spencer
• RE: Update Query - Consecutive Numbers
  • From: James Frater
• RE: parameter passthrough query
  • From: Duane Hookom
• Re: Classified by segment
  • From: John Spencer
• Re: pls help with query grid
  • From: John Spencer
• Re: Delete spaces in an entry
  • From: fredg
• Re: Finding non matching Data
  • From: John Spencer
• Re: Expression is to complicated?
  • From: Love Buzz
• Criteria Question
  • From: benbanyas
• RE: Query with multiple criteria
  • From: Love Buzz
• Re: Passing Parameters from one query to another
  • From: fredg
• Re: Append to Year to date table
  • From: Jeff Boyce
• Re: Can I use drop down boxes for a prompt in a query?
  • From: Tom
• Query with multiple criteria
  • From: Love Buzz
• Re: Expression is to complicated?
  • From: John Spencer
• RE: Joning on null value
  • From: KARL DEWEY
• RE: Update Query - Consecutive Numbers
  • From: Dale Fye
• RE: Update Query - Consecutive Numbers
  • From: Dale Fye
• Joning on null value
  • From: Marcie
• RE: Delete spaces in an entry
  • From: Dennis
• Re: Selecting the first from multiple records combining two tables
  • From: Jelle
• Re: Append to Year to date table
  • From: Mike D
• Delete spaces in an entry
  • From: Dimitris
• Re: Problem deleting records
  • From: Michel Walsh
• Re: Problem deleting records
  • From: MarcVS
• Re: Duplicate records
  • From: Michel Walsh
• RE: Selecting the first from multiple records combining two tables
  • From: Golfinray
• Re: Problem deleting records
  • From: Michel Walsh
• Re: Selecting the first from multiple records combining two tables
  • From: Michel Walsh
• RE: Update Query - Consecutive Numbers
  • From: James Frater
• Re: Classified by segment
  • From: Michel Walsh
• Re: query help urgent needed
  • From: Michel Walsh
• parameter passthrough query
  • From: Manju
• Re: ODBC error with SQL Server
  • From: Gary Walter
• RE: Make Table with autonumber ID field for ranking
  • From: Dale Fye
• RE: How to combine two queries into one?
  • From: Dale Fye
• RE: Using word distinct in Count function.
  • From: Dale Fye
• RE: Update Query - Consecutive Numbers
  • From: Dale Fye
• Re: Use Prompted variable more than once
  • From: CR
• Duplicate records
  • From: manju
• Update Query - Consecutive Numbers
  • From: James Frater
• Problem deleting records
  • From: MarcVS
• Re: Passing Parameters from one query to another
  • From: norm
• RE: Help Please?
  • From: scubadiver
• First day of week in pivot chart view
  • From: Jelle
• Selecting the first from multiple records combining two tables
  • From: Jelle
• Using word distinct in Count function.
  • From: Dawn
• Classified by segment
  • From: Dawn
• How to combine two queries into one?
  • From: Dawn
• Make Table with autonumber ID field for ranking
  • From: fishy
• RE: pls help with query grid
  • From: Duane Hookom
• pls help with query grid
  • From: subs
• Re: Delete Query - could not delete from specified tables
  • From: Margaret Bartley
• Re: Finding non matching Data
  • From: Song Su
• Re: Weird issue
  • From: aaron.kempf@xxxxxxxxx
• Re: Passing Parameters from one query to another
  • From: fredg
• Export to Excel with newer sheet in front
  • From: Song Su
• query help urgent needed
  • From: subs
• Finding non matching Data
  • From: BATTLESHIP
• Passing Parameters from one query to another
  • From: norm
• RE: How would I...
  • From: KARL DEWEY
• Re: Append to Year to date table
  • From: Jeff Boyce
• Re: How would I...
  • From: Jeff Boyce
• Re: Should I Use a Union Query?
  • From: Jeff Boyce
• RE: Prompting users and looking up data multiple times
  • From: Duane Hookom
• RE: Prompting users and looking up data multiple times
  • From: KARL DEWEY
• RE: Help with Query
  • From: KARL DEWEY
• Re: Replace on PART of the Text in a COMMENT field ???
  • From: fredg
• Should I Use a Union Query?
  • From: carissahodson
• How would I...
  • From: Question Boy
• Re: Expression is to complicated?
  • From: Love Buzz
• RE: Public Function
  • From: Dale Fye
• Append to Year to date table
  • From: Mike D
• Prompting users and looking up data multiple times
  • From: Cita
• Re: Expression is to complicated?
  • From: Love Buzz
• RE: Cross Tab Query with two values
  • From: Duane Hookom
• RE: Incorrect years being returned on action query
  • From: Duane Hookom
• Help with Query
  • From: r705271 via AccessMonster.com
• Re: Replace on PART of the Text in a COMMENT field ???
  • From: kev100 via AccessMonster.com
• Re: Randomization Field in a Query Question
  • From: KARL DEWEY
• Cross Tab Query with two values
  • From: Brennan
• Re: Expression is to complicated?
  • From: John Spencer
• Re: Returning multiply entries on Query
  • From: Nancy
• RE: Help Please?
  • From: Lisa
• Re: Randomization Field in a Query Question
  • From: case600lp
• RE: Multiple Records being returned in Query
  • From: BillA
• Re: Corrupt mdb??
  • From: Tony Toews [MVP]
• RE: Group by Weeks of the Month
  • From: Dale Fye
• Re: Including fields that have a total count of zero
  • From: tope12
• Public Function
  • From: Marcie
• RE: Show those who do not satisfy a condition
  • From: KARL DEWEY
• Parameters for Pass-thru query (Help!)
  • From: Chantal A
• Re: Update Query
  • From: fredg
• RE: Group by Weeks of the Month
  • From: KARL DEWEY
• Re: Expression is to complicated?
  • From: Love Buzz
• RE: Group by Weeks of the Month
  • From: MartyO
• RE: Incorrect years being returned on action query
  • From: Tim Castro
• Re: Comparing Lists
  • From: Bill
• Re: Remove Ties from a Top 5 query
  • From: Rick Brandt
• Re: Replace on PART of the Text in a COMMENT field ???
  • From: kev100 via AccessMonster.com
• Re: Comparing Lists
  • From: Bill
• Re: Update Query
  • From: John Spencer
• Re: Expression is to complicated?
  • From: John Spencer
• Re: Comparing Lists
  • From: Bill
• Re: Comparing Lists
  • From: John Spencer
• Re: Enter Parameter Value in calculation
  • From: John Spencer
• Re: Remove Ties from a Top 5 query
  • From: John Spencer
• Re: Over 30 Days
  • From: John W . Vinson
• RE: Remove Ties from a Top 5 query
  • From: Jerry Whittle
• Group by Weeks of the Month
  • From: MartyO
• RE: Merge 2 different tables
  • From: JezLisle via AccessMonster.com
• Expression is to complicated?
  • From: Love Buzz
• Update Query
  • From: Carl Gross
• RE: Remove Ties from a Top 5 query
  • From: Klatuu
• Re: Grouping by month and year in crosstab, without losing date value
  • From: Rachel Garrett
• Comparing Lists
  • From: Bill
• RE: Over 30 Days
  • From: Klatuu
• RE: Over 30 Days
  • From: lmossolle
• Re: Returning multiply entries on Query
  • From: John W . Vinson
• RE: Enter Parameter Value in calculation
  • From: Octet32
• RE: Over 30 Days
  • From: Klatuu
• RE: Enter Parameter Value in calculation
  • From: KARL DEWEY
• RE: Over 30 Days
  • From: lmossolle
• Re: Enter Parameter Value in calculation
  • From: BruceM
• Re: Calling managed code from an access database.
  • From: Michel Walsh
• RE: Remove Ties from a Top 5 query
  • From: Grd
• Re: Deleting Duplicate Records (Allen Browne post to 3/20/08)
  • From: FirstVette52
• Enter Parameter Value in calculation
  • From: Octet32
• RE: Randomization Field in a Query Question
  • From: KARL DEWEY
• Re: Calling managed code from an access database.
  • From: Michel Walsh
• RE: Over 30 Days
  • From: Klatuu
• RE: Merge 2 different tables
  • From: Jerry Whittle
• RE: Remove Ties from a Top 5 query
  • From: Jerry Whittle
• Re: query for current month
  • From: rciolkosz
• Over 30 Days
  • From: lmossolle
• Re: IIF STATEMENT
  • From: BruceM
• Remove Ties from a Top 5 query
  • From: Grd
• Re: query for current month
  • From: Michel Walsh
• Re: Use Prompted variable more than once
  • From: CR
• RE: query for current month
  • From: rciolkosz
• Re: query for current month
  • From: John Spencer
• Re: Values in crosstab represent change -- how to get query to return "current value" for each month?
  • From: Michel Walsh
• RE: query for current month
  • From: Golfinray
• IIF STATEMENT
  • From: ADD NEW DATA IN FORM?
• Re: Update TableA with data from TableB using Update Query
  • From: Michel Walsh
• Re: Limiting Query Results
  • From: benbanyas
• Re: Is this Possible? - Working Days
  • From: Michel Walsh
• Re: IN-Predicate means OR - I need AND
  • From: Michel Walsh
• Re: Limiting Query Results
  • From: Roger Carlson
• Limiting Query Results
  • From: benbanyas
• Form Entered Parameters for Pass-thru query
  • From: Chantal A
• query for current month
  • From: rciolkosz
• Re: Shared Database
  • From: Jeff Boyce
• Re: Use Prompted variable more than once
  • From: Jeff Boyce
• ODBC error with SQL Server
  • From: Dale Fye
• Re: Use Prompted variable more than once
  • From: John Spencer
• Re: There is missing a , sign ???
  • From: Albert D. Kallal
• Re: There is missing a , sign ???
  • From: John Spencer
• Re: Use Prompted variable more than once
  • From: Albert D. Kallal
• Re: Returning multiply entries on Query
  • From: Nancy
• Re: Count Account Services with multiple occurrences
  • From: John Spencer
• Re: Applying Wildcard for search
  • From: John Spencer
• Re: Not Selecting Field Name When Trying To Copy & Paste Cells
  • From: John Spencer
• Re: formatting numbers after using the nz function
  • From: John Spencer
• Re: Syntax error in UPDATE statement.
  • From: John Spencer
• Use Prompted variable more than once
  • From: CR
• Re: Using Multiple Fields to Find Unmatched Records
  • From: John Spencer
• There is missing a , sign ???
  • From: SpookiePower
• Re: Including fields that have a total count of zero
  • From: John Spencer
• RE: Merging 3 name fields and removing extra spaces
  • From: Sietske
• Shared Database
  • From: Nuno Gomes
• Re: How to replace "Blank" With "0"
  • From: Evi
• RE: Merging 3 name fields and removing extra spaces
  • From: Sietske
• Re: How to replace "Blank" With "0"
  • From: Syphonics via AccessMonster.com
• Show those who do not satisfy a condition
  • From: Sandy
• Count Account Services with multiple occurrences
  • From: crspycrtr
• Applying Wildcard for search
  • From: Participant
• Re: enter a count function to count records?
  • From: Evi
• Re: How to replace "Blank" With "0"
  • From: Evi
• Re: Delete Query - could not delete from specified tables
  • From: John W . Vinson
• RE: Syntax error in UPDATE statement.
  • From: MJ
• RE: Using Multiple Fields to Find Unmatched Records
  • From: Chris
• RE: Delete Query - could not delete from specified tables
  • From: Duane Hookom
• RE: Incorrect years being returned on action query
  • From: Duane Hookom
• Re: Enter multiple Parameters for a Field
  • From: John W . Vinson
• Randomization Field in a Query Question
  • From: case600lp
• Incorrect years being returned on action query
  • From: Tim Castro
• Delete Query - could not delete from specified tables
  • From: Margaret Bartley
• Re: Leading 0 won't count as duplicate
  • From: Ardy
• Not Selecting Field Name When Trying To Copy & Paste Cells
  • From: mcl
• Re: Finding records in one DB that are not in another
  • From: Cindy
• Re: rounding in update query
  • From: fredg
• Re: formatting numbers after using the nz function
  • From: Rick Brandt
• RE: sort field in ascending order and get the value of the 2nd row
  • From: KARL DEWEY
• Re: sort field in ascending order and get the value of the 2nd row?
  • From: John Spencer
• Re: formatting numbers after using the nz function
  • From: jlarson
• Re: Can I get a drop down menu of options in a query search?
  • From: fredg
• Re: formatting numbers after using the nz function
  • From: John Spencer
• Re: Finding records in one DB that are not in another
  • From: Jeff Boyce
• Re: Deleting Duplicate Records (Allen Browne post to 3/20/08)
  • From: John Spencer
• RE: Using Multiple Fields to Find Unmatched Records
  • From: KARL DEWEY
• Finding records in one DB that are not in another
  • From: Cindy
• RE: Including fields that have a total count of zero
  • From: KARL DEWEY
• rounding in update query
  • From: j9
• Re: $ Complex Access Query
  • From: david . barbetta
• Re: Updatable passthrough queries
  • From: Rick Brandt
• Re: Updatable passthrough queries
  • From: Rick Brandt
• Re: Need Mid Function
  • From: fredg
• formatting numbers after using the nz function
  • From: jlarson
• Enter multiple Parameters for a Field
  • From: Hannah
• RE: Leading 0 won't count as duplicate
  • From: KARL DEWEY
• Re: Run all queries in a group
  • From: fredg
• RE: Need Mid Function
  • From: KARL DEWEY
• Re: Can I get a drop down menu of options in a query search?
  • From: Brian S
• Re: Can I get a drop down menu of options in a query search?
  • From: fredg
• Leading 0 won't count as duplicate
  • From: Ardy
• Need Mid Function
  • From: Dataman
• Syntax error in UPDATE statement.
  • From: MJ
• RE: Using Multiple Fields to Find Unmatched Records
  • From: Chris
• RE: Can I get a drop down menu of options in a query search?
  • From: Brian S
• RE: Including fields that have a total count of zero
  • From: tope12
• RE: Accepting between criteria from text box in access 2007
  • From: H0MELY
• RE: sort field in ascending order and get the value of the 2nd row?
  • From: dicox
• RE: Including fields that have a total count of zero
  • From: KARL DEWEY
• Accepting between criteria from text box in access 2007
  • From: H0MELY
• RE: Can I get a drop down menu of options in a query search?
  • From: KARL DEWEY
• RE: Using Multiple Fields to Find Unmatched Records
  • From: KARL DEWEY
• RE: Count items over 30 days old
  • From: Jerry Whittle
• Re: Deleting Duplicate Records (Allen Browne post to 3/20/08)
  • From: FirstVette52
• Re: Returning multiply entries on Query
  • From: John W . Vinson
• Re: Deleting Duplicate Records (Allen Browne post to 3/20/08)
  • From: FirstVette52
• Re: INT conversion
  • From: Rich
• Run all queries in a group
  • From: CFitz
• Can I get a drop down menu of options in a query search?
  • From: Brian S
• Using Multiple Fields to Find Unmatched Records
  • From: Chris
• Re: Is this Possible? - Working Days
  • From: Lori
• Re: IN-Predicate means OR - I need AND
  • From: candide_sh
• Re: finding non-duplicated records
  • From: Confused about Access
• Re: Deleting Duplicate Records (Allen Browne post to 3/20/08)
  • From: John Spencer
• RE: Merge 2 different tables
  • From: JezLisle via AccessMonster.com
• Re: finding non-duplicated records
  • From: John Spencer
• RE: Deleting Duplicate Records (Allen Browne post to 3/20/08)
  • From: FirstVette52
• Re: sort field in ascending order and get the value of the 2nd row?
  • From: John Spencer
• Count items over 30 days old
  • From: lmossolle
• Including fields that have a total count of zero
  • From: tope12
• Re: Different destination fields
  • From: John Spencer
• RE: finding non-duplicated records
  • From: Confused about Access
• RE: Change Table in query
  • From: Jerry Whittle
• Re: Updatable passthrough queries
  • From: Jake
• Re: Update Query Help
  • From: John Spencer
• Re: re-coding values
  • From: Bluesky
• Change Table in query
  • From: Aurora
• RE: Complicated Query Update
  • From: Alex
• RE: Complicated Query Update
  • From: Jake
• Re: re-coding values
  • From: John Spencer
• RE: finding non-duplicated records
  • From: Klatuu
• Grouping by month and year in crosstab, without losing date value
  • From: Rachel Garrett
• RE: finding non-duplicated records
  • From: Confused about Access
• Re: Updatable passthrough queries
  • From: Dale Fye
• RE: Complicated Query Update
  • From: Alex
• RE: finding non-duplicated records
  • From: Klatuu
• RE: finding non-duplicated records
  • From: Confused about Access
• Re: Crosstab: how do I group dates by month?
  • From: Rachel Garrett
• RE: Complicated Query Update
  • From: Jake
• Crosstab: how do I group dates by month?
  • From: Rachel Garrett
• RE: Merge 2 different tables
  • From: Jerry Whittle
• Complicated Query Update
  • From: Alex
• Re: Update TableA with data from TableB using Update Query
  • From: Ellette
• Re: Between statement using Like
  • From: Jerry Whittle
• Re: Returning multiply entries on Query
  • From: Nancy
• RE: Update Query Help
  • From: Golfinray
• Values in crosstab represent change -- how to get query to return "current value" for each month?
  • From: Rachel Garrett
• RE: finding non-duplicated records
  • From: Klatuu
• RE: sort field in ascending order and get the value of the 2nd row?
  • From: Jake
• finding non-duplicated records
  • From: Confused about Access
• RE: sort field in ascending order and get the value of the 2nd row?
  • From: KARL DEWEY
• Calling managed code from an access database.
  • From: Jake
• Re: Updatable passthrough queries
  • From: Jake
• RE: Different destination fields
  • From: Shaun
• RE: Different destination fields
  • From: KARL DEWEY
• RE: Update Query Help
  • From: KARL DEWEY
• Re: Updatable passthrough queries
  • From: Dale Fye
• sort field in ascending order and get the value of the 2nd row?
  • From: dicox
• Different destination fields
  • From: Shaun
• Re: Want 5 records --> 1 record with 5 fields. Can this be a query?
  • From: Rachel Garrett
• RE: HELP SOUGHT: Access query returning Error in one column
  • From: Dale Fye
• Re: re-coding values
  • From: Bluesky
• Re: IN-Predicate means OR - I need AND
  • From: John Spencer
• Update Query Help
  • From: Golfinray
• Re: Append Problem
  • From: Mart
• RE: Updatable passthrough queries
  • From: Dale Fye
• Re: Updatable passthrough queries
  • From: Rick Brandt
• RE: Updatable passthrough queries
  • From: Jezza0
• Re: Want 5 records --> 1 record with 5 fields. Can this be a query?
  • From: Rachel Garrett
• Re: How to replace "Blank" With "0"
  • From: Syphonics via AccessMonster.com
• Re: Returning multiply entries on Query
  • From: John W . Vinson
• RE: design grid total line question.
  • From: JH
• Re: Is this Possible? - Working Days
  • From: Michel Walsh
• RE: Form Questions
  • From: Jake
• RE: Want 5 records --> 1 record with 5 fields. Can this be a query?
  • From: Jake
• Re: Update TableA with data from TableB using Update Query
  • From: Michel Walsh
• Updatable passthrough queries
  • From: Jake
• Form Questions
  • From: benbanyas
• Re: Query to Update Multiple Records Based on Current Record
  • From: Michel Walsh
• Re: Is this Possible? - Working Days
  • From: Michel Walsh
• Update TableA with data from TableB using Update Query
  • From: Ellette
• Re: Criteria
  • From: benbanyas
• Re: enter a count function to count records?
  • From: Char
• RE: Merge 2 different tables
  • From: JezLisle via AccessMonster.com
• Re: Criteria
  • From: benbanyas
• RE: Merge 2 different tables
  • From: JezLisle via AccessMonster.com
• Want 5 records --> 1 record with 5 fields. Can this be a query?
  • From: Rachel Garrett
• RE: Returning multiply entries on Query
  • From: NetworkTrade
• Is this Possible? - Working Days
  • From: Lori
• RE: Corrupt mdb??
  • From: NetworkTrade
• Re: Corrupt mdb??
  • From: Alan
• Re: IN-Predicate means OR - I need AND
  • From: Michel Walsh
• Re: design grid total line question.
  • From: John Spencer
• Corrupt mdb??
  • From: Tyler
• Re: How to replace "Blank" With "0"
  • From: Evi
• Re: IN-Predicate means OR - I need AND
  • From: John Spencer
• Re: Syntax error in insertinto statement
  • From: Wolfgang Kais
• Re: Passing Function values to a Query
  • From: FBxiii
• design grid total line question.
  • From: JH
• Re: Help with query
  • From: John Spencer
• Re: $ Complex Access Query
  • From: John Spencer
• Re: Append Problem
  • From: Stefan Hoffmann
• Re: Passing Function values to a Query
  • From: Stefan Hoffmann
• Re: Conditionally Update field in table with data from another table
  • From: John Spencer
• HELP SOUGHT: Access query returning Error in one column
  • From: Clinton M James
• Append Problem
  • From: Mart
• Re: IN-Predicate means OR - I need AND
  • From: candide_sh
• Re: Passing Function values to a Query
  • From: FBxiii
• Re: Passing Function values to a Query
  • From: Stefan Hoffmann
• Re: Passing Function values to a Query
  • From: FBxiii
• Re: Passing Function values to a Query
  • From: Stefan Hoffmann
• Passing Function values to a Query
  • From: FBxiii
• Re: Set up mask on parameter value
  • From: Khartoum
• Re: $ Complex Access Query
  • From: david . barbetta
• Re: $ Complex Access Query
  • From: David Glienna
• Re: Help with query
  • From: David Glienna
• Re: Delete Query wont work
  • From: Jeanette Cunningham
• Query to Update Multiple Records Based on Current Record
  • From: Newbold589
• Help with query
  • From: SF
• $ Complex Access Query
  • From: david . barbetta
• Burett Neo Icon Swiss Automatic Ladies Watch B5201CF
  • From: yxs046
• Returning multiply entries on Query
  • From: Nancy
• Re: how to calculate the number of person
  • From: littleskinny83
• Re: Conditionally Update field in table with data from another table
  • From: John W . Vinson
• Re: Replace on PART of the Text in a COMMENT field ???
  • From: fredg
• Re: Delete Query wont work
  • From: duke_man
• Re: Delete Query wont work
  • From: Jeanette Cunningham
• Delete Query wont work
  • From: duke_man
• Replace on PART of the Text in a COMMENT field ???
  • From: kev100 via AccessMonster.com
• Conditionally Update field in table with data from another table
  • From: Ellette
• Re: re-coding values
  • From: John Spencer
• RE: Splitting Out a listing tables
  • From: Duane Hookom
• Re: re-coding values
  • From: Bluesky
• Re: Avg query
  • From: John Spencer
• Re: Avg query
  • From: Michel Walsh
• RE: Rakamları yazıya çevirme access 2003 de
  • From: Tiago Nogueira
• Re: Avg query
  • From: Sandra
• Re: Between statement using Like
  • From: Crazyhorse
• Re: Delete Query One to Many
  • From: John Spencer
• Re: INT conversion
  • From: John Spencer
• Re: re-coding values
  • From: John Spencer
• Re: Avg query
  • From: John Spencer
• Re: Between statement using Like
  • From: Jerry Whittle
• Re: Avg query
  • From: Michel Walsh
• Delete Query One to Many
  • From: Erika
• Re: IN-Predicate means OR - I need AND
  • From: Michel Walsh
• Re: Between statement using Like
  • From: Crazyhorse
• re-coding values
  • From: Bluesky
• RE: Merge 2 different tables
  • From: Jerry Whittle
• Avg query
  • From: Sandra
• RE: Merge 2 different tables
  • From: JezLisle via AccessMonster.com
• Re: Between statement using Like
  • From: fredg
• Re: how do i?
  • From: George Applegate
• Re: Between statement using Like
  • From: Ron2006
• RE: Between statement using Like
  • From: Jerry Whittle
• Cartier Tank Francaise Steel Grey and Pink Dial Ladies Watch W51031Q3
  • From: blog407
• Between statement using Like
  • From: Crazyhorse
• RE: Merge 2 different tables
  • From: Jerry Whittle
• Add condition to current query
  • From: mike17316
• RE: Merge 2 different tables
  • From: JezLisle via AccessMonster.com
• RE: Merge 2 different tables
  • From: JezLisle via AccessMonster.com
• Re: IN-Predicate means OR - I need AND
  • From: Jerry Whittle
• Re: UNION QUERY
  • From: DS
• RE: IN-Predicate means OR - I need AND
  • From: Jerry Whittle
• Re: IN-Predicate means OR - I need AND
  • From: John Spencer
• RE: Merge 2 different tables
  • From: Jerry Whittle
• Merge 2 different tables
  • From: JezLisle via AccessMonster.com
• Rakamları yazıya çevirme access 2003 de
  • From: Estapan
• IN-Predicate means OR - I need AND
  • From: candide_sh
• Baume and Mercier Classima Executives XL Mens Watch 8734
  • From: blog271
• Re: INT conversion
  • From: Rich
• Re: how do i?
  • From: George Applegate
• RE: Weird issue
  • From: Sharao
• RE: Weird issue
  • From: Sharao
• Re: How to replace "Blank" With "0"
  • From: Syphonics via AccessMonster.com
• Baume and Mercier Capeland S Mens Watch 8577
  • From: blog192
• Warranty Expiration Query
  • From: YisMan
• Re: Max SQL length for Passthrough Query
  • From: Jezza0
• Re: How to replace "Blank" With "0"
  • From: Evi
• Re: Syntax error in insertinto statement
  • From: Sanju
• Map Query Output with Alternate Field Names
  • From: isliprlw
• Re: Max SQL length for Passthrough Query
  • From: Brendan Reynolds
• Re: Rename 3 values from tables field 'c', 'w' & ' ' to show 'courier'
  • From: pilch74@xxxxxxxxx
• Max SQL length for Passthrough Query
  • From: Jezza0
• RE: Splitting Out a listing tables
  • From: JezLisle via AccessMonster.com
• RE: Update Query... No error message, but table not updated
  • From: domibud
• Re: How to replace "Blank" With "0"
  • From: Syphonics via AccessMonster.com
• RE: Calculated date field - no date format
  • From: Bibi
• RE: Calculated date field - no date format
  • From: Duane Hookom
• Re: how to calculate the number of person
  • From: John W . Vinson
• Re: query problem
  • From: Andy
• Re: how do i?
  • From: John Spencer
• RE: Calculated date field - no date format
  • From: Bibi
• Re: Age of a group for a fix day
  • From: fredg
• Age of a group for a fix day
  • From: Telesphore
• Re: How to replace "Blank" With "0"
  • From: Evi
• How to replace "Blank" With "0"
  • From: Syphonics via AccessMonster.com
• Re: SQL Help Needed
  • From: Sylvain Lafontaine
• Re: UNION QUERY
  • From: Rick Brandt
• UNION QUERY
  • From: DS
• RE: Calculation Expression Help
  • From: Duane Hookom
• Re: Access 2000 on Vista
  • From: Alan
• RE: Splitting Out a listing tables
  • From: Duane Hookom
• Calculation Expression Help
  • From: SITCFanTN
• RE: Splitting Out a listing tables
  • From: JezLisle via AccessMonster.com
• Re: how to calculate the number of person
  • From: littleskinny83
• Re: how to calculate the number of person
  • From: John W . Vinson
• RE: Query that autonumber some columns
  • From: Duane Hookom
• RE: Calculated date field - no date format
  • From: Duane Hookom
• RE: how to calculate the number of person
  • From: Dale Fye
• RE: Calculated date field - no date format
  • From: Bibi
• how to calculate the number of person
  • From: littleskinny83
• RE: Query by days
  • From: Duane Hookom
• RE: Query that autonumber some columns
  • From: Marco
• RE: Query that autonumber some columns
  • From: Duane Hookom
• RE: Calculated date field - no date format
  • From: Duane Hookom
• RE: Calculated date field - no date format
  • From: Bibi
• Re: how do i?
  • From: George Applegate
• RE: Query by days
  • From: Marco
• Query that autonumber some columns
  • From: Marco
• Re: Query to return a subset of a set
  • From: David Wetmore
• RE: cutting off all but the first two letters
  • From: Naz
• Re: cutting off all but the first two letters
  • From: fredg
• Re: Strange values when summing in a query
  • From: Douglas J. Steele
• cutting off all but the first two letters
  • From: paul69
• Strange values when summing in a query
  • From: Kjell Harnesk
• Query by days
  • From: Naz
• Query by days
  • From: Naz
• Re: Access and servers question
  • From: dddddddd
• Re: Access and servers question
  • From: John W . Vinson
• RE: How do I the pull the first name from a fullname field in Acce
  • From: Robert in need of a Guru
• Re: Access and servers question
  • From: David W. Fenton
• Query to return a subset of a set
  • From: David Wetmore
• RE: Filtering duplicate participants from query based on a study name
  • From: Puciral
• Re: not display date in past
  • From: John Spencer
• Re: not display date in past
  • From: Jeff Boyce
• not display date in past
  • From: H0MELY
• Re: How do I filter data by blank cells in access
  • From: John W . Vinson
• RE: SQL Statment Help Needed
  • From: KARL DEWEY
• Re: Subquery help
  • From: K
• RE: How do I filter data by blank cells in access
  • From: Jason
• Re: Creating an All option in a combo box that will pull all recor
  • From: H0MELY
• Re: Creating an All option in a combo box that will pull all recor
  • From: H0MELY
• RE: Multiple Records being returned in Query
  • From: KARL DEWEY
• RE: SQL Statment Help Needed
  • From: Query Help
• Re: games on Excel
  • From: fredg
• Re: InStr with Or?
  • From: John Spencer
• Re: Creating an All option in a combo box that will pull all recor
  • From: John Spencer
• RE: How do I filter data by blank cells in access
  • From: KARL DEWEY
• Re: Subquery help
  • From: John Spencer
• Re: SQL Help Needed - Revisited
  • From: John Spencer
• RE: SQL Help Needed - Revisited
  • From: carl
• Multiple Records being returned in Query
  • From: BillA
• Subquery help
  • From: K
• RE: How to calculate work hours between two time/dates
  • From: Ken Sheridan
• Re: InStr with Or?
  • From: yator
• RE: How do I filter data by blank cells in access
  • From: Jason
• Re: Creating an All option in a combo box that will pull all recor
  • From: H0MELY
• RE: How do I filter data by blank cells in access
  • From: KARL DEWEY
• RE: SQL Statment Help Needed
  • From: KARL DEWEY
• games on Excel
  • From: Games will not open
• RE: How do I filter data by blank cells in access
  • From: Jason
• RE: SQL Help Needed - Revisited
  • From: KARL DEWEY
• RE: How do I filter data by blank cells in access
  • From: KARL DEWEY
• RE: How do I filter data by blank cells in access
  • From: NetworkTrade
• RE: Rename 3 values from tables field 'c', 'w' & ' ' to show 'courier'
  • From: KARL DEWEY
• SQL Statment Help Needed
  • From: Query Help
• Re: SQL Help Needed - Revisited
  • From: John Spencer
• How do I filter data by blank cells in access
  • From: Jason
• SQL Help Needed - Revisited
  • From: carl
• RE: Splitting Out a listing tables
  • From: Duane Hookom
• RE: Update Query... No error message, but table not updated
  • From: Duane Hookom
• Re: List all not in other table
  • From: Marshall Barton
• RE: Calculated date field - no date format
  • From: Duane Hookom
• RE: List all not in other table
  • From: Question Boy
• List all not in other table
  • From: Question Boy
• RE: How to calculate work hours between two time/dates
  • From: CanaryCrazy
• Re: Rename 3 values from tables field 'c', 'w' & ' ' to show 'courier', 'web' & 'post' - i'm a bit rusty.
  • From: pilch74@xxxxxxxxx
• Rename 3 values from tables field 'c', 'w' & ' ' to show 'courier', 'web' & 'post' - i'm a bit rusty.
  • From: pilch74@xxxxxxxxx
• Re: 90 day increments
  • From: Annette
• RE: IF function in Query
  • From: Supe
• Re: Create query that sums up categorical data
  • From: John Spencer
• Re: 90 day increments
  • From: John Spencer
• Re: Syntax error in insertinto statement
  • From: Wolfgang Kais
• RE: Calculated date field - no date format
  • From: Bibi
• RE: Update Query... No error message, but table not updated
  • From: domibud
• Update Query... No error message, but table not updated
  • From: domibud
• RE: Implementing a Hierarchy in MS Access
  • From: "Peter Yang[MSFT]"
• Splitting Out a listing tables
  • From: JezLisle via AccessMonster.com
• Syntax error in insertinto statement
  • From: Sanju
• RE: Create query that sums up categorical data
  • From: Duane Hookom
• RE: Calculated date field - no date format
  • From: Duane Hookom
• Calculated date field - no date format
  • From: Bibi
• Create query that sums up categorical data
  • From: Liz Yetter
• Re: Append query to append lots of record with range input
  • From: domibud
• Re: Creating an All option in a combo box that will pull all recor
  • From: John W . Vinson
• RE: How do you find the name of a subdatasheet?
  • From: Tonic_Writes
• Filtering duplicate participants from query based on a study name
  • From: Puciral
• How do you find the name of a subdatasheet?
  • From: Tonic_Writes
• Re: Creating an All option in a combo box that will pull all recor
  • From: John Spencer
• Re: Access and servers question
  • From: Dupatt
• RE: 90 day increments
  • From: KARL DEWEY
• RE: IF function in Query
  • From: KARL DEWEY
• Re: Creating an All option in a combo box that will pull all recor
  • From: H0MELY
• IF function in Query
  • From: Supe
• Re: Time Calculations
  • From: vepha
• Re: how do i?
  • From: George Applegate
• RE: How to calculate work hours between two time/dates
  • From: Ken Sheridan
• Re: Transfer records from one table to another ?
  • From: John Spencer
• RE: InStr with Or?
  • From: KARL DEWEY
• Re: InStr with Or?
  • From: John Spencer
• Re: Creating an All option in a combo box that will pull all records
  • From: John Spencer
• Re: Transfer records from one table to another ?
  • From: KARL DEWEY
• Re: SQL Help Needed
  • From: John Spencer
• RE: data type mismatch in query
  • From: KARL DEWEY
• RE: SQL Help Needed
  • From: KARL DEWEY
• Re: SQL Help Needed
  • From: John W . Vinson
• Re: 90 day increments
  • From: Ron2006
• Re: Transfer records from one table to another ?
  • From: SpookiePower
• Transfer records from one table to another ?
  • From: SpookiePower
• InStr with Or?
  • From: yator
• Creating an All option in a combo box that will pull all records
  • From: H0MELY
• 90 day increments
  • From: Annette
• RE: SQL Help Needed
  • From: carl
• Re: how do i?
  • From: Ron2006
• RE: How to calculate work hours between two time/dates
  • From: CanaryCrazy
• Re: Show 0-30 days from Today
  • From: Ron2006
• Re: Show 0-30 days from Today
  • From: Ron2006
• Re: I want to update "P O BOX" to "P.O. BOX"
  • From: KARL DEWEY
• RE: SQL Help Needed
  • From: KARL DEWEY
• Re: SQL Help Needed
  • From: John Spencer
• RE: How to calculate work hours between two time/dates
  • From: Ken Sheridan
• Re: IIF statement in a Query ?
  • From: Yula
• Re: Crosstab - what if I don't want my column headings grouped?
  • From: jan . mazing
• RE: Show 0-30 days from Today
  • From: KARL DEWEY
• Re: difference between not in and <>
  • From: John Spencer
• RE: Find a value based on two fields: one matching, and one closes
  • From: Matthew
• RE: NEED HELP with a multi-criteria query
  • From: KARL DEWEY
• SQL Help Needed
  • From: carl
• Re: NEED HELP with a multi-criteria query
  • From: John Spencer
• Re: I want to update "P O BOX" to "P.O. BOX"
  • From: Kelvin
• RE: Copy paste query results in word document
  • From: KARL DEWEY
• Re: Decrease space between top of page and report header
  • From: John Spencer
• Re: how do i?
  • From: John Spencer
• Re: Crosstab - what if I don't want my column headings grouped?
  • From: KARL DEWEY
• Re: IIF statement in a Query ?
  • From: John Spencer
• RE: data type mismatch in query
  • From: KARL DEWEY
• Re: difference between not in and <>
  • From: Jeff Boyce
• Re: Parse?
  • From: Lisa W.
• query hyperlink text
  • From: trayl
• Re: Parse?
  • From: KARL DEWEY
• difference between not in and <>
  • From: sverre
• RE: Query or VBA code
  • From: Monique
• RE: IIF statement in a Query ?
  • From: Jerry Whittle
• Re: Crosstab - what if I don't want my column headings grouped?
  • From: jan . mazing
• Copy paste query results in word document
  • From: Annette
• RE: Find a value based on two fields: one matching, and one closest (d
  • From: KARL DEWEY
• Re: Find a value based on two fields: one matching, and one closes
  • From: Matthew
• Re: Time Calculations
  • From: vepha
• Re: Find a value based on two fields: one matching, and one closest (d
  • From: Jeff Boyce
• RE: Crosstab - what if I don't want my column headings grouped?
  • From: KARL DEWEY
• NEED HELP with a multi-criteria query
  • From: Irina
• Re: Parse?
  • From: Lisa W.
• Crosstab - what if I don't want my column headings grouped?
  • From: jan . mazing
• Re: Show 0-30 days from Today
  • From: raskew via AccessMonster.com
• Find a value based on two fields: one matching, and one closest (d
  • From: Matthew
• Decrease space between top of page and report header
  • From: sverre
• RE: IIF statement in a Query ?
  • From: Yula
• Re: data type mismatch in query
  • From: juanakhusted via AccessMonster.com
• Re: How can I query by quarterly, semi annual and annually...
  • From: Stefan Hoffmann
• Re: access to text file
  • From: Michel Walsh
• RE: Show 0-30 days from Today
  • From: Golfinray
• Re: Parse?
  • From: Lisa W.
• Re: Functions in queries not working when called externally
  • From: DavidY
• RE: How to calculate work hours between two time/dates
  • From: CanaryCrazy
• How can I query by quarterly, semi annual and annually...
  • From: ickat22
• Show 0-30 days from Today
  • From: Robb @ FLW
• RE: Query Criteria from Form Problem
  • From: Ray S.
• Re: How do I validate a field has 5 characters (alphanumeric)?
  • From: John Spencer
• Re: data type mismatch in query
  • From: John Spencer
• RE: data type mismatch in query
  • From: juanakhusted via AccessMonster.com
• Re: Parse?
  • From: John Spencer
• Re: Append query to append lots of record with range input
  • From: John Spencer
• how do i?
  • From: George Applegate
• Re: access to text file
  • From: George Applegate
• RE: Query Criteria from Form Problem
  • From: Ray S.
• RE: data type mismatch in query
  • From: juanakhusted via AccessMonster.com
• Re: Functions in queries not working when called externally
  • From: Rick Brandt
• Functions in queries not working when called externally
  • From: DavidY
• RE: data type mismatch in query
  • From: juanakhusted via AccessMonster.com
• Re: Invalid use of null in query expression
  • From: Wolfgang Kais
• RE: data type mismatch in query
  • From: juanakhusted via AccessMonster.com
• RE: Query not updateable, yet in form it is.
  • From: MSROOKIE
• Re: How to calculate work hours between two time/dates
  • From: John W . Vinson
• Re: Access and servers question
  • From: John W . Vinson
• Query not updateable, yet in form it is.
  • From: MSROOKIE
• Re: Access and servers question
  • From: Dupatt
• Re: Full Outer Join
  • From: ooxx
• Re: Append query to append lots of record with range input
  • From: domibud
• Re: Access and servers question
  • From: David W. Fenton
• Re: Access and servers question
  • From: Dupatt
• Re: Make-Table Query Destroys the Wrong Table
  • From: Margaret Bartley
• Not Selecting Field names When Selecting Some Data
  • From: mcl
• RE: data type mismatch in query
  • From: Ken Sheridan
• RE: How to calculate work hours between two time/dates
  • From: Ken Sheridan
• RE: Query Criteria from Form Problem
  • From: KARL DEWEY
• RE: How do I validate a field has 5 characters (alphanumeric)?
  • From: KARL DEWEY
• Re: How to calculate work hours between two time/dates
  • From: John W . Vinson
• RE: How do I validate a field has 5 characters (alphanumeric)?
  • From: Ellette
• RE: Query Criteria from Form Problem
  • From: Ray S.
• RE: How do I validate a field has 5 characters (alphanumeric)?
  • From: KARL DEWEY
• RE: How to calculate work hours between two time/dates
  • From: CanaryCrazy
• RE: data type mismatch in query
  • From: KARL DEWEY
• RE: create hyperlink & append table
  • From: patti
• RE: Parse?
  • From: KARL DEWEY
• RE: Query Criteria from Form Problem
  • From: KARL DEWEY
• How do I validate a field has 5 characters (alphanumeric)?
  • From: Ellette
• RE: View
  • From: KARL DEWEY
• Re: Access and servers question
  • From: John W . Vinson
• data type mismatch in query
  • From: juanakhusted via AccessMonster.com
• Access and servers question
  • From: Dupatt
• RE: Parse?
  • From: Lisa W.
• RE: Query Criteria from Form Problem
  • From: Ray S.
• RE: View
  • From: ACarella
• RE: Parse?
  • From: KARL DEWEY
• RE: IIF statement in a Query ?
  • From: Jerry Whittle
• RE: Query Criteria from Form Problem
  • From: KARL DEWEY
• RE: View
  • From: KARL DEWEY
• View
  • From: ACarella
• Query Criteria from Form Problem
  • From: Ray S.
• IIF statement in a Query ?
  • From: Yula
• Re: Prefix Names and Dimmed Icons
  • From: Jeff Boyce
• Re: what is the best way to do this...
  • From: Michel Walsh
• Parse?
  • From: Lisa W.
• Re: dynamic crosstab query
  • From: John Spencer
• Re: Prefix Names and Dimmed Icons
  • From: John Spencer
• RE: Delete records
  • From: Golfinray
• Re: query parameter order
  • From: John Spencer
• RE: dynamic crosstab query
  • From: KARL DEWEY
• RE: Delete records
  • From: KARL DEWEY
• dynamic crosstab query
  • From: iccsi
• RE: Delete records
  • From: Golfinray
• RE: User input of numbers
  • From: John V
• Re: Prefix Names and Dimmed Icons
  • From: Jeff Boyce
• RE: User input of numbers
  • From: John V
• Re: query parameter order
  • From: AccessMan
• RE: User input of numbers
  • From: KARL DEWEY
• Re: what's wrong with this sql statment? (uses "SELECT-IN")
  • From: Bob
• Re: Using circular references
  • From: bismuth83
• Re: Using category groups in access 2007 causing queries to throw
  • From: KARL DEWEY
• RE: User input of numbers
  • From: John V
• Re: query parameter order
  • From: John Spencer
• RE: User input of numbers
  • From: John V
• Prefix Names and Dimmed Icons
  • From: Ann
• RE: what is the best way to do this...
  • From: KARL DEWEY
• Re: Query Design help?
  • From: John Spencer
• RE: User input of numbers
  • From: George
• RE: User input of numbers
  • From: George
• User input of numbers
  • From: John V
• Re: Using category groups in access 2007 causing queries to throw erro
  • From: cparker
• Re: INT conversion
  • From: John Spencer
• Advice for Audit log
  • From: Opal
• RE: Delete records
  • From: KARL DEWEY
• RE: Make-Table Query Destroys the Wrong Table
  • From: Jerry Whittle
• RE: ID Number Change
  • From: Jerry Whittle
• RE: Parameter Query for "ends with **"
  • From: KARL DEWEY
• ID Number Change
  • From: needing help
• RE: IIF Statement in Query Field Criteria
  • From: dhod
• Re: Parameter Query for "ends with **"
  • From: John W . Vinson
• RE: Parameter Query for "ends with **"
  • From: Student Databaser
• Re: Parameter Query for "ends with **"
  • From: fredg
• RE: Parameter Query for "ends with **"
  • From: KARL DEWEY
• RE: Parameter Query for "ends with **"
  • From: KARL DEWEY
• Re: Query Design help?
  • From: K
• RE: Using category groups in access 2007 causing queries to throw erro
  • From: KARL DEWEY
• RE: query parameter order
  • From: KARL DEWEY
• RE: IIF Statement in Query Field Criteria
  • From: KARL DEWEY
• RE: Delete records
  • From: Golfinray
• RE: Access 2007 - Equivalent to Excel's indirect function
  • From: KARL DEWEY
• RE: Crosstab Query Column Headings
  • From: Bob Barnes
• Parameter Query for "ends with **"
  • From: Student Databaser
• RE: what is the best way to do this...
  • From: misschanda via AccessMonster.com
• RE: Crosstab Query Column Headings
  • From: Duane Hookom
• Using category groups in access 2007 causing queries to throw error #3125
  • From: cparker
• Re: what is the best way to do this...
  • From: misschanda via AccessMonster.com
• RE: Access 2007 - Equivalent to Excel's indirect function
  • From: RL
• RE: Random selection - multiple criteria
  • From: Craig
• Re: Query Design help?
  • From: Jeff Boyce
• Re: Delete records
  • From: Jeff Boyce
• Re: Comparing & Finding Non-Duplicates
  • From: Jeff Boyce
• RE: Delete records
  • From: KARL DEWEY
• RE: Access 2007 - Equivalent to Excel's indirect function
  • From: KARL DEWEY
• RE: Crosstab Query Column Headings
  • From: Bob Barnes
• IIF Statement in Query Field Criteria
  • From: dhod
• query parameter order
  • From: AccessMan
• Re: Update Field
  • From: Jeff Boyce
• Comparing & Finding Non-Duplicates
  • From: Vylent Fyre
• RE: Random selection - multiple criteria
  • From: KARL DEWEY
• Access 2007 - Equivalent to Excel's indirect function
  • From: RL
• Re: INT conversion
  • From: Rich
• Re: Sort Cust list into 80/15/5 Groups
  • From: Michel Walsh
• Re: Deleting duplicate records/same table
  • From: Michel Walsh
• Re: Get accounts from SummaryTable to every record in DetailTable
  • From: Marshall Barton
• RE: Crosstab Query Column Headings
  • From: Bob Barnes
• Delete records
  • From: Golfinray
• RE: Random selection - multiple criteria
  • From: Craig
• Re: How to convert duplicate rows into unique rows in a Table?
  • From: KK
• Re: Option Groups with 6 options tied to 6 different fields
  • From: Rick Brandt
• Re: Option Groups with 6 options tied to 6 different fields
  • From: dogcrazzie via AccessMonster.com
• RE: Option Groups with 6 options tied to 6 different fields
  • From: dogcrazzie via AccessMonster.com
• Query Design help?
  • From: K
• Re: Append query to append lots of record with range input
  • From: John Spencer
• Re: Crosstab query with 3 main rows/colums + "Other"?
  • From: Geo
• Re: Invalid use of null in query expression
  • From: Jon
• Get accounts from SummaryTable to every record in DetailTable
  • From: XP
• Re: Crosstab query with 3 main rows/colums + "Other"?
  • From: John Spencer
• Re: Number Format not working
  • From: John Spencer
• Re: Number Format not working
  • From: Rick Brandt
• Re: How do I the pull the first name from a fullname field in Access?
  • From: John Spencer
• Crosstab query with 3 main rows/colums + "Other"?
  • From: Geo
• Query problem
  • From: jackrobyn1
• Re: Peculiar date problem
  • From: Brendan Reynolds
• Peculiar date problem
  • From: kksingh
• Number Format not working
  • From: Kerry Purdy
• Re: Update Field
  • From: Ricardo Furtado
• RE: How do I the pull the first name from a fullname field in Access?
  • From: Glenn Siswick
• RE: How do I the pull the first name from a fullname field in Access?
  • From: Glenn Siswick
• Re: Using query criteria for table name
  • From: John W . Vinson
• Re: Append query to append lots of record with range input
  • From: domibud
• How do I the pull the first name from a fullname field in Access?
  • From: Robert in need of a Guru
• RE: what's wrong with this sql statment? (uses "SELECT-IN")
  • From: Dale Fye
• Re: Attempting to run An Append Query
  • From: Darlene Regali
• RE: Crosstab Query Column Headings
  • From: Duane Hookom
• Re: Append query to append lots of record with range input
  • From: domibud
• Re: Option Groups with 6 options tied to 6 different fields
  • From: Margaret Bartley
• Make-Table Query Destroys the Wrong Table
  • From: Margaret Bartley
• Crosstab Query Column Headings
  • From: Bob Barnes
• create hyperlink & append table
  • From: patti
• RE: How to convert duplicate rows into unique rows in a Table?
  • From: KARL DEWEY
• Re: Compare data of column in many fields.
  • From: KARL DEWEY
• RE: Append two related tables
  • From: KARL DEWEY
• Append two related tables
  • From: shelter@xxxxxxxxxxxxxxxxxxxxxxx
• Append two related tables
  • From: shelter@xxxxxxxxxxxxxxxxxxxxxxx
• Re: Compare data of column in many fields.
  • From: raskew via AccessMonster.com
• RE: Option Groups with 6 options tied to 6 different fields
  • From: KARL DEWEY
• Re: Invalid use of null in query expression
  • From: Wolfgang Kais
• Compare data of column in many fields.
  • From: triann_a
• Re: Query With Ranges in output?
  • From: Sydneyej
• Re: two level cross tab query
  • From: Wolfgang Kais
• How to convert duplicate rows into unique rows in a Table?
  • From: KK
• Re: multiple ingredient search in historical recipe database
  • From: Anne S
• RE: Averages for Multiple Types
  • From: KARL DEWEY
• RE: two level cross tab query
  • From: KARL DEWEY
• Invalid use of null in query expression
  • From: Jon
• Option Groups with 6 options tied to 6 different fields
  • From: dogcrazzie
• RE: Random selection - multiple criteria
  • From: KARL DEWEY
• Re: INT conversion
  • From: raskew via AccessMonster.com
• Re: Sort Cust list into 80/15/5 Groups
  • From: ScottR3
• Re: INT conversion
  • From: Evi
• Re: Optional Variables in Functions (REPLACE and other 'Worksheet' functions)
  • From: Evi
• INT conversion
  • From: Rich
• RE: Averages for Multiple Types
  • From: bswood7
• Re: Deleting duplicate records/same table
  • From: Stacie2410
• Re: Deleting duplicate records/same table
  • From: Michel Walsh
• Re: Deleting duplicate records/same table
  • From: Stacie2410
• two level cross tab query
  • From: iccsi
• RE: Averages for Multiple Types
  • From: KARL DEWEY
• Re: Sort Cust list into 80/15/5 Groups
  • From: raskew via AccessMonster.com
• Re: Averages for Multiple Types
  • From: raskew via AccessMonster.com
• Re: Averages for Multiple Types
  • From: Michel Walsh
• Re: Deleting duplicate records/same table
  • From: Michel Walsh
• Averages for Multiple Types
  • From: bswood7
• Re: enter a count function to count records?
  • From: Evi
• Re: Deleting duplicate records/same table
  • From: Stacie2410
• Re: Sort Cust list into 80/15/5 Groups
  • From: Michel Walsh
• RE: Sort Cust list into 80/15/5 Groups
  • From: Golfinray
• Re: Deleting duplicate records/same table
  • From: Michel Walsh
• Re: Update Field
  • From: Jeff Boyce
• Update Field
  • From: Ricardo Furtado
• Re: Using query criteria for table name
  • From: Da Viking
• Re: Display all records between two dates
  • From: Les
• Re: enter a count function to count records?
  • From: Char
• RE: How to Filter on Multiple Fields
  • From: Char
• Random selection - multiple criteria
  • From: Craig
• RE: Calculating a total for column that has multiple conditions
  • From: themartellekid
• Re: Calculating a total for column that has multiple conditions
  • From: themartellekid
• Re: ranking data and updating a table
  • From: marilyn
• Sort Cust list into 80/15/5 Groups
  • From: ScottR3
• Deleting duplicate records/same table
  • From: Stacie2410
• RE: Weekly Crosstab Report
  • From: KARL DEWEY
• Weekly Crosstab Report
  • From: daveXP
• RE: what is the best way to do this...
  • From: KARL DEWEY
• Re: what is the best way to do this...
  • From: Michel Walsh
• Re: double check a query to compare prices for yesterday and today
  • From: Michel Walsh
• Re: access to text file
  • From: Michel Walsh
• Re: Using circular references
  • From: Michel Walsh
• Re: Append query to append lots of record with range input
  • From: Jeff Boyce
• what is the best way to do this...
  • From: misschanda via AccessMonster.com
• Re: Optional Variables in Functions (REPLACE and other 'Worksheet' functions)
  • From: John Spencer
• Re: Display all records between two dates
  • From: Ron2006
• Re: Display all records between two dates
  • From: John Spencer
• Re: multiple ingredient search in historical recipe database
  • From: John Spencer
• Append query to append lots of record with range input
  • From: domibud
• Optional Variables in Functions (REPLACE and other 'Worksheet' functions)
  • From: Evi
• Display all records between two dates
  • From: Les
• Re: Implementing a Hierarchy in MS Access
  • From: Stefan Hoffmann
• RE: Implementing a Hierarchy in MS Access
  • From: "Peter Yang[MSFT]"
• Re: Time Calculations
  • From: raskew s via AccessMonster.com
• Re: Set value for field if default gives #ERROR
  • From: Jeanette Cunningham
• Re: Union qry- results show #'s not words
  • From: John W . Vinson
• Time Calculations
  • From: vepha
• RE: group by name having 2 different groups ( weeks )
  • From: vepha
• Re: Union qry- results show #'s not words
  • From: sooz9
• Re: Update Query that will check Status.
  • From: Alchemist61
• Re: Search Criteria
  • From: Marshall Barton
• Re: Update Query that will check Status.
  • From: Alchemist61
• Set value for field if default gives #ERROR
  • From: Sandy
• Re: Converting Number To Time
  • From: Evi
• Re: Converting Number To Time
  • From: Evi
• Re: Search Criteria
  • From: KARL DEWEY
• Re: Update Query that will check Status.
  • From: John Spencer
• Re: Update Query that will check Status.
  • From: KARL DEWEY
• RE: multiple ingredient search in historical recipe database
  • From: KARL DEWEY
• Re: Update Query that will check Status.
  • From: Alchemist61
• RE: problem caused by sync profile
  • From: sgbch
• RE: Pass-Thru Query not working
  • From: KS31
• Using circular references
  • From: bismuth83
• Re: Pass-Thru Query not working
  • From: Sylvain Lafontaine
• Re: Implementing a Hierarchy in MS Access
  • From: Flavelle Ballem
• Re: Update Query that will check Status.
  • From: John Spencer
• mdb query locks up when a sql-server table linked?!?!?
  • From: bobg . hahc
• Update Query that will check Status.
  • From: Alchemist61
• Re: Implementing a Hierarchy in MS Access
  • From: Stefan Hoffmann
• Re: Converting Number To Time
  • From: Jeff Garrison
• Re: Converting Number To Time
  • From: John Spencer
• multiple ingredient search in historical recipe database
  • From: Anne S
• Re: Converting Number To Time
  • From: Evi
• Re: Converting Number To Time
  • From: Evi
• Converting Number To Time
  • From: Jeff Garrison
• Re: totaling like records within a query
  • From: Evi
• RE: How to Filter on Multiple Fields
  • From: Duane Hookom
• Re: enter a count function to count records?
  • From: Evi
• Pass-Thru Query not working
  • From: KS31
• Implementing a Hierarchy in MS Access
  • From: Flavelle Ballem
• RE: Changing data type in a Query
  • From: mscertified
• RE: How to Filter on Multiple Fields
  • From: Char
• Re: enter a count function to count records?
  • From: Char
• RE: Query Criteria
  • From: ladybug via AccessMonster.com
• RE: Tables and Queries
  • From: KARL DEWEY
• RE: I want to update "P O BOX" to "P.O. BOX"
  • From: KARL DEWEY
• Re: Search Criteria
  • From: Marshall Barton
• I want to update "P O BOX" to "P.O. BOX"
  • From: Kelvin
• Tables and Queries
  • From: Gringarlow
• Re: help...Can't delete from specified tables
  • From: John W . Vinson
• Re: Return total of totals?
  • From: Fred
• Re: Autonumbering/merging problem
  • From: Paul Hyett
• Search Criteria
  • From: JennKriv
• Re: Can't delete from specified tables on Unjoined Tables
  • From: Dave
• Re: Can't delete from specified tables on Unjoined Tables
  • From: John Spencer
• Re: Return total of totals?
  • From: John Spencer
• Re: Can't delete from specified tables on Unjoined Tables
  • From: Michel Walsh
• RE: Changing data type in a Query
  • From: JJonesJr
• Re: Min across fields not rows
  • From: John Spencer
• RE: Min across fields not rows
  • From: mscertified
• Can't delete from specified tables on Unjoined Tables
  • From: Dave
• RE: Changing data type in a Query
  • From: mscertified
• Re: Min across fields not rows
  • From: Jeff Boyce
• Re: Union qry- results show #'s not words
  • From: Jeff Boyce
• Changing data type in a Query
  • From: JJonesJr
• Return total of totals?
  • From: Fred
• Min across fields not rows
  • From: buzzmcduffie
• RE: group by name having 2 different groups ( weeks )
  • From: KARL DEWEY
• Re: Delete records based on two sets of criteria
  • From: Access Joe
• Re: retrieving only 10 rows
  • From: Ron2006
• OT: new MS support tact found in windows 64-bit newsgroup
  • From: Gary Walter
• Re: retrieving only 10 rows
  • From: Rick Brandt
• retrieving only 10 rows
  • From: Joao
• Re: cannot delete from "specified tables"
  • From: John Spencer
• Hot Shop Baume & Mercier Hampton Milleis - Baume & Mercier Minimum Price
  • From: yxs032
• Re: enter a count function to count records?
  • From: Evi
• Re: help...Can't delete from specified tables
  • From: Jeanette Cunningham
• Hot Shop Chopard Ice Cube Watches - Chopard Minimum Price
  • From: yxs066
• Hot Shop Master Hometime - Jaeger LeCoultre Minimum Price
  • From: yxs066
• help...Can't delete from specified tables
  • From: NewtoComputing
• Re: Table not available for Append query
  • From: Ruth
• Re: Table not available for Append query
  • From: Ruth
• Re: cannot delete from "specified tables"
  • From: NewtoComputing
• RE: Generate table
  • From: Martin Fishlock
• Re: cannot delete from "specified tables"
  • From: Ken Snell \(MVP\)
• Re: Shortcuts to Desktop
  • From: Cathy C
• cannot delete from "specified tables"
  • From: NewtoComputing
• Re: enter a count function to count records?
  • From: Kimberly
• Re: Shortcuts to Desktop
  • From: Albert D. Kallal
• Re: enter a count function to count records?
  • From: Evi
• Using Date Criteria with Other Criteria
  • From: amd via AccessMonster.com
• Re: enter a count function to count records?
  • From: Kimberly
• Re: enter a count function to count records?
  • From: Evi
• Generate table
  • From: Access Newbie
• enter a count function to count records?
  • From: Kimberly
• Re: SendKey????
  • From: Ken Snell \(MVP\)
• Shortcuts to Desktop
  • From: Cathy C
• Re: totaling like records within a query
  • From: bmcelroy via AccessMonster.com
• SendKey????
  • From: duncanjx
• Re: VB Editor Auto prompt turning off problem
  • From: duncanjx
• Re: Query expression cost increase by 15 percent
  • From: Martin Fishlock
• Sage Timberline Office - Job Costing
  • From: liukaiyuan
• Re: Autonumbering/merging problem
  • From: Paul Hyett
• Re: Invalid SQL Statement in VBA sub
  • From: Ken Snell \(MVP\)
• Re: VB Editor Auto prompt turning off problem
  • From: Marshall Barton
• Re: Query expression cost increase by 15 percent
  • From: fredg
• Re: Invalid SQL Statement in VBA sub
  • From: JCIrish
• Query expression cost increase by 15 percent
  • From: Dwayne
• Re: VB Editor Auto prompt turning off problem
  • From: fredg
• VB Editor Auto prompt turning off problem
  • From: duncanjx
• RE: Weird issue
  • From: Dale Fye
• Re: input box to update query
  • From: Evi
• Re: totaling like records within a query
  • From: Evi
• Re: Autonumbering/merging problem
  • From: mattia
• Autonumbering/merging problem
  • From: Paul Hyett
• Re: ranking data and updating a table
  • From: John Spencer
• RE: Query or VBA code
  • From: Dale Fye
• Re: Transactions and concurrency
  • From: Ken Sheridan
• Re: color column in datasheet view
  • From: Evi
• Re: Duplication of query
  • From: Marshall Barton
• Re: Duplication of query
  • From: John Spencer
• Re: totaling like records within a query
  • From: bmcelroy via AccessMonster.com
• Re: Query or VBA code
  • From: John Spencer
• Duplication of query
  • From: AJRoad
• Re: Re:I Meant Append Query - Sorry
  • From: Evi
• Re: Transactions and concurrency
  • From: Evi
• Re: How to Filter on Multiple Fields
  • From: Evi
• Re: Query or VBA code
  • From: Evi
• Transactions and concurrency
  • From: Michael Weber
• Re: totaling like records within a query
  • From: Evi
• RE: How to Filter on Multiple Fields
  • From: Duane Hookom
• Re: ranking data and updating a table
  • From: marilyn
• How to Filter on Multiple Fields
  • From: Paputxi
• totaling like records within a query
  • From: bmcelroy
• Re: Union qry- results show #'s not words
  • From: sooz9
• Query or VBA code
  • From: Monique
• Re: Union qry- results show #'s not words
  • From: sooz9
• Re:I Meant Append Query - Sorry
  • From: Dave
• Update query Criteria help needed
  • From: Dave
• Re: Union qry- results show #'s not words
  • From: Jeff Boyce
• Union qry- results show #'s not words
  • From: sooz9
• Re: Function in Query
  • From: Amy Blankenship
• Re: Function in Query
  • From: Hardhit
• Re: Displaying Categories with Non-zero values
  • From: Evi
• Re: Duplicate data in query
  • From: Evi
• Re: Syntax Question for Multiple Joins
  • From: John W . Vinson
• RE: default query result
  • From: NetworkTrade
• default query result
  • From: stickandrock
• RE: Weird issue
  • From: Jerry Whittle
• Re: Function in Query
  • From: Amy Blankenship
• Re: Function in Query
  • From: Amy Blankenship
• Re: DSUM Error
  • From: NeoFax
• Re: Syntax Question for Multiple Joins
  • From: Amy Blankenship
• Re: Syntax Question for Multiple Joins
  • From: GaryJ
• Re: how to get relation links to match when they dont match
  • From: Leslie Porter OHV
• RE: Weird issue
  • From: Tara
• Concatenating text with punctuation
  • From: EllenM
• Re: Weird issue
  • From: Tara
• Re: Time() - 5 minutes
  • From: Scott
• RE: Weird issue
  • From: Jerry Whittle
• Re: How can I LEFT JOIN two subqueries in the same SELECT statement?
  • From: John Spencer
• Re: Weird issue
  • From: John W . Vinson
• Re: Time() - 5 minutes
  • From: John W . Vinson
• Re: Syntax Question for Multiple Joins
  • From: John W . Vinson
• Re: DSUM Error
  • From: John Spencer
• Re: Function in Query
  • From: Hardhit
• Re: How can I LEFT JOIN two subqueries in the same SELECT statement?
  • From: N L
• Re: How can I LEFT JOIN two subqueries in the same SELECT statement?
  • From: N L
• Re: How can I LEFT JOIN two subqueries in the same SELECT statement?
  • From: N L
• Weird issue
  • From: Tara
• Re: Syntax Question for Multiple Joins
  • From: GaryJ
• Time() - 5 minutes
  • From: Scott
• Re: How can I LEFT JOIN two subqueries in the same SELECT statement?
  • From: Brian
• RE: Update query question
  • From: maheumann via AccessMonster.com
• RE: Calculating a total for column that has multiple conditions
  • From: KARL DEWEY
• Re: Syntax Question for Multiple Joins
  • From: Amy Blankenship
• Re: How can I LEFT JOIN two subqueries in the same SELECT statement?
  • From: Amy Blankenship
• Re: How can I LEFT JOIN two subqueries in the same SELECT statement?
  • From: John Spencer
• Re: Calculating a total for column that has multiple conditions
  • From: John Spencer
• Re: Union Query Removing records
  • From: Emma Aumack
• Re: Duplicate data in query
  • From: Beth Eadie
• RE: Update query question
  • From: Klatuu
• RE: Update query question
  • From: maheumann via AccessMonster.com
• Re: combining 2 fields that are in the same column, into 1 field
  • From: Freida
• Syntax Question for Multiple Joins
  • From: GaryJ
• Re: convert to number
  • From: Rich
• Re: Function in Query
  • From: Amy Blankenship
• How can I LEFT JOIN two subqueries in the same SELECT statement?
  • From: N L
• Re: Function in Query
  • From: Michel Walsh
• Re: how to get relation links to match when they dont match
  • From: John Spencer
• Re: Passing parameters via MS Query to Access
  • From: Michel Walsh
• RE: Calculating a total for column that has multiple conditions
  • From: themartellekid
• Re: Delete dups in a table
  • From: John Spencer
• RE: HELP with Query
  • From: Duane Hookom
• Re: Using combo box in a form -- how to make drop-down work?
  • From: Rachel Garrett
• Re: Selecting Distinct Memo Fields
  • From: John Spencer
• RE: Calculating a total for column that has multiple conditions
  • From: KARL DEWEY
• Re: Top 3 of multible catorgies
  • From: Michel Walsh
• Re: Delete records based on two sets of criteria
  • From: John Spencer
• Re: Displaying Categories with Non-zero values
  • From: John Spencer
• Re: HELP with Query
  • From: Hardhit
• RE: HELP with Query
  • From: KARL DEWEY
• Re: Delete dups in a table
  • From: Michel Walsh
• Function in Query
  • From: Hardhit
• RE: Update query question
  • From: Klatuu
• RE: Using combo box in a form -- how to make drop-down work?
  • From: Klatuu
• Re: DSUM Error
  • From: NeoFax
• HELP with Query
  • From: Robin
• RE: Delete dups in a table
  • From: Duane Hookom
• Re: Problem with percentages
  • From: Michel Walsh
• Re: ranking data and updating a table
  • From: Michel Walsh
• COMBINING TWO QUERIES
  • From: JOE POLLOCK
• RE: Using combo box in a form -- how to make drop-down work?
  • From: Duane Hookom
• Calculating a total for column that has multiple conditions
  • From: themartellekid
• Re: Delete records based on two sets of criteria
  • From: Gary Walter
• Re: how to get relation links to match when they dont match
  • From: Leslie Porter OHV
• Using combo box in a form -- how to make drop-down work?
  • From: Rachel Garrett
• Re: Delete records based on two sets of criteria
  • From: Gary Walter
• Re: how to get relation links to match when they dont match
  • From: Ron2006
• Update query question
  • From: maheumann via AccessMonster.com
• Re: Union Query Removing records
  • From: Jeff Boyce
• Re: Help with Query
  • From: Jeff Boyce
• how to get relation links to match when they dont match
  • From: Leslie Porter OHV
• Re: Delete records based on two sets of criteria
  • From: Access Joe
• Re: SharePoint MultiValue Field Data Extraction and UNION Query
  • From: Jeff Boyce
• Re: SharePoint MultiValue Field Data Extraction and UNION Query
  • From: Mike Hill
• RE: DSUM Error
  • From: Dennis
• RE: Crosstab Qry, column heading, by week number, show "Mar 9-16"
  • From: Ken Sheridan
• Re: Displaying Categories with Non-zero values
  • From: Dez
• Delete dups in a table
  • From: Dominick D.
• Selecting Distinct Memo Fields
  • From: Daffy
• DSUM Error
  • From: NeoFax
• Re: Delete records based on two sets of criteria
  • From: John Spencer
• Re: Delete records based on two sets of criteria
  • From: Access Joe
• Re: Delete records based on two sets of criteria
  • From: Evi
• Re: Displaying Categories with Non-zero values
  • From: Evi
• Re: Delete records based on two sets of criteria
  • From: John Spencer
• Re: Delete records based on two sets of criteria
  • From: Access Joe
• Re: Delete records based on two sets of criteria
  • From: Access Joe
• Re: Help with Query
  • From: Evi
• Re: Delete records based on two sets of criteria
  • From: Evi
• Help with Query
  • From: SX
• RE: Top 3 of multible catorgies
  • From: Ed Jordan
• Top 3 of multible catorgies
  • From: Ed Jordan
• Re: Crosstab query problem
  • From: Bongard
• Re: Crosstab query problem
  • From: KARL DEWEY
• Re: Delete records based on two sets of criteria
  • From: John Spencer
• Re: Union Query Removing records
  • From: John W . Vinson
• RE: Union Query Removing records
  • From: KARL DEWEY
• Union Query Removing records
  • From: Emma Aumack
• Re: Crosstab query problem
  • From: Bongard
• Re: Crosstab query problem
  • From: KARL DEWEY
• RE: convert zero-length to Null
  • From: KARL DEWEY
• RE: Do you have to pay for the translating service on Office?
  • From: KARL DEWEY
• RE: Grouping data from different columns
  • From: KARL DEWEY
• Re: Crosstab query problem
  • From: Bongard
• RE: Replace in 2007
  • From: Mapping
• Grouping data from different columns
  • From: Rachel Garrett
• Do you have to pay for the translating service on Office?
  • From: Othello
• Re: Query for Left(String,5) - Access 2007
  • From: JohnH
• RE: Crosstab query problem
  • From: KARL DEWEY
• RE: Problem with percentages
  • From: KARL DEWEY
• convert zero-length to Null
  • From: alwaweru
• double check a query to compare prices for yesterday and today
  • From: JRough
• Re: Delete records based on two sets of criteria
  • From: Evi
• access to text file
  • From: George Applegate
• Delete records based on two sets of criteria
  • From: Access Joe
• Crosstab query problem
  • From: Bongard
• SharePoint MultiValue Field Data Extraction and UNION Query
  • From: Mike Hill
• Problem with percentages
  • From: Golfinray
• Passing parameters via MS Query to Access
  • From: Yoam69
• RE: Crosstab Qry, column heading, by week number, show "Mar 9-16"
  • From: Todd
• Re: Search subform, goto record on main form.
  • From: Evi
• RE: Can this be done with access 2007
  • From: Need Help
• Re: How to replace a date in an insert query?
  • From: Leo Hamal
• ranking data and updating a table
  • From: marilyn
• Re: Create a specific sort order
  • From: fredg
• Help with and Update query
  • From: Brian
• RE: How to add my own functions to access 2007: to select in "buil
  • From: S.Clark
• Re: Create a specific sort order
  • From: Michel Walsh
• RE: How to add my own functions to access 2007: to select in "buil
  • From: Beepa
• Can a query residing in Access on a server be initiated via asp?
  • From: Dave
• WWW.ANUNCIOS-24H.COM
  • From: ANUNCIOS-24H.COM
• field association
  • From: misschanda via AccessMonster.com
• Re: Asterix
  • From: Love Buzz
• Re: Using query criteria for table name
  • From: John W . Vinson
• RE: Using query criteria for table name
  • From: KARL DEWEY
• Re: Why does this Nested IIF statement add AS fields
  • From: strive4peace
• Re: Why does this Nested IIF statement add AS fields
  • From: strive4peace
• Re: Group Query
  • From: lez
• Re: date query
  • From: lez
• Re: Group by and AVG and then would like to round the data....
  • From: John Spencer
• Re: Group Query
  • From: John Spencer
• Re: Query results and display nulls?
  • From: John Spencer
• Re: convert to number
  • From: Marshall Barton
• Re: How to replace a date in an insert query?
  • From: John W . Vinson
• Re: How to replace a date in an insert query?
  • From: Klatuu
• Re: Group Query
  • From: Lez
• Re: date query
  • From: fredg
• Re: Quarterly Billing for Partial periods
  • From: Michel Walsh
• Re: Trouble with 2 tables connected by reference table
  • From: Michel Walsh
• date query
  • From: lez
• Re: How to replace a date in an insert query?
  • From: Leo Hamal
• Re: Why does this Nested IIF statement add AS fields
  • From: jacqelynl via AccessMonster.com
• RE: Displaying Categories with Non-zero values
  • From: Dez
• RE: cumulative history of purchases by referrals
  • From: corebe via AccessMonster.com
• RE: Displaying Categories with Non-zero values
  • From: mscertified
• Re: Access SQL Query: Data Type Mismatch on TimeValue condition
  • From: GeeCeeBee
• Displaying Categories with Non-zero values
  • From: Dez
• Group by and AVG and then would like to round the data....
  • From: Gary F Shelton
• Using query criteria for table name
  • From: Da Viking
• RE: How to replace a date in an insert query?
  • From: Klatuu
• Re: Why does this Nested IIF statement add AS fields
  • From: jacqelynl via AccessMonster.com
• Re: Asterix
  • From: Ron2006
• Re: Why does this Nested IIF statement add AS fields
  • From: jacqelynl via AccessMonster.com
• How to replace a date in an insert query?
  • From: Leo Hamal
• Re: Ranking query
  • From: Dale Fye
• RE: How to add my own functions to access 2007: to select in "build"
  • From: S.Clark
• RE: Can this be done with access 2007
  • From: S.Clark
• RE: cumulative history of purchases by referrals
  • From: S.Clark
• RE: union query of complex queries
  • From: S.Clark
• Re: convert to number
  • From: Rich
• Re: Ranking query
  • From: BruceM
• Re: Group Query
  • From: John Spencer
• Re: Query results and display nulls?
  • From: CR
• Re: Append a record multiple times to a new table
  • From: John Spencer
• Group Query
  • From: lez
• Re: An Inner Join on an Inner Join
  • From: John Spencer
• Re: Create a specific sort order
  • From: Access Joe
• Re: SubDataSheet ability comes and goes without reason
  • From: Evi
• Re: SubDataSheet ability comes and goes without reason
  • From: Evi
• Re: Combine Multilple Tables
  • From: Evi
• Re: Change/Save to aggregate query shuts down Access
  • From: Alan
• Append a record multiple times to a new table
  • From: IncentGirl
• Re: Synchronization Module
  • From: David W. Fenton
• RE: Group by month then count rows
  • From: Matilda
• RE: Group by month then count rows
  • From: Duane Hookom
• RE: Group by month then count rows
  • From: Matilda
• RE: Group by month then count rows
  • From: Duane Hookom
• Re: Combine Multilple Tables
  • From: glg4e
• Group by month then count rows
  • From: Matilda
• RE: How to run an append Query in VBA on a recordset
  • From: magicdds-
• Re: Access SQL Query: Data Type Mismatch on TimeValue condition
  • From: John Spencer
• Re: Why does this Nested IIF statement add AS fields
  • From: John Spencer
• Re: Asterix
  • From: John W . Vinson
• RE: How to run an append Query in VBA on a recordset
  • From: Ken Sheridan
• Re: Create a specific sort order
  • From: KARL DEWEY
• RE: Access SQL Query: Data Type Mismatch on TimeValue condition
  • From: KARL DEWEY
• " is not a valid name
  • From: Sharon Peterson
• RE: Query Criteria
  • From: KARL DEWEY
• RE: Crosstab Qry, column heading, by week number, show "Mar 9-16"
  • From: Ken Sheridan
• Re: text to Date/time
  • From: Evi
• Re: Asterix
  • From: Evi
• Access SQL Query: Data Type Mismatch on TimeValue condition
  • From: gary-bennett
• Re: Create a specific sort order
  • From: fredg
• Crosstab Qry, column heading, by week number, show "Mar 9-16"
  • From: Todd
• Re: Why does this Nested IIF statement add AS fields
  • From: strive4peace